Symfony Profiler

Query Metrics

48 Database Queries

16 Different statements

97.48 ms Query time

0 Invalid entities

100 Managed entities

Queries


SELECT t0.id AS id_1, t0.date AS date_2, t0.venue AS venue_3, t0.scorers AS scorers_4, t0.homeTeam_id AS homeTeam_id_5, t0.awayTeam_id AS awayTeam_id_6, t0.matchDay_id AS matchDay_id_7, t0.resultContainer_id AS resultContainer_id_8, t9.id AS id_10, t9.startedAt AS startedAt_11, t9.status AS status_12, t9.visible AS visible_13, t9.streamUrl AS streamUrl_14, t9.currentResult_homeGoals AS currentResult_homeGoals_15, t9.currentResult_awayGoals AS currentResult_awayGoals_16, t9.match_id AS match_id_17, t9.currentSection_id AS currentSection_id_18, t0.report_id AS report_id_19 FROM football_match t0 LEFT JOIN football_ticker t9 ON t9.match_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = ? AND t0.discr IN ('idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch')
SELECT f0_.id AS id_0, f0_.year AS year_1, f0_.rounds AS rounds_2, f0_.sort AS sort_3, f0_.season_year AS season_year_4, f0_.season_startYear AS season_startYear_5, f0_.season_endYear AS season_endYear_6, f0_.competition_id AS competition_id_7 FROM football_competition_execution f0_ INNER JOIN football_matchday f1_ ON f0_.id = f1_.competitionExecution_id INNER JOIN football_match f2_ ON f1_.id = f2_.matchDay_id WHERE f2_.id = ?
SELECT f0_.id AS id_0, f0_.startedAt AS startedAt_1, f0_.status AS status_2, f0_.visible AS visible_3, f0_.streamUrl AS streamUrl_4, f0_.currentResult_homeGoals AS currentResult_homeGoals_5, f0_.currentResult_awayGoals AS currentResult_awayGoals_6, f0_.match_id AS match_id_7, f0_.currentSection_id AS currentSection_id_8 FROM football_ticker f0_ WHERE f0_.match_id = ?
SELECT t0.id AS id_1, t0.name_full AS name_full_2, t0.name_medium AS name_medium_3, t0.name_short AS name_short_4, t0.season_year AS season_year_5, t0.season_startYear AS season_startYear_6, t0.season_endYear AS season_endYear_7, t0.team_id AS team_id_8, t0.picture_id AS picture_id_9 FROM football_seasonteam t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name_full AS name_full_2, t0.name_medium AS name_medium_3, t0.name_short AS name_short_4, t0.season_year AS season_year_5, t0.season_startYear AS season_startYear_6, t0.season_endYear AS season_endYear_7, t0.team_id AS team_id_8, t0.picture_id AS picture_id_9 FROM football_seasonteam t0 WHERE t0.id = ?
SELECT f0_.id AS id_0, f0_.date AS date_1, f0_.venue AS venue_2, f0_.scorers AS scorers_3, f0_.homeTeam_id AS homeTeam_id_4, f0_.awayTeam_id AS awayTeam_id_5, f0_.matchDay_id AS matchDay_id_6, f0_.resultContainer_id AS resultContainer_id_7, f0_.report_id AS report_id_8 FROM football_match f0_ INNER JOIN football_seasonteam f1_ ON f0_.homeTeam_id = f1_.id INNER JOIN football_seasonteam f2_ ON f0_.awayTeam_id = f2_.id WHERE (f1_.team_id = ? OR f2_.team_id = ?) AND (f1_.team_id = ? OR f2_.team_id = ?) AND f0_.date < ? AND f0_.id <> ? ORDER BY f0_.date DESC
SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = ?
SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = ? AND t0.discr IN ('idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch')
SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = ?
SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = ? AND t0.discr IN ('idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch')
SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = ?
SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = ? AND t0.discr IN ('idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch')
SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = ?
SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = ? AND t0.discr IN ('idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch')
SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = ?
SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = ? AND t0.discr IN ('idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch')
SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = ?
SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = ? AND t0.discr IN ('idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch')
SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = ?
SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = ? AND t0.discr IN ('idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch')
SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = ?
SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = ? AND t0.discr IN ('idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch')
SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = ?
SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = ? AND t0.discr IN ('idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch')
SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = ?
SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = ? AND t0.discr IN ('idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch')
SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = ?
SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = ? AND t0.discr IN ('idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch')
SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = ?
SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = ? AND t0.discr IN ('idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch')
SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = ?
SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = ? AND t0.discr IN ('idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch')
SELECT t0.id AS id_1, t0.title AS title_2, t0.sort AS sort_3, t0.competitionExecution_id AS competitionExecution_id_4 FROM football_matchday t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.logo AS logo_2, t0.name_full AS name_full_3, t0.name_medium AS name_medium_4, t0.name_short AS name_short_5, t0.selection_id AS selection_id_6 FROM football_team t0 WHERE t0.id = ?
SELECT DATABASE()
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
SELECT DATABASE()
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
SELECT DATABASE()
SELECT t.TABLE_NAME,
           t.ENGINE,
           t.AUTO_INCREMENT,
           t.TABLE_COMMENT,
           t.CREATE_OPTIONS,
           t.TABLE_COLLATION,
           ccsa.CHARACTER_SET_NAME
      FROM information_schema.TABLES t
        INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
          ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
SELECT DATABASE()
SELECT DISTINCT            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION /*!50116,
            c.UPDATE_RULE,
            c.DELETE_RULE */
FROM information_schema.key_column_usage k /*!50116
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'ndbeltinci' */ ORDER BY k.ORDINAL_POSITION
SELECT       c.COLUMN_NAME        AS field,
       c.COLUMN_TYPE       AS type,
       c.IS_NULLABLE        AS `null`,
       c.COLUMN_KEY         AS `key`,
       c.COLUMN_DEFAULT     AS `default`,
       c.EXTRA,
       c.COLUMN_COMMENT     AS comment,
       c.CHARACTER_SET_NAME AS characterset,
       c.COLLATION_NAME     AS collation
FROM information_schema.COLUMNS c
    INNER JOIN information_schema.TABLES t
        ON t.TABLE_NAME = c.TABLE_NAME
     WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
SELECT DATABASE()
SELECT        NON_UNIQUE  AS Non_Unique,
        INDEX_NAME  AS Key_name,
        COLUMN_NAME AS Column_Name,
        SUB_PART    AS Sub_Part,
        INDEX_TYPE  AS Index_Type
FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX
SELECT * FROM doctrine_migration_versions
SELECT DATABASE()

#▲	Time	Info
1	1.30 ms	SELECT t0.id AS id_1, t0.date AS date_2, t0.venue AS venue_3, t0.scorers AS scorers_4, t0.homeTeam_id AS homeTeam_id_5, t0.awayTeam_id AS awayTeam_id_6, t0.matchDay_id AS matchDay_id_7, t0.resultContainer_id AS resultContainer_id_8, t9.id AS id_10, t9.startedAt AS startedAt_11, t9.status AS status_12, t9.visible AS visible_13, t9.streamUrl AS streamUrl_14, t9.currentResult_homeGoals AS currentResult_homeGoals_15, t9.currentResult_awayGoals AS currentResult_awayGoals_16, t9.match_id AS match_id_17, t9.currentSection_id AS currentSection_id_18, t0.report_id AS report_id_19 FROM football_match t0 LEFT JOIN football_ticker t9 ON t9.match_id = t0.id WHERE t0.id = ? Parameters: [`"2151"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.date AS date_2, t0.venue AS venue_3, t0.scorers AS scorers_4, t0.homeTeam_id AS homeTeam_id_5, t0.awayTeam_id AS awayTeam_id_6, t0.matchDay_id AS matchDay_id_7, t0.resultContainer_id AS resultContainer_id_8, t9.id AS id_10, t9.startedAt AS startedAt_11, t9.status AS status_12, t9.visible AS visible_13, t9.streamUrl AS streamUrl_14, t9.currentResult_homeGoals AS currentResult_homeGoals_15, t9.currentResult_awayGoals AS currentResult_awayGoals_16, t9.match_id AS match_id_17, t9.currentSection_id AS currentSection_id_18, t0.report_id AS report_id_19 FROM football_match t0 LEFT JOIN football_ticker t9 ON t9.match_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.date AS date_2, t0.venue AS venue_3, t0.scorers AS scorers_4, t0.homeTeam_id AS homeTeam_id_5, t0.awayTeam_id AS awayTeam_id_6, t0.matchDay_id AS matchDay_id_7, t0.resultContainer_id AS resultContainer_id_8, t9.id AS id_10, t9.startedAt AS startedAt_11, t9.status AS status_12, t9.visible AS visible_13, t9.streamUrl AS streamUrl_14, t9.currentResult_homeGoals AS currentResult_homeGoals_15, t9.currentResult_awayGoals AS currentResult_awayGoals_16, t9.match_id AS match_id_17, t9.currentSection_id AS currentSection_id_18, t0.report_id AS report_id_19 FROM football_match t0 LEFT JOIN football_ticker t9 ON t9.match_id = t0.id WHERE t0.id = '2151';
2	0.78 ms	SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = ? AND t0.discr IN ('idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch') Parameters: [`404`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = ? AND t0.discr IN ( 'idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch' ) SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = 404 AND t0.discr IN ('idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch');
3	0.89 ms	SELECT f0_.id AS id_0, f0_.year AS year_1, f0_.rounds AS rounds_2, f0_.sort AS sort_3, f0_.season_year AS season_year_4, f0_.season_startYear AS season_startYear_5, f0_.season_endYear AS season_endYear_6, f0_.competition_id AS competition_id_7 FROM football_competition_execution f0_ INNER JOIN football_matchday f1_ ON f0_.id = f1_.competitionExecution_id INNER JOIN football_match f2_ ON f1_.id = f2_.matchDay_id WHERE f2_.id = ? Parameters: [`2151`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.year AS year_1, f0_.rounds AS rounds_2, f0_.sort AS sort_3, f0_.season_year AS season_year_4, f0_.season_startYear AS season_startYear_5, f0_.season_endYear AS season_endYear_6, f0_.competition_id AS competition_id_7 FROM football_competition_execution f0_ INNER JOIN football_matchday f1_ ON f0_.id = f1_.competitionExecution_id INNER JOIN football_match f2_ ON f1_.id = f2_.matchDay_id WHERE f2_.id = ? SELECT f0_.id AS id_0, f0_.year AS year_1, f0_.rounds AS rounds_2, f0_.sort AS sort_3, f0_.season_year AS season_year_4, f0_.season_startYear AS season_startYear_5, f0_.season_endYear AS season_endYear_6, f0_.competition_id AS competition_id_7 FROM football_competition_execution f0_ INNER JOIN football_matchday f1_ ON f0_.id = f1_.competitionExecution_id INNER JOIN football_match f2_ ON f1_.id = f2_.matchDay_id WHERE f2_.id = 2151;
4	4.64 ms	SELECT f0_.id AS id_0, f0_.startedAt AS startedAt_1, f0_.status AS status_2, f0_.visible AS visible_3, f0_.streamUrl AS streamUrl_4, f0_.currentResult_homeGoals AS currentResult_homeGoals_5, f0_.currentResult_awayGoals AS currentResult_awayGoals_6, f0_.match_id AS match_id_7, f0_.currentSection_id AS currentSection_id_8 FROM football_ticker f0_ WHERE f0_.match_id = ? Parameters: [`2151`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.startedAt AS startedAt_1, f0_.status AS status_2, f0_.visible AS visible_3, f0_.streamUrl AS streamUrl_4, f0_.currentResult_homeGoals AS currentResult_homeGoals_5, f0_.currentResult_awayGoals AS currentResult_awayGoals_6, f0_.match_id AS match_id_7, f0_.currentSection_id AS currentSection_id_8 FROM football_ticker f0_ WHERE f0_.match_id = ? SELECT f0_.id AS id_0, f0_.startedAt AS startedAt_1, f0_.status AS status_2, f0_.visible AS visible_3, f0_.streamUrl AS streamUrl_4, f0_.currentResult_homeGoals AS currentResult_homeGoals_5, f0_.currentResult_awayGoals AS currentResult_awayGoals_6, f0_.match_id AS match_id_7, f0_.currentSection_id AS currentSection_id_8 FROM football_ticker f0_ WHERE f0_.match_id = 2151;
5	4.10 ms	SELECT t0.id AS id_1, t0.name_full AS name_full_2, t0.name_medium AS name_medium_3, t0.name_short AS name_short_4, t0.season_year AS season_year_5, t0.season_startYear AS season_startYear_6, t0.season_endYear AS season_endYear_7, t0.team_id AS team_id_8, t0.picture_id AS picture_id_9 FROM football_seasonteam t0 WHERE t0.id = ? Parameters: [`399`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name_full AS name_full_2, t0.name_medium AS name_medium_3, t0.name_short AS name_short_4, t0.season_year AS season_year_5, t0.season_startYear AS season_startYear_6, t0.season_endYear AS season_endYear_7, t0.team_id AS team_id_8, t0.picture_id AS picture_id_9 FROM football_seasonteam t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name_full AS name_full_2, t0.name_medium AS name_medium_3, t0.name_short AS name_short_4, t0.season_year AS season_year_5, t0.season_startYear AS season_startYear_6, t0.season_endYear AS season_endYear_7, t0.team_id AS team_id_8, t0.picture_id AS picture_id_9 FROM football_seasonteam t0 WHERE t0.id = 399;
6	8.29 ms	SELECT t0.id AS id_1, t0.name_full AS name_full_2, t0.name_medium AS name_medium_3, t0.name_short AS name_short_4, t0.season_year AS season_year_5, t0.season_startYear AS season_startYear_6, t0.season_endYear AS season_endYear_7, t0.team_id AS team_id_8, t0.picture_id AS picture_id_9 FROM football_seasonteam t0 WHERE t0.id = ? Parameters: [`378`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name_full AS name_full_2, t0.name_medium AS name_medium_3, t0.name_short AS name_short_4, t0.season_year AS season_year_5, t0.season_startYear AS season_startYear_6, t0.season_endYear AS season_endYear_7, t0.team_id AS team_id_8, t0.picture_id AS picture_id_9 FROM football_seasonteam t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name_full AS name_full_2, t0.name_medium AS name_medium_3, t0.name_short AS name_short_4, t0.season_year AS season_year_5, t0.season_startYear AS season_startYear_6, t0.season_endYear AS season_endYear_7, t0.team_id AS team_id_8, t0.picture_id AS picture_id_9 FROM football_seasonteam t0 WHERE t0.id = 378;
7	45.22 ms	SELECT f0_.id AS id_0, f0_.date AS date_1, f0_.venue AS venue_2, f0_.scorers AS scorers_3, f0_.homeTeam_id AS homeTeam_id_4, f0_.awayTeam_id AS awayTeam_id_5, f0_.matchDay_id AS matchDay_id_6, f0_.resultContainer_id AS resultContainer_id_7, f0_.report_id AS report_id_8 FROM football_match f0_ INNER JOIN football_seasonteam f1_ ON f0_.homeTeam_id = f1_.id INNER JOIN football_seasonteam f2_ ON f0_.awayTeam_id = f2_.id WHERE (f1_.team_id = ? OR f2_.team_id = ?) AND (f1_.team_id = ? OR f2_.team_id = ?) AND f0_.date < ? AND f0_.id <> ? ORDER BY f0_.date DESC Parameters: [`89 89 1 1 "2026-07-05 15:48:47" 2151`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.date AS date_1, f0_.venue AS venue_2, f0_.scorers AS scorers_3, f0_.homeTeam_id AS homeTeam_id_4, f0_.awayTeam_id AS awayTeam_id_5, f0_.matchDay_id AS matchDay_id_6, f0_.resultContainer_id AS resultContainer_id_7, f0_.report_id AS report_id_8 FROM football_match f0_ INNER JOIN football_seasonteam f1_ ON f0_.homeTeam_id = f1_.id INNER JOIN football_seasonteam f2_ ON f0_.awayTeam_id = f2_.id WHERE ( f1_.team_id = ? OR f2_.team_id = ? ) AND ( f1_.team_id = ? OR f2_.team_id = ? ) AND f0_.date < ? AND f0_.id <> ? ORDER BY f0_.date DESC SELECT f0_.id AS id_0, f0_.date AS date_1, f0_.venue AS venue_2, f0_.scorers AS scorers_3, f0_.homeTeam_id AS homeTeam_id_4, f0_.awayTeam_id AS awayTeam_id_5, f0_.matchDay_id AS matchDay_id_6, f0_.resultContainer_id AS resultContainer_id_7, f0_.report_id AS report_id_8 FROM football_match f0_ INNER JOIN football_seasonteam f1_ ON f0_.homeTeam_id = f1_.id INNER JOIN football_seasonteam f2_ ON f0_.awayTeam_id = f2_.id WHERE (f1_.team_id = 89 OR f2_.team_id = 89) AND (f1_.team_id = 1 OR f2_.team_id = 1) AND f0_.date < '2026-07-05 15:48:47' AND f0_.id <> 2151 ORDER BY f0_.date DESC;
8	0.76 ms	SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = ? Parameters: [`4046`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = ? SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = 4046;
9	0.59 ms	SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = ? AND t0.discr IN ('idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch') Parameters: [`1980`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = ? AND t0.discr IN ( 'idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch' ) SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = 1980 AND t0.discr IN ('idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch');
10	0.46 ms	SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = ? Parameters: [`3941`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = ? SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = 3941;
11	0.50 ms	SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = ? AND t0.discr IN ('idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch') Parameters: [`1880`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = ? AND t0.discr IN ( 'idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch' ) SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = 1880 AND t0.discr IN ('idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch');
12	0.42 ms	SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = ? Parameters: [`3903`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = ? SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = 3903;
13	0.44 ms	SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = ? AND t0.discr IN ('idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch') Parameters: [`1870`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = ? AND t0.discr IN ( 'idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch' ) SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = 1870 AND t0.discr IN ('idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch');
14	0.40 ms	SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = ? Parameters: [`3764`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = ? SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = 3764;
15	0.40 ms	SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = ? AND t0.discr IN ('idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch') Parameters: [`1720`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = ? AND t0.discr IN ( 'idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch' ) SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = 1720 AND t0.discr IN ('idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch');
16	0.43 ms	SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = ? Parameters: [`3632`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = ? SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = 3632;
17	0.40 ms	SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = ? AND t0.discr IN ('idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch') Parameters: [`1595`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = ? AND t0.discr IN ( 'idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch' ) SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = 1595 AND t0.discr IN ('idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch');
18	0.39 ms	SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = ? Parameters: [`3485`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = ? SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = 3485;
19	0.37 ms	SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = ? AND t0.discr IN ('idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch') Parameters: [`1470`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = ? AND t0.discr IN ( 'idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch' ) SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = 1470 AND t0.discr IN ('idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch');
20	0.36 ms	SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = ? Parameters: [`3441`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = ? SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = 3441;
21	0.38 ms	SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = ? AND t0.discr IN ('idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch') Parameters: [`1435`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = ? AND t0.discr IN ( 'idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch' ) SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = 1435 AND t0.discr IN ('idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch');
22	0.36 ms	SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = ? Parameters: [`3348`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = ? SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = 3348;
23	0.40 ms	SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = ? AND t0.discr IN ('idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch') Parameters: [`1325`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = ? AND t0.discr IN ( 'idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch' ) SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = 1325 AND t0.discr IN ('idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch');
24	0.36 ms	SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = ? Parameters: [`3185`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = ? SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = 3185;
25	0.38 ms	SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = ? AND t0.discr IN ('idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch') Parameters: [`1195`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = ? AND t0.discr IN ( 'idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch' ) SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = 1195 AND t0.discr IN ('idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch');
26	0.36 ms	SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = ? Parameters: [`3055`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = ? SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = 3055;
27	0.41 ms	SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = ? AND t0.discr IN ('idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch') Parameters: [`1075`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = ? AND t0.discr IN ( 'idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch' ) SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = 1075 AND t0.discr IN ('idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch');
28	0.36 ms	SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = ? Parameters: [`2923`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = ? SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = 2923;
29	0.37 ms	SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = ? AND t0.discr IN ('idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch') Parameters: [`960`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = ? AND t0.discr IN ( 'idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch' ) SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = 960 AND t0.discr IN ('idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch');
30	0.36 ms	SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = ? Parameters: [`2791`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = ? SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = 2791;
31	0.37 ms	SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = ? AND t0.discr IN ('idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch') Parameters: [`845`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = ? AND t0.discr IN ( 'idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch' ) SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = 845 AND t0.discr IN ('idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch');
32	0.39 ms	SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = ? Parameters: [`1993`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = ? SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.status AS status_3, t0.visible AS visible_4, t0.streamUrl AS streamUrl_5, t0.currentResult_homeGoals AS currentResult_homeGoals_6, t0.currentResult_awayGoals AS currentResult_awayGoals_7, t0.match_id AS match_id_8, t0.currentSection_id AS currentSection_id_9 FROM football_ticker t0 WHERE t0.match_id = 1993;
33	8.88 ms	SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = ? AND t0.discr IN ('idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch') Parameters: [`284`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = ? AND t0.discr IN ( 'idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch' ) SELECT t0.id AS id_1, t0.sequenceNumber AS sequenceNumber_2, t0.ticker_id AS ticker_id_3, t0.discr, t0.startedAt AS startedAt_4, t0.type AS type_5 FROM football_ticker_section t0 WHERE t0.id = 284 AND t0.discr IN ('idle', 'play', 'beforeMatch', 'firstHalf', 'secondHalf', 'firstExtraTime', 'secondExtraTime', 'penalty', 'break', 'afterMatch');
34	0.81 ms	SELECT t0.id AS id_1, t0.title AS title_2, t0.sort AS sort_3, t0.competitionExecution_id AS competitionExecution_id_4 FROM football_matchday t0 WHERE t0.id = ? Parameters: [`331`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.sort AS sort_3, t0.competitionExecution_id AS competitionExecution_id_4 FROM football_matchday t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.title AS title_2, t0.sort AS sort_3, t0.competitionExecution_id AS competitionExecution_id_4 FROM football_matchday t0 WHERE t0.id = 331;
35	0.85 ms	SELECT t0.id AS id_1, t0.logo AS logo_2, t0.name_full AS name_full_3, t0.name_medium AS name_medium_4, t0.name_short AS name_short_5, t0.selection_id AS selection_id_6 FROM football_team t0 WHERE t0.id = ? Parameters: [`89`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.logo AS logo_2, t0.name_full AS name_full_3, t0.name_medium AS name_medium_4, t0.name_short AS name_short_5, t0.selection_id AS selection_id_6 FROM football_team t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.logo AS logo_2, t0.name_full AS name_full_3, t0.name_medium AS name_medium_4, t0.name_short AS name_short_5, t0.selection_id AS selection_id_6 FROM football_team t0 WHERE t0.id = 89;
36	0.57 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
37	1.22 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"ndbeltinci"`] View formatted query View runnable query Explain query SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'ndbeltinci' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
38	0.35 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
39	0.98 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"ndbeltinci"`] View formatted query View runnable query Explain query SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'ndbeltinci' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
40	0.55 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
41	1.13 ms	SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE' Parameters: [`"ndbeltinci" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE' SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = 'ndbeltinci' AND t.TABLE_NAME = 'doctrine_migration_versions' AND t.TABLE_TYPE = 'BASE TABLE';
42	0.32 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
43	1.64 ms	SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /!50116, c.UPDATE_RULE, c.DELETE_RULE / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME / WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /!50116 AND c.CONSTRAINT_SCHEMA = 'ndbeltinci' / ORDER BY k.ORDINAL_POSITION Parameters: [`"ndbeltinci" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /!50116, c.UPDATE_RULE, c.DELETE_RULE / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME / WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /!50116 AND c.CONSTRAINT_SCHEMA = 'ndbeltinci' / ORDER BY k.ORDINAL_POSITION SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /!50116, c.UPDATE_RULE, c.DELETE_RULE / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME / WHERE k.TABLE_SCHEMA = 'ndbeltinci' AND k.TABLE_NAME = 'doctrine_migration_versions' AND k.REFERENCED_COLUMN_NAME IS NOT NULL /!50116 AND c.CONSTRAINT_SCHEMA = 'ndbeltinci' / ORDER BY k.ORDINAL_POSITION;
44	2.35 ms	SELECT c.COLUMN_NAME AS field, c.COLUMN_TYPE AS type, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS comment, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS collation FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION Parameters: [`"ndbeltinci" "ndbeltinci" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT c.COLUMN_NAME AS field, c.COLUMN_TYPE AS type, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS comment, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS collation FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION SELECT c.COLUMN_NAME AS field, c.COLUMN_TYPE AS type, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS comment, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS collation FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = 'ndbeltinci' AND t.TABLE_SCHEMA = 'ndbeltinci' AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION;
45	0.43 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
46	0.64 ms	SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX Parameters: [`"ndbeltinci" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = 'ndbeltinci' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY SEQ_IN_INDEX;
47	0.59 ms	SELECT * FROM doctrine_migration_versions Parameters: [] View formatted query View runnable query Explain query SELECT * FROM doctrine_migration_versions SELECT * FROM doctrine_migration_versions;
48	0.53 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();

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
Core\Entity\Football\FootballMatch	14
Core\Entity\Football\MatchDay	14
Core\Entity\Football\ResultContainer	14
Core\Entity\Football\LiveTicker\LiveTicker	14
Core\Entity\Football\LiveTicker\Section\Section	14
Core\Entity\Football\Match\Report	13
Core\Entity\Football\Team\SeasonTeam	12
Core\Entity\Football\Team\Team	2
Core\Entity\Football\CompetitionExecution	1
Core\Entity\Football\Competition	1
Core\Entity\Football\Selection	1

Entities Mapping

Class	Mapping errors
Core\Entity\Football\FootballMatch	No errors.
Core\Entity\Football\Team\TeamName	No errors.
Core\Entity\Football\Season	No errors.
Core\Entity\Football\Team\SeasonTeam	No errors.
Core\Entity\Football\MatchDay	No errors.
Core\Entity\Football\ResultContainer	No errors.
Core\Entity\Football\Match\Result	No errors.
Core\Entity\Football\LiveTicker\LiveTicker	No errors.
Core\Entity\Football\LiveTicker\Section\Section	No errors.
Core\Entity\Football\Match\Report	No errors.
Core\Entity\Football\LiveTicker\Section\IdleSection	No errors.
Core\Entity\Football\LiveTicker\Section\PlaySection	No errors.
Core\Entity\Football\LiveTicker\Section\BeforeMatchSection	No errors.
Core\Entity\Football\LiveTicker\Section\FirstHalfSection	No errors.
Core\Entity\Football\LiveTicker\Section\SecondHalfSection	No errors.
Core\Entity\Football\LiveTicker\Section\FirstExtraTimeSection	No errors.
Core\Entity\Football\LiveTicker\Section\SecondExtraTimeSection	No errors.
Core\Entity\Football\LiveTicker\Section\PenaltySection	No errors.
Core\Entity\Football\LiveTicker\Section\BreakSection	No errors.
Core\Entity\Football\LiveTicker\Section\AfterMatchSection	No errors.
Core\Entity\Football\LiveTicker\AbstractEvent	No errors.
Core\Entity\Football\CompetitionExecution	No errors.
Core\Entity\Football\CompetitionSettings	No errors.
Core\Entity\Football\Competition	No errors.
Core\Entity\Football\Table\PointPenalty	No errors.
Core\Entity\Football\Team\Team	No errors.
Core\Entity\Media\Media	No errors.
Core\Entity\Football\Player\SeasonPlayer	No errors.
Core\Entity\Football\Selection	No errors.
Core\Entity\Football\Result	No errors.
Core\Entity\Football\Match\Lineup	No errors.
Core\Entity\Football\Match\Goal	No errors.
Core\Entity\Football\CompetitionLogos	No errors.
Core\Entity\Media\Directory	No errors.
Core\Entity\Football\Player\Player	No errors.
Core\Entity\Football\Player\SeasonPlayerImages	No errors.

Symfony Profiler

GET https://new.ndbeltinci.net/tekme/2151/ilirija-beltinci

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping