Angers, France

0% of people recommend visiting Angers, France

Angers, France

0% of people recommend Angers, France

Is Angers, France worth visiting?

No recommendations have been made. Create an account to add one.

Trips that visit Angers, France

No trips visit Angers, France yet

Nearby cities

Closest cities in same country

	City	Distance
	Nantes, France	80km
	Rennes, France	108km
	Le Havre, France	231km
	Paris, France	264km
	Bordeaux, France	292km
	Brest, France	310km
	Reims, France	391km
	Dijon, France	418km
	Lille, France	439km
	Saint-Étienne, France	440km
	Lyon, France	453km
	Toulouse, France	456km
	Grenoble, France	544km
	Montpellier, France	550km
	Strasbourg, France	628km
	Marseille, France	654km
	Toulon, France	699km
	Nice, France	735km

Closest EU cities

	City	Distance
	Portsmouth, Great Britain (UK)	371km
	Bournemouth, Great Britain (UK)	373km
	Poole, Great Britain (UK)	375km
	Southampton, Great Britain (UK)	386km
	Plymouth, Great Britain (UK)	417km

History
+
Request History
4 previous requests available
====
Session
+
Session
- 0(null)
====
Request
+
Request

Cake Params
- plugin(null)
- controllerlocations
- actionview
- named(empty)
- pass(array)
  0757347
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys(array)
  0controller
  1action
- options(array)
  defaultRoute(true)
- defaults(array)
  plugin(null)
- template/:controller/:action/*
====

Sql Log

Sql Logs

default

Total Time: 72 ms
Total Queries: 175 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT COUNT(*) AS `count` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 757347	1	1	0
SELECT `LocationsTrip`.`id`, `LocationsTrip`.`location_id`, `LocationsTrip`.`trip_id`, `LocationsTrip`.`days`, `LocationsTrip`.`budget`, `LocationsTrip`.`priority`, `LocationsTrip`.`notes`, `LocationsTrip`.`ignore`, `LocationsTrip`.`must_see`, `LocationsTrip`.`created`, `LocationsTrip`.`modified`, `LocationsTrip`.`end_date`, `LocationsTrip`.`start_date`, `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id`, `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`budget`, `Trip`.`start_location`, `Trip`.`trip_length`, `Trip`.`featured`, `Trip`.`user_id`, `Trip`.`created`, `Trip`.`modified` FROM `europe`.`locations_trips` AS `LocationsTrip` LEFT JOIN `europe`.`locations` AS `Location` ON (`LocationsTrip`.`location_id` = `Location`.`id`) LEFT JOIN `europe`.`trips` AS `Trip` ON (`LocationsTrip`.`trip_id` = `Trip`.`id`) WHERE `LocationsTrip`.`location_id` = 757347	0	0	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id`, `Country`.`id`, `Country`.`code`, `Country`.`name`, `Country`.`full_name`, `Country`.`iso3`, `Country`.`number`, `Country`.`continent_code`, `Country`.`display_order`, `Country`.`flag_color`, `Country`.`currency_code`, `Country`.`currency_name`, `Country`.`languages`, `Country`.`iso2` FROM `europe`.`locations` AS `Location` LEFT JOIN `europe`.`countries` AS `Country` ON (`Location`.`country_id` = `Country`.`id`) WHERE `Location`.`id` = 757347 LIMIT 1	1	1	0
SELECT `WorthVisiting`.`id`, `WorthVisiting`.`location_id`, `WorthVisiting`.`is_it_worth_visiting`, `WorthVisiting`.`explain_why`, `WorthVisiting`.`created`, `WorthVisiting`.`modified`, `WorthVisiting`.`alternative_location`, `WorthVisiting`.`user_id` FROM `europe`.`worth_visitings` AS `WorthVisiting` WHERE `WorthVisiting`.`location_id` = (757347)	0	0	0
SELECT `Direction`.`id`, `Direction`.`location_id`, `Direction`.`user_from`, `Direction`.`user_to`, `Direction`.`to` FROM `europe`.`directions` AS `Direction` WHERE `Direction`.`location_id` = (757347)	5	5	2	maybe slow
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 838843	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 828585	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 838743	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 840487	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 838653	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 757347	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 757347	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 757347	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 757347	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 757347	1	1	0
SELECT `Leg`.`id`, `Leg`.`direction_id` FROM `europe`.`legs` AS `Leg` WHERE `Leg`.`direction_id` IN (261, 262, 263, 264, 265)	0	0	0
SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`budget`, `Trip`.`start_location`, `Trip`.`trip_length`, `Trip`.`featured`, `Trip`.`user_id`, `Trip`.`created`, `Trip`.`modified`, `LocationsTrip`.`id`, `LocationsTrip`.`location_id`, `LocationsTrip`.`trip_id`, `LocationsTrip`.`days`, `LocationsTrip`.`budget`, `LocationsTrip`.`priority`, `LocationsTrip`.`notes`, `LocationsTrip`.`ignore`, `LocationsTrip`.`must_see`, `LocationsTrip`.`created`, `LocationsTrip`.`modified`, `LocationsTrip`.`end_date`, `LocationsTrip`.`start_date` FROM `europe`.`trips` AS `Trip` JOIN `europe`.`locations_trips` AS `LocationsTrip` ON (`LocationsTrip`.`location_id` = 757347 AND `LocationsTrip`.`trip_id` = `Trip`.`id`)	0	0	0
SELECT id, population, city, LOWER(iso2) as iso, lat, lng, 111.045* DEGREES(ACOS(COS(RADIANS(latpoint)) * COS(RADIANS(lat)) * COS(RADIANS(longpoint) - RADIANS(lng)) + SIN(RADIANS(latpoint)) * SIN(RADIANS(lat)))) AS distance_in_km FROM locations JOIN ( SELECT 47.466667 AS latpoint, -.55 AS longpoint ) AS p ON 1=1 WHERE iso2 != "fr" AND population > 150000 AND id != 757347 ORDER BY distance_in_km LIMIT 5	5	5	29	maybe slow
SELECT id, population, city, LOWER(iso2) as iso, lat, lng, 111.045* DEGREES(ACOS(COS(RADIANS(latpoint)) * COS(RADIANS(lat)) * COS(RADIANS(longpoint) - RADIANS(lng)) + SIN(RADIANS(latpoint)) * SIN(RADIANS(lat)))) AS distance_in_km FROM locations JOIN ( SELECT 47.466667 AS latpoint, -.55 AS longpoint ) AS p ON 1=1 WHERE iso2 = "fr" AND population > 150000 AND id != 757347 ORDER BY distance_in_km LIMIT 25	18	18	25	maybe slow
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id`, `Country`.`id`, `Country`.`code`, `Country`.`name`, `Country`.`full_name`, `Country`.`iso3`, `Country`.`number`, `Country`.`continent_code`, `Country`.`display_order`, `Country`.`flag_color`, `Country`.`currency_code`, `Country`.`currency_name`, `Country`.`languages`, `Country`.`iso2` FROM `europe`.`locations` AS `Location` LEFT JOIN `europe`.`countries` AS `Country` ON (`Location`.`country_id` = `Country`.`id`) WHERE `Location`.`id` = 757347 LIMIT 1	1	1	0
SELECT `WorthVisiting`.`id`, `WorthVisiting`.`location_id`, `WorthVisiting`.`is_it_worth_visiting`, `WorthVisiting`.`explain_why`, `WorthVisiting`.`created`, `WorthVisiting`.`modified`, `WorthVisiting`.`alternative_location`, `WorthVisiting`.`user_id` FROM `europe`.`worth_visitings` AS `WorthVisiting` WHERE `WorthVisiting`.`location_id` = (757347)	0	0	0
SELECT `Direction`.`id`, `Direction`.`location_id`, `Direction`.`user_from`, `Direction`.`user_to`, `Direction`.`to` FROM `europe`.`directions` AS `Direction` WHERE `Direction`.`location_id` = (757347)	5	5	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 838843	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 828585	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 838743	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 840487	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 838653	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 757347	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 757347	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 757347	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 757347	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 757347	1	1	0
SELECT `Leg`.`id`, `Leg`.`direction_id` FROM `europe`.`legs` AS `Leg` WHERE `Leg`.`direction_id` IN (261, 262, 263, 264, 265)	0	0	0
SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`budget`, `Trip`.`start_location`, `Trip`.`trip_length`, `Trip`.`featured`, `Trip`.`user_id`, `Trip`.`created`, `Trip`.`modified`, `LocationsTrip`.`id`, `LocationsTrip`.`location_id`, `LocationsTrip`.`trip_id`, `LocationsTrip`.`days`, `LocationsTrip`.`budget`, `LocationsTrip`.`priority`, `LocationsTrip`.`notes`, `LocationsTrip`.`ignore`, `LocationsTrip`.`must_see`, `LocationsTrip`.`created`, `LocationsTrip`.`modified`, `LocationsTrip`.`end_date`, `LocationsTrip`.`start_date` FROM `europe`.`trips` AS `Trip` JOIN `europe`.`locations_trips` AS `LocationsTrip` ON (`LocationsTrip`.`location_id` = 757347 AND `LocationsTrip`.`trip_id` = `Trip`.`id`)	0	0	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id`, `Country`.`id`, `Country`.`code`, `Country`.`name`, `Country`.`full_name`, `Country`.`iso3`, `Country`.`number`, `Country`.`continent_code`, `Country`.`display_order`, `Country`.`flag_color`, `Country`.`currency_code`, `Country`.`currency_name`, `Country`.`languages`, `Country`.`iso2` FROM `europe`.`locations` AS `Location` LEFT JOIN `europe`.`countries` AS `Country` ON (`Location`.`country_id` = `Country`.`id`) WHERE `Location`.`id` = 838843 LIMIT 1	1	1	0
SELECT `WorthVisiting`.`id`, `WorthVisiting`.`location_id`, `WorthVisiting`.`is_it_worth_visiting`, `WorthVisiting`.`explain_why`, `WorthVisiting`.`created`, `WorthVisiting`.`modified`, `WorthVisiting`.`alternative_location`, `WorthVisiting`.`user_id` FROM `europe`.`worth_visitings` AS `WorthVisiting` WHERE `WorthVisiting`.`location_id` = (838843)	0	0	0
SELECT `Direction`.`id`, `Direction`.`location_id`, `Direction`.`user_from`, `Direction`.`user_to`, `Direction`.`to` FROM `europe`.`directions` AS `Direction` WHERE `Direction`.`location_id` = (838843)	5	5	3	maybe slow
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 788013	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 793348	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 806386	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 802290	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 196386	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 838843	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 838843	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 838843	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 838843	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 838843	1	1	0
SELECT `Leg`.`id`, `Leg`.`direction_id` FROM `europe`.`legs` AS `Leg` WHERE `Leg`.`direction_id` IN (781, 782, 783, 784, 785)	0	0	0
SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`budget`, `Trip`.`start_location`, `Trip`.`trip_length`, `Trip`.`featured`, `Trip`.`user_id`, `Trip`.`created`, `Trip`.`modified`, `LocationsTrip`.`id`, `LocationsTrip`.`location_id`, `LocationsTrip`.`trip_id`, `LocationsTrip`.`days`, `LocationsTrip`.`budget`, `LocationsTrip`.`priority`, `LocationsTrip`.`notes`, `LocationsTrip`.`ignore`, `LocationsTrip`.`must_see`, `LocationsTrip`.`created`, `LocationsTrip`.`modified`, `LocationsTrip`.`end_date`, `LocationsTrip`.`start_date` FROM `europe`.`trips` AS `Trip` JOIN `europe`.`locations_trips` AS `LocationsTrip` ON (`LocationsTrip`.`location_id` = 838843 AND `LocationsTrip`.`trip_id` = `Trip`.`id`)	0	0	0
SELECT `Direction`.`id`, `Direction`.`location_id`, `Direction`.`user_from`, `Direction`.`user_to`, `Direction`.`to` FROM `europe`.`directions` AS `Direction` WHERE `location_id` = 757347 AND `to` = 838843 LIMIT 1	1	1	1
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id`, `Country`.`id`, `Country`.`code`, `Country`.`name`, `Country`.`full_name`, `Country`.`iso3`, `Country`.`number`, `Country`.`continent_code`, `Country`.`display_order`, `Country`.`flag_color`, `Country`.`currency_code`, `Country`.`currency_name`, `Country`.`languages`, `Country`.`iso2` FROM `europe`.`locations` AS `Location` LEFT JOIN `europe`.`countries` AS `Country` ON (`Location`.`country_id` = `Country`.`id`) WHERE `Location`.`id` = 757347 LIMIT 1	1	1	0
SELECT `WorthVisiting`.`id`, `WorthVisiting`.`location_id`, `WorthVisiting`.`is_it_worth_visiting`, `WorthVisiting`.`explain_why`, `WorthVisiting`.`created`, `WorthVisiting`.`modified`, `WorthVisiting`.`alternative_location`, `WorthVisiting`.`user_id` FROM `europe`.`worth_visitings` AS `WorthVisiting` WHERE `WorthVisiting`.`location_id` = (757347)	0	0	0
SELECT `Direction`.`id`, `Direction`.`location_id`, `Direction`.`user_from`, `Direction`.`user_to`, `Direction`.`to` FROM `europe`.`directions` AS `Direction` WHERE `Direction`.`location_id` = (757347)	5	5	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 838843	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 828585	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 838743	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 840487	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 838653	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 757347	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 757347	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 757347	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 757347	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 757347	1	1	0
SELECT `Leg`.`id`, `Leg`.`direction_id` FROM `europe`.`legs` AS `Leg` WHERE `Leg`.`direction_id` IN (261, 262, 263, 264, 265)	0	0	0
SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`budget`, `Trip`.`start_location`, `Trip`.`trip_length`, `Trip`.`featured`, `Trip`.`user_id`, `Trip`.`created`, `Trip`.`modified`, `LocationsTrip`.`id`, `LocationsTrip`.`location_id`, `LocationsTrip`.`trip_id`, `LocationsTrip`.`days`, `LocationsTrip`.`budget`, `LocationsTrip`.`priority`, `LocationsTrip`.`notes`, `LocationsTrip`.`ignore`, `LocationsTrip`.`must_see`, `LocationsTrip`.`created`, `LocationsTrip`.`modified`, `LocationsTrip`.`end_date`, `LocationsTrip`.`start_date` FROM `europe`.`trips` AS `Trip` JOIN `europe`.`locations_trips` AS `LocationsTrip` ON (`LocationsTrip`.`location_id` = 757347 AND `LocationsTrip`.`trip_id` = `Trip`.`id`)	0	0	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id`, `Country`.`id`, `Country`.`code`, `Country`.`name`, `Country`.`full_name`, `Country`.`iso3`, `Country`.`number`, `Country`.`continent_code`, `Country`.`display_order`, `Country`.`flag_color`, `Country`.`currency_code`, `Country`.`currency_name`, `Country`.`languages`, `Country`.`iso2` FROM `europe`.`locations` AS `Location` LEFT JOIN `europe`.`countries` AS `Country` ON (`Location`.`country_id` = `Country`.`id`) WHERE `Location`.`id` = 828585 LIMIT 1	1	1	0
SELECT `WorthVisiting`.`id`, `WorthVisiting`.`location_id`, `WorthVisiting`.`is_it_worth_visiting`, `WorthVisiting`.`explain_why`, `WorthVisiting`.`created`, `WorthVisiting`.`modified`, `WorthVisiting`.`alternative_location`, `WorthVisiting`.`user_id` FROM `europe`.`worth_visitings` AS `WorthVisiting` WHERE `WorthVisiting`.`location_id` = (828585)	0	0	0
SELECT `Direction`.`id`, `Direction`.`location_id`, `Direction`.`user_from`, `Direction`.`user_to`, `Direction`.`to` FROM `europe`.`directions` AS `Direction` WHERE `Direction`.`location_id` = (828585)	5	5	3	maybe slow
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 788013	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 806386	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 763868	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 793348	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 802290	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 828585	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 828585	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 828585	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 828585	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 828585	1	1	0
SELECT `Leg`.`id`, `Leg`.`direction_id` FROM `europe`.`legs` AS `Leg` WHERE `Leg`.`direction_id` IN (761, 762, 763, 764, 765)	0	0	0
SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`budget`, `Trip`.`start_location`, `Trip`.`trip_length`, `Trip`.`featured`, `Trip`.`user_id`, `Trip`.`created`, `Trip`.`modified`, `LocationsTrip`.`id`, `LocationsTrip`.`location_id`, `LocationsTrip`.`trip_id`, `LocationsTrip`.`days`, `LocationsTrip`.`budget`, `LocationsTrip`.`priority`, `LocationsTrip`.`notes`, `LocationsTrip`.`ignore`, `LocationsTrip`.`must_see`, `LocationsTrip`.`created`, `LocationsTrip`.`modified`, `LocationsTrip`.`end_date`, `LocationsTrip`.`start_date` FROM `europe`.`trips` AS `Trip` JOIN `europe`.`locations_trips` AS `LocationsTrip` ON (`LocationsTrip`.`location_id` = 828585 AND `LocationsTrip`.`trip_id` = `Trip`.`id`)	0	0	0
SELECT `Direction`.`id`, `Direction`.`location_id`, `Direction`.`user_from`, `Direction`.`user_to`, `Direction`.`to` FROM `europe`.`directions` AS `Direction` WHERE `location_id` = 757347 AND `to` = 828585 LIMIT 1	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id`, `Country`.`id`, `Country`.`code`, `Country`.`name`, `Country`.`full_name`, `Country`.`iso3`, `Country`.`number`, `Country`.`continent_code`, `Country`.`display_order`, `Country`.`flag_color`, `Country`.`currency_code`, `Country`.`currency_name`, `Country`.`languages`, `Country`.`iso2` FROM `europe`.`locations` AS `Location` LEFT JOIN `europe`.`countries` AS `Country` ON (`Location`.`country_id` = `Country`.`id`) WHERE `Location`.`id` = 757347 LIMIT 1	1	1	0
SELECT `WorthVisiting`.`id`, `WorthVisiting`.`location_id`, `WorthVisiting`.`is_it_worth_visiting`, `WorthVisiting`.`explain_why`, `WorthVisiting`.`created`, `WorthVisiting`.`modified`, `WorthVisiting`.`alternative_location`, `WorthVisiting`.`user_id` FROM `europe`.`worth_visitings` AS `WorthVisiting` WHERE `WorthVisiting`.`location_id` = (757347)	0	0	0
SELECT `Direction`.`id`, `Direction`.`location_id`, `Direction`.`user_from`, `Direction`.`user_to`, `Direction`.`to` FROM `europe`.`directions` AS `Direction` WHERE `Direction`.`location_id` = (757347)	5	5	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 838843	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 828585	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 838743	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 840487	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 838653	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 757347	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 757347	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 757347	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 757347	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 757347	1	1	0
SELECT `Leg`.`id`, `Leg`.`direction_id` FROM `europe`.`legs` AS `Leg` WHERE `Leg`.`direction_id` IN (261, 262, 263, 264, 265)	0	0	0
SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`budget`, `Trip`.`start_location`, `Trip`.`trip_length`, `Trip`.`featured`, `Trip`.`user_id`, `Trip`.`created`, `Trip`.`modified`, `LocationsTrip`.`id`, `LocationsTrip`.`location_id`, `LocationsTrip`.`trip_id`, `LocationsTrip`.`days`, `LocationsTrip`.`budget`, `LocationsTrip`.`priority`, `LocationsTrip`.`notes`, `LocationsTrip`.`ignore`, `LocationsTrip`.`must_see`, `LocationsTrip`.`created`, `LocationsTrip`.`modified`, `LocationsTrip`.`end_date`, `LocationsTrip`.`start_date` FROM `europe`.`trips` AS `Trip` JOIN `europe`.`locations_trips` AS `LocationsTrip` ON (`LocationsTrip`.`location_id` = 757347 AND `LocationsTrip`.`trip_id` = `Trip`.`id`)	0	0	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id`, `Country`.`id`, `Country`.`code`, `Country`.`name`, `Country`.`full_name`, `Country`.`iso3`, `Country`.`number`, `Country`.`continent_code`, `Country`.`display_order`, `Country`.`flag_color`, `Country`.`currency_code`, `Country`.`currency_name`, `Country`.`languages`, `Country`.`iso2` FROM `europe`.`locations` AS `Location` LEFT JOIN `europe`.`countries` AS `Country` ON (`Location`.`country_id` = `Country`.`id`) WHERE `Location`.`id` = 838743 LIMIT 1	1	1	0
SELECT `WorthVisiting`.`id`, `WorthVisiting`.`location_id`, `WorthVisiting`.`is_it_worth_visiting`, `WorthVisiting`.`explain_why`, `WorthVisiting`.`created`, `WorthVisiting`.`modified`, `WorthVisiting`.`alternative_location`, `WorthVisiting`.`user_id` FROM `europe`.`worth_visitings` AS `WorthVisiting` WHERE `WorthVisiting`.`location_id` = (838743)	0	0	0
SELECT `Direction`.`id`, `Direction`.`location_id`, `Direction`.`user_from`, `Direction`.`user_to`, `Direction`.`to` FROM `europe`.`directions` AS `Direction` WHERE `Direction`.`location_id` = (838743)	5	5	3	maybe slow
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 788013	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 806386	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 763868	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 793348	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 802290	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 838743	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 838743	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 838743	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 838743	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 838743	1	1	0
SELECT `Leg`.`id`, `Leg`.`direction_id` FROM `europe`.`legs` AS `Leg` WHERE `Leg`.`direction_id` IN (776, 777, 778, 779, 780)	0	0	0
SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`budget`, `Trip`.`start_location`, `Trip`.`trip_length`, `Trip`.`featured`, `Trip`.`user_id`, `Trip`.`created`, `Trip`.`modified`, `LocationsTrip`.`id`, `LocationsTrip`.`location_id`, `LocationsTrip`.`trip_id`, `LocationsTrip`.`days`, `LocationsTrip`.`budget`, `LocationsTrip`.`priority`, `LocationsTrip`.`notes`, `LocationsTrip`.`ignore`, `LocationsTrip`.`must_see`, `LocationsTrip`.`created`, `LocationsTrip`.`modified`, `LocationsTrip`.`end_date`, `LocationsTrip`.`start_date` FROM `europe`.`trips` AS `Trip` JOIN `europe`.`locations_trips` AS `LocationsTrip` ON (`LocationsTrip`.`location_id` = 838743 AND `LocationsTrip`.`trip_id` = `Trip`.`id`)	0	0	0
SELECT `Direction`.`id`, `Direction`.`location_id`, `Direction`.`user_from`, `Direction`.`user_to`, `Direction`.`to` FROM `europe`.`directions` AS `Direction` WHERE `location_id` = 757347 AND `to` = 838743 LIMIT 1	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id`, `Country`.`id`, `Country`.`code`, `Country`.`name`, `Country`.`full_name`, `Country`.`iso3`, `Country`.`number`, `Country`.`continent_code`, `Country`.`display_order`, `Country`.`flag_color`, `Country`.`currency_code`, `Country`.`currency_name`, `Country`.`languages`, `Country`.`iso2` FROM `europe`.`locations` AS `Location` LEFT JOIN `europe`.`countries` AS `Country` ON (`Location`.`country_id` = `Country`.`id`) WHERE `Location`.`id` = 757347 LIMIT 1	1	1	0
SELECT `WorthVisiting`.`id`, `WorthVisiting`.`location_id`, `WorthVisiting`.`is_it_worth_visiting`, `WorthVisiting`.`explain_why`, `WorthVisiting`.`created`, `WorthVisiting`.`modified`, `WorthVisiting`.`alternative_location`, `WorthVisiting`.`user_id` FROM `europe`.`worth_visitings` AS `WorthVisiting` WHERE `WorthVisiting`.`location_id` = (757347)	0	0	0
SELECT `Direction`.`id`, `Direction`.`location_id`, `Direction`.`user_from`, `Direction`.`user_to`, `Direction`.`to` FROM `europe`.`directions` AS `Direction` WHERE `Direction`.`location_id` = (757347)	5	5	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 838843	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 828585	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 838743	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 840487	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 838653	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 757347	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 757347	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 757347	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 757347	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 757347	1	1	0
SELECT `Leg`.`id`, `Leg`.`direction_id` FROM `europe`.`legs` AS `Leg` WHERE `Leg`.`direction_id` IN (261, 262, 263, 264, 265)	0	0	0
SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`budget`, `Trip`.`start_location`, `Trip`.`trip_length`, `Trip`.`featured`, `Trip`.`user_id`, `Trip`.`created`, `Trip`.`modified`, `LocationsTrip`.`id`, `LocationsTrip`.`location_id`, `LocationsTrip`.`trip_id`, `LocationsTrip`.`days`, `LocationsTrip`.`budget`, `LocationsTrip`.`priority`, `LocationsTrip`.`notes`, `LocationsTrip`.`ignore`, `LocationsTrip`.`must_see`, `LocationsTrip`.`created`, `LocationsTrip`.`modified`, `LocationsTrip`.`end_date`, `LocationsTrip`.`start_date` FROM `europe`.`trips` AS `Trip` JOIN `europe`.`locations_trips` AS `LocationsTrip` ON (`LocationsTrip`.`location_id` = 757347 AND `LocationsTrip`.`trip_id` = `Trip`.`id`)	0	0	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id`, `Country`.`id`, `Country`.`code`, `Country`.`name`, `Country`.`full_name`, `Country`.`iso3`, `Country`.`number`, `Country`.`continent_code`, `Country`.`display_order`, `Country`.`flag_color`, `Country`.`currency_code`, `Country`.`currency_name`, `Country`.`languages`, `Country`.`iso2` FROM `europe`.`locations` AS `Location` LEFT JOIN `europe`.`countries` AS `Country` ON (`Location`.`country_id` = `Country`.`id`) WHERE `Location`.`id` = 840487 LIMIT 1	1	1	0
SELECT `WorthVisiting`.`id`, `WorthVisiting`.`location_id`, `WorthVisiting`.`is_it_worth_visiting`, `WorthVisiting`.`explain_why`, `WorthVisiting`.`created`, `WorthVisiting`.`modified`, `WorthVisiting`.`alternative_location`, `WorthVisiting`.`user_id` FROM `europe`.`worth_visitings` AS `WorthVisiting` WHERE `WorthVisiting`.`location_id` = (840487)	0	0	0
SELECT `Direction`.`id`, `Direction`.`location_id`, `Direction`.`user_from`, `Direction`.`user_to`, `Direction`.`to` FROM `europe`.`directions` AS `Direction` WHERE `Direction`.`location_id` = (840487)	5	5	2	maybe slow
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 788013	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 806386	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 793348	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 802290	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 763868	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 840487	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 840487	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 840487	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 840487	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 840487	1	1	0
SELECT `Leg`.`id`, `Leg`.`direction_id` FROM `europe`.`legs` AS `Leg` WHERE `Leg`.`direction_id` IN (786, 787, 788, 789, 790)	0	0	0
SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`budget`, `Trip`.`start_location`, `Trip`.`trip_length`, `Trip`.`featured`, `Trip`.`user_id`, `Trip`.`created`, `Trip`.`modified`, `LocationsTrip`.`id`, `LocationsTrip`.`location_id`, `LocationsTrip`.`trip_id`, `LocationsTrip`.`days`, `LocationsTrip`.`budget`, `LocationsTrip`.`priority`, `LocationsTrip`.`notes`, `LocationsTrip`.`ignore`, `LocationsTrip`.`must_see`, `LocationsTrip`.`created`, `LocationsTrip`.`modified`, `LocationsTrip`.`end_date`, `LocationsTrip`.`start_date` FROM `europe`.`trips` AS `Trip` JOIN `europe`.`locations_trips` AS `LocationsTrip` ON (`LocationsTrip`.`location_id` = 840487 AND `LocationsTrip`.`trip_id` = `Trip`.`id`)	0	0	0
SELECT `Direction`.`id`, `Direction`.`location_id`, `Direction`.`user_from`, `Direction`.`user_to`, `Direction`.`to` FROM `europe`.`directions` AS `Direction` WHERE `location_id` = 757347 AND `to` = 840487 LIMIT 1	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id`, `Country`.`id`, `Country`.`code`, `Country`.`name`, `Country`.`full_name`, `Country`.`iso3`, `Country`.`number`, `Country`.`continent_code`, `Country`.`display_order`, `Country`.`flag_color`, `Country`.`currency_code`, `Country`.`currency_name`, `Country`.`languages`, `Country`.`iso2` FROM `europe`.`locations` AS `Location` LEFT JOIN `europe`.`countries` AS `Country` ON (`Location`.`country_id` = `Country`.`id`) WHERE `Location`.`id` = 757347 LIMIT 1	1	1	0
SELECT `WorthVisiting`.`id`, `WorthVisiting`.`location_id`, `WorthVisiting`.`is_it_worth_visiting`, `WorthVisiting`.`explain_why`, `WorthVisiting`.`created`, `WorthVisiting`.`modified`, `WorthVisiting`.`alternative_location`, `WorthVisiting`.`user_id` FROM `europe`.`worth_visitings` AS `WorthVisiting` WHERE `WorthVisiting`.`location_id` = (757347)	0	0	0
SELECT `Direction`.`id`, `Direction`.`location_id`, `Direction`.`user_from`, `Direction`.`user_to`, `Direction`.`to` FROM `europe`.`directions` AS `Direction` WHERE `Direction`.`location_id` = (757347)	5	5	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 838843	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 828585	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 838743	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 840487	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 838653	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 757347	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 757347	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 757347	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 757347	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 757347	1	1	0
SELECT `Leg`.`id`, `Leg`.`direction_id` FROM `europe`.`legs` AS `Leg` WHERE `Leg`.`direction_id` IN (261, 262, 263, 264, 265)	0	0	0
SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`budget`, `Trip`.`start_location`, `Trip`.`trip_length`, `Trip`.`featured`, `Trip`.`user_id`, `Trip`.`created`, `Trip`.`modified`, `LocationsTrip`.`id`, `LocationsTrip`.`location_id`, `LocationsTrip`.`trip_id`, `LocationsTrip`.`days`, `LocationsTrip`.`budget`, `LocationsTrip`.`priority`, `LocationsTrip`.`notes`, `LocationsTrip`.`ignore`, `LocationsTrip`.`must_see`, `LocationsTrip`.`created`, `LocationsTrip`.`modified`, `LocationsTrip`.`end_date`, `LocationsTrip`.`start_date` FROM `europe`.`trips` AS `Trip` JOIN `europe`.`locations_trips` AS `LocationsTrip` ON (`LocationsTrip`.`location_id` = 757347 AND `LocationsTrip`.`trip_id` = `Trip`.`id`)	0	0	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id`, `Country`.`id`, `Country`.`code`, `Country`.`name`, `Country`.`full_name`, `Country`.`iso3`, `Country`.`number`, `Country`.`continent_code`, `Country`.`display_order`, `Country`.`flag_color`, `Country`.`currency_code`, `Country`.`currency_name`, `Country`.`languages`, `Country`.`iso2` FROM `europe`.`locations` AS `Location` LEFT JOIN `europe`.`countries` AS `Country` ON (`Location`.`country_id` = `Country`.`id`) WHERE `Location`.`id` = 838653 LIMIT 1	1	1	0
SELECT `WorthVisiting`.`id`, `WorthVisiting`.`location_id`, `WorthVisiting`.`is_it_worth_visiting`, `WorthVisiting`.`explain_why`, `WorthVisiting`.`created`, `WorthVisiting`.`modified`, `WorthVisiting`.`alternative_location`, `WorthVisiting`.`user_id` FROM `europe`.`worth_visitings` AS `WorthVisiting` WHERE `WorthVisiting`.`location_id` = (838653)	0	0	0
SELECT `Direction`.`id`, `Direction`.`location_id`, `Direction`.`user_from`, `Direction`.`user_to`, `Direction`.`to` FROM `europe`.`directions` AS `Direction` WHERE `Direction`.`location_id` = (838653)	5	5	3	maybe slow
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 763868	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 806386	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 788013	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 1093733	1	1	0
SELECT `To`.`id`, `To`.`iso2`, `To`.`region`, `To`.`population`, `To`.`lat`, `To`.`lng`, `To`.`city`, `To`.`country_id` FROM `europe`.`locations` AS `To` WHERE `To`.`id` = 1094675	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 838653	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 838653	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 838653	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 838653	1	1	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id` FROM `europe`.`locations` AS `Location` WHERE `Location`.`id` = 838653	1	1	0
SELECT `Leg`.`id`, `Leg`.`direction_id` FROM `europe`.`legs` AS `Leg` WHERE `Leg`.`direction_id` IN (921, 922, 923, 924, 925)	0	0	0
SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`budget`, `Trip`.`start_location`, `Trip`.`trip_length`, `Trip`.`featured`, `Trip`.`user_id`, `Trip`.`created`, `Trip`.`modified`, `LocationsTrip`.`id`, `LocationsTrip`.`location_id`, `LocationsTrip`.`trip_id`, `LocationsTrip`.`days`, `LocationsTrip`.`budget`, `LocationsTrip`.`priority`, `LocationsTrip`.`notes`, `LocationsTrip`.`ignore`, `LocationsTrip`.`must_see`, `LocationsTrip`.`created`, `LocationsTrip`.`modified`, `LocationsTrip`.`end_date`, `LocationsTrip`.`start_date` FROM `europe`.`trips` AS `Trip` JOIN `europe`.`locations_trips` AS `LocationsTrip` ON (`LocationsTrip`.`location_id` = 838653 AND `LocationsTrip`.`trip_id` = `Trip`.`id`)	0	0	0
SELECT `Direction`.`id`, `Direction`.`location_id`, `Direction`.`user_from`, `Direction`.`user_to`, `Direction`.`to` FROM `europe`.`directions` AS `Direction` WHERE `location_id` = 757347 AND `to` = 838653 LIMIT 1	1	1	1
Select 100/count(location_id) * sum(case is_it_worth_visiting when 1 then 1 else 0 end) as worthVisitingPercentage From worth_visitings WHERE location_id = 757347	1	1	0

116 duplicate queries run.

Query Explain:

Click an "Explain" link above, to see the query explanation.

====

Timer

Memory

Peak Memory Use 8.64 MB

Message	Memory use
Component initialization	1.66 MB
Controller action start	2.32 MB
Controller render start	3.66 MB
View render complete	4.05 MB

Timers

Total Request Time: 636 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	11.38
Event: Controller.startup	0.85
Controller action	487.33
Event: Controller.beforeRender	16.02
» Processing toolbar data	15.85
Rendering View	3.69
» Event: View.beforeRender	0.04
» Rendering APP/View/Locations/view.ctp	1.71
» Event: View.afterRender	0.03
» Event: View.beforeLayout	0.03
» Rendering APP/View/Layouts/default.ctp	1.16
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- title_for_layoutAngers, France - one of the best European backpacking destinations for 2016?
- worthVisitingPercentage(null)
- closestSameCities(array)
  0(array)
  locations(array)
  id800095
  population284677
  cityNantes, France
  lat47.216667
  lng-1.55
  0(array)
  isofr
  distance_in_km80.20386771515821
  1(array)
  locations(array)
  id806386
  population213334
  cityRennes, France
  lat48.083333
  lng-1.683333
  0(array)
  isofr
  distance_in_km108.82128723877506
  2(array)
  locations(array)
  id788013
  population188605
  cityLe Havre, France
  lat49.5
  lng.133333
  0(array)
  isofr
  distance_in_km231.32279397221416
  3(array)
  locations(array)
  id802290
  population2110694
  cityParis, France
  lat48.866667
  lng2.333333
  0(array)
  isofr
  distance_in_km264.11325713339806
  4(array)
  locations(array)
  id762699
  population219311
  cityBordeaux, France
  lat44.833333
  lng-.566667
  0(array)
  isofr
  distance_in_km292.42138290440863
  5(array)
  locations(array)
  id763868
  population150554
  cityBrest, France
  lat48.4
  lng-4.483333
  0(array)
  isofr
  distance_in_km310.4052712192352
  6(array)
  locations(array)
  id806276
  population192688
  cityReims, France
  lat49.25
  lng4.033333
  0(array)
  isofr
  distance_in_km391.80025520052664
  7(array)
  locations(array)
  id771982
  population153692
  cityDijon, France
  lat47.316667
  lng5.016667
  0(array)
  isofr
  distance_in_km418.71911874305425
  8(array)
  locations(array)
  id793348
  population189746
  cityLille, France
  lat50.633333
  lng3.066667
  0(array)
  isofr
  distance_in_km439.12935979960156
  9(array)
  locations(array)
  id810011
  population170416
  citySaint-Étienne, France
  lat45.433333
  lng4.4
  0(array)
  isofr
  distance_in_km440.79124892685144
  10(array)
  locations(array)
  id794590
  population463700
  cityLyon, France
  lat45.75
  lng4.85
  0(array)
  isofr
  distance_in_km453.7784033942246
  11(array)
  locations(array)
  id817884
  population411145
  cityToulouse, France
  lat43.6
  lng1.433333
  0(array)
  isofr
  distance_in_km456.20703028744106
  12(array)
  locations(array)
  id777671
  population154853
  cityGrenoble, France
  lat45.166667
  lng5.716667
  0(array)
  isofr
  distance_in_km544.0395790069675
  13(array)
  locations(array)
  id799022
  population238887
  cityMontpellier, France
  lat43.6
  lng3.883333
  0(array)
  isofr
  distance_in_km550.5176177209092
  14(array)
  locations(array)
  id816584
  population273506
  cityStrasbourg, France
  lat48.583333
  lng7.75
  0(array)
  isofr
  distance_in_km628.4320739692375
  15(array)
  locations(array)
  id795894
  population792823
  cityMarseille, France
  lat43.3
  lng5.4
  0(array)
  isofr
  distance_in_km654.9408923830076
  16(array)
  locations(array)
  id817878
  population154465
  cityToulon, France
  lat43.116667
  lng5.933333
  0(array)
  isofr
  distance_in_km699.4382374900205
  17(array)
  locations(array)
  id800596
  population341621
  cityNice, France
  lat43.7
  lng7.25
  0(array)
  isofr
  distance_in_km735.9245998795061
- closestCities(array)
  0(array)
  locations(array)
  id838843
  population194151
  cityPortsmouth, Great Britain (UK)
  lat50.7967
  lng-1.083333
  0(array)
  isogb
  distance_in_km371.8056074200023
  1(array)
  locations(array)
  id828585
  population175017
  cityBournemouth, Great Britain (UK)
  lat50.716667
  lng-1.883333
  0(array)
  isogb
  distance_in_km373.6762768891612
  2(array)
  locations(array)
  id838743
  population150092
  cityPoole, Great Britain (UK)
  lat50.716667
  lng-2
  0(array)
  isogb
  distance_in_km375.96364695468435
  3(array)
  locations(array)
  id840487
  population246201
  citySouthampton, Great Britain (UK)
  lat50.9
  lng-1.4
  0(array)
  isogb
  distance_in_km386.20668298640874
  4(array)
  locations(array)
  id838653
  population247298
  cityPlymouth, Great Britain (UK)
  lat50.396389
  lng-4.138611
  0(array)
  isogb
  distance_in_km417.48201019881355
- trips(empty)
- location(array)
  Location(array)
  id757347
  iso2fr
  regionB5
  population158585
  lat47.466667
  lng-.55
  cityAngers, France
  country_id(null)
  picture/img/location/757347.jpg
  settlement_typeCity
  Country(array)
  id(null)
  code(null)
  name(null)
  full_name(null)
  iso3(null)
  number(null)
  continent_code(null)
  display_order(null)
  flag_color(null)
  currency_code(null)
  currency_name(null)
  languages(null)
  iso2(null)
  WorthVisiting(empty)
  Direction(array)
  0(array)
  id261
  location_id757347
  user_from(null)
  user_to(null)
  to838843
  To(array)
  id838843
  iso2gb
  regionK6
  population194151
  lat50.7967
  lng-1.083333
  cityPortsmouth, Great Britain (UK)
  country_id(null)
  picture/img/location/grid-default-thumb.png
  settlement_typeCity
  Location(array)
  id757347
  iso2fr
  regionB5
  population158585
  lat47.466667
  lng-.55
  cityAngers, France
  country_id(null)
  picture/img/location/757347.jpg
  settlement_typeCity
  Leg(empty)
  1(array)
  id262
  location_id757347
  user_from(null)
  user_to(null)
  to828585
  To(array)
  id828585
  iso2gb
  regionB2
  population175017
  lat50.716667
  lng-1.883333
  cityBournemouth, Great Britain (UK)
  country_id(null)
  picture/img/location/grid-default-thumb.png
  settlement_typeCity
  Location(array)
  id757347
  iso2fr
  regionB5
  population158585
  lat47.466667
  lng-.55
  cityAngers, France
  country_id(null)
  picture/img/location/757347.jpg
  settlement_typeCity
  Leg(empty)
  2(array)
  id263
  location_id757347
  user_from(null)
  user_to(null)
  to838743
  To(array)
  id838743
  iso2gb
  regionK5
  population150092
  lat50.716667
  lng-2
  cityPoole, Great Britain (UK)
  country_id(null)
  picture/img/location/grid-default-thumb.png
  settlement_typeCity
  Location(array)
  id757347
  iso2fr
  regionB5
  population158585
  lat47.466667
  lng-.55
  cityAngers, France
  country_id(null)
  picture/img/location/757347.jpg
  settlement_typeCity
  Leg(empty)
  3(array)
  id264
  location_id757347
  user_from(null)
  user_to(null)
  to840487
  To(array)
  id840487
  iso2gb
  regionM4
  population246201
  lat50.9
  lng-1.4
  citySouthampton, Great Britain (UK)
  country_id(null)
  picture/img/location/grid-default-thumb.png
  settlement_typeCity
  Location(array)
  id757347
  iso2fr
  regionB5
  population158585
  lat47.466667
  lng-.55
  cityAngers, France
  country_id(null)
  picture/img/location/757347.jpg
  settlement_typeCity
  Leg(empty)
  4(array)
  id265
  location_id757347
  user_from(null)
  user_to(null)
  to838653
  To(array)
  id838653
  iso2gb
  regionK4
  population247298
  lat50.396389
  lng-4.138611
  cityPlymouth, Great Britain (UK)
  country_id(null)
  picture/img/location/grid-default-thumb.png
  settlement_typeCity
  Location(array)
  id757347
  iso2fr
  regionB5
  population158585
  lat47.466667
  lng-.55
  cityAngers, France
  country_id(null)
  picture/img/location/757347.jpg
  settlement_typeCity
  Leg(empty)
  Trip(empty)
- url_for_layoutsolobackpackers.com
- user_for_layout(null)
- $request->data(empty)
- $this->validationErrors(array)
  Location(empty)
  User(empty)
  Activity(empty)
  LocationsTrip(empty)
  Trip(empty)
  Country(empty)
  WorthVisiting(empty)
  Direction(empty)
  To(empty)
  Leg(empty)
- Loaded Helpers(array)
  0Number
  1SimpleGraph
  2DebugTimer
  3Toolbar
  4Html
  5Session
  6HtmlToolbar
  7Form
====

Environment

App Constants

Constant	Value
CONFIG	'/usr/share/nginx/html/app/app/Config/'

CakePHP Constants

Constant	Value
APP	'/usr/share/nginx/html/app/app/'
APP_DIR	'app'
APPLIBS	'/usr/share/nginx/html/app/app/Lib/'
CACHE	'/usr/share/nginx/html/app/tmp/cache/'
CAKE	'/usr/share/nginx/html/app/vendor/cakephp/cakephp/lib/Cake/'
CAKE_CORE_INCLUDE_PATH	'/usr/share/nginx/html/app/vendor/cakephp/cakephp/lib'
CORE_PATH	'/usr/share/nginx/html/app/vendor/cakephp/cakephp/lib/'
CAKE_VERSION	'2.10.12'
CSS	'/usr/share/nginx/html/app/webroot/css/'
CSS_URL	'css/'
DS	'/'
FULL_BASE_URL	'http://solobackpackers.com'
IMAGES	'/usr/share/nginx/html/app/webroot/img/'
IMAGES_URL	'img/'
JS	'/usr/share/nginx/html/app/webroot/js/'
JS_URL	'js/'
LOGS	'/usr/share/nginx/html/app/tmp/logs/'
ROOT	'/usr/share/nginx/html/app'
TESTS	'/usr/share/nginx/html/app/app/Test/'
TMP	'/usr/share/nginx/html/app/tmp/'
VENDORS	'/usr/share/nginx/html/app/vendors/'
WEBROOT_DIR	'webroot'
WWW_ROOT	'/usr/share/nginx/html/app/webroot/'

PHP Environment

Environment Variable	Value
Php Version	'5.5.9-1ubuntu4.26'
User	'www-data'
Home	'/var/www'
Fcgi Role	'RESPONDER'
Query String	''
Request Method	'GET'
Content Type	''
Content Length	''
Script Filename	'/usr/share/nginx/html/app/webroot/index.php'
Script Name	'/index.php'
Request Uri	'/locations/view/757347'
Document Uri	'/index.php'
Document Root	'/usr/share/nginx/html/app/webroot'
Server Protocol	'HTTP/1.1'
Gateway Interface	'CGI/1.1'
Server Software	'nginx/1.4.6'
Remote Addr	'54.198.15.20'
Remote Port	'41596'
Server Addr	'138.68.135.139'
Server Port	'80'
Server Name	''
Redirect Status	'200'
Http User Agent	'CCBot/2.0 (https://commoncrawl.org/faq/)'
Http Accept	'text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8'
Http Host	'solobackpackers.com'
Http Connection	'Keep-Alive'
Http Accept Encoding	'gzip'
Php Self	'/index.php'
Request Time Float	(float) 1539638994.3515
Request Time	(int) 1539638994
App Name	'app'
Debug	(int) 2
Security Salt	'DYhG93b0qyJfIxfs2guVoUubWwvniR2G0FgaC9mi'
Security Cipher Seed	'76859309657453542496749683645'
Database Test Url	'mysql://root@localhost/europe?encoding=utf8'
Database Url	'mysql://root@localhost/europe?encoding=utf8'
Cache Url	'file:///CACHE/?prefix=APP_NAME_&duration=DURATION'
Cache Debug Kit Url	'file:///CACHE/?prefix=APP_NAME_debug_kit_&duration=DURATION'
Cache Cake Core Url	'file:///CACHE/?prefix=APP_NAME_cake_core_&duration=DURATION'
Cache Cake Model Url	'file:///CACHE/?prefix=APP_NAME_cake_model_&duration=DURATION'
Log Url	'file:///LOGS/?types=notice,info,debug&file=debug'
Log Error Url	'file:///LOGS/?types=warning,error,critical,alert,emergency&file=error'
Email Url	'mail://localhost/?from=you@localhost'
Email Smtp Url	'smtp://user:secret@localhost:25/?from[site@localhost]=My+Site&timeout=30'
Email Fast Url	'smtp://user:secret@localhost:25/?from=you@localhost&messageId=1&template=0&layout=0&timeout=30'

====

Include
+
Included Files

Include Paths
- 1/usr/share/php
- 2/usr/share/pear
- 3-> /usr/share/nginx/html/app/vendor/cakephp/cakephp/lib/Cake/
Included Files
- core(array)
  Behavior(array)
  0CORE/Model/Behavior/ContainableBehavior.php
  Cache(array)
  0CORE/Cache/Cache.php
  1CORE/Cache/Engine/FileEngine.php
  2CORE/Cache/CacheEngine.php
  Component(array)
  0CORE/Controller/Component/RequestHandlerComponent.php
  1CORE/Controller/Component/SessionComponent.php
  2CORE/Controller/Component/PaginatorComponent.php
  3CORE/Controller/Component/AuthComponent.php
  4CORE/Controller/Component/Auth/FormAuthenticate.php
  5CORE/Controller/Component/Auth/BaseAuthenticate.php
  Config(array)
  0CORE/Config/routes.php
  1CORE/Config/config.php
  Controller(array)
  0CORE/Controller/Controller.php
  1CORE/Controller/ComponentCollection.php
  2CORE/Controller/Component.php
  Datasource(array)
  0CORE/Model/Datasource/CakeSession.php
  1CORE/Model/Datasource/Database/Mysql.php
  2CORE/Model/Datasource/DboSource.php
  3CORE/Model/Datasource/DataSource.php
  Error(array)
  0CORE/Error/exceptions.php
  1CORE/Error/ErrorHandler.php
  I18n(array)
  0CORE/I18n/I18n.php
  1CORE/I18n/L10n.php
  Log(array)
  0CORE/Log/CakeLog.php
  1CORE/Log/LogEngineCollection.php
  2CORE/Log/Engine/FileLog.php
  3CORE/Log/Engine/BaseLog.php
  4CORE/Log/CakeLogInterface.php
  Model(array)
  0CORE/Model/Model.php
  1CORE/Model/BehaviorCollection.php
  2CORE/Model/ModelBehavior.php
  3CORE/Model/ConnectionManager.php
  Network(array)
  0CORE/Network/CakeRequest.php
  1CORE/Network/CakeResponse.php
  Other(array)
  0CORE/bootstrap.php
  1CORE/basics.php
  2CORE/Core/App.php
  3CORE/Core/Configure.php
  4CORE/Core/CakePlugin.php
  5CORE/Event/CakeEventManager.php
  6CORE/Event/CakeEventListener.php
  7CORE/Event/CakeEvent.php
  8CORE/Core/CakeObject.php
  9CORE/Core/Object.php
  Routing(array)
  0CORE/Routing/Dispatcher.php
  1CORE/Routing/Filter/AssetDispatcher.php
  2CORE/Routing/DispatcherFilter.php
  3CORE/Routing/Filter/CacheDispatcher.php
  4CORE/Routing/Router.php
  5CORE/Routing/Route/CakeRoute.php
  6CORE/Routing/Route/PluginShortRoute.php
  Utility(array)
  0CORE/Utility/Hash.php
  1CORE/Utility/ObjectCollection.php
  2CORE/Utility/Inflector.php
  3CORE/Utility/Debugger.php
  4CORE/Utility/CakeText.php
  5CORE/Utility/ClassRegistry.php
  View(array)
  0CORE/View/HelperCollection.php
- app(array)
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/routes.php
  3APP/Config/database.php
  Controller(array)
  0APP/Controller/LocationsController.php
  1APP/Controller/AppController.php
  Model(array)
  0APP/Model/Location.php
  1APP/Model/AppModel.php
  2APP/Model/User.php
  3APP/Model/Activity.php
  4APP/Model/LocationsTrip.php
  5APP/Model/Trip.php
  6APP/Model/Country.php
  7APP/Model/WorthVisiting.php
  8APP/Model/Direction.php
  9APP/Model/Leg.php
- plugins(array)
  Crud(array)
  Plugin(array)
  0Crud/Lib/CrudControllerTrait.php
  1Crud/Lib/Panel/CrudPanel.php
  Component(array)
  0Crud/Controller/Component/CrudComponent.php
  Controller(array)
  0Crud/Controller/Crud/CrudSubject.php
  1Crud/Controller/Crud/Listener/RelatedModelsListener.php
  2Crud/Controller/Crud/CrudListener.php
  3Crud/Controller/Crud/CrudBaseObject.php
  4Crud/Controller/Crud/Listener/DebugKitListener.php
  5Crud/Controller/Crud/Listener/ApiListener.php
  6Crud/Controller/Crud/Listener/ApiPaginationListener.php
  7Crud/Controller/Crud/Listener/ApiQueryLogListener.php
  DebugKit(array)
  Component(array)
  0DebugKit/Controller/Component/ToolbarComponent.php
  Plugin(array)
  0DebugKit/Lib/DebugMemory.php
  1DebugKit/Lib/Panel/HistoryPanel.php
  2DebugKit/Lib/DebugPanel.php
  3DebugKit/Lib/Panel/SessionPanel.php
  4DebugKit/Lib/Panel/RequestPanel.php
  5DebugKit/Lib/Panel/SqlLogPanel.php
  6DebugKit/Lib/Panel/TimerPanel.php
  7DebugKit/Lib/Panel/LogPanel.php
  8DebugKit/Lib/Log/Engine/DebugKitLog.php
  9DebugKit/Lib/Panel/VariablesPanel.php
  10DebugKit/Lib/Panel/EnvironmentPanel.php
  11DebugKit/Lib/Panel/IncludePanel.php
  12DebugKit/Lib/DebugTimer.php
====
Crud
+
Config
- ActionCurrent action is not handled by Crud
- Component(array)
  actions(empty)
  eventPrefixCrud
  listeners(array)
  RelatedModels(array)
  classNameCrud.RelatedModels
  DebugKit(array)
  classNameCrud.DebugKit
  Api(array)
  classNameCrud.Api
  ApiPagination(array)
  classNameCrud.ApiPagination
  ApiQueryLog(array)
  classNameCrud.ApiQueryLog
  messages(array)
  domaincrud
  invalidId(array)
  code400
  classBadRequestException
  textInvalid id
  recordNotFound(array)
  code404
  classNotFoundException
  textNot found
  badRequestMethod(array)
  code405
  classMethodNotAllowedException
  textMethod not allowed. This action permits only {methods}
  eventLogging(true)
- Listeners(array)
  RelatedModels(array)
  classNameCrud.RelatedModels
  DebugKit(array)
  classNameCrud.DebugKit
  Api(array)
  viewClasses(array)
  jsonCrud.CrudJson
  xmlCrud.CrudXml
  detectors(array)
  json(array)
  extjson
  acceptsapplication/json
  xml(array)
  extxml
  acceptstext/xml
  exception(array)
  typedefault
  classBadRequestException
  messageUnknown error
  code0
  classNameCrud.Api
  ApiPagination(array)
  classNameCrud.ApiPagination
  ApiQueryLog(array)
  classNameCrud.ApiQueryLog
Events triggered
- Crud.startup(array)
  data(empty)
  callbacks(array)
  0DebugKitListener::startup
====

Angers, France

Angers, France

0% of people recommend visiting Angers, France

Angers, France

Is Angers, France worth visiting?

No recommendations have been made. Create an account to add one.

Trips that visit Angers, France

No trips visit Angers, France yet

Nearby cities

Closest cities in same country

Closest EU cities

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 72 ms Total Queries: 175 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Config

Events triggered

Total Time: 72 ms
Total Queries: 175 queries