GET https://asmo.pl/api/templates/1/layers

Query Metrics

12 Database Queries
5 Different statements
36.52 ms Query time
2 Invalid entities
18 Managed entities

Queries

Group similar statements

# Time Info
1 2.99 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 3.17 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.template_id = ? LIMIT 1
Parameters:
[
  1
]
3 3.00 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 2.84 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:
[
  964
]
5 3.45 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
]
6 2.74 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
]
7 3.13 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
]
8 3.36 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 3.28 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
]
10 2.73 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
]
11 2.51 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
]
12 3.33 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
]

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\DonationPresetLayer 6
App\Entity\PresetLayerEffect 5
App\Entity\Effect 3
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.