Query Metrics
7
Database Queries
7
Different statements
6.59 ms
Query time
0
Invalid entities
4
Managed entities
Queries
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.