Connection to sql... 8.9 ms

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

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

SELECT dp.id, dp.alias, dp.name, dp.last_name, dp.fullname, dp.nick, dp.birthdate, dp.birthcountry, dp.CountryCode AS code, dp.bCountryCode, dp.CountryCodeb AS codeb, dp.role, dp.foot, dp.side, dp.height, dp.weight, dp.international, dp.internationalg, dp.twitter, dp.website, dp.dead_date, dp.bdfId, dp.birthplace, dp.palmares, c.Name AS country, c2.Name AS countryb FROM dataplayers AS dp LEFT JOIN country AS c ON dp.CountryCode=c.iso_code LEFT JOIN country AS c2 ON dp.CountryCodeb=c2.iso_code WHERE dp.alias='Zaletel-478128'
2 2.1 ms player/index.php

SELECT rp.player_id, rp.year, rp.squadNumber, rp.league_id, rp.team_id, rp.teamId, rp.category_id, rp.captain, ct.id AS competition_id, ct.name AS competition_name, ct.alias AS competition_alias, ct.logo AS competition_logo FROM rel_players AS rp INNER JOIN categories AS ct ON rp.category_id=ct.id WHERE rp.player_id=478128 AND rp.in_squad=1 GROUP BY ct.id, rp.year ORDER BY rp.year DESC, ct.troncal DESC, ct.coefficient DESC, rp.teamId ASC
3 2.3 ms player/index.php

SELECT dt.id, dt.nameShow, dt.basealias, dt.CountryCode, dt.short_name FROM datateams AS dt WHERE dt.id IN (2689,63477,10108,13646,3727,102716,65957,86281,63711)
4 1.8 ms player/index.php

SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=478128 AND type_rel = 1 LIMIT 1
5 1.9 ms player/index.php

SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2689 AND type_rel = 2 LIMIT 1
6 1.9 ms player/index.php

SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2689 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
7 2.3 ms player/index.php

SELECT n.id, n.author_id, n.headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name, n.live_headline, n.live_teaser FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (111936,264613,274061,764160,1145240) ORDER BY n.cover_points DESC, update_date DESC
8 2.3 ms player/index.php

SELECT p.id, p.title, p.views, p.votes_up, p.downloads, p.totalcomments, p.author_id FROM rel_pictures AS rp INNER JOIN pictures AS p ON p.id=rp.id_picture WHERE rp.id_content=478128 AND rp.type=3 AND p.revised=1 AND p.ban_type=0 AND p.banned=0 GROUP BY p.id ORDER BY p.id DESC LIMIT 18
9 2.2 ms player/index.php

SELECT e.action, e.minute, e.match_id, l.categoryId AS competition_id FROM events2024 AS e INNER JOIN leagues AS l ON e.league_id=l.id WHERE e.player_id=478128 AND l.categoryId IN (13,153,604,2671) ORDER BY e.league_id ASC, e.action ASC
10 2.4 ms player/index.php

SELECT l.categoryId AS competition_id, l.year, ddr.id_match FROM dreamteam_data_real AS ddr INNER JOIN rel_dreamteam_real AS rdr ON ddr.id=rdr.team_number INNER JOIN leagues AS l ON ddr.league_id=l.id AND l.year=2024 WHERE rdr.player_id=478128 AND l.categoryId IN (13,153,604,2671) ORDER BY l.categoryId ASC
11 6.3 ms player/index.php

SELECT l.categoryId AS competition_id, rdr.year,cal.id AS id_match FROM rel_dreamteam_historical AS rdr INNER JOIN calendars2024 AS cal ON cal.id = rdr.match_id INNER JOIN leagues AS l ON l.id=cal.league_id WHERE rdr.year=2024 AND rdr.playerid=478128 AND l.categoryId IN (13,153,604,2671) ORDER BY l.categoryId ASC;
12 2.1 ms player/index.php

SELECT l.total_group, l.group_code, rp.year AS year, rp.squadNumber, rp.league_id, dt.id AS team_id, dt.nameShow AS team_name, dt.basealias, ct.id AS category_id, ct.name AS category_name, ct.alias AS category_alias, ct.troncal, ct.true_level, ct.official, ct.logo AS category_logo FROM rel_players AS rp INNER JOIN datateams AS dt ON rp.teamId=dt.id INNER JOIN categories_besoccer AS ct ON rp.category_id=ct.id INNER JOIN leagues_besoccer as l ON (l.categoryId = ct.id) WHERE rp.player_id='478128' AND rp.year='2024' GROUP BY ct.id,dt.id ORDER BY ct.troncal DESC, ct.coefficient DESC
13 3.5 ms player/index.php

SELECT p.playerId, p.year, p.CountryCode, p.league_id, p.categoryId, p.teamId, p.age, sum(p.2nd_red) as totalsecondyellow,sum(p.goals) as totalgoals, sum(p.pen_goals) as totalpengoals, sum(p.apps) as totalappearances, sum(p.minutes) as totalminutes, sum(p.goals_conceded) as totalgoalsconceded, sum(p.pen_err) as totalpenaltyerrors, sum(p.pen_save) as totalpenaltysaves, sum(p.yellow_cards) as totalyellowcards, sum(p.red_cards) as totalredcards, sum(p.substitutions) as totalsubs, sum(p.in) as totalsubsin, sum(p.out) as totalsubsout, sum(p.own_goal) as totalowngoals, sum(p.assists) as totalassist, sum(p.completed) as totalfullmatchescompleted, sum(p.lineup) as totallineupappearances FROM detail_player_match as p WHERE p.playerId=478128 AND p.year=2024 GROUP BY p.categoryId, p.teamId
14 3 ms player/index.php

TOTAL TIME 35 ms QUERIES 13 FILE player/index.php

SELECT c.id as match_id, c.league_id,cat.logo,cat.name,l.group_code,c.acta,c.isVideo,l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments,c.betId,c.penaltis1,c.penaltis2,c.prorroga,c.status,c.minute,c.finished FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2024 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE c.id IN (11194,718052,11197,718053,718057,718061,11122,11128,11130,11206,11137,11209,11146,11218,11152,11224,11170,11229,11176,718033,718038,11182,718043,11183,718046,718047,657440,657660,671276,676434,591371,570634,11116,511050) GROUP BY c.id ORDER BY c.shedule DESC
15 3 ms application/mods/player/partidos.php

TOTAL TIME 2.8 ms QUERIES 1 FILE application/mods/player/partidos.php

SELECT rel.id, dp.nick, rel.player_id, rel.year, dp.alias, dp.role FROM rel_players rel INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE rel.team_id=6583532 AND rel.in_squad=1 GROUP BY rel.player_id ORDER BY dp.role ASC, dp.nick ASC
16 2.8 ms application/mods/player/squad.php

TOTAL TIME 2.5 ms QUERIES 1 FILE application/mods/player/squad.php

SELECT rel.id,dp.nick,rel.player_id,dp.alias FROM rel_players rel INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE rel.team_id=6583532 AND rel.in_squad=1 GROUP BY rel.player_id ORDER BY dp.role ASC, dp.nick ASC
17 2.5 ms application/mods/player/companeros.php

TOTAL TIME 0 us QUERIES 0 FILE application/mods/player/companeros.php