GET https://dev.musicdistributions.com/operator/chat/2

Query Metrics

7 Database Queries
6 Different statements
10.63 ms Query time
0 Invalid entities
34 Managed entities

Queries

Group similar statements

# Time Info
1 0.76 ms
SELECT d0_.domain AS domain_0, d0_.activity AS activity_1, d0_.id AS id_2, d0_.created AS created_3, d0_.modified AS modified_4, d0_.company_name AS company_name_5, d0_.company_address AS company_address_6, d0_.primary_email AS primary_email_7, d0_.support_email AS support_email_8, d0_.sales_email AS sales_email_9, d0_.telegram AS telegram_10, d0_.vk AS vk_11, d0_.contact_person AS contact_person_12, d0_.contract_no AS contract_no_13, d0_.label_name AS label_name_14, d0_.label_country AS label_country_15, d0_.personal_percentage AS personal_percentage_16, d0_.percentage AS percentage_17, d0_.inside_percentage AS inside_percentage_18, d0_.type AS type_19, d0_.policies_id AS policies_id_20, d0_.terms_id AS terms_id_21, d0_.privacy_id AS privacy_id_22 FROM domains d0_ WHERE (d0_.domain = ?) AND d0_.type IN ('CUSTOM_DOMAIN', 'LABEL_DOMAIN')
Parameters:
[
  "dev.musicdistributions.com"
]
2 0.64 ms
SELECT d0_.domain AS domain_0, d0_.activity AS activity_1, d0_.id AS id_2, d0_.created AS created_3, d0_.modified AS modified_4, d0_.company_name AS company_name_5, d0_.company_address AS company_address_6, d0_.primary_email AS primary_email_7, d0_.support_email AS support_email_8, d0_.sales_email AS sales_email_9, d0_.telegram AS telegram_10, d0_.vk AS vk_11, d0_.contact_person AS contact_person_12, d0_.contract_no AS contract_no_13, d0_.label_name AS label_name_14, d0_.label_country AS label_country_15, d0_.personal_percentage AS personal_percentage_16, d0_.percentage AS percentage_17, d0_.inside_percentage AS inside_percentage_18, d0_.type AS type_19, d0_.policies_id AS policies_id_20, d0_.terms_id AS terms_id_21, d0_.privacy_id AS privacy_id_22 FROM domains d0_ WHERE (d0_.activity = 1 AND d0_.domain = ?) AND d0_.type IN ('LABEL_DOMAIN')
Parameters:
[
  "dev.musicdistributions.com"
]
3 6.90 ms
SELECT t0.ip AS ip_1, t0.strike AS strike_2, t0.last_activity AS last_activity_3, t0.password AS password_4, t0.roles AS roles_5, t0.first_name AS first_name_6, t0.middle_name AS middle_name_7, t0.last_name AS last_name_8, t0.email AS email_9, t0.phone AS phone_10, t0.country AS country_11, t0.activity AS activity_12, t0.id AS id_13, t0.created AS created_14, t0.modified AS modified_15, t0.percentage AS percentage_16, t0.inside_percentage AS inside_percentage_17, t19.verified_email AS verified_email_18, t19.id AS id_20, t19.created AS created_21, t19.modified AS modified_22, t19.user_id AS user_id_23, t0.context_id AS context_id_24, t0.referral_id AS referral_id_25, t0.discr FROM users t0 LEFT JOIN kyc t19 ON t19.user_id = t0.id WHERE t0.id = ? AND t0.discr IN ('user')
Parameters:
[
  1
]
4 0.64 ms
SELECT t0.telegram_user_id AS telegram_user_id_1, t0.username AS username_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.id AS id_5 FROM support_chats t0 WHERE t0.id = ?
Parameters:
[
  "2"
]
5 0.37 ms
SELECT t0.sender_type AS sender_type_1, t0.text AS text_2, t0.file AS file_3, t0.id AS id_4, t0.created AS created_5, t0.chat_id AS chat_id_6 FROM support_chat_messages t0 WHERE t0.chat_id = ? ORDER BY t0.id ASC
Parameters:
[
  2
]
6 0.69 ms
SELECT t0.status AS status_1, t0.accepting_date AS accepting_date_2, t0.release_title AS release_title_3, t0.additional_info AS additional_info_4, t0.moderation_comment AS moderation_comment_5, t0.label AS label_6, t0.copyright_year AS copyright_year_7, t0.copyright_holder AS copyright_holder_8, t0.copyright_music AS copyright_music_9, t0.platforms AS platforms_10, t0.territories AS territories_11, t0.upc AS upc_12, t0.primary_artist AS primary_artist_13, t0.feat_artist AS feat_artist_14, t0.start_sales_date AS start_sales_date_15, t0.old_start_sales_date AS old_start_sales_date_16, t0.image AS image_17, t0.language AS language_18, t0.id AS id_19, t0.created AS created_20, t0.modified AS modified_21, t0.white_label_id AS white_label_id_22, t0.owner_id AS owner_id_23, t0.genre_id AS genre_id_24 FROM releases t0 WHERE t0.owner_id = ? AND t0.status = ?
Parameters:
[
  1
  2
]
7 0.64 ms
SELECT t0.status AS status_1, t0.accepting_date AS accepting_date_2, t0.release_title AS release_title_3, t0.additional_info AS additional_info_4, t0.moderation_comment AS moderation_comment_5, t0.label AS label_6, t0.copyright_year AS copyright_year_7, t0.copyright_holder AS copyright_holder_8, t0.copyright_music AS copyright_music_9, t0.platforms AS platforms_10, t0.territories AS territories_11, t0.upc AS upc_12, t0.primary_artist AS primary_artist_13, t0.feat_artist AS feat_artist_14, t0.start_sales_date AS start_sales_date_15, t0.old_start_sales_date AS old_start_sales_date_16, t0.image AS image_17, t0.language AS language_18, t0.id AS id_19, t0.created AS created_20, t0.modified AS modified_21, t0.white_label_id AS white_label_id_22, t0.owner_id AS owner_id_23, t0.genre_id AS genre_id_24 FROM releases t0 WHERE t0.owner_id = ? AND t0.status = ?
Parameters:
[
  1
  2
]

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\Entity\SupportChatMessage 25
App\Entity\GeneratedDoc 3
App\Entity\Abstracts\Domain 1
App\Entity\Abstracts\User 1
App\Entity\Kyc 1
App\Entity\SupportChat 1
App\Entity\Release 1
App\Entity\Genre 1

Entities Mapping