Query Metrics
6
Database Queries
6
Different statements
1.33 ms
Query time
0
Invalid entities
2
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
0.55 ms (40.98%) |
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:
[
3
]
|
||||||||||||||||||||||||||||||
|
0.32 ms (23.94%) |
1 |
SELECT COUNT(s0_.id) AS sclr_0 FROM subscription s0_ WHERE s0_.creator_id = ? AND s0_.status = ? AND (s0_.expires_at IS NULL OR s0_.expires_at > ?)
Parameters:
[ 2 "active" "2026-04-26 15:12:24" ]
|
||||||||||||||||||||||||||||||
|
0.14 ms (10.20%) |
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.12 ms (9.02%) |
1 |
SELECT COUNT(p0_.id) AS sclr_0 FROM post p0_ WHERE p0_.creator_id = ?
Parameters:
[
2
]
|
||||||||||||||||||||||||||||||
|
0.12 ms (8.72%) |
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_ WHERE v0_.status = ? ORDER BY v0_.submitted_at ASC
Parameters:
[
"pending"
]
|
||||||||||||||||||||||||||||||
|
0.10 ms (7.14%) |
1 |
SELECT COUNT(s0_.id) AS sclr_0 FROM support_ticket s0_ WHERE s0_.status = ?
Parameters:
[
"open"
]
|
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 | 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\Tag | No errors. |
| App\Entity\Post | No errors. |
| App\Entity\Subscription | No errors. |
| App\Entity\PostReport | No errors. |
| App\Entity\SupportTicket | No errors. |
| App\Entity\VerificationRequest | No errors. |