https://www.kmo.org.pl/kmoapdev.php/ru/user/155

Query Metrics

5 Database Queries
5 Different statements
1.86 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.63 ms
(33.89%)
1
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:
[
  "155"
]
0.34 ms
(18.32%)
1
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:
[
  94
]
0.33 ms
(17.90%)
1
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:
[
  155
]
0.31 ms
(16.75%)
1
SELECT t0.id AS id_1, t0.timestamp AS timestamp_2, t0.news_id AS news_id_3, t0.text AS text_4, t0.status AS status_5, t0.user_id AS user_id_6 FROM events t0 WHERE t0.user_id = ?
Parameters:
[
  155
]
0.24 ms
(13.14%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.extension AS extension_4, t0.mime AS mime_5, t0.width AS width_6, t0.height AS height_7, t0.size AS size_8, t0.channels AS channels_9, t0.ts_created AS ts_created_10, t0.ts_modified AS ts_modified_11, t0.ts_deleted AS ts_deleted_12 FROM files t0 WHERE t0.id = ?
Parameters:
[
  762
]

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\User
  • The field AppBundle\Entity\User#events is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\Event#user does not contain the required 'inversedBy="events"' attribute.
AppBundle\Entity\File
  • The field AppBundle\Entity\File#folders is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\FolderFile#file does not contain the required 'inversedBy="folders"' attribute.
AppBundle\Entity\Role No errors.
AppBundle\Entity\Club
  • The field AppBundle\Entity\Club#galleries is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\Gallery#club does not contain the required 'inversedBy="galleries"' attribute.
  • The field AppBundle\Entity\Club#inspirations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\Inspiration#club does not contain the required 'inversedBy="inspirations"' attribute.
AppBundle\Entity\Event No errors.
AppBundle\Entity\FolderFile No errors.
AppBundle\Entity\Gallery No errors.
AppBundle\Entity\Inspiration No errors.