GET http://bandoo-dev.ru/api/app/campaigns/pending

Query Metrics

2 Database Queries
2 Different statements
11.11 ms Query time
3 Invalid entities
2 Managed entities

Queries

Group similar statements

# Time Info
1 4.95 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_.vk_profile_imported AS vk_profile_imported_17, u0_.vk_confirmed AS vk_confirmed_18, u0_.first_jwt_at AS first_jwt_at_19, u0_.new_email AS new_email_20, u0_.new_email_token AS new_email_token_21, u0_.status AS status_22, u0_.block_reason AS block_reason_23, u0_.role AS role_24, u0_.last_visit_at AS last_visit_at_25, u0_.activity_status AS activity_status_26, u0_.confirm_token_token AS confirm_token_token_27, u0_.confirm_token_expires AS confirm_token_expires_28, u0_.name_first AS name_first_29, u0_.name_last AS name_last_30, u0_.name_middle AS name_middle_31, u0_.avatar_small_hash AS avatar_small_hash_32, u0_.avatar_original_hash AS avatar_original_hash_33, u0_.reset_token_token AS reset_token_token_34, u0_.reset_token_expires AS reset_token_expires_35, u0_.city_id AS city_id_36 FROM "user_users" u0_ WHERE u0_.email = ?
Parameters:
[
  "1a8395f8-35f3-4830-a427-6eae60d2c576@1f226046-3b14-49b3-9753-2b4c6bd31aba.com"
]
2 6.16 ms
SELECT a0_.id AS id_0, a0_.slug AS slug_1, a0_.title AS title_2, a0_.body AS body_3, a0_.image_url AS image_url_4, a0_.display_mode AS display_mode_5, a0_.delay_days AS delay_days_6, a0_.starts_at AS starts_at_7, a0_.ends_at AS ends_at_8, a0_.priority AS priority_9, a0_.allow_dismiss_forever AS allow_dismiss_forever_10, a0_.is_active AS is_active_11, a0_.created_at AS created_at_12 FROM app_campaign a0_ WHERE a0_.is_active = ? ORDER BY a0_.priority DESC, a0_.created_at ASC
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\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\AppCampaign\Entity\AppCampaign No errors.
App\Model\AppCampaign\Entity\AppCampaignLink No errors.
App\Model\AppCampaign\Entity\AppCampaignUserState No errors.