Query Metrics
7
Database Queries
6
Different statements
1.75 ms
Query time
0
Invalid entities
5
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
0.68 ms (38.86%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.created_at AS created_at_5, t0.is_verified AS is_verified_6, t0.is_banned AS is_banned_7, t0.welcome_seen AS welcome_seen_8, t0.phone_verified AS phone_verified_9, t0.email_verification_token AS email_verification_token_10, t0.email_verification_token_expires_at AS email_verification_token_expires_at_11, t0.registration_ip AS registration_ip_12, t0.registration_country AS registration_country_13, t0.registration_city AS registration_city_14, t0.registration_region AS registration_region_15, t0.registration_latitude AS registration_latitude_16, t0.registration_longitude AS registration_longitude_17, t0.user_type AS user_type_18, t19.id AS id_20, t19.pseudo AS pseudo_21, t19.first_name AS first_name_22, t19.last_name AS last_name_23, t19.date_of_birth AS date_of_birth_24, t19.phone AS phone_25, t19.profile_picture AS profile_picture_26, t19.gender AS gender_27, t19.country AS country_28, t19.bio AS bio_29, t19.created_at AS created_at_30, t19.user_id AS user_id_31, t32.id AS id_33, t32.pseudo AS pseudo_34, t32.first_name AS first_name_35, t32.last_name AS last_name_36, t32.date_of_birth AS date_of_birth_37, t32.country AS country_38, t32.bio AS bio_39, t32.profile_picture AS profile_picture_40, t32.cover_picture AS cover_picture_41, t32.height AS height_42, t32.weight AS weight_43, t32.shoe_size AS shoe_size_44, t32.has_tattoo AS has_tattoo_45, t32.tattoo_description AS tattoo_description_46, t32.has_piercing AS has_piercing_47, t32.piercing_description AS piercing_description_48, t32.gender AS gender_49, t32.phone AS phone_50, t32.website AS website_51, t32.instagram AS instagram_52, t32.snapchat AS snapchat_53, t32.show_subscribers_count AS show_subscribers_count_54, t32.show_posts_count AS show_posts_count_55, t32.origin AS origin_56, t32.has_pedicure AS has_pedicure_57, t32.sexual_orientation AS sexual_orientation_58, t32.hair_color AS hair_color_59, t32.created_at AS created_at_60, t32.subscription_price AS subscription_price_61, t32.id_document_path AS id_document_path_62, t32.selfie_document_path AS selfie_document_path_63, t32.is_certified AS is_certified_64, t32.auto_message_enabled AS auto_message_enabled_65, t32.auto_message_content AS auto_message_content_66, t32.notif_new_subscriber AS notif_new_subscriber_67, t32.notif_new_message AS notif_new_message_68, t32.notif_new_like AS notif_new_like_69, t32.iban AS iban_70, t32.bic AS bic_71, t32.bank_account_name AS bank_account_name_72, t32.user_id AS user_id_73 FROM `user` t0 LEFT JOIN fan_profile t19 ON t19.user_id = t0.id LEFT JOIN creator_profile t32 ON t32.user_id = t0.id WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
|
0.39 ms (22.14%) |
2 |
SELECT v0_.id AS id_0, v0_.status AS status_1, v0_.full_name AS full_name_2, v0_.document_type AS document_type_3, v0_.document_note AS document_note_4, v0_.submitted_at AS submitted_at_5, v0_.reviewed_at AS reviewed_at_6, v0_.admin_note AS admin_note_7, v0_.creator_id AS creator_id_8 FROM verification_request v0_ WHERE v0_.status = ? ORDER BY v0_.submitted_at ASC
Parameters:
[
"pending"
]
|
||||||||||||||||||||||||||||
|
0.21 ms (11.87%) |
1 |
SELECT t0.id AS id_1, t0.pseudo AS pseudo_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.date_of_birth AS date_of_birth_5, t0.country AS country_6, t0.bio AS bio_7, t0.profile_picture AS profile_picture_8, t0.cover_picture AS cover_picture_9, t0.height AS height_10, t0.weight AS weight_11, t0.shoe_size AS shoe_size_12, t0.has_tattoo AS has_tattoo_13, t0.tattoo_description AS tattoo_description_14, t0.has_piercing AS has_piercing_15, t0.piercing_description AS piercing_description_16, t0.gender AS gender_17, t0.phone AS phone_18, t0.website AS website_19, t0.instagram AS instagram_20, t0.snapchat AS snapchat_21, t0.show_subscribers_count AS show_subscribers_count_22, t0.show_posts_count AS show_posts_count_23, t0.origin AS origin_24, t0.has_pedicure AS has_pedicure_25, t0.sexual_orientation AS sexual_orientation_26, t0.hair_color AS hair_color_27, t0.created_at AS created_at_28, t0.subscription_price AS subscription_price_29, t0.id_document_path AS id_document_path_30, t0.selfie_document_path AS selfie_document_path_31, t0.is_certified AS is_certified_32, t0.auto_message_enabled AS auto_message_enabled_33, t0.auto_message_content AS auto_message_content_34, t0.notif_new_subscriber AS notif_new_subscriber_35, t0.notif_new_message AS notif_new_message_36, t0.notif_new_like AS notif_new_like_37, t0.iban AS iban_38, t0.bic AS bic_39, t0.bank_account_name AS bank_account_name_40, t0.user_id AS user_id_41 FROM creator_profile t0 WHERE t0.id = ?
Parameters:
[
2
]
|
||||||||||||||||||||||||||||
|
0.19 ms (11.08%) |
1 |
SELECT COUNT(s0_.id) AS sclr_0 FROM support_ticket s0_ WHERE s0_.status = ?
Parameters:
[
"open"
]
|
||||||||||||||||||||||||||||
|
0.15 ms (8.29%) |
1 |
SELECT p0_.id AS id_0, p0_.reason AS reason_1, p0_.created_at AS created_at_2, p0_.post_id AS post_id_3, p0_.user_id AS user_id_4 FROM post_report p0_ ORDER BY p0_.created_at DESC LIMIT 999
Parameters:
[] |
||||||||||||||||||||||||||||
|
0.14 ms (7.77%) |
1 |
SELECT v0_.id AS id_0, v0_.status AS status_1, v0_.full_name AS full_name_2, v0_.document_type AS document_type_3, v0_.document_note AS document_note_4, v0_.submitted_at AS submitted_at_5, v0_.reviewed_at AS reviewed_at_6, v0_.admin_note AS admin_note_7, v0_.creator_id AS creator_id_8 FROM verification_request v0_ ORDER BY v0_.submitted_at DESC
Parameters:
[]
|
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\User | 2 |
| App\Entity\FanProfile | 1 |
| App\Entity\VerificationRequest | 1 |
| App\Entity\CreatorProfile | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\FanProfile | No errors. |
| App\Entity\CreatorProfile | No errors. |
| App\Entity\VerificationRequest | No errors. |
| App\Entity\PostReport | No errors. |
| App\Entity\Post | No errors. |
| App\Entity\SupportTicket | No errors. |
| App\Entity\Tag | No errors. |