GET https://app.vchat.dev/paywall/special/check

Query Metrics

7 Database Queries
7 Different statements
6.59 ms Query time
0 Invalid entities
4 Managed entities

Queries

Group similar statements

default connection

# Time Info
1 0.78 ms
SELECT t0.ip_number AS ip_number_1, t0.ip AS ip_2, t0.country_code AS country_code_3, t0.city_name AS city_name_4, t0.country_name AS country_name_5, t0.region_name AS region_name_6, t0.region_short_name AS region_short_name_7, t0.timezone AS timezone_8, t0.zipcode AS zipcode_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.is_proxy AS is_proxy_12, t0.proxy_type AS proxy_type_13, t0.risk_score AS risk_score_14 FROM ip_geo t0 WHERE t0.ip_number = ?
Parameters:
[
  1332642299
]
2 1.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.birth_date AS birth_date_3, t0.gender AS gender_4, t0.orientation AS orientation_5, t0.email AS email_6, t0.pwd AS pwd_7, t0.ok AS ok_8, t0.create_ts AS create_ts_9, t0.partner_id AS partner_id_10, t0.application AS application_11, t0.is_fake AS is_fake_12, t0.timezone AS timezone_13, t0.locale AS locale_14, t0.category AS category_15, t0.platform AS platform_16, t0.previous_avatar_photo_id AS previous_avatar_photo_id_17, t0.is_request_log_enabled AS is_request_log_enabled_18, t0.is_socket_message_log_enabled AS is_socket_message_log_enabled_19, t0.is_amplitude_log_enabled AS is_amplitude_log_enabled_20, t0.deactivated_at AS deactivated_at_21, t0.region AS region_22, t0.previous_ok AS previous_ok_23, t0.roles AS roles_24, t0.kasha_revision_id AS kasha_revision_id_25, t0.kasha_funnel_id AS kasha_funnel_id_26, t0.deleted_at AS deleted_at_27, t0.photo_id AS photo_id_28, t29.id AS id_30, t29.agency_id AS agency_id_31, t29.referrer_id AS referrer_id_32, t29.comment AS comment_33, t29.nationality AS nationality_34, t29.languages AS languages_35, t29.priority AS priority_36, t29.retention_priority AS retention_priority_37, t29.photo_validation_status AS photo_validation_status_38, t29.public_visible AS public_visible_39, t29.verification_status AS verification_status_40, t29.banned_until AS banned_until_41, t29.has_role_agent AS has_role_agent_42, t29.has_role_referral AS has_role_referral_43, t29.has_role_worker AS has_role_worker_44, t29.ban_status AS ban_status_45, t29.feedback_rating AS feedback_rating_46, t29.profile_category AS profile_category_47, t29.moderated_at AS moderated_at_48, t29.is_hiti_flutter AS is_hiti_flutter_49, t29.is_welcome_snfsent AS is_welcome_snfsent_50, t29.is_post_onboarding_earn_snfsent AS is_post_onboarding_earn_snfsent_51, t29.priority_hold_until AS priority_hold_until_52, t29.level_change_check_at AS level_change_check_at_53, t29.created_at AS created_at_54, t29.updated_at AS updated_at_55, t29.user_id AS user_id_56 FROM users t0 LEFT JOIN streamer t29 ON t29.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  150519
]
3 0.87 ms
SELECT b0_.id AS id_0, b0_.device_id AS device_id_1, b0_.ban_reason_type_key AS ban_reason_type_key_2 FROM banned_user_device b0_ WHERE b0_.device_id = ?
Parameters:
[
  "c5529d07-7a4f-4e52-8715-d262f1d98cbe"
]
4 1.03 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.birth_date AS birth_date_3, t0.gender AS gender_4, t0.orientation AS orientation_5, t0.email AS email_6, t0.pwd AS pwd_7, t0.ok AS ok_8, t0.create_ts AS create_ts_9, t0.partner_id AS partner_id_10, t0.application AS application_11, t0.is_fake AS is_fake_12, t0.timezone AS timezone_13, t0.locale AS locale_14, t0.category AS category_15, t0.platform AS platform_16, t0.previous_avatar_photo_id AS previous_avatar_photo_id_17, t0.is_request_log_enabled AS is_request_log_enabled_18, t0.is_socket_message_log_enabled AS is_socket_message_log_enabled_19, t0.is_amplitude_log_enabled AS is_amplitude_log_enabled_20, t0.deactivated_at AS deactivated_at_21, t0.region AS region_22, t0.previous_ok AS previous_ok_23, t0.roles AS roles_24, t0.kasha_revision_id AS kasha_revision_id_25, t0.kasha_funnel_id AS kasha_funnel_id_26, t0.deleted_at AS deleted_at_27, t0.photo_id AS photo_id_28, t29.id AS id_30, t29.agency_id AS agency_id_31, t29.referrer_id AS referrer_id_32, t29.comment AS comment_33, t29.nationality AS nationality_34, t29.languages AS languages_35, t29.priority AS priority_36, t29.retention_priority AS retention_priority_37, t29.photo_validation_status AS photo_validation_status_38, t29.public_visible AS public_visible_39, t29.verification_status AS verification_status_40, t29.banned_until AS banned_until_41, t29.has_role_agent AS has_role_agent_42, t29.has_role_referral AS has_role_referral_43, t29.has_role_worker AS has_role_worker_44, t29.ban_status AS ban_status_45, t29.feedback_rating AS feedback_rating_46, t29.profile_category AS profile_category_47, t29.moderated_at AS moderated_at_48, t29.is_hiti_flutter AS is_hiti_flutter_49, t29.is_welcome_snfsent AS is_welcome_snfsent_50, t29.is_post_onboarding_earn_snfsent AS is_post_onboarding_earn_snfsent_51, t29.priority_hold_until AS priority_hold_until_52, t29.level_change_check_at AS level_change_check_at_53, t29.created_at AS created_at_54, t29.updated_at AS updated_at_55, t29.user_id AS user_id_56 FROM users t0 LEFT JOIN streamer t29 ON t29.user_id = t0.id WHERE t0.email = ? AND t0.application = ? AND t0.deleted_at IS NULL LIMIT 1
Parameters:
[
  "bdbdbdbdjj@gmail.com"
  "ios_chat"
]
5 1.15 ms
SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.platform AS platform_3, t0.application AS application_4, t0.view_type AS view_type_5, t0.`order` AS order_6, t0.not_enough_shown AS not_enough_shown_7, t0.used AS used_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.pay_bundle_id AS pay_bundle_id_11 FROM customer_special_activated t0 WHERE t0.customer_id = ? AND t0.platform = ? AND t0.application = ? AND t0.used = ? LIMIT 1
Parameters:
[
  b"\x01™=|ÕôuÁÊ75\x0F©\x01"
  1
  "ios_chat"
  0
]

customer connection

# Time Info
1 0.66 ms
SELECT c0_.id AS id_0, c0_.account_id AS account_id_1, c0_.source AS source_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c0_.customer_id AS customer_id_5 FROM customer_account_binding c0_ WHERE c0_.account_id = ? AND c0_.source = ?
Parameters:
[
  150519
  "ios_chat"
]
2 0.88 ms
SELECT t0.id AS id_1, t0.roles AS roles_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM customer t0 WHERE t0.id = ?
Parameters:
[
  b"\x01™=|ÕôuÁÊ75\x0F©\x01"
]

Database Connections

Name Service
default doctrine.dbal.default_connection
log doctrine.dbal.log_connection
thread doctrine.dbal.thread_connection
thread_1 doctrine.dbal.thread_1_connection
thread_2 doctrine.dbal.thread_2_connection
thread_3 doctrine.dbal.thread_3_connection
thread_4 doctrine.dbal.thread_4_connection
thread_5 doctrine.dbal.thread_5_connection
thread_6 doctrine.dbal.thread_6_connection
thread_7 doctrine.dbal.thread_7_connection
thread_8 doctrine.dbal.thread_8_connection
thread_9 doctrine.dbal.thread_9_connection
thread_10 doctrine.dbal.thread_10_connection
customer doctrine.dbal.customer_connection
media doctrine.dbal.media_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
log doctrine.orm.log_entity_manager
thread doctrine.orm.thread_entity_manager
thread_1 doctrine.orm.thread_1_entity_manager
thread_2 doctrine.orm.thread_2_entity_manager
thread_3 doctrine.orm.thread_3_entity_manager
thread_4 doctrine.orm.thread_4_entity_manager
thread_5 doctrine.orm.thread_5_entity_manager
thread_6 doctrine.orm.thread_6_entity_manager
thread_7 doctrine.orm.thread_7_entity_manager
thread_8 doctrine.orm.thread_8_entity_manager
thread_9 doctrine.orm.thread_9_entity_manager
thread_10 doctrine.orm.thread_10_entity_manager
customer doctrine.orm.customer_entity_manager
media doctrine.orm.media_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Main\Geo\IpGeo 1
App\Entity\Main\User\User 1

log entity manager

Class Amount of managed objects

thread entity manager

Class Amount of managed objects

thread_1 entity manager

Class Amount of managed objects

thread_2 entity manager

Class Amount of managed objects

thread_3 entity manager

Class Amount of managed objects

thread_4 entity manager

Class Amount of managed objects

thread_5 entity manager

Class Amount of managed objects

thread_6 entity manager

Class Amount of managed objects

thread_7 entity manager

Class Amount of managed objects

thread_8 entity manager

Class Amount of managed objects

thread_9 entity manager

Class Amount of managed objects

thread_10 entity manager

Class Amount of managed objects

customer entity manager

Class Amount of managed objects
App\Domain\Customer\Infrastructure\Doctrine\Mapping\AccountBinding 1
App\Domain\Customer\Infrastructure\Doctrine\Mapping\Customer 1

media entity manager

Class Amount of managed objects

Entities Mapping

default entity manager

Class Mapping errors
App\Entity\Main\Geo\IpGeo No errors.
App\Entity\Main\User\User No errors.
App\Entity\Main\User\UserPhoto No errors.
App\Entity\Main\Streamer\Streamer No errors.
App\Entity\Main\User\Auth\OAuthAccessToken No errors.
App\Entity\Main\User\UserInterest No errors.
App\Entity\Main\User\Auth\UserAuthKey No errors.
App\Entity\Main\User\UserComplaint No errors.
App\Entity\Main\Device\AppInstall No errors.
App\Entity\Main\Experiment\UserExperiment No errors.
App\Entity\Main\Balance\UserCoinBalance No errors.
App\Entity\Main\User\BannedUserDevice No errors.
App\Entity\Main\Special\CustomerActivatedSpecial No errors.
App\Entity\Main\PayBundle No errors.

log entity manager

No loaded entities.

thread entity manager

No loaded entities.

thread_1 entity manager

No loaded entities.

thread_2 entity manager

No loaded entities.

thread_3 entity manager

No loaded entities.

thread_4 entity manager

No loaded entities.

thread_5 entity manager

No loaded entities.

thread_6 entity manager

No loaded entities.

thread_7 entity manager

No loaded entities.

thread_8 entity manager

No loaded entities.

thread_9 entity manager

No loaded entities.

thread_10 entity manager

No loaded entities.

customer entity manager

Class Mapping errors
App\Domain\Customer\Infrastructure\Doctrine\Mapping\AccountBinding No errors.
App\Domain\Customer\Infrastructure\Doctrine\Mapping\Customer No errors.

media entity manager

No loaded entities.