Query Metrics
8
Database Queries
8
Different statements
0.55 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.08 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.created_at AS created_at_7, t0.company_id AS company_id_8, t9.id AS id_10, t9.avatar AS avatar_11, t9.bio AS bio_12, t9.preferences AS preferences_13, t9.location AS location_14, t9.job_title AS job_title_15, t9.linkedin_url AS linkedin_url_16, t9.twitter_url AS twitter_url_17, t9.instagram_url AS instagram_url_18, t9.user_id AS user_id_19 FROM "user" t0 LEFT JOIN user_profile t9 ON t9.user_id = t0.id WHERE t0.id = ?
Parameters:
[
18
]
|
2 | 0.06 ms |
SELECT COUNT(c0_.id) AS sclr_0 FROM chat_message c0_ WHERE c0_.type = ? AND c0_.user_id <> ? AND c0_.is_read = ?
Parameters:
[ "global" 18 0 ] |
3 | 0.07 ms |
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.logo AS logo_2, t0_.created_at AS created_at_3 FROM team t0_ INNER JOIN user_team u1_ ON t0_.id = u1_.team_id WHERE u1_.user_id = ? ORDER BY t0_.name ASC
Parameters:
[
18
]
|
4 | 0.06 ms |
SELECT COUNT(c0_.id) AS sclr_0 FROM chat_message c0_ WHERE c0_.team_id = ? AND c0_.user_id <> ? AND c0_.is_read = ?
Parameters:
[ 18 18 0 ] |
5 | 0.09 ms |
SELECT DISTINCT s0_.id AS id_0, s0_.name AS name_1, s0_.start_date AS start_date_2, s0_.end_date AS end_date_3, s0_.is_active AS is_active_4, s0_.default_validation_method AS default_validation_method_5, s0_.activity_config AS activity_config_6, s0_.summary AS summary_7, s0_.image_filename AS image_filename_8, s0_.rewards AS rewards_9, s0_.use_balanced_scoring AS use_balanced_scoring_10, s0_.company_id AS company_id_11 FROM season s0_ INNER JOIN team_season t1_ ON s0_.id = t1_.season_id INNER JOIN team t2_ ON t1_.team_id = t2_.id INNER JOIN user_team u3_ ON t2_.id = u3_.team_id WHERE u3_.user_id = ? ORDER BY s0_.start_date DESC
Parameters:
[
18
]
|
6 | 0.06 ms |
SELECT t0.id AS id_1, t0.webhook_url AS webhook_url_2, t0.space_name AS space_name_3, t0.is_enabled AS is_enabled_4, t0.timezone AS timezone_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.season_id AS season_id_8 FROM season_google_chat_config t0 WHERE t0.season_id = ?
Parameters:
[
13
]
|
7 | 0.06 ms |
SELECT COUNT(c0_.id) AS sclr_0 FROM chat_message c0_ WHERE c0_.season_id = ? AND c0_.user_id <> ? AND c0_.is_read = ?
Parameters:
[ 13 18 0 ] |
8 | 0.07 ms |
SELECT DISTINCT c0_.recipient_id AS sclr_0, c0_.user_id AS sclr_1 FROM chat_message c0_ WHERE c0_.type = ? AND ((c0_.user_id = ? OR c0_.recipient_id = ?)) ORDER BY c0_.created_at DESC LIMIT 20
Parameters:
[ "direct" 18 18 ] |
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\Company | No errors. |
App\Entity\UserProfile | No errors. |
App\Entity\UserTeam | No errors. |
App\Entity\Submission | No errors. |
App\Entity\ChatMessage | No errors. |
App\Entity\Notification | No errors. |
App\Entity\Team | No errors. |
App\Entity\TeamSeason | No errors. |
App\Entity\Season | No errors. |
App\Entity\ActivityConfiguration | No errors. |
App\Entity\SeasonGoogleChatConfig | No errors. |
App\Entity\SeasonGoogleChatMessageType | No errors. |