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

Query Metrics

13 Database Queries
4 Different statements
8.60 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
4.93 ms
(57.30%)
8
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.logo_style AS logo_style_19, t9.school_id AS school_id_20, t9.communication_id AS communication_id_21, t9.gallery_id AS gallery_id_22, t9.video_gallery_id AS video_gallery_id_23, t9.document_gallery_id AS document_gallery_id_24, t9.contact_gallery_id AS contact_gallery_id_25, t9.profile_picture_id AS profile_picture_id_26, t9.header_picture_id AS header_picture_id_27, t9.profile_link_id AS profile_link_id_28 FROM school t0 LEFT JOIN school_profile t9 ON t9.school_id = t0.id WHERE t0.id = ?
Parameters:
[
  370
]
1.71 ms
(19.94%)
3
SELECT t0.id AS id_1, t0.optional_name AS optional_name_2, t0.director_mail AS director_mail_3, t0.is_visible AS is_visible_4, t0.rookie_district_id AS rookie_district_id_5, t0.school_id AS school_id_6, t0.rookie_time_slot_id AS rookie_time_slot_id_7 FROM rookie_school t0 WHERE t0.rookie_time_slot_id = ?
Parameters:
[
  7
]
1.28 ms
(14.88%)
1
SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.open_at AS open_at_2, r0_.close_at AS close_at_3, r0_.work_from AS work_from_4, r0_.work_to AS work_to_5, r0_.comment AS comment_6, r0_.rookie_district_id AS rookie_district_id_7, r0_.rookie_time_slot_state_id AS rookie_time_slot_state_id_8 FROM rookie_time_slot r0_ LEFT JOIN rookie_district r1_ ON r0_.rookie_district_id = r1_.id LEFT JOIN rookie_time_slot_state r2_ ON r0_.rookie_time_slot_state_id = r2_.id WHERE r1_.id = 1 AND r0_.id NOT IN (9, 60) AND r2_.id = 1 ORDER BY r0_.open_at ASC
Parameters:
[]
0.68 ms
(7.88%)
1
SELECT t0.id AS id_1, t0.district_name AS district_name_2, t0.event_type AS event_type_3, t0.event_state AS event_state_4 FROM rookie_district t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]

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.