Connection to sql... 9 ms

SELECT type FROM routes WHERE alias = 'segunda_madrid_cadete2020'
1 1.8 ms config/routes_file.php

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

SELECT c.id, c.name, c.alias, c.shortName, c.logo, c.location, c.continent, c.class, c.troncal, c.coefficient, c.CountryCode FROM categories c WHERE c.alias = 'segunda_madrid_cadete'
2 1.9 ms controllers/category.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=736 AND l.year=2020 ORDER BY l.group_code
3 3.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=736 GROUP BY year ORDER BY year DESC
4 2.4 ms controllers/category.php

SELECT type,categoryId,year FROM historical_resume WHERE (categoryId = 736 and (year = 2020 OR year = 0))
5 2 ms controllers/category.php

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

SELECT * FROM futbol.categories_coef WHERE parentId=736 or sonId=736 LIMIT 1
8 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 = 736 AND l.year=2020 AND l.group_code>=1 AND l.group_code = 8 ORDER BY l.group_code ASC
9 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.tables2020_base 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 = 52176 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC, t.points DESC, t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
10 2.5 ms controllers/category.php

SELECT team, position, round FROM futbol.tables2020_base WHERE league_id=52176 AND round=25 ORDER BY team ASC;
11 1.9 ms controllers/category.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 52176 LIMIT 1
12 16.4 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 `calendars2020_base` 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` = 52176 AND c.`round` = 7 ORDER BY shedule ASC LIMIT 200
13 2.4 ms controllers/category.php

SELECT c.id, 2020 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 events2020 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2020 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 52176 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 (10144058,10144057,10144056,10144055,10144054,10144053) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
14 2.2 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=52176 AND rel.round=7
15 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 = 736 AND l.year='2020' AND l.group_code=8 ORDER BY l.end_prev ASC, l.group_code DESC
16 2 ms controllers/category.php

SELECT 2020 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 calendars2020_base 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 = 2020 WHERE c.league_id = 52176 AND c.round =7 GROUP BY c.id ORDER BY c.shedule ASC, t1.conference ASC, field(CountryCode_local,'ES') DESC, field(CountryCode_visitor,'ES') DESC
17 2.5 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 = 22581 AND active = 1
18 3.1 ms controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='212a0488abf6c0d52971d8e90bf314f9'
19 1.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 = 124117 AND active = 1
20 3.1 ms controllers/category.php

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

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

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

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

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='71249081f8b767253cd8841324288b1c'
25 1.8 ms controllers/category.php

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

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='212a0488abf6c0d52971d8e90bf314f9'
27 1.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 = 92528 AND active = 1
28 3.1 ms controllers/category.php

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

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='36606e85840bb85db6521cd308082a21'
30 1.8 ms controllers/category.php

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

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

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

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

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='212a0488abf6c0d52971d8e90bf314f9'
35 1.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 = 104922 AND active = 1
36 3.9 ms controllers/category.php

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

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

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='79b6ae4ce99e33b634a24499333a04bc'
39 2 ms controllers/category.php

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

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

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

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='212a0488abf6c0d52971d8e90bf314f9'
43 1.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 = 104709 AND active = 1
44 4.4 ms controllers/category.php

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

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='36606e85840bb85db6521cd308082a21'
46 2 ms controllers/category.php

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

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

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

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

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='212a0488abf6c0d52971d8e90bf314f9'
51 2 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 = 96043 AND active = 1
52 4.5 ms controllers/category.php

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

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

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='79b6ae4ce99e33b634a24499333a04bc'
55 2 ms controllers/category.php

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

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

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='531a9e10f15396b097aa1513d4e89bd0'
58 2 ms controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='212a0488abf6c0d52971d8e90bf314f9'
59 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(736) AND rel.ln='es' ORDER BY rel.cover_points DESC, rel.newId DESC LIMIT 1,20
60 2.4 ms controllers/category.php

SELECT `type`, `order`,`rule` as rtext FROM futbol.rules WHERE categoryId=736 ORDER BY `order` ASC
61 1.9 ms controllers/category.php

TOTAL TIME 142.4 ms QUERIES 59 FILE controllers/category.php