PATCH https://asmo.pl/api/layers/973

Query Metrics

5 Database Queries
5 Different statements
9.66 ms Query time
1 Invalid entities
4 Managed entities

Queries

Group similar statements

# Time Info
1 1.92 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.nickname AS nickname_3, t0.roles AS roles_4, t0.password AS password_5, t0.is_verified AS is_verified_6, t0.account_type AS account_type_7, t0.categories AS categories_8, t0.avatar_source AS avatar_source_9, t0.custom_avatar AS custom_avatar_10, t0.background_image AS background_image_11, t0.is_company AS is_company_12, t0.full_name AS full_name_13, t0.company_name AS company_name_14, t0.phone AS phone_15, t0.country AS country_16, t0.city AS city_17, t0.address AS address_18, t0.zip_code AS zip_code_19, t20.id AS id_21, t20.default_tts_voice AS default_tts_voice_22, t20.default_tts_language AS default_tts_language_23, t20.message_delay_ms AS message_delay_ms_24, t20.max_tts_duration_sec AS max_tts_duration_sec_25, t20.test_donation_text AS test_donation_text_26, t20.test_donation_username AS test_donation_username_27, t20.test_donation_amount AS test_donation_amount_28, t20.test_donation_gif AS test_donation_gif_29, t20.show_test_donation_data AS show_test_donation_data_30, t20.user_id AS user_id_31 FROM `user` t0 LEFT JOIN user_donation_settings t20 ON t20.user_id = t0.id WHERE t0.email = ? LIMIT 1
Parameters:
[
  "stylempl@gmail.com"
]
2 1.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.width AS width_4, t0.height AS height_5, t0.color AS color_6, t0.font_size AS font_size_7, t0.position_x AS position_x_8, t0.position_y AS position_y_9, t0.editable AS editable_10, t0.content AS content_11, t0.text_shadow_color AS text_shadow_color_12, t0.text_shadow_blur AS text_shadow_blur_13, t0.text_shadow_alpha AS text_shadow_alpha_14, t0.font_family AS font_family_15, t0.text_align AS text_align_16, t0.sort_order AS sort_order_17, t0.delay AS delay_18, t0.display_duration AS display_duration_19, t0.volume AS volume_20, t0.always_visible AS always_visible_21, t0.hide AS hide_22, t0.duration AS duration_23, t0.preset_id AS preset_id_24 FROM donation_preset_layer t0 WHERE t0.id = ?
Parameters:
[
  973
]
3 1.99 ms
"START TRANSACTION"
Parameters:
[]
4 2.47 ms
UPDATE donation_preset_layer SET position_x = ?, position_y = ? WHERE id = ?
Parameters:
[
  67
  16
  973
]
5 2.01 ms
"COMMIT"
Parameters:
[]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\User 1
App\Entity\UserDonationSettings 1
App\Entity\DonationPresetLayer 1
App\Entity\DonationPreset 1

Entities Mapping

Class Mapping errors
App\Entity\User
  • The field App\Entity\User#mediaAssets is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\MediaAsset#user does not contain the required 'inversedBy="mediaAssets"' attribute.
  • The field App\Entity\User#donationGoals is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\DonationGoal#user does not contain the required 'inversedBy="donationGoals"' attribute.
  • The field App\Entity\User#donationPolls is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\DonationPoll#user does not contain the required 'inversedBy="donationPolls"' attribute.
  • The field App\Entity\User#donationWheelSpins is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\DonationWheelSpin#user does not contain the required 'inversedBy="donationWheelSpins"' attribute.
  • The field App\Entity\User#donationEvents is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\DonationEvent#user does not contain the required 'inversedBy="donationEvents"' attribute.
  • The field App\Entity\User#donationFonts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\DonationFont#user does not contain the required 'inversedBy="donationFonts"' attribute.
App\Entity\UserDonationSettings No errors.
App\Entity\MediaAsset No errors.
App\Entity\DonationGoal No errors.
App\Entity\DonationPoll No errors.
App\Entity\DonationWheelSpin No errors.
App\Entity\DonationEvent No errors.
App\Entity\DonationFont No errors.
App\Entity\DonationPresetLayer No errors.
App\Entity\DonationPreset No errors.
App\Entity\PresetLayerEffect No errors.