https://www.kmo.org.pl/kmoapdev.php/pl/club/187

Query Metrics

6 Database Queries
6 Different statements
2.37 ms Query time
3 Invalid entities

Queries

Group similar statements

# 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
  • 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\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\Gallery No errors.
AppBundle\Entity\Inspiration No errors.
AppBundle\Entity\Notification No errors.
AppBundle\Entity\Event No errors.
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.