Connection to sql... 8.9 ms

SELECT type FROM routes WHERE alias = 'clasificacion_mundial_africa2024'
1 1.7 ms config/routes_file.php

TOTAL TIME 3.8 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=121 AND l.year=2024 ORDER BY l.group_code
2 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=121 GROUP BY year ORDER BY year DESC
3 2.1 ms controllers/category.php

SELECT type,categoryId,year FROM historical_resume WHERE (categoryId = 121 and (year = 2024 OR year = 0))
4 1.8 ms controllers/category.php

SELECT total FROM bs_rel_resume_items WHERE itemId=121 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 (121,136)
6 2 ms controllers/category.php

SELECT * FROM futbol.categories_coef WHERE parentId=121 or sonId=121 LIMIT 1
7 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 = 121 AND l.year=2024 AND l.group_code>=1 AND l.group_code = 6 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.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 = 72787 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
9 2.3 ms controllers/category.php

SELECT team, position, round FROM futbol.tables2024 WHERE league_id=72787 AND round=4 ORDER BY team ASC;
10 1.9 ms controllers/category.php

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

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='674bb194410ce60f317f3d5dd1db4305'
12 1.9 ms controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='3269534d0552a10a1ad4c58de0acb34a'
13 1.9 ms controllers/category.php

SELECT * FROM futbol.categories_coef WHERE parentId=121 or sonId=121 LIMIT 1
14 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 = 121 AND l.year=2023 AND l.group_code>=1 AND l.group_code = 6 ORDER BY l.group_code ASC
15 1.9 ms controllers/category.php

SELECT * FROM futbol.categories_coef WHERE parentId=121 or sonId=121 LIMIT 1
16 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 = 121 AND l.year=2022 AND l.group_code>=1 AND l.group_code = 6 ORDER BY l.group_code ASC
17 1.9 ms controllers/category.php

SELECT * FROM futbol.categories_coef WHERE parentId=121 or sonId=121 LIMIT 1
18 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 = 121 AND l.year=2021 AND l.group_code>=1 AND l.group_code = 6 ORDER BY l.group_code ASC
19 1.9 ms controllers/category.php

SELECT * FROM futbol.categories_coef WHERE parentId=121 or sonId=121 LIMIT 1
20 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 = 121 AND l.year=2020 AND l.group_code>=1 AND l.group_code = 6 ORDER BY l.group_code ASC
21 1.9 ms controllers/category.php

SELECT id FROM leagues_mobile WHERE categoryId=121 AND `year`=2024 AND `group_code`=6 ORDER BY id ASC
22 1.8 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 (72787) and d.year=2024 GROUP BY d.playerId ORDER BY goals DESC, apps ASC, dp.nick ASC LIMIT 1000;
23 25.9 ms controllers/category.php

SELECT player_id, squadNumber FROM futbol.rel_players WHERE category_id = 121 and year=2024
24 19.9 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(121) AND rel.ln='es' ORDER BY rel.cover_points DESC, rel.newId DESC LIMIT 1,20
25 2.7 ms controllers/category.php

SELECT e.name as author,n.id, n.alias, n.media, n.headline, n.teaser, n.subheadline, n.live_headline, n.update_date, n.other_media, n.views, n.teaser, n.comments FROM bs_news n LEFT JOIN bs_editors e ON e.id=n.author_id AND n.ln=e.ln WHERE n.status = 1 AND n.ln='es' AND n.id IN (1319287,1319181,1319076,1318884,1318826,1318641,1317465,1317409,1313188,1307711,1307709,1307639,1307017,1305880,1305848,1304871,1304563,1298683,1297005,1296811) ORDER BY n.cover_points DESC, n.creation_date DESC
26 3.2 ms controllers/category.php

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

TOTAL TIME 140.4 ms QUERIES 43 FILE controllers/category.php