Query Metrics
6
Database Queries
6
Different statements
2.37 ms
Query time
3
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.63 ms | SELECT t0.id AS id_1, t0.name AS name_2, t0.street AS street_3, t0.number AS number_4, t0.postcode AS postcode_5, t0.city AS city_6, t0.color AS color_7, t0.voivodeship AS voivodeship_8, t0.country AS country_9, t0.institution AS institution_10, t0.levels AS levels_11, t0.link AS link_12, t0.location AS location_13, t0.location_json AS location_json_14, t0.main_owner_id AS main_owner_id_15 FROM clubs t0 WHERE t0.id = ?
Parameters:
[
"187"
]
|
2 | 0.51 ms | SELECT t0.id AS id_1, t0.timestamp AS timestamp_2, t0.timestamp_read AS timestamp_read_3, t0.timestamp_done AS timestamp_done_4, t0.type AS type_5, t0.action AS action_6, t0.info AS info_7, t0.data AS data_8, t0.done_value AS done_value_9, t0.owner_from_id AS owner_from_id_10, t0.owner_to_id AS owner_to_id_11, t0.club_id AS club_id_12, t0.event_id AS event_id_13 FROM notifications t0 WHERE t0.club_id = ? AND t0.owner_to_id IS NULL ORDER BY t0.timestamp DESC
Parameters:
[
187
]
|
3 | 0.28 ms | SELECT t0.id AS id_1, t0.username AS username_2, t0.reset_token AS reset_token_3, t0.activate_token AS activate_token_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.password AS password_7, t0.email AS email_8, t0.profile AS profile_9, t0.specialization AS specialization_10, t0.specialization_custom AS specialization_custom_11, t0.phone AS phone_12, t0.is_email_visible AS is_email_visible_13, t0.is_active AS is_active_14, t0.acc_terms AS acc_terms_15, t0.acc_data AS acc_data_16, t0.acc_newsletter_kmo AS acc_newsletter_kmo_17, t0.acc_newsletter_cnk AS acc_newsletter_cnk_18, t0.acc_newsletter_teacher_cnk AS acc_newsletter_teacher_cnk_19, t0.register_incomplete AS register_incomplete_20, t0.info AS info_21, t0.custom_events AS custom_events_22, t0.partners AS partners_23, t0.photo_id AS photo_id_24 FROM users t0 WHERE t0.id = ?
Parameters:
[
383
]
|
4 | 0.38 ms | SELECT t0.id AS id_1, t0.username AS username_2, t0.reset_token AS reset_token_3, t0.activate_token AS activate_token_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.password AS password_7, t0.email AS email_8, t0.profile AS profile_9, t0.specialization AS specialization_10, t0.specialization_custom AS specialization_custom_11, t0.phone AS phone_12, t0.is_email_visible AS is_email_visible_13, t0.is_active AS is_active_14, t0.acc_terms AS acc_terms_15, t0.acc_data AS acc_data_16, t0.acc_newsletter_kmo AS acc_newsletter_kmo_17, t0.acc_newsletter_cnk AS acc_newsletter_cnk_18, t0.acc_newsletter_teacher_cnk AS acc_newsletter_teacher_cnk_19, t0.register_incomplete AS register_incomplete_20, t0.info AS info_21, t0.custom_events AS custom_events_22, t0.partners AS partners_23, t0.photo_id AS photo_id_24 FROM users t0 INNER JOIN club_user ON t0.id = club_user.user_id WHERE club_user.club_id = ?
Parameters:
[
187
]
|
5 | 0.32 ms | SELECT t0.id AS id_1, t0.name AS name_2, t0.street AS street_3, t0.number AS number_4, t0.postcode AS postcode_5, t0.city AS city_6, t0.color AS color_7, t0.voivodeship AS voivodeship_8, t0.country AS country_9, t0.institution AS institution_10, t0.levels AS levels_11, t0.link AS link_12, t0.location AS location_13, t0.location_json AS location_json_14, t0.main_owner_id AS main_owner_id_15 FROM clubs t0 INNER JOIN club_user ON t0.id = club_user.club_id WHERE club_user.user_id = ?
Parameters:
[
383
]
|
6 | 0.25 ms | SELECT t0.id AS id_1, t0.timestamp AS timestamp_2, t0.files AS files_3, t0.title AS title_4, t0.video AS video_5, t0.user_id AS user_id_6, t0.club_id AS club_id_7 FROM galleries t0 WHERE t0.club_id = ?
Parameters:
[
187
]
|
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.
Entities Mapping
Class | Mapping errors |
---|---|
AppBundle\Entity\Club |
|
AppBundle\Entity\User |
|
AppBundle\Entity\Gallery | No errors. |
AppBundle\Entity\Inspiration | No errors. |
AppBundle\Entity\Notification | No errors. |
AppBundle\Entity\Event | No errors. |
AppBundle\Entity\File |
|
AppBundle\Entity\Role | No errors. |