Connection to sql... 8.8 ms

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

TOTAL TIME 4.1 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=19 AND l.year=1953 ORDER BY l.group_code
2 2.2 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=19 GROUP BY year ORDER BY year DESC
3 2.3 ms controllers/category.php

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

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

SELECT * FROM futbol.categories_coef WHERE parentId=19 or sonId=19 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 = 19 AND l.year=1953 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.tables1953 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 = 5720 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
9 2.5 ms controllers/category.php

SELECT team, position, round FROM futbol.tables1953 WHERE league_id=5720 AND round=25 ORDER BY team ASC;
10 1.8 ms controllers/category.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 5720 LIMIT 1
11 12 ms controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
12 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 `calendars1953` 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` = 5720 AND c.`round` = 30 ORDER BY shedule ASC LIMIT 200
13 2.5 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=5720 AND rel.round=30
14 2.3 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 = 19 AND l.year='1953' AND l.group_code=1 ORDER BY l.end_prev ASC, l.group_code DESC
15 2.1 ms controllers/category.php

SELECT 1953 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 calendars1953 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 = 1953 WHERE c.league_id = 5720 AND c.round =30 GROUP BY c.id ORDER BY c.shedule ASC, t1.conference ASC, field(CountryCode_local,'ES') DESC, field(CountryCode_visitor,'ES') DESC
16 2.3 ms controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='ee89e028576abbdb8f5e2922ffa6612b'
17 1.9 ms controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='5281601ba9e69765f3cc9698bdb672f2'
18 2 ms controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='3151090b16fde9e7ff044d7e165a7412'
19 1.9 ms controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='5e60b5ec40e89b36af60305c59be3a00'
20 1.8 ms controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='4ec3b69ed63112f7e8865f1e94706f35'
21 1.9 ms controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='10baa8b2e5f6bd44d6fc3845578df5e3'
22 1.9 ms controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='a084288bc6a0f07728af01f6b4dfe6d3'
23 1.9 ms controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='1df861fe51f457b17d0c4508e5cd42b6'
24 2 ms controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='6decc7a13941fd42daa4fbd69e65935f'
25 1.9 ms controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='7db10ce56f99e5425a2d429c7d394bdf'
26 1.9 ms controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='1a2a1340f3741e963834f82a364b3fee'
27 1.9 ms controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='748935a7655467c0132a01f4cc051685'
28 1.9 ms controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='4b1ddd643fea47e16092ebf093f63004'
29 2 ms controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='739134fed84a79ca4f9ed5eb1349cb76'
30 1.9 ms controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='8605c790e31dc4f7b2b68c6cf4d99c2e'
31 1.8 ms controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='943a1bcc4ff4b6c24273f8b6dfa34585'
32 1.9 ms controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='99e3c77bd9b8b06a5cbec5ca7ed00a7f'
33 1.9 ms controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='003e4a381cf8b16be461e334072c0fe0'
34 1.9 ms controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='ef48f94260867a2a9fdad53362cd24a0'
35 1.9 ms controllers/category.php

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

TOTAL TIME 76.9 ms QUERIES 34 FILE controllers/category.php