Query Metrics
3
Database Queries
3
Different statements
3.81 ms
Query time
5
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
2.29 ms (59.91%) |
1 |
SELECT t0.id AS id_3, t0.created AS created_4, t0.status AS status_5, t0.sentry_logging AS sentry_logging_6, t0.type, t1.description AS description_7, t1.`key` AS key_8, t1.key_type AS key_type_9, t2.email AS email_10, t2.password AS password_11, t2.first_name AS first_name_12, t2.last_name AS last_name_13, t2.phone_number AS phone_number_14, t2.country AS country_15, t2.session_token AS session_token_16, t2.meta AS meta_17 FROM users t0 LEFT JOIN users_api t1 ON t0.id = t1.id LEFT JOIN users_interactive t2 ON t0.id = t2.id INNER JOIN roles ON t0.id = roles.user_id WHERE roles.account_id = ?
Parameters:
[
5
]
|
1.09 ms (28.69%) |
1 |
SELECT SUM(t0_.amount) AS sclr_0, a1_.id AS id_1, a1_.name AS name_2, a1_.created AS created_3, a1_.status AS status_4, a1_.time_zone AS time_zone_5, a1_.fdow AS fdow_6, a1_.billing_method AS billing_method_7, a1_.billing_details AS billing_details_8, a1_.price AS price_9, a1_.external_sub_id_url AS external_sub_id_url_10, a1_.meta AS meta_11, a1_.verified AS verified_12, a1_.badge_info AS badge_info_13, a2_.created AS created_14, a2_.runout AS runout_15, a1_.id AS id_16, a2_.id AS id_17 FROM accounts a1_ LEFT JOIN transactions t0_ ON a1_.id = t0_.account_id AND (t0_.status = ?) LEFT JOIN accounts_runout a2_ ON a1_.id = a2_.id WHERE a1_.id = ? GROUP BY a1_.id, a1_.name, a1_.created, a1_.status, a1_.time_zone, a1_.fdow, a1_.billing_method, a1_.billing_details, a1_.price, a1_.external_sub_id_url, a1_.meta, a1_.verified, a1_.badge_info, a1_.id, a2_.created, a2_.runout, a2_.id
Parameters:
[ "completed" 5 ] |
0.43 ms (11.40%) |
1 |
SELECT u0_.id AS id_0 FROM users u0_ LEFT JOIN users_api u1_ ON u0_.id = u1_.id LEFT JOIN users_interactive u2_ ON u0_.id = u2_.id INNER JOIN roles r3_ ON u0_.id = r3_.user_id WHERE r3_.status = ? AND r3_.account_id = ? AND r3_.type = ? LIMIT 1
Parameters:
[ "active" 5 "owner" ] |
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\Account |
|
App\Entity\Transaction | No errors. |
App\Entity\AccountRunout | No errors. |
App\Entity\Role | No errors. |
App\Entity\Zone |
|
App\Entity\GwocDomain | No errors. |
App\Entity\User |
|
App\Entity\UserApi |
|
App\Entity\UserInteractive |
|
App\Entity\UserAllowedClient | No errors. |