GET https://admin.dev.rippla.com/admin/influencers/3788

Query Metrics

7 Database Queries
7 Different statements
18.76 ms Query time
10 Invalid entities
11 Managed entities

Queries

Group similar statements

# Time Info
1 3.67 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.password_hash AS password_hash_5, t0.is_active AS is_active_6 FROM admins t0 WHERE t0.id = ?
Parameters:
[
  1
]
2 2.89 ms
SELECT t0.id AS id_1, t0.account AS account_2, t0.engagement_rates AS engagement_rates_3, t0.verification_status AS verification_status_4, t0.full_name AS full_name_5, t0.biography AS biography_6, t0.followers AS followers_7, t0.average_likes AS average_likes_8, t0.average_comments AS average_comments_9, t0.language_code AS language_code_10, t0.verification_code AS verification_code_11, t0.profile_updated AS profile_updated_12, t0.is_datasource_verified AS is_datasource_verified_13, t0.datasource_type AS datasource_type_14, t0.age_group AS age_group_15, t0.avg_reels_plays AS avg_reels_plays_16, t0.avg_shares AS avg_shares_17, t0.email AS email_18, t0.verification_reject_reason AS verification_reject_reason_19, t0.auto_verification_result AS auto_verification_result_20, t0.verification_comment AS verification_comment_21, t0.avg_ratings AS avg_ratings_22, t0.count_ratings AS count_ratings_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.deleted_at AS deleted_at_26, t0.user_id AS user_id_27, t0.service_id AS service_id_28, t0.avatar_id AS avatar_id_29, t0.city_id AS city_id_30 FROM accounts t0 WHERE t0.id = ?
Parameters:
[
  "3788"
]
3 2.89 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.is_blocked AS is_blocked_3, t0.email AS email_4, t0.full_name AS full_name_5, t0.phone AS phone_6, t0.description AS description_7, t0.query_params AS query_params_8, t0.messengers AS messengers_9, t0.preferred_locale AS preferred_locale_10, t0.stripe_customer_id AS stripe_customer_id_11, t0.firebase_uid AS firebase_uid_12, t0.user_uuid_for_create_notification_contact AS user_uuid_for_create_notification_contact_13, t0.notification_settings AS notification_settings_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.deleted_at AS deleted_at_17, t0.accounts AS accounts_18, t0.role FROM users t0 WHERE t0.id = ? AND t0.role IN ('1')
Parameters:
[
  "408"
]
4 1.78 ms
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.type AS type_2, s0_.deleted_at AS deleted_at_3, s0_.icon_id AS icon_id_4 FROM services s0_ WHERE s0_.type = ? AND s0_.deleted_at IS NULL ORDER BY s0_.id ASC
Parameters:
[
  2
]
5 1.31 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.cloudflare_file_id AS cloudflare_file_id_4, t0.type AS type_5, t0.created_at AS created_at_6 FROM files t0 WHERE t0.id = ?
Parameters:
[
  "2276"
]
6 4.22 ms
SELECT t0.id AS id_1, t0.received_at AS received_at_2, t0.data_source AS data_source_3, t0.raw_data AS raw_data_4, t0.processed_data AS processed_data_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.account_id AS account_id_8 FROM account_data t0 WHERE t0.account_id = ?
Parameters:
[
  3788
]
7 2.00 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.origin_title AS origin_title_3 FROM interests t0 INNER JOIN account_interest ON t0.id = account_interest.interest_id WHERE account_interest.account_id = ?
Parameters:
[
  3788
]

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\Domain\User\Entity\Account\Service 5
App\Domain\User\Entity\Account\AccountData 2
App\Domain\User\Entity\Admin\Admin 1
App\Domain\User\Entity\Account\Account 1
App\Domain\User\Entity\User 1
App\Domain\File\File 1

Entities Mapping

Class Mapping errors
App\Domain\User\Entity\Admin\Admin No errors.
App\Domain\User\Entity\Account\Account
  • The field 'App\Domain\User\Entity\Account\Account#engagementRates' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Domain\User\Entity\Account\Account#avgRatings' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Domain\User\Entity\User No errors.
App\Domain\User\Entity\InfluencerUser No errors.
App\Domain\User\Entity\Account\Service No errors.
App\Domain\File\File No errors.
App\Domain\Dictionary\Entity\Coordinate
  • The field 'App\Domain\Dictionary\Entity\Coordinate#latitude' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Domain\Dictionary\Entity\Coordinate#longitude' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Domain\Dictionary\Entity\City
  • The field 'App\Domain\Dictionary\Entity\City#coordinate.latitude' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Domain\Dictionary\Entity\City#coordinate.longitude' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Domain\Dictionary\Entity\Interest No errors.
App\Domain\User\Entity\AccountAudience\AccountAudienceLanguage
  • The field 'App\Domain\User\Entity\AccountAudience\AccountAudienceLanguage#share' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Domain\User\Entity\AccountAudience\AccountAudienceCountry
  • The field 'App\Domain\User\Entity\AccountAudience\AccountAudienceCountry#share' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Domain\User\Entity\AccountAudience\AccountAudienceCity
  • The field 'App\Domain\User\Entity\AccountAudience\AccountAudienceCity#share' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Domain\User\Entity\AccountAudience\AccountAudienceGender
  • The field 'App\Domain\User\Entity\AccountAudience\AccountAudienceGender#share' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Domain\User\Entity\AccountAudience\AccountAudienceAgeRange
  • The field 'App\Domain\User\Entity\AccountAudience\AccountAudienceAgeRange#maleShare' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Domain\User\Entity\AccountAudience\AccountAudienceAgeRange#femaleShare' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Domain\User\Entity\AccountAudience\AccountAudienceAgeRange#share' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Domain\User\Entity\Account\AccountData No errors.
App\Domain\Campaign\Entity\Collaboration\Collaboration No errors.
App\Domain\User\Entity\Account\AccountPost No errors.
App\Domain\User\Entity\RefreshToken No errors.
App\Domain\Notification\Entity\Notification No errors.
App\Domain\Notification\Entity\NotificationContact No errors.
App\Domain\Subscription\Entity\UserSubscription
  • The association App\Domain\Subscription\Entity\UserSubscription#subscriptionChanges refers to the owning side field App\Domain\Subscription\Entity\UserSubscriptionChange#userSubscription which does not exist.
App\Domain\AIAssistant\Entity\AssistantChatMessage
  • The field App\Domain\AIAssistant\Entity\AssistantChatMessage#requests is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Domain\AIAssistant\Entity\AssistantChatMessage#response does not contain the required 'inversedBy: "requests"' attribute.
App\Domain\Subscription\Entity\UserNotificationSubscription No errors.
App\Domain\Location\Entity\Location No errors.