Connection to sql... 9 ms

SELECT l.table_suffix, ct.id, ct.alias, ct.name AS name,ct.logo, ct.CountryCode, l.year, ct.location, ct.continent, l.extraName, ct.competition_type, ct.troncal, ct.coefficient, ct.ctype, l.id AS league_id, l.year, l.total_teams, l.current_round,l.current_table_round, l.total_rounds, l.total_group, l.group_code, l.legend, l.legendExtra, l.playoff, l.end_prev, l.start_date, l.end_date, l.table_suffix,l.start_date,l.end_date, ct.parentId FROM futbol.categories AS ct INNER JOIN leagues_besoccer AS l ON ct.id=l.categoryId WHERE ct.id=2458 AND l.year=2021 ORDER BY l.group_code
1 2.1 ms controllers/category.php

SELECT year AS title, year FROM leagues WHERE (group_code = 0 OR total_num_tablesR>=1 OR total_teamsR >=1 OR text_mode > 0) AND categoryId=2458 GROUP BY year ORDER BY year DESC
2 1.9 ms controllers/category.php

SELECT type,categoryId,year FROM historical_resume WHERE (categoryId = 2458 and (year = 2021 OR year = 0))
3 1.9 ms controllers/category.php

SELECT total FROM bs_rel_resume_items WHERE itemId=2458 AND type_rel=3 AND ln='es'
4 1.9 ms controllers/category.php

SELECT ct.id, ct.alias, ct.name AS name, ct.active_year as year, ct.CountryCode as cc FROM futbol.categories AS ct WHERE ct.parentId in (2458,110)
5 1.9 ms controllers/category.php

SELECT * FROM futbol.categories_coef WHERE parentId=2458 or sonId=2458 LIMIT 1
6 1.9 ms controllers/category.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2458 AND l.year=2021 AND l.group_code>=1 AND l.group_code = 2 ORDER BY l.group_code ASC
7 2 ms controllers/category.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables2021 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 62175 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
8 2.3 ms controllers/category.php

SELECT team, position, round FROM futbol.tables2021 WHERE league_id=62175 AND round=9 ORDER BY team ASC;
9 1.9 ms controllers/category.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 62175 LIMIT 1
10 8.7 ms controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
11 2 ms controllers/category.php

SELECT c.isVideo, c.id,c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars2021` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 62175 AND c.`round` = 10 ORDER BY shedule ASC LIMIT 200
12 2.3 ms controllers/category.php

SELECT c.id, 2021 as year, ev.match_id,dp.alias,ev.minute,ev.action,ev.player_id,e.name,e.classf,dp.nick,rel.squadNumber,rel.player_id as playerId,rel.team_id,rel.teamId FROM events2021 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2021 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 62175 AND (ev.team1id=rel.team_id OR ev.team2id=rel.team_id) INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE ev.match_id IN (348607,348608,348610,348609) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
13 2.3 ms controllers/category.php

SELECT id FROM leagues_mobile WHERE categoryId=2458 AND `year`=2021 AND `group_code`=2 ORDER BY id ASC
14 1.9 ms controllers/category.php

SELECT dp.CountryCode, dt.basealias,dp.alias as player_alias,dp.role as player_role, dp.id as player_id, dp.nick,dt.id as team_id, dt.nameShow as team_name, SUM(d.goals) as goals, SUM(d.apps) as apps, SUM(d.completed) as completed, SUM(d.pen_save) as pen_save, SUM(d.reserved) as reserved, SUM(d.pen_goals) as pen_goals, SUM(d.pen_err) as pen_err,SUM(d.lineup) as lineups, SUM(d.expulsions) as expulsions, SUM(d.yellow_cards) as yellow_cards,SUM(d.red_cards) as red_cards,d.role, SUM(d.substitutions) as substitutions, SUM(d.lineup) as lineup, SUM(d.minutes) as minutes, SUM(d.assists) as assists, SUM(d.called) as called, SUM(d.cards) as cards FROM futbol.detail_player_match d INNER JOIN datateams dt on dt.id=d.teamId INNER JOIN dataplayers dp on dp.id=d.playerId WHERE d.league_id in (62175) and d.year=2021 GROUP BY d.playerId ORDER BY goals DESC, apps ASC, dp.nick ASC LIMIT 1000;
15 2 ms controllers/category.php

SELECT rel.newId, rel.typeId, cat.name FROM bs_news_rel rel INNER JOIN categories cat ON cat.id=rel.typeId WHERE rel.type_rel=3 AND rel.typeId in(2458) AND rel.ln='es' ORDER BY rel.cover_points DESC, rel.newId DESC LIMIT 1,20
16 2.8 ms controllers/category.php

TOTAL TIME 39.8 ms QUERIES 16 FILE controllers/category.php