Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 2
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Debug
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT r0_.world_map_x AS world_map_x_0, r0_.world_map_y AS world_map_y_1, r0_.map AS map_2, r0_.map_width AS map_width_3, r0_.map_height AS map_height_4, r0_.id AS id_5, r0_.version AS version_6, r0_.uuid AS uuid_7, r0_.name AS name_8, r0_.description AS description_9 FROM region r0_ WHERE r0_.name = ?

[
  "Forest"
]

SELECT
  r0_.world_map_x AS world_map_x_0,
  r0_.world_map_y AS world_map_y_1,
  r0_.map AS map_2,
  r0_.map_width AS map_width_3,
  r0_.map_height AS map_height_4,
  r0_.id AS id_5,
  r0_.version AS version_6,
  r0_.uuid AS uuid_7,
  r0_.name AS name_8,
  r0_.description AS description_9
FROM
  region r0_
WHERE
  r0_.name = ?

SELECT r0_.world_map_x AS world_map_x_0, r0_.world_map_y AS world_map_y_1, r0_.map AS map_2, r0_.map_width AS map_width_3, r0_.map_height AS map_height_4, r0_.id AS id_5, r0_.version AS version_6, r0_.uuid AS uuid_7, r0_.name AS name_8, r0_.description AS description_9 FROM region r0_ WHERE r0_.name = 'Forest';

SELECT l0_.region_map_x AS region_map_x_0, l0_.region_map_y AS region_map_y_1, l0_.security_level AS security_level_2, l0_.background AS background_3, l0_.minimap AS minimap_4, l0_.grid_width AS grid_width_5, l0_.grid_height AS grid_height_6, l0_.id AS id_7, l0_.version AS version_8, l0_.uuid AS uuid_9, l0_.name AS name_10, l0_.description AS description_11, l0_.rendered AS rendered_12, l0_.exterior AS exterior_13, l0_.on_map AS on_map_14, l0_.secret AS secret_15, l0_.respawn_point AS respawn_point_16, l0_.no_rescue AS no_rescue_17, l0_.no_combat AS no_combat_18, l0_.off_record AS off_record_19, l0_.muffled AS muffled_20, l0_.region_id AS region_id_21 FROM location l0_ WHERE l0_.region_id = ? AND l0_.on_map = true AND l0_.secret = false

[
  2
]

SELECT
  l0_.region_map_x AS region_map_x_0,
  l0_.region_map_y AS region_map_y_1,
  l0_.security_level AS security_level_2,
  l0_.background AS background_3,
  l0_.minimap AS minimap_4,
  l0_.grid_width AS grid_width_5,
  l0_.grid_height AS grid_height_6,
  l0_.id AS id_7,
  l0_.version AS version_8,
  l0_.uuid AS uuid_9,
  l0_.name AS name_10,
  l0_.description AS description_11,
  l0_.rendered AS rendered_12,
  l0_.exterior AS exterior_13,
  l0_.on_map AS on_map_14,
  l0_.secret AS secret_15,
  l0_.respawn_point AS respawn_point_16,
  l0_.no_rescue AS no_rescue_17,
  l0_.no_combat AS no_combat_18,
  l0_.off_record AS off_record_19,
  l0_.muffled AS muffled_20,
  l0_.region_id AS region_id_21
FROM
  location l0_
WHERE
  l0_.region_id = ?
  AND l0_.on_map = true
  AND l0_.secret = false

SELECT l0_.region_map_x AS region_map_x_0, l0_.region_map_y AS region_map_y_1, l0_.security_level AS security_level_2, l0_.background AS background_3, l0_.minimap AS minimap_4, l0_.grid_width AS grid_width_5, l0_.grid_height AS grid_height_6, l0_.id AS id_7, l0_.version AS version_8, l0_.uuid AS uuid_9, l0_.name AS name_10, l0_.description AS description_11, l0_.rendered AS rendered_12, l0_.exterior AS exterior_13, l0_.on_map AS on_map_14, l0_.secret AS secret_15, l0_.respawn_point AS respawn_point_16, l0_.no_rescue AS no_rescue_17, l0_.no_combat AS no_combat_18, l0_.off_record AS off_record_19, l0_.muffled AS muffled_20, l0_.region_id AS region_id_21 FROM location l0_ WHERE l0_.region_id = 2 AND l0_.on_map = true AND l0_.secret = false;

SELECT t0.type AS type_1, t0.service_data AS service_data_2, t0.min_reputation AS min_reputation_3, t0.open_hour AS open_hour_4, t0.close_hour AS close_hour_5, t0.guarded AS guarded_6, t0.id AS id_7, t0.version AS version_8, t0.uuid AS uuid_9, t0.title AS title_10, t0.location_id AS location_id_11 FROM location_service t0 WHERE t0.location_id IN (?, ?)

[
  5
  6
]

SELECT
  t0.type AS type_1,
  t0.service_data AS service_data_2,
  t0.min_reputation AS min_reputation_3,
  t0.open_hour AS open_hour_4,
  t0.close_hour AS close_hour_5,
  t0.guarded AS guarded_6,
  t0.id AS id_7,
  t0.version AS version_8,
  t0.uuid AS uuid_9,
  t0.title AS title_10,
  t0.location_id AS location_id_11
FROM
  location_service t0
WHERE
  t0.location_id IN (?, ?)

SELECT t0.type AS type_1, t0.service_data AS service_data_2, t0.min_reputation AS min_reputation_3, t0.open_hour AS open_hour_4, t0.close_hour AS close_hour_5, t0.guarded AS guarded_6, t0.id AS id_7, t0.version AS version_8, t0.uuid AS uuid_9, t0.title AS title_10, t0.location_id AS location_id_11 FROM location_service t0 WHERE t0.location_id IN (5, 6);

SELECT l0_.type AS type_0, l0_.to_x AS to_x_1, l0_.to_y AS to_y_2, l0_.instanciated AS instanciated_3, l0_.stamina_cost AS stamina_cost_4, l0_.hunger_cost AS hunger_cost_5, l0_.money_cost AS money_cost_6, l0_.restriction AS restriction_7, l0_.restriction_details AS restriction_details_8, l0_.id AS id_9, l0_.version AS version_10, l0_.uuid AS uuid_11, l0_.title AS title_12, l0_.from_location_id AS from_location_id_13, l0_.to_location_id AS to_location_id_14 FROM location_connection l0_ WHERE (l0_.from_location_id IN (?, ?) OR l0_.to_location_id IN (?, ?)) AND l0_.type <> ?

[
  5
  6
  5
  6
  3
]

SELECT
  l0_.type AS type_0,
  l0_.to_x AS to_x_1,
  l0_.to_y AS to_y_2,
  l0_.instanciated AS instanciated_3,
  l0_.stamina_cost AS stamina_cost_4,
  l0_.hunger_cost AS hunger_cost_5,
  l0_.money_cost AS money_cost_6,
  l0_.restriction AS restriction_7,
  l0_.restriction_details AS restriction_details_8,
  l0_.id AS id_9,
  l0_.version AS version_10,
  l0_.uuid AS uuid_11,
  l0_.title AS title_12,
  l0_.from_location_id AS from_location_id_13,
  l0_.to_location_id AS to_location_id_14
FROM
  location_connection l0_
WHERE
  (
    l0_.from_location_id IN (?, ?)
    OR l0_.to_location_id IN (?, ?)
  )
  AND l0_.type <> ?

SELECT l0_.type AS type_0, l0_.to_x AS to_x_1, l0_.to_y AS to_y_2, l0_.instanciated AS instanciated_3, l0_.stamina_cost AS stamina_cost_4, l0_.hunger_cost AS hunger_cost_5, l0_.money_cost AS money_cost_6, l0_.restriction AS restriction_7, l0_.restriction_details AS restriction_details_8, l0_.id AS id_9, l0_.version AS version_10, l0_.uuid AS uuid_11, l0_.title AS title_12, l0_.from_location_id AS from_location_id_13, l0_.to_location_id AS to_location_id_14 FROM location_connection l0_ WHERE (l0_.from_location_id IN (5, 6) OR l0_.to_location_id IN (5, 6)) AND l0_.type <> 3;