Query Metrics
7
Database Queries
6
Different statements
7.76 ms
Query time
0
Invalid entities
34
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
3.32 ms (42.87%) |
1 |
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
]
|
||||||||||||||||||||||||||
|
2.05 ms (26.39%) |
2 |
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 ] |
||||||||||||||||||||||||||
|
0.79 ms (10.16%) |
1 |
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"
]
|
||||||||||||||||||||||||||
|
0.67 ms (8.65%) |
1 |
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"
]
|
||||||||||||||||||||||||||
|
0.60 ms (7.75%) |
1 |
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"
]
|
||||||||||||||||||||||||||
|
0.32 ms (4.18%) |
1 |
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
]
|
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
| Class | Mapping errors |
|---|---|
| App\Entity\Abstracts\Domain | No errors. |
| App\Entity\Domain\CustomDomain | No errors. |
| App\Entity\Domain\WhiteLabel | No errors. |
| App\Entity\GeneratedDoc | No errors. |
| App\Entity\Balance | No errors. |
| App\Entity\Abstracts\User | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Kyc | No errors. |
| App\Entity\Release | No errors. |
| App\Entity\PaymentInfo | No errors. |
| App\Entity\SupportChat | No errors. |
| App\Entity\SupportChatMessage | No errors. |
| App\Entity\Genre | No errors. |
| App\Entity\Track | No errors. |