Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

44.41 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲	Time	Info
1	24.68 ms	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%"`] View formatted query View runnable query Explain query 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 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('%2026%') OR LOWER(p2_.short_name) LIKE LOWER('%2026%') OR LOWER(p2_.original_name) LIKE LOWER('%2026%') OR LOWER(p3_.name) LIKE LOWER('%2026%') OR LOWER(p3_.short_name) LIKE LOWER('%2026%') OR LOWER(p3_.original_name) LIKE LOWER('%2026%') OR LOWER(m1_.character1) LIKE LOWER('%2026%') OR LOWER(m1_.character2) LIKE LOWER('%2026%') OR LOWER(m1_.event) LIKE LOWER('%2026%')) AND r0_.is_valid = 1 ORDER BY m1_.played_at DESC LIMIT 50;
2	19.73 ms	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%"`] View formatted query View runnable query Explain query 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 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('%2026%') OR LOWER(p2_.short_name) LIKE LOWER('%2026%') OR LOWER(p2_.original_name) LIKE LOWER('%2026%') OR LOWER(p3_.name) LIKE LOWER('%2026%') OR LOWER(p3_.short_name) LIKE LOWER('%2026%') OR LOWER(p3_.original_name) LIKE LOWER('%2026%') OR LOWER(m1_.character1) LIKE LOWER('%2026%') OR LOWER(m1_.character2) LIKE LOWER('%2026%') OR LOWER(m1_.event) LIKE LOWER('%2026%')) AND r0_.is_valid = 1 ORDER BY m1_.played_at DESC) dctrn_result) dctrn_table;

#▲

Time

Info

24.68 ms

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%"
]

View formatted query View runnable query Explain query

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

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('%2026%') OR LOWER(p2_.short_name) LIKE LOWER('%2026%') OR LOWER(p2_.original_name) LIKE LOWER('%2026%') OR LOWER(p3_.name) LIKE LOWER('%2026%') OR LOWER(p3_.short_name) LIKE LOWER('%2026%') OR LOWER(p3_.original_name) LIKE LOWER('%2026%') OR LOWER(m1_.character1) LIKE LOWER('%2026%') OR LOWER(m1_.character2) LIKE LOWER('%2026%') OR LOWER(m1_.event) LIKE LOWER('%2026%')) AND r0_.is_valid = 1 ORDER BY m1_.played_at DESC LIMIT 50;

19.73 ms

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%"
]

View formatted query View runnable query Explain query

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

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('%2026%') OR LOWER(p2_.short_name) LIKE LOWER('%2026%') OR LOWER(p2_.original_name) LIKE LOWER('%2026%') OR LOWER(p3_.name) LIKE LOWER('%2026%') OR LOWER(p3_.short_name) LIKE LOWER('%2026%') OR LOWER(p3_.original_name) LIKE LOWER('%2026%') OR LOWER(m1_.character1) LIKE LOWER('%2026%') OR LOWER(m1_.character2) LIKE LOWER('%2026%') OR LOWER(m1_.event) LIKE LOWER('%2026%')) AND r0_.is_valid = 1 ORDER BY m1_.played_at DESC) dctrn_result) dctrn_table;

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.

Symfony Profiler

GET http://street-fighter-6.anagraph.org/fr/replay/index?search=2026

Configuration Settings

Theme

Page Width