Symfony Profiler

Query Metrics

4 Database Queries

3 Different statements

7.36 ms Query time

1 Invalid entities

8 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.97 ms
(40.35%)

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:

[
  958
]

View formatted query View runnable query Explain query View query backtrace

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 = ?

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 = 958;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 146)
7	App\Controller\Api\PresetLayerController->update (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

2.34 ms
(31.78%)

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"
]

View formatted query View runnable query Explain query View query backtrace

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

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 = 'stylempl@gmail.com' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 54)
5	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 208)
6	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->loadUser (line 105)
7	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->{closure:Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator::authenticate():105} (line 91)
8	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
9	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 40)
10	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 115)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 178)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 156)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 138)
17	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 38)
18	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 58)
19	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
20	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
21	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 91)
22	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
23	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
24	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
26	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
27	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

2.05 ms
(27.87%)

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 = ? AND t0.kind = ? LIMIT 1

Parameters:

[
  958
  "entry"
]

View formatted query View runnable query Explain query View query backtrace

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 = ?
  AND t0.kind = ?
LIMIT
  1

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 = 958 AND t0.kind = 'entry' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 236)
5	App\Controller\Api\PresetLayerController->update (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

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	2
App\Entity\Effect	2
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.
App\Entity\Effect	No errors.

Symfony Profiler

PATCH https://asmo.pl/api/preset-layers/958

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping