Query Metrics
19
Database Queries
11
Different statements
1.92 ms
Query time
0
Invalid entities
0
Cache hits
0
Cache misses
0
Cache puts
Queries
default connection
#▲ | Time | Info |
---|---|---|
1 | 0.13 ms |
SELECT t0.token AS token_1, t0.expires_at AS expires_at_2, t0.id AS id_3, t0.user_id AS user_id_4 FROM user_access_token t0 WHERE t0.token = ? LIMIT 1
Parameters:
[
"e5ff6c127b395b6e232d5d88c4f773da9b06f12bbcfd8704"
]
|
2 | 0.08 ms |
SELECT t0.password AS password_1, t0.username AS username_2, t0.roles AS roles_3, t0.user_agent AS user_agent_4, t0.are_notifications_enabled AS are_notifications_enabled_5, t0.not_registered_token AS not_registered_token_6, t0.migrated_from_not_registered AS migrated_from_not_registered_7, t0.migrate_code AS migrate_code_8, t0.last_activity AS last_activity_9, t0.id AS id_10, t0.creation_date AS creation_date_11, t0.apple_data_id AS apple_data_id_12, t0.membership_id AS membership_id_13, t0.avatar_id AS avatar_id_14, t0.profile_id AS profile_id_15, t0.stripe_member_id AS stripe_member_id_16 FROM user t0 WHERE t0.id = ?
Parameters:
[
"379163356520294"
]
|
3 | 0.07 ms |
SELECT t0.premium_expires AS premium_expires_1, t0.subscription_type AS subscription_type_2, t0.allowed_trial AS allowed_trial_3, t0.cancelled_subscription AS cancelled_subscription_4, t0.id AS id_5 FROM user_membership t0 WHERE t0.id = ?
Parameters:
[
"126965829210177"
]
|
4 | 0.06 ms |
SELECT t0.name AS name_1, t0.browser_id AS browser_id_2, t0.is_enabled AS is_enabled_3, t0.share_slug AS share_slug_4, t0.enabled_for_collaboration AS enabled_for_collaboration_5, t0.emoji AS emoji_6, t0.id AS id_7, t0.creation_date AS creation_date_8, t0.order_index AS order_index_9, t0.user_id AS user_id_10, t0.section_id AS section_id_11 FROM toast_session t0 WHERE t0.is_enabled = ?
Parameters:
[
0
]
|
5 | 0.07 ms |
SELECT t0.name AS name_1, t0.device_id AS device_id_2, t0.sync_enabled AS sync_enabled_3, t0.id AS id_4, t0.session_id AS session_id_5, t0.user_id AS user_id_6 FROM active_device t0 WHERE t0.device_id = ? AND t0.user_id = ? LIMIT 1
Parameters:
[ "b9ee90cb-76d3-44ea-a281-3c735c5d40e0-chrome" "379163356520294" ] |
6 | 0.34 ms |
SELECT t0.name AS name_1, t0.url AS url_2, t0.icon AS icon_3, t0.order_index AS order_index_4, t0.is_pin AS is_pin_5, t0.id AS id_6, t0.creation_date AS creation_date_7, t0.device_id AS device_id_8 FROM active_session_tab t0 WHERE t0.device_id = ? ORDER BY t0.order_index ASC
Parameters:
[
"253177355021393"
]
|
7 | 0.07 ms |
"START TRANSACTION"
Parameters:
[] |
8 | 0.15 ms |
INSERT INTO active_session_tab (name, url, icon, order_index, is_pin, id, creation_date, device_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "Apple" "https://www.apple.com/" "https://www.apple.com/favicon.ico" 0 0 "624540074340943" "2025-06-01 15:54:49" "253177355021393" ] |
9 | 0.08 ms |
INSERT INTO active_session_tab (name, url, icon, order_index, is_pin, id, creation_date, device_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "Folders - Toast" "https://back.dotoast.com/user/sessions/368823467228814" "https://back.dotoast.com/img/logo-black.svg" 1 0 "277200453699601" "2025-06-01 15:54:49" "253177355021393" ] |
10 | 0.08 ms |
INSERT INTO active_session_tab (name, url, icon, order_index, is_pin, id, creation_date, device_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "VW.com | Official Home of Volkswagen Cars & SUVs" "https://www.vw.com/en.html" "https://www.vw.com/etc.clientlibs/clientlibs/vwa-ngw18/ngw18-frontend/apps/resources/statics/favicons/favicon.ico" 2 0 "379287362219239" "2025-06-01 15:54:49" "253177355021393" ] |
11 | 0.07 ms |
INSERT INTO active_session_tab (name, url, icon, order_index, is_pin, id, creation_date, device_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "Amazon.com. Spend less. Smile more." "https://www.amazon.com/" "https://www.amazon.com/favicon.ico" 3 0 "170164542830895" "2025-06-01 15:54:49" "253177355021393" ] |
12 | 0.09 ms |
DELETE FROM active_session_tab WHERE id = ?
Parameters:
[
"987308031357089"
]
|
13 | 0.08 ms |
DELETE FROM active_session_tab WHERE id = ?
Parameters:
[
"132704653266559"
]
|
14 | 0.08 ms |
DELETE FROM active_session_tab WHERE id = ?
Parameters:
[
"108653353936539"
]
|
15 | 0.07 ms |
DELETE FROM active_session_tab WHERE id = ?
Parameters:
[
"299690801369959"
]
|
16 | 0.08 ms |
"COMMIT"
Parameters:
[] |
17 | 0.08 ms |
"START TRANSACTION"
Parameters:
[] |
18 | 0.17 ms |
UPDATE user SET last_activity = ? WHERE id = ?
Parameters:
[ "2025-06-01" "379163356520294" ] |
19 | 0.06 ms |
"COMMIT"
Parameters:
[] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
remote | doctrine.dbal.remote_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
0
Hits
0
Misses
0
Puts
Entities Mapping
Class | Mapping errors |
---|---|
App\Database\Domain\Entity\AbstractEntity | No errors. |
App\Database\Domain\Entity\User\UserAccessToken | No errors. |
App\Database\Domain\Entity\User\User | No errors. |
App\Database\Domain\Entity\User\UserAppleData | No errors. |
App\Database\Domain\Entity\User\UserMembership | No errors. |
App\Database\Domain\Entity\User\UserAvatar | No errors. |
App\Database\Domain\Entity\User\UserProfile | No errors. |
App\Database\Domain\Entity\User\UserStripeMember | No errors. |
App\Database\Domain\Entity\User\UserNotification | No errors. |
App\Database\Domain\Entity\Sessions\ToastSession | No errors. |
App\Database\Domain\Entity\Sessions\ToastSessionSection | No errors. |
App\Database\Domain\Entity\Sessions\ActiveSessions\ActiveDevice | No errors. |
App\Database\Domain\Entity\Sessions\ActiveSessions\ActiveSession | No errors. |
App\Database\Domain\Entity\Sessions\ActiveSessions\ActiveSessionTab | No errors. |