Connection to sql... 8.4 ms

SELECT old,new FROM redirect WHERE old = 'historico'
1 1.8 ms config/routes_file.php

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

SELECT dt.*,cou.Name as Name,cou.Continent as Continent,cou.Region,dp.latitude,dp.longitude,dp.name as geo_location, ds.header_color as color1 FROM datateams AS dt LEFT JOIN country AS cou ON LOWER(cou.Code2) = dt.CountryCode LEFT JOIN dataplaces dp on dp.geonameid=dt.geonameid LEFT JOIN datateams_shields ds on ds.teamId=dt.id WHERE dt.basealias='buchbach' LIMIT 1
2 84.2 ms controllers/home.php

SELECT dp.id, dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=9730 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
3 1.9 ms controllers/home.php

SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=9730 AND role_id=2 ORDER BY rp.date_ini DESC LIMIT 1
4 1.8 ms controllers/home.php

SELECT rs.teamId, ds.id AS stadiumId, ds.name, ds.seats, ds.yearBuilt, ds.typefield, ds.city, ds.address, ds.size, ds.fans, ds.phone, ds.fax FROM rel_stadiums AS rs INNER JOIN datastadiums AS ds ON ds.id = rs.stadium_id WHERE rs.teamId = 9730 AND active = 1
5 2.8 ms controllers/home.php

SELECT c.troncal, t.conference, c.id AS category_id, t.id as team_id,t.league_id,c.name as cat_name, c.name_english as cat_name_en,l.year,l.tables,l.current_round,l.group_code,l.total_group,c.active_year,c.alias, l.table_suffix, c.logo as league_logo FROM teams AS t INNER JOIN leagues_besoccer l ON l.id = t.league_id INNER JOIN categories_besoccer c ON c.id = l.categoryId WHERE t.teamId = 9730 AND c.ctype != 12 ORDER BY c.troncal DESC, l.year DESC, l.end_prev ASC, c.parentId ASC, c.coefficient DESC, l.group_code = 0 ASC, l.group_code ASC LIMIT 2
6 2.9 ms controllers/home.php

SELECT ct.id FROM categories_besoccer AS ct INNER JOIN leagues_besoccer AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=9730 AND ct.ctype!=12 AND ct.status=1 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC
7 2.6 ms controllers/home.php

SELECT ct.id, ct.alias, ct.name AS name, ct.logo, ct.CountryCode, ct.active_year, ct.location, ct.continent, ct.competition_type, ct.troncal, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_teams, l.current_round, l.total_rounds, l.total_group, l.group_code, l.legend, l.legendExtra, l.playoff, l.end_prev, l.end_date, t.id as team_id, t.name as team_name FROM categories_besoccer AS ct INNER JOIN leagues_besoccer AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams t on t.teamId=9730 and l.id=t.league_id WHERE ct.id IN (178,1949) ORDER BY ct.coefficient DESC, ct.id ASC, l.group_code ASC
8 2.7 ms controllers/home.php

SELECT dt.nameShow,(cast(tab.gf as signed) - cast(tab.ga as signed) + 100) as diff,tab.*,t.teamId FROM teams AS t INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories c ON c.id = l.categoryId INNER JOIN tables2025 as tab ON tab.league_id = t.league_id AND tab.team = t.id INNER JOIN datateams dt ON dt.id = t.teamId WHERE c.troncal = 1 AND t.league_id = 76491 AND tab.round = 24 ORDER BY tab.points DESC, diff DESC, tab.ga DESC, dt.nameShow ASC
9 2.8 ms controllers/home.php

SELECT dp.id, dp.birthplace, dp.nick,dp.name,dp.last_name,dp.alias,dp.birthdate,dp.height,dp.weight,dp.foot,dp.side, dp.role, 2025 AS year, rp.squadNumber,'' as num,'' as pos,'' as idplayer,'' as goals,'' as reds,'' as yellows,IF(dp.CountryCode IS NULL,'',dp.CountryCode) AS CountryCode, '' as gender FROM futbol.rel_players as rp INNER JOIN futbol.dataplayers as dp on rp.player_id=dp.id and rp.in_squad=1 WHERE rp.year=2025 and rp.team_id=6644949 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC
10 3.3 ms controllers/home.php

SELECT total FROM bs_rel_resume_items WHERE itemId=9730 AND type_rel=2 AND ln='es'
11 1.9 ms controllers/home.php

SELECT rb.id FROM rel_budgets AS rb WHERE (rb.official_budget = 1 or rb.official_budget = 2 or rb.official_budget = 0) AND (rb.origin_team_id IN (9730) OR rb.destination_team_id IN (9730)) AND rb.year = 2025 AND rb.active = 1 LIMIT 1
12 2.9 ms controllers/home.php

SELECT ip.id as id, ip.datateamId, site_name as club,ip.json_data FROM club_projects.club_teams ct INNER JOIN club_projects.info_projects ip ON ip.id = ct.project_id WHERE ct.rel_datateamId=9730 LIMIT 1
13 1.9 ms controllers/home.php

SELECT dt.nameShow FROM datateams AS dt WHERE dt.id=9730 LIMIT 1
14 1.8 ms controllers/home.php

SELECT cat.alias, cat.location as cc, cat.logo, cat.name AS category_name, dtm.year, dtm.categoryId,(SUM(dtm.lineup) DIV 11) AS apps, SUM(dtm.goals) AS goals, SUM(dtm.assists) AS assists, SUM(dtm.yellow_cards) AS yellow_cards, SUM(dtm.expulsions) AS expulsions, dtm.league_id, dtm.teamId, cat.troncal,lea.group_code, lea.id as league_id FROM detail_team_match AS dtm INNER JOIN categories_besoccer AS cat ON dtm.categoryId = cat.id LEFT JOIN leagues lea ON lea.id=dtm.league_id WHERE teamId = 9730 AND cat.official = 1 GROUP BY dtm.year, dtm.categoryId ORDER BY dtm.year DESC, dtm.categoryId ASC
15 330 ms controllers/home.php

SELECT player_id FROM rel_players rp WHERE rp.category_id=178 and rp.year=2025 AND rp.in_squad=1 AND teamId=9730
16 2.9 ms controllers/home.php

SELECT id FROM leagues WHERE categoryId=178 AND `year`=2025 ORDER BY id ASC
17 2.7 ms controllers/home.php

SELECT count(*) as total, dp.CountryCode as countryCode, dp.id as player_id, dp.nick,dt.id as teamId, dt.nameShow as teamName,dt.basealias,dt.id as team_id,dp.role,rp.squadNumber FROM events2025 e INNER JOIN dataplayers dp on dp.id= e.player_id INNER JOIN datateams dt on dt.id=e.teamId INNER JOIN rel_players rp ON rp.category_id=178 and rp.year=2025 and rp.player_id=dp.id WHERE e.league_id in (76491,76492,76493,76494,76707) AND e.action<31 AND (e.action IN (1,2,11,12,13,26)) AND dt.id=9730 GROUP BY e.player_id ORDER BY total DESC, e.player_id DESC LIMIT 50
18 5 ms controllers/home.php

SELECT dp.id as player_id, SUM(d.minutes) as minutes, sum(d.lineup) as lineup, sum(d.reserved) as reserved, sum(d.in) as inside, sum(d.out) as outside 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.categoryId = 178 and d.year=2025 AND dp.id in (690001,578534,283669,204930,3324396,976595,432442,868733,3166324,3166377,3324397,396143,726915,700377,456402,292403,3166311,277232,3166384,3176605,3400451,652957,3612305) GROUP BY d.playerId
19 17.3 ms controllers/home.php

SELECT count(*) as total, dp.CountryCode as countryCode, dp.id as player_id, dp.nick, dt.id as teamId, dt.nameShow as teamName, dt.basealias,dt.id as team_id,dp.role,rp.squadNumber FROM events2025 e INNER JOIN dataplayers dp on dp.id= e.player_id INNER JOIN datateams dt on dt.id=e.teamId INNER JOIN rel_players rp ON rp.category_id=178 and rp.year=2025 and rp.player_id=dp.id WHERE e.league_id in (76491,76492,76493,76494,76707) AND e.action<31 AND e.action=3 AND dt.id=9730 GROUP BY e.player_id ORDER BY total DESC, e.player_id DESC LIMIT 50
20 4.2 ms controllers/home.php

SELECT dp.id as player_id, SUM(d.minutes) as minutes, sum(d.lineup) as lineup, sum(d.reserved) as reserved, sum(d.in) as inside, sum(d.out) as outside 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.categoryId = 178 and d.year=2025 AND dp.id in (578534) GROUP BY d.playerId
21 2.9 ms controllers/home.php

SELECT count(*) as total, dp.CountryCode as countryCode, dp.id as player_id, dp.nick, dt.id as teamId, dt.nameShow as teamName, dt.basealias,dt.id as team_id,dp.role,rp.squadNumber FROM events2025 e INNER JOIN dataplayers dp on dp.id= e.player_id INNER JOIN datateams dt on dt.id=e.teamId INNER JOIN rel_players rp ON rp.category_id=178 and rp.year=2025 and rp.player_id=dp.id WHERE e.league_id in (76491,76492,76493,76494,76707) AND e.action<31 AND e.action=4 AND dt.id=9730 GROUP BY e.player_id ORDER BY total DESC, e.player_id DESC LIMIT 50
22 4.2 ms controllers/home.php

SELECT count(*) as total, dp.CountryCode as countryCode, dp.id as player_id, dp.nick, dt.id as teamId, dt.nameShow as teamName, dt.basealias,dt.id as team_id,dp.role,rp.squadNumber FROM events2025 e INNER JOIN dataplayers dp on dp.id= e.player_id INNER JOIN datateams dt on dt.id=e.teamId INNER JOIN rel_players rp ON rp.category_id=178 and rp.year=2025 and rp.player_id=dp.id WHERE e.league_id in (76491,76492,76493,76494,76707) AND e.action<31 AND e.action=5 AND dt.id=9730 GROUP BY e.player_id ORDER BY total DESC, e.player_id DESC LIMIT 50
23 6.4 ms controllers/home.php

SELECT dp.id as player_id, SUM(d.minutes) as minutes, sum(d.lineup) as lineup, sum(d.reserved) as reserved, sum(d.in) as inside, sum(d.out) as outside 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.categoryId = 178 and d.year=2025 AND dp.id in (690001,456402,292403,726915,283669,204930,3324396,3166324,3166311,868733,652957,432442,396143,339441,3176605,3166377,976595,700377,277232) GROUP BY d.playerId
24 15.2 ms controllers/home.php

SELECT count(*) as total, dp.CountryCode as countryCode, dp.id as player_id, dp.nick, dt.id as teamId, dt.nameShow as teamName, dt.basealias,dt.id as team_id,dp.role,rp.squadNumber FROM events2025 e INNER JOIN dataplayers dp on dp.id= e.player_id INNER JOIN datateams dt on dt.id=e.teamId INNER JOIN rel_players rp ON rp.category_id=178 and rp.year=2025 and rp.player_id=dp.id WHERE e.league_id in (76491,76492,76493,76494,76707) AND e.action<31 AND e.action=22 AND dt.id=9730 GROUP BY e.player_id ORDER BY total DESC, e.player_id DESC LIMIT 50
25 2.2 ms controllers/home.php

SELECT count(*) as total, dp.CountryCode as countryCode, dp.id as player_id, dp.nick, dt.id as teamId, dt.nameShow as teamName, dt.basealias,dt.id as team_id,dp.role,rp.squadNumber FROM events2025 e INNER JOIN dataplayers dp on dp.id= e.player_id INNER JOIN datateams dt on dt.id=e.teamId INNER JOIN rel_players rp ON rp.category_id=178 and rp.year=2025 and rp.player_id=dp.id WHERE e.league_id in (76491,76492,76493,76494,76707) AND e.action<31 AND e.action=2 AND dt.id=9730 GROUP BY e.player_id ORDER BY total DESC, e.player_id DESC LIMIT 50
26 6.4 ms controllers/home.php

SELECT dp.id as player_id, SUM(d.minutes) as minutes, sum(d.lineup) as lineup, sum(d.reserved) as reserved, sum(d.in) as inside, sum(d.out) as outside 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.categoryId = 178 and d.year=2025 AND dp.id in (700377) GROUP BY d.playerId
27 2.4 ms controllers/home.php

SELECT count(*) as total, dp.CountryCode as countryCode, dp.id as player_id, dp.nick, dt.id as teamId, dt.nameShow as teamName, dt.basealias,dt.id as team_id,dp.role,rp.squadNumber FROM events2025 e INNER JOIN dataplayers dp on dp.id= e.player_id INNER JOIN datateams dt on dt.id=e.teamId INNER JOIN rel_players rp ON rp.category_id=178 and rp.year=2025 and rp.player_id=dp.id WHERE e.league_id in (76491,76492,76493,76494,76707) AND e.action<31 AND e.action=15 AND dt.id=9730 GROUP BY e.player_id ORDER BY total DESC, e.player_id DESC LIMIT 50
28 2.7 ms controllers/home.php

SELECT count(*) as total, dp.CountryCode as countryCode, dp.id as player_id, dp.nick, dt.id as teamId, dt.nameShow as teamName, dt.basealias,dt.id as team_id,dp.role,rp.squadNumber FROM events2025 e INNER JOIN dataplayers dp on dp.id= e.player_id INNER JOIN datateams dt on dt.id=e.teamId INNER JOIN rel_players rp ON rp.category_id=178 and rp.year=2025 and rp.player_id=dp.id WHERE e.league_id in (76491,76492,76493,76494,76707) AND e.action<31 AND e.action=16 AND dt.id=9730 GROUP BY e.player_id ORDER BY total DESC, e.player_id DESC LIMIT 50
29 2.6 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=178 or sonId=178 LIMIT 1
30 1.8 ms controllers/home.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 = 178 AND l.year=2025 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
31 2 ms controllers/home.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.tables2025 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 = 76491 AND t.round = 24 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
32 3.1 ms controllers/home.php

SELECT team, position, round FROM futbol.tables2025 WHERE league_id=76491 AND round=23 ORDER BY team ASC;
33 1.9 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='4e385e8aec65064e7b6b8f7357785c15'
34 2 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='731f3222d5f00c116376fec2d09c3339'
35 1.9 ms controllers/home.php

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

SELECT * FROM futbol.categories_coef WHERE parentId=178 or sonId=178 LIMIT 1
37 1.8 ms controllers/home.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 = 178 AND l.year=2024 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
38 2 ms controllers/home.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.tables2024 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 = 72239 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
39 2.7 ms controllers/home.php

SELECT team, position, round FROM futbol.tables2024 WHERE league_id=72239 AND round=33 ORDER BY team ASC;
40 1.8 ms controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 72239 LIMIT 1
41 24.3 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='731f3222d5f00c116376fec2d09c3339'
42 2 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
43 1.9 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=178 or sonId=178 LIMIT 1
44 1.8 ms controllers/home.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 = 178 AND l.year=2023 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
45 1.9 ms controllers/home.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.tables2023 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 = 68045 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
46 3.1 ms controllers/home.php

SELECT team, position, round FROM futbol.tables2023 WHERE league_id=68045 AND round=37 ORDER BY team ASC;
47 1.9 ms controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 68045 LIMIT 1
48 24.6 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='731f3222d5f00c116376fec2d09c3339'
49 1.9 ms controllers/home.php

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

SELECT * FROM futbol.categories_coef WHERE parentId=178 or sonId=178 LIMIT 1
51 1.8 ms controllers/home.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 = 178 AND l.year=2022 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
52 2 ms controllers/home.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.tables2022 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 = 63156 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
53 3.8 ms controllers/home.php

SELECT team, position, round FROM futbol.tables2022 WHERE league_id=63156 AND round=37 ORDER BY team ASC;
54 1.9 ms controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 63156 LIMIT 1
55 21.7 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='4e385e8aec65064e7b6b8f7357785c15'
56 2.1 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='731f3222d5f00c116376fec2d09c3339'
57 1.9 ms controllers/home.php

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

SELECT * FROM futbol.categories_coef WHERE parentId=178 or sonId=178 LIMIT 1
59 1.8 ms controllers/home.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 = 178 AND l.year=2020 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
60 1.9 ms controllers/home.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 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 = 50101 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
61 3.6 ms controllers/home.php

SELECT team, position, round FROM futbol.tables2020 WHERE league_id=50101 AND round=22 ORDER BY team ASC;
62 1.9 ms controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 50101 LIMIT 1
63 27.2 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='731f3222d5f00c116376fec2d09c3339'
64 1.9 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
65 1.8 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=178 or sonId=178 LIMIT 1
66 1.7 ms controllers/home.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 = 178 AND l.year=2019 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
67 1.8 ms controllers/home.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.tables2019 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 = 43941 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
68 2.6 ms controllers/home.php

SELECT team, position, round FROM futbol.tables2019 WHERE league_id=43941 AND round=33 ORDER BY team ASC;
69 1.7 ms controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 43941 LIMIT 1
70 16.5 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='731f3222d5f00c116376fec2d09c3339'
71 1.8 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
72 1.9 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=178 or sonId=178 LIMIT 1
73 1.7 ms controllers/home.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 = 178 AND l.year=2018 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
74 1.8 ms controllers/home.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.tables2018 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 = 38887 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
75 3.4 ms controllers/home.php

SELECT team, position, round FROM futbol.tables2018 WHERE league_id=38887 AND round=37 ORDER BY team ASC;
76 1.8 ms controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 38887 LIMIT 1
77 18.7 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='731f3222d5f00c116376fec2d09c3339'
78 1.8 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
79 1.9 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=178 or sonId=178 LIMIT 1
80 1.8 ms controllers/home.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 = 178 AND l.year=2017 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
81 1.9 ms controllers/home.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.tables2017 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 = 33371 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
82 2.7 ms controllers/home.php

SELECT team, position, round FROM futbol.tables2017 WHERE league_id=33371 AND round=33 ORDER BY team ASC;
83 1.9 ms controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 33371 LIMIT 1
84 15.6 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='731f3222d5f00c116376fec2d09c3339'
85 1.8 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
86 1.8 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=178 or sonId=178 LIMIT 1
87 1.7 ms controllers/home.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 = 178 AND l.year=2016 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
88 1.8 ms controllers/home.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.tables2016 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 = 15528 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
89 3 ms controllers/home.php

SELECT team, position, round FROM futbol.tables2016 WHERE league_id=15528 AND round=33 ORDER BY team ASC;
90 1.9 ms controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 15528 LIMIT 1
91 23 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=178 or sonId=178 LIMIT 1
92 1.7 ms controllers/home.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 = 178 AND l.year=2015 AND l.group_code>=1 AND l.group_code = 4 ORDER BY l.group_code ASC
93 1.8 ms controllers/home.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.tables2015 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 = 3904 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
94 4.1 ms controllers/home.php

SELECT team, position, round FROM futbol.tables2015 WHERE league_id=3904 AND round=33 ORDER BY team ASC;
95 2 ms controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 3904 LIMIT 1
96 17.7 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='731f3222d5f00c116376fec2d09c3339'
97 1.8 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
98 1.8 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=178 or sonId=178 LIMIT 1
99 1.7 ms controllers/home.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 = 178 AND l.year=2014 AND l.group_code>=1 AND l.group_code = 4 ORDER BY l.group_code ASC
100 1.9 ms controllers/home.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.tables2014 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 = 2508 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
101 3.1 ms controllers/home.php

SELECT team, position, round FROM futbol.tables2014 WHERE league_id=2508 AND round=37 ORDER BY team ASC;
102 2.2 ms controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 2508 LIMIT 1
103 15.7 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=178 or sonId=178 LIMIT 1
104 1.8 ms controllers/home.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 = 178 AND l.year=2013 AND l.group_code>=1 AND l.group_code = 4 ORDER BY l.group_code ASC
105 1.9 ms controllers/home.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.tables2013 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 = 2008 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
106 2.9 ms controllers/home.php

SELECT team, position, round FROM futbol.tables2013 WHERE league_id=2008 AND round=37 ORDER BY team ASC;
107 1.9 ms controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 2008 LIMIT 1
108 15.6 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='731f3222d5f00c116376fec2d09c3339'
109 1.8 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
110 1.8 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=573 or sonId=573 LIMIT 1
111 1.7 ms controllers/home.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 = 573 AND l.year=2012 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
112 1.8 ms controllers/home.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.tables2012 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 = 19820 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
113 3.3 ms controllers/home.php

SELECT team, position, round FROM futbol.tables2012 WHERE league_id=19820 AND round=33 ORDER BY team ASC;
114 2.1 ms controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 19820 LIMIT 1
115 25 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=573 or sonId=573 LIMIT 1
116 1.8 ms controllers/home.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 = 573 AND l.year=2011 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
117 1.9 ms controllers/home.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.tables2011 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 = 19831 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
118 3.1 ms controllers/home.php

SELECT team, position, round FROM futbol.tables2011 WHERE league_id=19831 AND round=33 ORDER BY team ASC;
119 2 ms controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 19831 LIMIT 1
120 15.5 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=573 or sonId=573 LIMIT 1
121 1.8 ms controllers/home.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 = 573 AND l.year=2010 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
122 2 ms controllers/home.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.tables2010 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 = 19842 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
123 3.1 ms controllers/home.php

SELECT team, position, round FROM futbol.tables2010 WHERE league_id=19842 AND round=37 ORDER BY team ASC;
124 2 ms controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 19842 LIMIT 1
125 15.5 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=573 or sonId=573 LIMIT 1
126 1.8 ms controllers/home.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 = 573 AND l.year=2009 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
127 1.8 ms controllers/home.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.tables2009 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 = 19854 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
128 2.9 ms controllers/home.php

SELECT team, position, round FROM futbol.tables2009 WHERE league_id=19854 AND round=33 ORDER BY team ASC;
129 1.8 ms controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 19854 LIMIT 1
130 13.9 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=178 or sonId=178 LIMIT 1
131 1.7 ms controllers/home.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 = 178 AND l.year=2025 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
132 1.8 ms controllers/home.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.tables2025 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 = 76491 AND t.round = 24 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
133 2.6 ms controllers/home.php

SELECT team, position, round FROM futbol.tables2025 WHERE league_id=76491 AND round=23 ORDER BY team ASC;
134 1.8 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='4e385e8aec65064e7b6b8f7357785c15'
135 1.9 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='731f3222d5f00c116376fec2d09c3339'
136 1.9 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
137 1.8 ms controllers/home.php

SELECT dt.id,t.id as id_comp, dt.nameShow, dt.translate, l.group_code, 0 AS favorite,dt.basealias,dt.fullName,t.conference,dt.short_name,ct.ctype,l.year, ds.header_color as color1, dt.countryCode FROM datateams AS dt INNER JOIN teams AS t ON dt.id=t.teamId INNER JOIN leagues AS l ON t.league_id=l.id INNER JOIN categories AS ct ON ct.id=l.categoryId LEFT JOIN datateams_shields ds on ds.teamId=dt.id WHERE l.categoryId=178 AND l.year=2025 AND l.group_code='1' ORDER BY l.group_code, dt.nameShow ASC
138 2.5 ms controllers/home.php

SELECT dt.id,t.id as id_comp, dt.nameShow, dt.translate, l.group_code, 0 AS favorite,dt.basealias,dt.fullName,t.conference,dt.short_name,ct.ctype,l.year, ds.header_color as color1, dt.countryCode FROM datateams AS dt INNER JOIN teams AS t ON dt.id=t.teamId INNER JOIN leagues AS l ON t.league_id=l.id INNER JOIN categories AS ct ON ct.id=l.categoryId LEFT JOIN datateams_shields ds on ds.teamId=dt.id WHERE l.categoryId=1949 AND l.year=2025 AND l.group_code='1' ORDER BY l.group_code, dt.nameShow ASC
139 2 ms controllers/home.php

TOTAL TIME 926.5 ms QUERIES 137 FILE controllers/home.php