GET https://dev.flexhosting.co/honeyguide-mne/projects

Query Metrics

16 Database Queries
4 Different statements
7.80 ms Query time
0 Invalid entities
63 Managed entities

Queries

Group similar statements

# Time Info
1 4.47 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.budget AS budget_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM project t0
Parameters:
[]
2 1.18 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.unit AS unit_4, t0.baseline_value AS baseline_value_5, t0.target_value AS target_value_6, t0.current_value AS current_value_7, t0.category AS category_8, t0.frequency AS frequency_9, t0.created_at AS created_at_10, t0.project_id AS project_id_11 FROM indicator t0 WHERE t0.project_id = ?
Parameters:
[
  1
]
3 0.71 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.planned_date AS planned_date_5, t0.completed_date AS completed_date_6, t0.category AS category_7, t0.participant_count AS participant_count_8, t0.cost AS cost_9, t0.responsible_person AS responsible_person_10, t0.created_at AS created_at_11, t0.project_id AS project_id_12, t0.location_id AS location_id_13 FROM activity t0 WHERE t0.project_id = ?
Parameters:
[
  1
]
4 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.region AS region_3, t0.district AS district_4, t0.country AS country_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.area_hectares AS area_hectares_8, t0.location_type AS location_type_9, t0.created_at AS created_at_10 FROM location t0 INNER JOIN project_location ON t0.id = project_location.location_id WHERE project_location.project_id = ?
Parameters:
[
  1
]
5 0.09 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.unit AS unit_4, t0.baseline_value AS baseline_value_5, t0.target_value AS target_value_6, t0.current_value AS current_value_7, t0.category AS category_8, t0.frequency AS frequency_9, t0.created_at AS created_at_10, t0.project_id AS project_id_11 FROM indicator t0 WHERE t0.project_id = ?
Parameters:
[
  2
]
6 0.09 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.planned_date AS planned_date_5, t0.completed_date AS completed_date_6, t0.category AS category_7, t0.participant_count AS participant_count_8, t0.cost AS cost_9, t0.responsible_person AS responsible_person_10, t0.created_at AS created_at_11, t0.project_id AS project_id_12, t0.location_id AS location_id_13 FROM activity t0 WHERE t0.project_id = ?
Parameters:
[
  2
]
7 0.09 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.region AS region_3, t0.district AS district_4, t0.country AS country_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.area_hectares AS area_hectares_8, t0.location_type AS location_type_9, t0.created_at AS created_at_10 FROM location t0 INNER JOIN project_location ON t0.id = project_location.location_id WHERE project_location.project_id = ?
Parameters:
[
  2
]
8 0.08 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.unit AS unit_4, t0.baseline_value AS baseline_value_5, t0.target_value AS target_value_6, t0.current_value AS current_value_7, t0.category AS category_8, t0.frequency AS frequency_9, t0.created_at AS created_at_10, t0.project_id AS project_id_11 FROM indicator t0 WHERE t0.project_id = ?
Parameters:
[
  3
]
9 0.08 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.planned_date AS planned_date_5, t0.completed_date AS completed_date_6, t0.category AS category_7, t0.participant_count AS participant_count_8, t0.cost AS cost_9, t0.responsible_person AS responsible_person_10, t0.created_at AS created_at_11, t0.project_id AS project_id_12, t0.location_id AS location_id_13 FROM activity t0 WHERE t0.project_id = ?
Parameters:
[
  3
]
10 0.10 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.region AS region_3, t0.district AS district_4, t0.country AS country_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.area_hectares AS area_hectares_8, t0.location_type AS location_type_9, t0.created_at AS created_at_10 FROM location t0 INNER JOIN project_location ON t0.id = project_location.location_id WHERE project_location.project_id = ?
Parameters:
[
  3
]
11 0.09 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.unit AS unit_4, t0.baseline_value AS baseline_value_5, t0.target_value AS target_value_6, t0.current_value AS current_value_7, t0.category AS category_8, t0.frequency AS frequency_9, t0.created_at AS created_at_10, t0.project_id AS project_id_11 FROM indicator t0 WHERE t0.project_id = ?
Parameters:
[
  4
]
12 0.07 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.planned_date AS planned_date_5, t0.completed_date AS completed_date_6, t0.category AS category_7, t0.participant_count AS participant_count_8, t0.cost AS cost_9, t0.responsible_person AS responsible_person_10, t0.created_at AS created_at_11, t0.project_id AS project_id_12, t0.location_id AS location_id_13 FROM activity t0 WHERE t0.project_id = ?
Parameters:
[
  4
]
13 0.08 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.region AS region_3, t0.district AS district_4, t0.country AS country_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.area_hectares AS area_hectares_8, t0.location_type AS location_type_9, t0.created_at AS created_at_10 FROM location t0 INNER JOIN project_location ON t0.id = project_location.location_id WHERE project_location.project_id = ?
Parameters:
[
  4
]
14 0.08 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.unit AS unit_4, t0.baseline_value AS baseline_value_5, t0.target_value AS target_value_6, t0.current_value AS current_value_7, t0.category AS category_8, t0.frequency AS frequency_9, t0.created_at AS created_at_10, t0.project_id AS project_id_11 FROM indicator t0 WHERE t0.project_id = ?
Parameters:
[
  5
]
15 0.11 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.planned_date AS planned_date_5, t0.completed_date AS completed_date_6, t0.category AS category_7, t0.participant_count AS participant_count_8, t0.cost AS cost_9, t0.responsible_person AS responsible_person_10, t0.created_at AS created_at_11, t0.project_id AS project_id_12, t0.location_id AS location_id_13 FROM activity t0 WHERE t0.project_id = ?
Parameters:
[
  5
]
16 0.10 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.region AS region_3, t0.district AS district_4, t0.country AS country_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.area_hectares AS area_hectares_8, t0.location_type AS location_type_9, t0.created_at AS created_at_10 FROM location t0 INNER JOIN project_location ON t0.id = project_location.location_id WHERE project_location.project_id = ?
Parameters:
[
  5
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Activity 33
App\Entity\Indicator 20
App\Entity\Project 5
App\Entity\Location 5

Entities Mapping

Class Mapping errors
App\Entity\Project No errors.
App\Entity\Indicator No errors.
App\Entity\Activity No errors.
App\Entity\Location No errors.
App\Entity\Measurement No errors.