GET https://asmo.pl/api/presets/362/layers

Query Metrics

15 Database Queries
5 Different statements
14.53 ms Query time
2 Invalid entities
25 Managed entities

Queries

Group similar statements

# Time Info
1 3.86 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 0.83 ms
SELECT t0.id AS id_1, t0.min_amount AS min_amount_2, t0.max_amount AS max_amount_3, t0.priority AS priority_4, t0.active AS active_5, t0.sort_order AS sort_order_6, t0.template_id AS template_id_7 FROM donation_preset t0 WHERE t0.id = ?
Parameters:
[
  362
]
3 1.55 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.preset_id = ? ORDER BY t0.sort_order ASC
Parameters:
[
  362
]
4 0.94 ms
SELECT t0.id AS id_1, t0.kind AS kind_2, t0.target AS target_3, t0.sort_order AS sort_order_4, t0.params AS params_5, t0.preset_layer_id AS preset_layer_id_6, t0.effect_id AS effect_id_7 FROM preset_layer_effect t0 WHERE t0.preset_layer_id = ?
Parameters:
[
  975
]
5 0.54 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.display_name AS display_name_3, t0.default_params AS default_params_4, t0.params AS params_5, t0.kinds AS kinds_6 FROM effect t0 WHERE t0.id = ?
Parameters:
[
  5
]
6 0.65 ms
SELECT t0.id AS id_1, t0.kind AS kind_2, t0.target AS target_3, t0.sort_order AS sort_order_4, t0.params AS params_5, t0.preset_layer_id AS preset_layer_id_6, t0.effect_id AS effect_id_7 FROM preset_layer_effect t0 WHERE t0.preset_layer_id = ?
Parameters:
[
  936
]
7 0.57 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.display_name AS display_name_3, t0.default_params AS default_params_4, t0.params AS params_5, t0.kinds AS kinds_6 FROM effect t0 WHERE t0.id = ?
Parameters:
[
  66
]
8 0.60 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.display_name AS display_name_3, t0.default_params AS default_params_4, t0.params AS params_5, t0.kinds AS kinds_6 FROM effect t0 WHERE t0.id = ?
Parameters:
[
  8
]
9 0.49 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.display_name AS display_name_3, t0.default_params AS default_params_4, t0.params AS params_5, t0.kinds AS kinds_6 FROM effect t0 WHERE t0.id = ?
Parameters:
[
  3
]
10 0.61 ms
SELECT t0.id AS id_1, t0.kind AS kind_2, t0.target AS target_3, t0.sort_order AS sort_order_4, t0.params AS params_5, t0.preset_layer_id AS preset_layer_id_6, t0.effect_id AS effect_id_7 FROM preset_layer_effect t0 WHERE t0.preset_layer_id = ?
Parameters:
[
  958
]
11 0.61 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.display_name AS display_name_3, t0.default_params AS default_params_4, t0.params AS params_5, t0.kinds AS kinds_6 FROM effect t0 WHERE t0.id = ?
Parameters:
[
  71
]
12 1.02 ms
SELECT t0.id AS id_1, t0.kind AS kind_2, t0.target AS target_3, t0.sort_order AS sort_order_4, t0.params AS params_5, t0.preset_layer_id AS preset_layer_id_6, t0.effect_id AS effect_id_7 FROM preset_layer_effect t0 WHERE t0.preset_layer_id = ?
Parameters:
[
  937
]
13 0.81 ms
SELECT t0.id AS id_1, t0.kind AS kind_2, t0.target AS target_3, t0.sort_order AS sort_order_4, t0.params AS params_5, t0.preset_layer_id AS preset_layer_id_6, t0.effect_id AS effect_id_7 FROM preset_layer_effect t0 WHERE t0.preset_layer_id = ?
Parameters:
[
  959
]
14 0.94 ms
SELECT t0.id AS id_1, t0.kind AS kind_2, t0.target AS target_3, t0.sort_order AS sort_order_4, t0.params AS params_5, t0.preset_layer_id AS preset_layer_id_6, t0.effect_id AS effect_id_7 FROM preset_layer_effect t0 WHERE t0.preset_layer_id = ?
Parameters:
[
  963
]
15 0.50 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.display_name AS display_name_3, t0.default_params AS default_params_4, t0.params AS params_5, t0.kinds AS kinds_6 FROM effect t0 WHERE t0.id = ?
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\PresetLayerEffect 9
App\Entity\DonationPresetLayer 6
App\Entity\Effect 6
App\Entity\User 1
App\Entity\UserDonationSettings 1
App\Entity\DonationPreset 1
App\Entity\DonationTemplate 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\DonationPreset No errors.
App\Entity\DonationTemplate
  • The field App\Entity\DonationTemplate#presets is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\DonationPreset#template does not contain the required 'inversedBy="presets"' attribute.
App\Entity\DonationPresetLayer No errors.
App\Entity\PresetLayerEffect No errors.
App\Entity\Effect No errors.