Dublin, Ireland

0% of people recommend visiting Dublin, Ireland

Dublin, Ireland

0% of people recommend Dublin, Ireland

Is Dublin, Ireland worth visiting?

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

Trips that visit Dublin, Ireland

Trip starting at London, Great Britain (UK)

Nearby cities

Closest cities in same country

	City	Distance
	Cork, Ireland	219km

Closest EU cities

	City	Distance
	Belfast, Great Britain (UK)	140km
	Liverpool, Great Britain (UK)	215km
	Preston, Great Britain (UK)	237km
	Swansea, Great Britain (UK)	243km
	Manchester, Great Britain (UK)	267km

History
+
Request History
1 previous requests available
- Restore to current request
- locations/view/553851
====
Session
+
Session
- 0(null)
====
Request
+
Request

Cake Params
- plugin(null)
- controllerlocations
- actionview
- named(empty)
- pass(array)
  01094675
- 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: 207 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `Suggestion`.`id`, `Suggestion`.`location_id`, `Suggestion`.`locations_trip_id`, `Suggestion`.`suggestion`, `Suggestion`.`user_id`, `Suggestion`.`trip_id`, `Suggestion`.`accepted`, `Suggestion`.`created`, `Suggestion`.`modified` FROM `europe`.`suggestions` AS `Suggestion` WHERE `Suggestion`.`trip_id` = (95)	0	0	0
SELECT `Message`.`id`, `Message`.`trip_id`, `Message`.`user_id`, `Message`.`locations_trip_id`, `Message`.`created` FROM `europe`.`messages` AS `Message` WHERE `Message`.`trip_id` = (95)	0	0	0
SELECT `Location`.`id`, `Location`.`iso2`, `Location`.`region`, `Location`.`population`, `Location`.`lat`, `Location`.`lng`, `Location`.`city`, `Location`.`country_id`, `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`.`locations` AS `Location` JOIN `europe`.`locations_trips` AS `LocationsTrip` ON (`LocationsTrip`.`trip_id` = 95 AND `LocationsTrip`.`location_id` = `Location`.`id`) ORDER BY `LocationsTrip`.`priority` ASC	5	5	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` = 1094675 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` = (1094675)	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` = (1094675)	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` = 828007	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` = 835853	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` = 838918	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` = 841229	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` = 836729	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` = 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` = 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` = 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` = 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` = 1094675	1	1	0
SELECT `Leg`.`id`, `Leg`.`direction_id` FROM `europe`.`legs` AS `Leg` WHERE `Leg`.`direction_id` IN (101, 102, 103, 104, 105)	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` = 1094675 AND `LocationsTrip`.`trip_id` = `Trip`.`id`)	1	1	0
SELECT `StartingLocation`.`id`, `StartingLocation`.`iso2`, `StartingLocation`.`region`, `StartingLocation`.`population`, `StartingLocation`.`lat`, `StartingLocation`.`lng`, `StartingLocation`.`city`, `StartingLocation`.`country_id` FROM `europe`.`locations` AS `StartingLocation` WHERE `StartingLocation`.`id` = 836336	1	1	0
SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`name`, `User`.`email`, `User`.`role`, `User`.`date_of_birth`, `User`.`country_id`, `User`.`created`, `User`.`modified`, `User`.`gender`, `User`.`about`, `User`.`what_i_love_most_about_backpacking`, `User`.`what_i_hate_about_backpacking`, `User`.`photo`, (YEAR(NOW())-YEAR(date_of_birth)) AS `User__age` FROM `europe`.`users` AS `User` WHERE `User`.`id` = 34	1	1	0
SELECT `Suggestion`.`id`, `Suggestion`.`location_id`, `Suggestion`.`locations_trip_id`, `Suggestion`.`suggestion`, `Suggestion`.`user_id`, `Suggestion`.`trip_id`, `Suggestion`.`accepted`, `Suggestion`.`created`, `Suggestion`.`modified` FROM `europe`.`suggestions` AS `Suggestion` WHERE `Suggestion`.`trip_id` = (95)	0	0	0
SELECT `Message`.`id`, `Message`.`trip_id`, `Message`.`user_id`, `Message`.`locations_trip_id`, `Message`.`created` FROM `europe`.`messages` AS `Message` WHERE `Message`.`trip_id` = (95)	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 53.3330556 AS latpoint, -6.2488889 AS longpoint ) AS p ON 1=1 WHERE iso2 != "ie" AND population > 150000 AND id != 1094675 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 53.3330556 AS latpoint, -6.2488889 AS longpoint ) AS p ON 1=1 WHERE iso2 = "ie" AND population > 150000 AND id != 1094675 ORDER BY distance_in_km LIMIT 25	1	1	35	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` = 1094675 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` = (1094675)	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` = (1094675)	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` = 828007	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` = 835853	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` = 838918	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` = 841229	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` = 836729	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` = 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` = 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` = 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` = 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` = 1094675	1	1	0
SELECT `Leg`.`id`, `Leg`.`direction_id` FROM `europe`.`legs` AS `Leg` WHERE `Leg`.`direction_id` IN (101, 102, 103, 104, 105)	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` = 1094675 AND `LocationsTrip`.`trip_id` = `Trip`.`id`)	1	1	0
SELECT `StartingLocation`.`id`, `StartingLocation`.`iso2`, `StartingLocation`.`region`, `StartingLocation`.`population`, `StartingLocation`.`lat`, `StartingLocation`.`lng`, `StartingLocation`.`city`, `StartingLocation`.`country_id` FROM `europe`.`locations` AS `StartingLocation` WHERE `StartingLocation`.`id` = 836336	1	1	0
SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`name`, `User`.`email`, `User`.`role`, `User`.`date_of_birth`, `User`.`country_id`, `User`.`created`, `User`.`modified`, `User`.`gender`, `User`.`about`, `User`.`what_i_love_most_about_backpacking`, `User`.`what_i_hate_about_backpacking`, `User`.`photo`, (YEAR(NOW())-YEAR(date_of_birth)) AS `User__age` FROM `europe`.`users` AS `User` WHERE `User`.`id` = 34	1	1	0
SELECT `Suggestion`.`id`, `Suggestion`.`location_id`, `Suggestion`.`locations_trip_id`, `Suggestion`.`suggestion`, `Suggestion`.`user_id`, `Suggestion`.`trip_id`, `Suggestion`.`accepted`, `Suggestion`.`created`, `Suggestion`.`modified` FROM `europe`.`suggestions` AS `Suggestion` WHERE `Suggestion`.`trip_id` = (95)	0	0	0
SELECT `Message`.`id`, `Message`.`trip_id`, `Message`.`user_id`, `Message`.`locations_trip_id`, `Message`.`created` FROM `europe`.`messages` AS `Message` WHERE `Message`.`trip_id` = (95)	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` = 828007 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` = (828007)	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` = (828007)	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` = 1094675	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` = 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` = 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` = 1756342	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` = 828007	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` = 828007	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` = 828007	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` = 828007	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` = 828007	1	1	0
SELECT `Leg`.`id`, `Leg`.`direction_id` FROM `europe`.`legs` AS `Leg` WHERE `Leg`.`direction_id` IN (461, 462, 463, 464, 465)	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` = 828007 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` = 1094675 AND `to` = 828007 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` = 1094675 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` = (1094675)	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` = (1094675)	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` = 828007	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` = 835853	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` = 838918	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` = 841229	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` = 836729	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` = 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` = 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` = 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` = 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` = 1094675	1	1	0
SELECT `Leg`.`id`, `Leg`.`direction_id` FROM `europe`.`legs` AS `Leg` WHERE `Leg`.`direction_id` IN (101, 102, 103, 104, 105)	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` = 1094675 AND `LocationsTrip`.`trip_id` = `Trip`.`id`)	1	1	0
SELECT `StartingLocation`.`id`, `StartingLocation`.`iso2`, `StartingLocation`.`region`, `StartingLocation`.`population`, `StartingLocation`.`lat`, `StartingLocation`.`lng`, `StartingLocation`.`city`, `StartingLocation`.`country_id` FROM `europe`.`locations` AS `StartingLocation` WHERE `StartingLocation`.`id` = 836336	1	1	0
SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`name`, `User`.`email`, `User`.`role`, `User`.`date_of_birth`, `User`.`country_id`, `User`.`created`, `User`.`modified`, `User`.`gender`, `User`.`about`, `User`.`what_i_love_most_about_backpacking`, `User`.`what_i_hate_about_backpacking`, `User`.`photo`, (YEAR(NOW())-YEAR(date_of_birth)) AS `User__age` FROM `europe`.`users` AS `User` WHERE `User`.`id` = 34	1	1	0
SELECT `Suggestion`.`id`, `Suggestion`.`location_id`, `Suggestion`.`locations_trip_id`, `Suggestion`.`suggestion`, `Suggestion`.`user_id`, `Suggestion`.`trip_id`, `Suggestion`.`accepted`, `Suggestion`.`created`, `Suggestion`.`modified` FROM `europe`.`suggestions` AS `Suggestion` WHERE `Suggestion`.`trip_id` = (95)	0	0	0
SELECT `Message`.`id`, `Message`.`trip_id`, `Message`.`user_id`, `Message`.`locations_trip_id`, `Message`.`created` FROM `europe`.`messages` AS `Message` WHERE `Message`.`trip_id` = (95)	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` = 835853 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` = (835853)	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` = (835853)	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` = 1094675	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` = 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` = 1756342	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 `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` = 835853	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` = 835853	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` = 835853	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` = 835853	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` = 835853	1	1	0
SELECT `Leg`.`id`, `Leg`.`direction_id` FROM `europe`.`legs` AS `Leg` WHERE `Leg`.`direction_id` IN (466, 467, 468, 469, 470)	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` = 835853 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` = 1094675 AND `to` = 835853 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` = 1094675 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` = (1094675)	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` = (1094675)	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` = 828007	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` = 835853	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` = 838918	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` = 841229	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` = 836729	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` = 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` = 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` = 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` = 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` = 1094675	1	1	0
SELECT `Leg`.`id`, `Leg`.`direction_id` FROM `europe`.`legs` AS `Leg` WHERE `Leg`.`direction_id` IN (101, 102, 103, 104, 105)	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` = 1094675 AND `LocationsTrip`.`trip_id` = `Trip`.`id`)	1	1	0
SELECT `StartingLocation`.`id`, `StartingLocation`.`iso2`, `StartingLocation`.`region`, `StartingLocation`.`population`, `StartingLocation`.`lat`, `StartingLocation`.`lng`, `StartingLocation`.`city`, `StartingLocation`.`country_id` FROM `europe`.`locations` AS `StartingLocation` WHERE `StartingLocation`.`id` = 836336	1	1	0
SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`name`, `User`.`email`, `User`.`role`, `User`.`date_of_birth`, `User`.`country_id`, `User`.`created`, `User`.`modified`, `User`.`gender`, `User`.`about`, `User`.`what_i_love_most_about_backpacking`, `User`.`what_i_hate_about_backpacking`, `User`.`photo`, (YEAR(NOW())-YEAR(date_of_birth)) AS `User__age` FROM `europe`.`users` AS `User` WHERE `User`.`id` = 34	1	1	0
SELECT `Suggestion`.`id`, `Suggestion`.`location_id`, `Suggestion`.`locations_trip_id`, `Suggestion`.`suggestion`, `Suggestion`.`user_id`, `Suggestion`.`trip_id`, `Suggestion`.`accepted`, `Suggestion`.`created`, `Suggestion`.`modified` FROM `europe`.`suggestions` AS `Suggestion` WHERE `Suggestion`.`trip_id` = (95)	0	0	0
SELECT `Message`.`id`, `Message`.`trip_id`, `Message`.`user_id`, `Message`.`locations_trip_id`, `Message`.`created` FROM `europe`.`messages` AS `Message` WHERE `Message`.`trip_id` = (95)	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` = 838918 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` = (838918)	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` = (838918)	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` = 1094675	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` = 1756342	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` = 793348	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` = 838918	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` = 838918	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` = 838918	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` = 838918	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` = 838918	1	1	0
SELECT `Leg`.`id`, `Leg`.`direction_id` FROM `europe`.`legs` AS `Leg` WHERE `Leg`.`direction_id` IN (476, 477, 478, 479, 480)	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` = 838918 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` = 1094675 AND `to` = 838918 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` = 1094675 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` = (1094675)	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` = (1094675)	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` = 828007	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` = 835853	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` = 838918	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` = 841229	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` = 836729	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` = 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` = 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` = 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` = 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` = 1094675	1	1	0
SELECT `Leg`.`id`, `Leg`.`direction_id` FROM `europe`.`legs` AS `Leg` WHERE `Leg`.`direction_id` IN (101, 102, 103, 104, 105)	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` = 1094675 AND `LocationsTrip`.`trip_id` = `Trip`.`id`)	1	1	0
SELECT `StartingLocation`.`id`, `StartingLocation`.`iso2`, `StartingLocation`.`region`, `StartingLocation`.`population`, `StartingLocation`.`lat`, `StartingLocation`.`lng`, `StartingLocation`.`city`, `StartingLocation`.`country_id` FROM `europe`.`locations` AS `StartingLocation` WHERE `StartingLocation`.`id` = 836336	1	1	0
SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`name`, `User`.`email`, `User`.`role`, `User`.`date_of_birth`, `User`.`country_id`, `User`.`created`, `User`.`modified`, `User`.`gender`, `User`.`about`, `User`.`what_i_love_most_about_backpacking`, `User`.`what_i_hate_about_backpacking`, `User`.`photo`, (YEAR(NOW())-YEAR(date_of_birth)) AS `User__age` FROM `europe`.`users` AS `User` WHERE `User`.`id` = 34	1	1	0
SELECT `Suggestion`.`id`, `Suggestion`.`location_id`, `Suggestion`.`locations_trip_id`, `Suggestion`.`suggestion`, `Suggestion`.`user_id`, `Suggestion`.`trip_id`, `Suggestion`.`accepted`, `Suggestion`.`created`, `Suggestion`.`modified` FROM `europe`.`suggestions` AS `Suggestion` WHERE `Suggestion`.`trip_id` = (95)	0	0	0
SELECT `Message`.`id`, `Message`.`trip_id`, `Message`.`user_id`, `Message`.`locations_trip_id`, `Message`.`created` FROM `europe`.`messages` AS `Message` WHERE `Message`.`trip_id` = (95)	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` = 841229 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` = (841229)	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` = (841229)	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` = 1094675	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` = 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` = 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 `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` = 841229	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` = 841229	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` = 841229	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` = 841229	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` = 841229	1	1	0
SELECT `Leg`.`id`, `Leg`.`direction_id` FROM `europe`.`legs` AS `Leg` WHERE `Leg`.`direction_id` IN (481, 482, 483, 484, 485)	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` = 841229 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` = 1094675 AND `to` = 841229 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` = 1094675 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` = (1094675)	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` = (1094675)	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` = 828007	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` = 835853	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` = 838918	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` = 841229	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` = 836729	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` = 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` = 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` = 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` = 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` = 1094675	1	1	0
SELECT `Leg`.`id`, `Leg`.`direction_id` FROM `europe`.`legs` AS `Leg` WHERE `Leg`.`direction_id` IN (101, 102, 103, 104, 105)	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` = 1094675 AND `LocationsTrip`.`trip_id` = `Trip`.`id`)	1	1	0
SELECT `StartingLocation`.`id`, `StartingLocation`.`iso2`, `StartingLocation`.`region`, `StartingLocation`.`population`, `StartingLocation`.`lat`, `StartingLocation`.`lng`, `StartingLocation`.`city`, `StartingLocation`.`country_id` FROM `europe`.`locations` AS `StartingLocation` WHERE `StartingLocation`.`id` = 836336	1	1	0
SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`name`, `User`.`email`, `User`.`role`, `User`.`date_of_birth`, `User`.`country_id`, `User`.`created`, `User`.`modified`, `User`.`gender`, `User`.`about`, `User`.`what_i_love_most_about_backpacking`, `User`.`what_i_hate_about_backpacking`, `User`.`photo`, (YEAR(NOW())-YEAR(date_of_birth)) AS `User__age` FROM `europe`.`users` AS `User` WHERE `User`.`id` = 34	1	1	0
SELECT `Suggestion`.`id`, `Suggestion`.`location_id`, `Suggestion`.`locations_trip_id`, `Suggestion`.`suggestion`, `Suggestion`.`user_id`, `Suggestion`.`trip_id`, `Suggestion`.`accepted`, `Suggestion`.`created`, `Suggestion`.`modified` FROM `europe`.`suggestions` AS `Suggestion` WHERE `Suggestion`.`trip_id` = (95)	0	0	0
SELECT `Message`.`id`, `Message`.`trip_id`, `Message`.`user_id`, `Message`.`locations_trip_id`, `Message`.`created` FROM `europe`.`messages` AS `Message` WHERE `Message`.`trip_id` = (95)	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` = 836729 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` = (836729)	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` = (836729)	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` = 1094675	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` = 1756342	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` = 793348	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` = 836729	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` = 836729	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` = 836729	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` = 836729	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` = 836729	1	1	0
SELECT `Leg`.`id`, `Leg`.`direction_id` FROM `europe`.`legs` AS `Leg` WHERE `Leg`.`direction_id` IN (471, 472, 473, 474, 475)	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` = 836729 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` = 1094675 AND `to` = 836729 LIMIT 1	1	1	0
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 = 1094675	1	1	0

139 duplicate queries run.

Query Explain:

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

====

Timer

Memory

Peak Memory Use 6.71 MB

Message	Memory use
Component initialization	1.66 MB
Controller action start	2.32 MB
Controller render start	3.86 MB
View render complete	4.25 MB

Timers

Total Request Time: 678 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	13.18
Event: Controller.startup	0.79
Controller action	530.97
Event: Controller.beforeRender	6.00
» Processing toolbar data	5.86
Rendering View	3.23
» Event: View.beforeRender	0.05
» Rendering APP/View/Locations/view.ctp	0.94
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/default.ctp	1.30
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- title_for_layoutDublin, Ireland - one of the best European backpacking destinations for 2016?
- worthVisitingPercentage(null)
- closestSameCities(array)
  0(array)
  locations(array)
  id1093733
  population188908
  cityCork, Ireland
  lat51.8986111
  lng-8.4958333
  0(array)
  isoie
  distance_in_km219.80324814946223
- closestCities(array)
  0(array)
  locations(array)
  id828007
  population585994
  cityBelfast, Great Britain (UK)
  lat54.583333
  lng-5.933333
  0(array)
  isogb
  distance_in_km140.35912360912997
  1(array)
  locations(array)
  id835853
  population468946
  cityLiverpool, Great Britain (UK)
  lat53.416667
  lng-3
  0(array)
  isogb
  distance_in_km215.4103051483305
  2(array)
  locations(array)
  id838918
  population190688
  cityPreston, Great Britain (UK)
  lat53.766667
  lng-2.716667
  0(array)
  isogb
  distance_in_km237.93173106738402
  3(array)
  locations(array)
  id841229
  population170885
  citySwansea, Great Britain (UK)
  lat51.633333
  lng-3.966667
  0(array)
  isogb
  distance_in_km243.7872414190001
  4(array)
  locations(array)
  id836729
  population395516
  cityManchester, Great Britain (UK)
  lat53.5
  lng-2.216667
  0(array)
  isogb
  distance_in_km267.46790325119383
- trips(array)
  0(array)
  LocationsTrip(array)
  id1
  location_id1094675
  trip_id95
  days(null)
  budget(null)
  priority(null)
  notes(null)
  ignore(null)
  must_see(null)
  created(null)
  modified(null)
  end_date(null)
  start_date(null)
  Location(array)
  id1094675
  iso2ie
  region07
  population1024027
  lat53.3330556
  lng-6.2488889
  cityDublin, Ireland
  country_id(null)
  Country(empty)
  WorthVisiting(empty)
  Direction(array)
  0(array)
  id101
  location_id1094675
  user_from(null)
  user_to(null)
  to828007
  1(array)
  id102
  location_id1094675
  user_from(null)
  user_to(null)
  to835853
  2(array)
  id103
  location_id1094675
  user_from(null)
  user_to(null)
  to838918
  3(array)
  id104
  location_id1094675
  user_from(null)
  user_to(null)
  to841229
  4(array)
  id105
  location_id1094675
  user_from(null)
  user_to(null)
  to836729
  Trip(array)
  0(array)
  id95
  titleTrip starting at London, Great Britain (UK)
  description(null)
  start_date2016-04-09
  end_date(null)
  budget(null)
  start_location836336
  trip_length(null)
  featured(null)
  user_id34
  created2016-04-09 17:24:44
  modified2016-04-09 17:24:44
  LocationsTrip(array)
  id1
  location_id1094675
  trip_id95
  days(null)
  budget(null)
  priority(null)
  notes(null)
  ignore(null)
  must_see(null)
  created(null)
  modified(null)
  end_date(null)
  start_date(null)
  picture/img/location/1094675.jpg
  settlement_typeMetropolis
  Trip(array)
  id95
  titleTrip starting at London, Great Britain (UK)
  description(null)
  start_date2016-04-09
  end_date(null)
  budget(null)
  start_location836336
  trip_length(null)
  featured(null)
  user_id34
  created2016-04-09 17:24:44
  modified2016-04-09 17:24:44
  StartingLocation(array)
  id836336
  iso2gb
  regionH9
  population7421228
  lat51.5002
  lng-0.1262
  cityLondon, Great Britain (UK)
  country_id(null)
  picture/img/location/836336.jpg
  settlement_typeMetropolis
  User(array)
  id34
  usernamechadhomings
  passworddfadf0b44aa15b0b97b13d34806d8e3635683a33c267c49a5e0d9002884e620e
  name
  emailmatt+chadhomings@angryjogger.com
  role(null)
  date_of_birth(null)
  country_id(null)
  created2016-04-09 17:11:21
  modified2016-04-09 17:21:39
  gender(null)
  about
  what_i_love_most_about_backpacking
  what_i_hate_about_backpacking
  photodownload.jpeg
  age(null)
  Suggestion(empty)
  Message(empty)
  Location(array)
  0(array)
  id1094675
  iso2ie
  region07
  population1024027
  lat53.3330556
  lng-6.2488889
  cityDublin, Ireland
  country_id(null)
  picture/img/location/1094675.jpg
  settlement_typeMetropolis
  LocationsTrip(array)
  id1
  location_id1094675
  trip_id95
  days(null)
  budget(null)
  priority(null)
  notes(null)
  ignore(null)
  must_see(null)
  created(null)
  modified(null)
  end_date(null)
  start_date(null)
  1(array)
  id802290
  iso2fr
  regionA8
  population2110694
  lat48.866667
  lng2.333333
  cityParis, France
  country_id(null)
  picture/img/location/802290.jpg
  settlement_typeMetropolis
  LocationsTrip(array)
  id2
  location_id802290
  trip_id95
  days(null)
  budget(null)
  priority(null)
  notes(null)
  ignore(null)
  must_see(null)
  created(null)
  modified(null)
  end_date(null)
  start_date(null)
  2(array)
  id567379
  iso2de
  region16
  population3398362
  lat52.516667
  lng13.4
  cityBerlin, Germany
  country_id(null)
  picture/img/location/567379.jpg
  settlement_typeMetropolis
  LocationsTrip(array)
  id3
  location_id567379
  trip_id95
  days(null)
  budget(null)
  priority(null)
  notes(null)
  ignore(null)
  must_see(null)
  created(null)
  modified(null)
  end_date(null)
  start_date(null)
  3(array)
  id607451
  iso2de
  region02
  population497593
  lat49.447778
  lng11.068333
  cityNuremberg, Germany
  country_id(null)
  picture/img/location/607451.jpg
  settlement_typeLarge city
  LocationsTrip(array)
  id4
  location_id607451
  trip_id95
  days(null)
  budget(null)
  priority(null)
  notes(null)
  ignore(null)
  must_see(null)
  created(null)
  modified(null)
  end_date(null)
  start_date(null)
  4(array)
  id356444
  iso2ch
  region25
  population346185
  lat47.366667
  lng8.55
  cityZürich, Switzerland
  country_id(null)
  picture/img/location/356444.jpg
  settlement_typeLarge city
  LocationsTrip(array)
  id5
  location_id356444
  trip_id95
  days(null)
  budget(null)
  priority(null)
  notes(null)
  ignore(null)
  must_see(null)
  created(null)
  modified(null)
  end_date(null)
  start_date(null)
- location(array)
  Location(array)
  id1094675
  iso2ie
  region07
  population1024027
  lat53.3330556
  lng-6.2488889
  cityDublin, Ireland
  country_id(null)
  picture/img/location/1094675.jpg
  settlement_typeMetropolis
  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)
  id101
  location_id1094675
  user_from(null)
  user_to(null)
  to828007
  To(array)
  id828007
  iso2gb
  regionR3
  population585994
  lat54.583333
  lng-5.933333
  cityBelfast, Great Britain (UK)
  country_id(null)
  picture/img/location/828007.jpg
  settlement_typeLarge city
  Location(array)
  id1094675
  iso2ie
  region07
  population1024027
  lat53.3330556
  lng-6.2488889
  cityDublin, Ireland
  country_id(null)
  picture/img/location/1094675.jpg
  settlement_typeMetropolis
  Leg(empty)
  1(array)
  id102
  location_id1094675
  user_from(null)
  user_to(null)
  to835853
  To(array)
  id835853
  iso2gb
  regionH8
  population468946
  lat53.416667
  lng-3
  cityLiverpool, Great Britain (UK)
  country_id(null)
  picture/img/location/835853.jpg
  settlement_typeLarge city
  Location(array)
  id1094675
  iso2ie
  region07
  population1024027
  lat53.3330556
  lng-6.2488889
  cityDublin, Ireland
  country_id(null)
  picture/img/location/1094675.jpg
  settlement_typeMetropolis
  Leg(empty)
  2(array)
  id103
  location_id1094675
  user_from(null)
  user_to(null)
  to838918
  To(array)
  id838918
  iso2gb
  regionH2
  population190688
  lat53.766667
  lng-2.716667
  cityPreston, Great Britain (UK)
  country_id(null)
  picture/img/location/grid-default-thumb.png
  settlement_typeCity
  Location(array)
  id1094675
  iso2ie
  region07
  population1024027
  lat53.3330556
  lng-6.2488889
  cityDublin, Ireland
  country_id(null)
  picture/img/location/1094675.jpg
  settlement_typeMetropolis
  Leg(empty)
  3(array)
  id104
  location_id1094675
  user_from(null)
  user_to(null)
  to841229
  To(array)
  id841229
  iso2gb
  regionZ1
  population170885
  lat51.633333
  lng-3.966667
  citySwansea, Great Britain (UK)
  country_id(null)
  picture/img/location/grid-default-thumb.png
  settlement_typeCity
  Location(array)
  id1094675
  iso2ie
  region07
  population1024027
  lat53.3330556
  lng-6.2488889
  cityDublin, Ireland
  country_id(null)
  picture/img/location/1094675.jpg
  settlement_typeMetropolis
  Leg(empty)
  4(array)
  id105
  location_id1094675
  user_from(null)
  user_to(null)
  to836729
  To(array)
  id836729
  iso2gb
  regionI2
  population395516
  lat53.5
  lng-2.216667
  cityManchester, Great Britain (UK)
  country_id(null)
  picture/img/location/836729.jpg
  settlement_typeLarge city
  Location(array)
  id1094675
  iso2ie
  region07
  population1024027
  lat53.3330556
  lng-6.2488889
  cityDublin, Ireland
  country_id(null)
  picture/img/location/1094675.jpg
  settlement_typeMetropolis
  Leg(empty)
  Trip(array)
  0(array)
  id95
  titleTrip starting at London, Great Britain (UK)
  description(null)
  start_date2016-04-09
  end_date(null)
  budget(null)
  start_location836336
  trip_length(null)
  featured(null)
  user_id34
  created2016-04-09 17:24:44
  modified2016-04-09 17:24:44
  LocationsTrip(array)
  id1
  location_id1094675
  trip_id95
  days(null)
  budget(null)
  priority(null)
  notes(null)
  ignore(null)
  must_see(null)
  created(null)
  modified(null)
  end_date(null)
  start_date(null)
  StartingLocation(array)
  id836336
  iso2gb
  regionH9
  population7421228
  lat51.5002
  lng-0.1262
  cityLondon, Great Britain (UK)
  country_id(null)
  picture/img/location/836336.jpg
  settlement_typeMetropolis
  User(array)
  id34
  usernamechadhomings
  passworddfadf0b44aa15b0b97b13d34806d8e3635683a33c267c49a5e0d9002884e620e
  name
  emailmatt+chadhomings@angryjogger.com
  role(null)
  date_of_birth(null)
  country_id(null)
  created2016-04-09 17:11:21
  modified2016-04-09 17:21:39
  gender(null)
  about
  what_i_love_most_about_backpacking
  what_i_hate_about_backpacking
  photodownload.jpeg
  age(null)
  Suggestion(empty)
  Message(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)
  StartingLocation(empty)
  Suggestion(empty)
  Message(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/1094675'
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	'55032'
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) 1539641766.0989
Request Time	(int) 1539641766
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/Suggestion.php
  10APP/Model/Message.php
  11APP/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
====

Dublin, Ireland

Dublin, Ireland

0% of people recommend visiting Dublin, Ireland

Dublin, Ireland

Is Dublin, Ireland worth visiting?

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

Trips that visit Dublin, Ireland

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: 207 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: 207 queries