Query Metrics
2
Database Queries
2
Different statements
44.41 ms
Query time
0
Invalid entities
0
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
24.68 ms (55.58%) |
1 |
SELECT r0_.video_platform AS video_platform_0, r0_.video_id AS video_id_1, r0_.video_timestamp AS video_timestamp_2, r0_.is_valid AS is_valid_3, r0_.description AS description_4, r0_.id AS id_5, r0_.created_at AS created_at_6, r0_.updated_at AS updated_at_7, m1_.character1 AS character1_8, m1_.variation1 AS variation1_9, m1_.winner AS winner_10, m1_.character2 AS character2_11, m1_.variation2 AS variation2_12, m1_.played_at AS played_at_13, m1_.version AS version_14, m1_.first_to AS first_to_15, m1_.connection AS connection_16, m1_.context AS context_17, m1_.event AS event_18, m1_.id AS id_19, m1_.created_at AS created_at_20, m1_.updated_at AS updated_at_21, p2_.name AS name_22, p2_.short_name AS short_name_23, p2_.original_name AS original_name_24, p2_.country AS country_25, p2_.main_character AS main_character_26, p2_.cfn_alias AS cfn_alias_27, p2_.discord_alias AS discord_alias_28, p2_.challonge_alias AS challonge_alias_29, p2_.start_ggid AS start_ggid_30, p2_.tonamel_id AS tonamel_id_31, p2_.esport_earnings_id AS esport_earnings_id_32, p2_.twitter_id AS twitter_id_33, p2_.twitch_channel AS twitch_channel_34, p2_.id AS id_35, p3_.name AS name_36, p3_.short_name AS short_name_37, p3_.original_name AS original_name_38, p3_.country AS country_39, p3_.main_character AS main_character_40, p3_.cfn_alias AS cfn_alias_41, p3_.discord_alias AS discord_alias_42, p3_.challonge_alias AS challonge_alias_43, p3_.start_ggid AS start_ggid_44, p3_.tonamel_id AS tonamel_id_45, p3_.esport_earnings_id AS esport_earnings_id_46, p3_.twitter_id AS twitter_id_47, p3_.twitch_channel AS twitch_channel_48, p3_.id AS id_49, r0_.sender_id AS sender_id_50, r0_.matching_id AS matching_id_51, m1_.player1_id AS player1_id_52, m1_.player2_id AS player2_id_53 FROM replay r0_ LEFT JOIN matching m1_ ON r0_.matching_id = m1_.id LEFT JOIN player p2_ ON m1_.player1_id = p2_.id LEFT JOIN player p3_ ON m1_.player2_id = p3_.id WHERE (LOWER(p2_.name) LIKE LOWER(?) OR LOWER(p2_.short_name) LIKE LOWER(?) OR LOWER(p2_.original_name) LIKE LOWER(?) OR LOWER(p3_.name) LIKE LOWER(?) OR LOWER(p3_.short_name) LIKE LOWER(?) OR LOWER(p3_.original_name) LIKE LOWER(?) OR LOWER(m1_.character1) LIKE LOWER(?) OR LOWER(m1_.character2) LIKE LOWER(?) OR LOWER(m1_.event) LIKE LOWER(?)) AND r0_.is_valid = 1 ORDER BY m1_.played_at DESC LIMIT 50
Parameters:
[ "%2026%" "%2026%" "%2026%" "%2026%" "%2026%" "%2026%" "%2026%" "%2026%" "%2026%" ] |
|
19.73 ms (44.42%) |
1 |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_5 FROM (SELECT r0_.video_platform AS video_platform_0, r0_.video_id AS video_id_1, r0_.video_timestamp AS video_timestamp_2, r0_.is_valid AS is_valid_3, r0_.description AS description_4, r0_.id AS id_5, r0_.created_at AS created_at_6, r0_.updated_at AS updated_at_7, m1_.character1 AS character1_8, m1_.variation1 AS variation1_9, m1_.winner AS winner_10, m1_.character2 AS character2_11, m1_.variation2 AS variation2_12, m1_.played_at AS played_at_13, m1_.version AS version_14, m1_.first_to AS first_to_15, m1_.connection AS connection_16, m1_.context AS context_17, m1_.event AS event_18, m1_.id AS id_19, m1_.created_at AS created_at_20, m1_.updated_at AS updated_at_21, p2_.name AS name_22, p2_.short_name AS short_name_23, p2_.original_name AS original_name_24, p2_.country AS country_25, p2_.main_character AS main_character_26, p2_.cfn_alias AS cfn_alias_27, p2_.discord_alias AS discord_alias_28, p2_.challonge_alias AS challonge_alias_29, p2_.start_ggid AS start_ggid_30, p2_.tonamel_id AS tonamel_id_31, p2_.esport_earnings_id AS esport_earnings_id_32, p2_.twitter_id AS twitter_id_33, p2_.twitch_channel AS twitch_channel_34, p2_.id AS id_35, p3_.name AS name_36, p3_.short_name AS short_name_37, p3_.original_name AS original_name_38, p3_.country AS country_39, p3_.main_character AS main_character_40, p3_.cfn_alias AS cfn_alias_41, p3_.discord_alias AS discord_alias_42, p3_.challonge_alias AS challonge_alias_43, p3_.start_ggid AS start_ggid_44, p3_.tonamel_id AS tonamel_id_45, p3_.esport_earnings_id AS esport_earnings_id_46, p3_.twitter_id AS twitter_id_47, p3_.twitch_channel AS twitch_channel_48, p3_.id AS id_49 FROM replay r0_ LEFT JOIN matching m1_ ON r0_.matching_id = m1_.id LEFT JOIN player p2_ ON m1_.player1_id = p2_.id LEFT JOIN player p3_ ON m1_.player2_id = p3_.id WHERE (LOWER(p2_.name) LIKE LOWER(?) OR LOWER(p2_.short_name) LIKE LOWER(?) OR LOWER(p2_.original_name) LIKE LOWER(?) OR LOWER(p3_.name) LIKE LOWER(?) OR LOWER(p3_.short_name) LIKE LOWER(?) OR LOWER(p3_.original_name) LIKE LOWER(?) OR LOWER(m1_.character1) LIKE LOWER(?) OR LOWER(m1_.character2) LIKE LOWER(?) OR LOWER(m1_.event) LIKE LOWER(?)) AND r0_.is_valid = 1 ORDER BY m1_.played_at DESC) dctrn_result) dctrn_table
Parameters:
[ "%2026%" "%2026%" "%2026%" "%2026%" "%2026%" "%2026%" "%2026%" "%2026%" "%2026%" ] |
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\replay\Replay | No errors. |
| App\Entity\replay\Matching | No errors. |
| App\Entity\replay\Player | No errors. |
| App\Entity\User | No errors. |