Connection to sql... 8.7 ms

SELECT type FROM routes WHERE alias = 'championship1933'
1 1.9 ms config/routes_file.php

TOTAL TIME 4.3 ms QUERIES 2 FILE config/routes_file.php

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=25 AND l.year=1933 ORDER BY l.group_code
2 2.4 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=25 GROUP BY year ORDER BY year DESC
3 2.7 ms controllers/category.php

SELECT type,categoryId,year FROM historical_resume WHERE (categoryId = 25 and (year = 1933 OR year = 0))
4 1.9 ms controllers/category.php

SELECT total FROM bs_rel_resume_items WHERE itemId=25 AND type_rel=3 AND ln='es'
5 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 (25,10)
6 1.9 ms controllers/category.php

SELECT * FROM futbol.categories_coef WHERE parentId=25 or sonId=25 LIMIT 1
7 1.8 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 = 25 AND l.year=1933 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
8 1.9 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.tables1933 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 = 23339 AND t.round = 42 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
9 4.4 ms controllers/category.php

SELECT team, position, round FROM futbol.tables1933 WHERE league_id=23339 AND round=41 ORDER BY team ASC;
10 1.9 ms controllers/category.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 23339 LIMIT 1
11 10.7 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 `calendars1933` 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` = 23339 AND c.`round` = 20 ORDER BY shedule ASC LIMIT 200
12 2.6 ms controllers/category.php

SELECT c.id, 1933 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 events1933 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars1933 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 23339 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 (2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2031) 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 rel.media_id, rel.team1, rel.team2, m.name, m.type, m.lang, m.location, rel.id AS rel_id, m.url FROM rel_media_match AS rel INNER JOIN media AS m ON m.id=rel.media_id WHERE (m.lang='es' OR m.language='spanish') AND rel.active=1 AND rel.league_id=23339 AND rel.round=20
14 2.1 ms controllers/category.php

SELECT l.id, l.current_round, l.year, l.playoff, l.group_code, l.total_group, l.total_rounds, c.coefficient as coefficient, c.name AS competition_name, c.ctype, c.cat, l.table_suffix, c.competition_type, l.categoryId,l.split_league,l.extraName FROM categories AS c INNER JOIN leagues AS l ON c.id = l.categoryId WHERE categoryId = 25 AND l.year='1933' AND l.group_code=1 ORDER BY l.end_prev ASC, l.group_code DESC
15 1.9 ms controllers/category.php

SELECT 1933 as year, c.round, c.stadium AS stadium_id,c.isVideo,rel.media_id,c.id, dt1.id as datateam1, dt2.id as datateam2,c.league_id,c.extra,dt1.basealias as basealias1,dt2.basealias as basealias2, dt1.nameShow AS team1_name, dt2.nameShow AS team2_name, dt1.translate AS translate1, dt2.translate AS translate2, dt1.short_name AS local_abbr, dt2.short_name AS visitor_abbr,c.shedule as sheduleb, c.shedule AS shedule, CONVERT_TZ(NOW(), 'Europe/Madrid', 'Europe/Madrid') AS cur_date, c.r1, c.r2, c.team1, c.team2, 0 AS numc, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.finished, c.minute, IF(TIME(c.shedule)='00:00:00',1,0) AS no_hour , dt1.CountryCode AS CountryCode_local,dt2.CountryCode AS CountryCode_visitor, t1.conference as conference1, t2.conference as conference2, dt1.ctype FROM calendars1933 AS c INNER JOIN datateams as dt1 ON c.datateam1=dt1.id INNER JOIN datateams AS dt2 ON c.datateam2=dt2.id INNER JOIN teams t1 on t1.id = c.team1 INNER JOIN teams t2 on t2.id = c.team2 LEFT JOIN rel_media_match rel ON rel.cid = c.id AND rel.year = 1933 WHERE c.league_id = 23339 AND c.round =20 GROUP BY c.id ORDER BY c.shedule ASC, t1.conference ASC, field(CountryCode_local,'ES') DESC, field(CountryCode_visitor,'ES') DESC
16 2.7 ms controllers/category.php

SELECT ds.name as stadium FROM rel_stadiums AS rs INNER JOIN datastadiums AS ds ON ds.id = rs.stadium_id WHERE rs.teamId = 9178 AND active = 1
17 3.9 ms controllers/category.php

SELECT ds.name as stadium FROM rel_stadiums AS rs INNER JOIN datastadiums AS ds ON ds.id = rs.stadium_id WHERE rs.teamId = 9202 AND active = 1
18 3.8 ms controllers/category.php

SELECT ds.name as stadium FROM rel_stadiums AS rs INNER JOIN datastadiums AS ds ON ds.id = rs.stadium_id WHERE rs.teamId = 9208 AND active = 1
19 3.9 ms controllers/category.php

SELECT ds.name as stadium FROM rel_stadiums AS rs INNER JOIN datastadiums AS ds ON ds.id = rs.stadium_id WHERE rs.teamId = 9201 AND active = 1
20 3.8 ms controllers/category.php

SELECT ds.name as stadium FROM rel_stadiums AS rs INNER JOIN datastadiums AS ds ON ds.id = rs.stadium_id WHERE rs.teamId = 9756 AND active = 1
21 3.8 ms controllers/category.php

SELECT `type`, `order`,`rule` as rtext FROM futbol.rules WHERE categoryId=25 ORDER BY `order` ASC
22 1.8 ms controllers/category.php

TOTAL TIME 61.8 ms QUERIES 20 FILE controllers/category.php