Query Metrics
2
Database Queries
2
Different statements
12.37 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.13 ms |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.google_id AS google_id_13, t0.mts_id AS mts_id_14, t0.pingboard_id AS pingboard_id_15, t0.reports_to_id AS reports_to_id_16, t0.google_access_token AS google_access_token_17, t0.jwt_token AS jwt_token_18, t0.mts_access_token AS mts_access_token_19, t0.picture AS picture_20, t0.name AS name_21, t0.first_name AS first_name_22, t0.last_name AS last_name_23, t0.position AS position_24, t0.user_info AS user_info_25, t0.login_type AS login_type_26, t0.team_id AS team_id_27, t0.whitelisted_ips AS whitelisted_ips_28, t0.status AS status_29 FROM users t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
25
]
|
| 2 | 11.24 ms |
SELECT o0_.id AS id_0, o0_.advertiser_id AS sclr_1, m1_.name AS name_2, m2_.name AS name_3, u3_.name AS name_4, u3_.email AS email_5, o0_.period AS period_6, o0_.revenue AS revenue_7, o0_.revision_comment AS revision_comment_8, o0_.status AS status_9, DATE_FORMAT(o0_.date_approved, '%Y-%m-%d %H:%i:%s') AS sclr_10, o0_.added_by_email AS added_by_email_11, u4_.name AS name_12, o0_.revenue AS revenue_13, o0_.date_inserted AS date_inserted_14, o0_.date_updated AS date_updated_15, o0_.approved_by_email AS approved_by_email_16, u5_.name AS name_17, DATE(o0_.period) AS sclr_18, WEEK(o0_.period) AS sclr_19, MONTH(o0_.period) AS sclr_20, YEAR(o0_.period) AS sclr_21 FROM okr_control o0_ INNER JOIN mafo_advertisers m1_ ON o0_.advertiser_id = m1_.id LEFT JOIN users u3_ ON (m1_.account_manager_email = u3_.email) LEFT JOIN users u4_ ON (u4_.email = o0_.added_by_email) LEFT JOIN users u5_ ON (u5_.email = o0_.approved_by_email) LEFT JOIN mobupps_teams m2_ ON (u3_.team_id = m2_.id) WHERE o0_.period >= ? AND o0_.period <= ? AND o0_.is_deleted = ? ORDER BY o0_.id DESC
Parameters:
[ "2026-01-1" "2026-01-1" 0 ] |
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 |
|---|---|
| FOS\UserBundle\Model\User | No errors. |
| App\Entity\Users | No errors. |
| App\Entity\OkrControl | No errors. |
| App\Entity\MafoId\MafoAdvertisers | No errors. |
| App\Entity\MobuppsTeams | No errors. |