Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

26.06 ms Query time

4 Invalid entities

2 Managed entities

Queries

Group similar statements

#▲	Time	Info
1	9.49 ms	SELECT u0_.id AS id_0, u0_.public_number AS public_number_1, u0_.date AS date_2, u0_.email AS email_3, u0_.phone AS phone_4, u0_.phone_numeric AS phone_numeric_5, u0_.privacy_mask AS privacy_mask_6, u0_.push_settings_mask AS push_settings_mask_7, u0_.publish_daily_count AS publish_daily_count_8, u0_.publish_daily_at AS publish_daily_at_9, u0_.settings AS settings_10, u0_.password AS password_11, u0_.about AS about_12, u0_.stuff AS stuff_13, u0_.vk_code_verifier AS vk_code_verifier_14, u0_.vk_id AS vk_id_15, u0_.vk_avatar AS vk_avatar_16, u0_.new_email AS new_email_17, u0_.new_email_token AS new_email_token_18, u0_.status AS status_19, u0_.role AS role_20, u0_.is_online AS is_online_21, u0_.last_visit AS last_visit_22, u0_.last_visit_at AS last_visit_at_23, u0_.confirm_token_token AS confirm_token_token_24, u0_.confirm_token_expires AS confirm_token_expires_25, u0_.name_first AS name_first_26, u0_.name_last AS name_last_27, u0_.name_middle AS name_middle_28, u0_.avatar_small_hash AS avatar_small_hash_29, u0_.avatar_original_hash AS avatar_original_hash_30, u0_.reset_token_token AS reset_token_token_31, u0_.reset_token_expires AS reset_token_expires_32, u0_.city_id AS city_id_33 FROM "user_users" u0_ WHERE u0_.email = ? Parameters: [`"80e51a4e-1b0b-456a-93dd-210d099ca9ed@775d2008-9edb-4e71-bccf-e3a51be771ba.com"`] View formatted query View runnable query Explain query SELECT u0_.id AS id_0, u0_.public_number AS public_number_1, u0_.date AS date_2, u0_.email AS email_3, u0_.phone AS phone_4, u0_.phone_numeric AS phone_numeric_5, u0_.privacy_mask AS privacy_mask_6, u0_.push_settings_mask AS push_settings_mask_7, u0_.publish_daily_count AS publish_daily_count_8, u0_.publish_daily_at AS publish_daily_at_9, u0_.settings AS settings_10, u0_.password AS password_11, u0_.about AS about_12, u0_.stuff AS stuff_13, u0_.vk_code_verifier AS vk_code_verifier_14, u0_.vk_id AS vk_id_15, u0_.vk_avatar AS vk_avatar_16, u0_.new_email AS new_email_17, u0_.new_email_token AS new_email_token_18, u0_.status AS status_19, u0_.role AS role_20, u0_.is_online AS is_online_21, u0_.last_visit AS last_visit_22, u0_.last_visit_at AS last_visit_at_23, u0_.confirm_token_token AS confirm_token_token_24, u0_.confirm_token_expires AS confirm_token_expires_25, u0_.name_first AS name_first_26, u0_.name_last AS name_last_27, u0_.name_middle AS name_middle_28, u0_.avatar_small_hash AS avatar_small_hash_29, u0_.avatar_original_hash AS avatar_original_hash_30, u0_.reset_token_token AS reset_token_token_31, u0_.reset_token_expires AS reset_token_expires_32, u0_.city_id AS city_id_33 FROM "user_users" u0_ WHERE u0_.email = ? SELECT u0_.id AS id_0, u0_.public_number AS public_number_1, u0_.date AS date_2, u0_.email AS email_3, u0_.phone AS phone_4, u0_.phone_numeric AS phone_numeric_5, u0_.privacy_mask AS privacy_mask_6, u0_.push_settings_mask AS push_settings_mask_7, u0_.publish_daily_count AS publish_daily_count_8, u0_.publish_daily_at AS publish_daily_at_9, u0_.settings AS settings_10, u0_.password AS password_11, u0_.about AS about_12, u0_.stuff AS stuff_13, u0_.vk_code_verifier AS vk_code_verifier_14, u0_.vk_id AS vk_id_15, u0_.vk_avatar AS vk_avatar_16, u0_.new_email AS new_email_17, u0_.new_email_token AS new_email_token_18, u0_.status AS status_19, u0_.role AS role_20, u0_.is_online AS is_online_21, u0_.last_visit AS last_visit_22, u0_.last_visit_at AS last_visit_at_23, u0_.confirm_token_token AS confirm_token_token_24, u0_.confirm_token_expires AS confirm_token_expires_25, u0_.name_first AS name_first_26, u0_.name_last AS name_last_27, u0_.name_middle AS name_middle_28, u0_.avatar_small_hash AS avatar_small_hash_29, u0_.avatar_original_hash AS avatar_original_hash_30, u0_.reset_token_token AS reset_token_token_31, u0_.reset_token_expires AS reset_token_expires_32, u0_.city_id AS city_id_33 FROM "user_users" u0_ WHERE u0_.email = '80e51a4e-1b0b-456a-93dd-210d099ca9ed@775d2008-9edb-4e71-bccf-e3a51be771ba.com';
2	16.58 ms	SELECT COUNT(a.id) FROM item_items a WHERE a.user_id = ? Parameters: [`"73ee8243-c222-4e78-8531-b0b1108d27bc"`] View formatted query View runnable query Explain query SELECT COUNT(a.id) FROM item_items a WHERE a.user_id = ? SELECT COUNT(a.id) FROM item_items a WHERE a.user_id = '73ee8243-c222-4e78-8531-b0b1108d27bc';

#▲

Time

Info

9.49 ms

SELECT u0_.id AS id_0, u0_.public_number AS public_number_1, u0_.date AS date_2, u0_.email AS email_3, u0_.phone AS phone_4, u0_.phone_numeric AS phone_numeric_5, u0_.privacy_mask AS privacy_mask_6, u0_.push_settings_mask AS push_settings_mask_7, u0_.publish_daily_count AS publish_daily_count_8, u0_.publish_daily_at AS publish_daily_at_9, u0_.settings AS settings_10, u0_.password AS password_11, u0_.about AS about_12, u0_.stuff AS stuff_13, u0_.vk_code_verifier AS vk_code_verifier_14, u0_.vk_id AS vk_id_15, u0_.vk_avatar AS vk_avatar_16, u0_.new_email AS new_email_17, u0_.new_email_token AS new_email_token_18, u0_.status AS status_19, u0_.role AS role_20, u0_.is_online AS is_online_21, u0_.last_visit AS last_visit_22, u0_.last_visit_at AS last_visit_at_23, u0_.confirm_token_token AS confirm_token_token_24, u0_.confirm_token_expires AS confirm_token_expires_25, u0_.name_first AS name_first_26, u0_.name_last AS name_last_27, u0_.name_middle AS name_middle_28, u0_.avatar_small_hash AS avatar_small_hash_29, u0_.avatar_original_hash AS avatar_original_hash_30, u0_.reset_token_token AS reset_token_token_31, u0_.reset_token_expires AS reset_token_expires_32, u0_.city_id AS city_id_33 FROM "user_users" u0_ WHERE u0_.email = ?

Parameters:

[
  "80e51a4e-1b0b-456a-93dd-210d099ca9ed@775d2008-9edb-4e71-bccf-e3a51be771ba.com"
]

View formatted query View runnable query Explain query

SELECT
  u0_.id AS id_0,
  u0_.public_number AS public_number_1,
  u0_.date AS date_2,
  u0_.email AS email_3,
  u0_.phone AS phone_4,
  u0_.phone_numeric AS phone_numeric_5,
  u0_.privacy_mask AS privacy_mask_6,
  u0_.push_settings_mask AS push_settings_mask_7,
  u0_.publish_daily_count AS publish_daily_count_8,
  u0_.publish_daily_at AS publish_daily_at_9,
  u0_.settings AS settings_10,
  u0_.password AS password_11,
  u0_.about AS about_12,
  u0_.stuff AS stuff_13,
  u0_.vk_code_verifier AS vk_code_verifier_14,
  u0_.vk_id AS vk_id_15,
  u0_.vk_avatar AS vk_avatar_16,
  u0_.new_email AS new_email_17,
  u0_.new_email_token AS new_email_token_18,
  u0_.status AS status_19,
  u0_.role AS role_20,
  u0_.is_online AS is_online_21,
  u0_.last_visit AS last_visit_22,
  u0_.last_visit_at AS last_visit_at_23,
  u0_.confirm_token_token AS confirm_token_token_24,
  u0_.confirm_token_expires AS confirm_token_expires_25,
  u0_.name_first AS name_first_26,
  u0_.name_last AS name_last_27,
  u0_.name_middle AS name_middle_28,
  u0_.avatar_small_hash AS avatar_small_hash_29,
  u0_.avatar_original_hash AS avatar_original_hash_30,
  u0_.reset_token_token AS reset_token_token_31,
  u0_.reset_token_expires AS reset_token_expires_32,
  u0_.city_id AS city_id_33
FROM
  "user_users" u0_
WHERE
  u0_.email = ?

SELECT u0_.id AS id_0, u0_.public_number AS public_number_1, u0_.date AS date_2, u0_.email AS email_3, u0_.phone AS phone_4, u0_.phone_numeric AS phone_numeric_5, u0_.privacy_mask AS privacy_mask_6, u0_.push_settings_mask AS push_settings_mask_7, u0_.publish_daily_count AS publish_daily_count_8, u0_.publish_daily_at AS publish_daily_at_9, u0_.settings AS settings_10, u0_.password AS password_11, u0_.about AS about_12, u0_.stuff AS stuff_13, u0_.vk_code_verifier AS vk_code_verifier_14, u0_.vk_id AS vk_id_15, u0_.vk_avatar AS vk_avatar_16, u0_.new_email AS new_email_17, u0_.new_email_token AS new_email_token_18, u0_.status AS status_19, u0_.role AS role_20, u0_.is_online AS is_online_21, u0_.last_visit AS last_visit_22, u0_.last_visit_at AS last_visit_at_23, u0_.confirm_token_token AS confirm_token_token_24, u0_.confirm_token_expires AS confirm_token_expires_25, u0_.name_first AS name_first_26, u0_.name_last AS name_last_27, u0_.name_middle AS name_middle_28, u0_.avatar_small_hash AS avatar_small_hash_29, u0_.avatar_original_hash AS avatar_original_hash_30, u0_.reset_token_token AS reset_token_token_31, u0_.reset_token_expires AS reset_token_expires_32, u0_.city_id AS city_id_33 FROM "user_users" u0_ WHERE u0_.email = '80e51a4e-1b0b-456a-93dd-210d099ca9ed@775d2008-9edb-4e71-bccf-e3a51be771ba.com';

16.58 ms

SELECT COUNT(a.id) FROM item_items a WHERE a.user_id = ?

Parameters:

[
  "73ee8243-c222-4e78-8531-b0b1108d27bc"
]

View formatted query View runnable query Explain query

SELECT
  COUNT(a.id)
FROM
  item_items a
WHERE
  a.user_id = ?

SELECT COUNT(a.id) FROM item_items a WHERE a.user_id = '73ee8243-c222-4e78-8531-b0b1108d27bc';

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\Model\User\Entity\User	1
App\Model\City\Entity\CityReference	1

Entities Mapping

Class	Mapping errors
App\Model\User\Entity\ConfirmToken	No errors.
App\Model\User\Entity\Name	No errors.
App\Model\User\Entity\Avatar	No errors.
App\Model\User\Entity\ResetToken	No errors.
App\Model\User\Entity\User	The field 'App\Model\User\Entity\User#phoneNumeric' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
App\Model\City\Entity\CityReference	The field 'App\Model\City\Entity\CityReference#foundationYear' has the property type 'int' that differs from the metadata field type 'string' returned by the 'string' DBAL type.
App\Model\User\Entity\Network\Network	No errors.
App\Model\User\Entity\Review\Reply	No errors.
App\Model\User\Entity\Review\Review	No errors.
App\Model\User\Entity\Achievement\Achievement	No errors.
App\Model\User\Entity\Photo	No errors.
App\Model\User\Entity\Video	No errors.
App\Model\User\Entity\Audio	The field 'App\Model\User\Entity\Audio#duration' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
App\Model\User\Entity\Album	No errors.
App\Model\User\Entity\Link\Link	No errors.
App\Model\User\Entity\Like\Like	No errors.
App\Model\User\Entity\Viewed\Viewed	No errors.
App\Model\User\Entity\Favorite\Favorite	No errors.
App\Model\User\Entity\FavoriteUser\FavoriteUser	No errors.
App\Model\User\Entity\Message\MessageStatus	No errors.
App\Model\User\Entity\Message\Message	No errors.
App\Model\User\Entity\Instrument\UserInstrument	No errors.
App\Model\User\Entity\FcmToken\UserFcmToken	No errors.
App\Model\Item\Entity\RejectReason\RejectReason	No errors.
App\Model\Item\Entity\Up	No errors.
App\Model\Item\Entity\Job	No errors.
App\Model\Item\Entity\Item	The field App\Model\Item\Entity\Item#claims is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Model\Item\Entity\Claim\ItemClaim#item does not contain the required 'inversedBy="claims"' attribute. The field App\Model\Item\Entity\Item#promotions is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Model\Item\Entity\Promotion\ItemPromotion#item does not contain the required 'inversedBy="promotions"' attribute.

Symfony Profiler

GET http://bandoo-dev.ru/api/user/items-counter/73ee8243-c222-4e78-8531-b0b1108d27bc

Configuration Settings

Theme

Page Width