Query Metrics
5
Database Queries
5
Different statements
3.72 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.73 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.status AS status_5, t0.phone_number AS phone_number_6, t0.email AS email_7, t0.firstname AS firstname_8, t0.lastname AS lastname_9, t0.sex AS sex_10, t0.relationship AS relationship_11, t0.birthday AS birthday_12, t0.height AS height_13, t0.children AS children_14, t0.food_type AS food_type_15, t0.zodiac_sign AS zodiac_sign_16, t0.human_design AS human_design_17, t0.human_design_type AS human_design_type_18, t0.instagram AS instagram_19, t0.vkontakte AS vkontakte_20, t0.youtube AS youtube_21, t0.website AS website_22, t0.contact_email AS contact_email_23, t0.contact_phone_number AS contact_phone_number_24, t0.telegram AS telegram_25, t0.odnoklassniki AS odnoklassniki_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.activity_at AS activity_at_29, t0.last_seen_at AS last_seen_at_30, t0.offer AS offer_31, t0.profile_status AS profile_status_32, t0.about_text AS about_text_33, t0.dating_description AS dating_description_34, t0.visibility AS visibility_35, t0.activity AS activity_36, t0.invite_id AS invite_id_37, t0.profile_picture_id AS profile_picture_id_38, t0.question_id AS question_id_39, t0.city_id AS city_id_40 FROM users t0 WHERE t0.id = ?
Parameters:
[
124
]
|
| 2 | 0.33 ms |
"START TRANSACTION"
Parameters:
[] |
| 3 | 0.50 ms |
UPDATE users SET activity_at = ? WHERE id = ?
Parameters:
[ "2025-12-04 13:17:47" 124 ] |
| 4 | 1.51 ms |
"COMMIT"
Parameters:
[] |
| 5 | 0.64 ms |
SELECT COUNT(m0_.id) AS sclr_0 FROM messages m0_ INNER JOIN conversations c1_ ON m0_.conversation_id = c1_.id INNER JOIN conversation_participants c2_ ON c1_.id = c2_.conversation_id WHERE c2_.user_id = ? AND m0_.sender_id <> ? AND m0_.deleted_at IS NULL AND ((c2_.last_read_at IS NULL OR m0_.created_at > c2_.last_read_at))
Parameters:
[ 124 124 ] |
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Invite | No errors. |
| App\Entity\Attachment | No errors. |
| App\Entity\Question | No errors. |
| App\Entity\City | No errors. |
| App\Entity\Film | No errors. |
| App\Entity\Book | No errors. |
| App\Entity\Quote | No errors. |
| App\Entity\Video | No errors. |
| App\Entity\Poem | No errors. |
| App\Entity\Review | No errors. |
| App\Entity\Interest | No errors. |
| App\Entity\Activity | No errors. |
| App\Entity\UserQuestionAnswer | No errors. |
| App\Entity\BookQuestionAnswer | No errors. |
| App\Entity\Subscription | No errors. |
| App\Entity\Message | No errors. |
| App\Entity\Conversation | No errors. |
| App\Entity\ConversationParticipant | No errors. |