GET https://evalcomp.dataccessor.com/admin/referential

Query Metrics

11 Database Queries
5 Different statements
10.98 ms Query time
0 Invalid entities
161 Managed entities

Queries

Group similar statements

# Time Info
1 2.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.mark_system_id AS mark_system_id_3 FROM referential t0
Parameters:
[]
2 1.30 ms
SELECT t0.id AS id_1, t0.route_name AS route_name_2, t0.title AS title_3, t0.content AS content_4, t0.enabled AS enabled_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM page_help t0 WHERE t0.route_name = ? AND t0.enabled = ? LIMIT 1
Parameters:
[
  "admin_referential_index"
  1
]
3 1.50 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.position AS position_4, t0.depth AS depth_5, t0.color AS color_6, t0.referential_id AS referential_id_7, t0.parent_id AS parent_id_8 FROM referential_item t0 WHERE t0.referential_id = ?
Parameters:
[
  5
]
4 0.77 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.fault_flag_enabled AS fault_flag_enabled_4 FROM mark_system t0 WHERE t0.id = ?
Parameters:
[
  3
]
5 0.94 ms
SELECT t0.id AS id_1, t0.depth AS depth_2, t0.label AS label_3, t0.color AS color_4, t0.referential_id AS referential_id_5 FROM referential_depth_label t0 WHERE t0.referential_id = ? ORDER BY t0.depth ASC
Parameters:
[
  5
]
6 0.81 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.position AS position_4, t0.depth AS depth_5, t0.color AS color_6, t0.referential_id AS referential_id_7, t0.parent_id AS parent_id_8 FROM referential_item t0 WHERE t0.referential_id = ?
Parameters:
[
  6
]
7 0.60 ms
SELECT t0.id AS id_1, t0.depth AS depth_2, t0.label AS label_3, t0.color AS color_4, t0.referential_id AS referential_id_5 FROM referential_depth_label t0 WHERE t0.referential_id = ? ORDER BY t0.depth ASC
Parameters:
[
  6
]
8 0.89 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.position AS position_4, t0.depth AS depth_5, t0.color AS color_6, t0.referential_id AS referential_id_7, t0.parent_id AS parent_id_8 FROM referential_item t0 WHERE t0.referential_id = ?
Parameters:
[
  7
]
9 0.61 ms
SELECT t0.id AS id_1, t0.depth AS depth_2, t0.label AS label_3, t0.color AS color_4, t0.referential_id AS referential_id_5 FROM referential_depth_label t0 WHERE t0.referential_id = ? ORDER BY t0.depth ASC
Parameters:
[
  7
]
10 0.78 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.position AS position_4, t0.depth AS depth_5, t0.color AS color_6, t0.referential_id AS referential_id_7, t0.parent_id AS parent_id_8 FROM referential_item t0 WHERE t0.referential_id = ?
Parameters:
[
  8
]
11 0.66 ms
SELECT t0.id AS id_1, t0.depth AS depth_2, t0.label AS label_3, t0.color AS color_4, t0.referential_id AS referential_id_5 FROM referential_depth_label t0 WHERE t0.referential_id = ? ORDER BY t0.depth ASC
Parameters:
[
  8
]

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\ReferentialItem 145
App\Entity\ReferentialDepthLabel 11
App\Entity\Referential 4
App\Entity\MarkSystem 1

Entities Mapping