https://design.berufsreise-dev.at/graphql/

Query Metrics

2 Database Queries
2 Different statements
4.29 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 3.06 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.school_number AS school_number_3, t0.url AS url_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.communication_id AS communication_id_7, t0.address_id AS address_id_8, t9.id AS id_10, t9.uuid AS uuid_11, t9.name AS name_12, t9.description AS description_13, t9.training_information AS training_information_14, t9.certificate_information AS certificate_information_15, t9.url AS url_16, t9.click_count AS click_count_17, t9.is_visible AS is_visible_18, t9.school_id AS school_id_19, t9.communication_id AS communication_id_20, t9.gallery_id AS gallery_id_21, t9.video_gallery_id AS video_gallery_id_22, t9.document_gallery_id AS document_gallery_id_23, t9.contact_gallery_id AS contact_gallery_id_24, t9.profile_picture_id AS profile_picture_id_25, t9.header_picture_id AS header_picture_id_26, t9.profile_link_id AS profile_link_id_27 FROM school t0 LEFT JOIN school_profile t9 ON t9.school_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
  167
]
2 1.24 ms
SELECT g0_.id AS id_0, g0_.start_at AS start_at_1, g0_.end_at AS end_at_2, g0_.pause_at AS pause_at_3, g0_.duration AS duration_4, g0_.created_at AS created_at_5, g0_.school_class_id AS school_class_id_6 FROM game_timer g0_ LEFT JOIN school_class s1_ ON g0_.school_class_id = s1_.id LEFT JOIN school s2_ ON s1_.school_id = s2_.id WHERE s2_.id = ? AND g0_.start_at <= ? AND ? <= g0_.end_at ORDER BY g0_.created_at DESC
Parameters:
[
  167
  "2024-11-18 20:44:05"
  "2024-11-18 20:44:05"
]

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.