Connection to sql... 521 us

SELECT old,new FROM redirect WHERE old = 'partidos'
1 390 us config/routes_file.php

TOTAL TIME 4 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='Cd-Calahorra' LIMIT 1
2 3.6 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=672 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
3 192 us 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=672 AND role_id=2 ORDER BY rp.date_ini DESC LIMIT 1
4 185 us 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 = 672 AND active = 1
5 1.7 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 = 672 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 1.4 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=672 AND ct.ctype!=12 AND ct.status=1 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC
7 2.2 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=672 and l.id=t.league_id WHERE ct.id IN (2469,169) ORDER BY ct.coefficient DESC, ct.id ASC, l.group_code ASC
8 837 us 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 = 76670 AND tab.round = 26 ORDER BY tab.points DESC, diff DESC, tab.ga DESC, dt.nameShow ASC
9 652 us 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=6648501 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC
10 1.2 ms controllers/home.php

SELECT total FROM bs_rel_resume_items WHERE itemId=672 AND type_rel=2 AND ln='es'
11 136 us 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 (672) OR rb.destination_team_id IN (672)) AND rb.year = 2025 AND rb.active = 1 LIMIT 1
12 877 us 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=672 LIMIT 1
13 163 us 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 = 672 AND cat.official = 1 GROUP BY dtm.year, dtm.categoryId ORDER BY dtm.year DESC, dtm.categoryId ASC
14 14.4 ms controllers/home.php

SELECT player_id FROM rel_players rp WHERE rp.category_id=2469 and rp.year=2025 AND rp.in_squad=1 AND teamId=672
15 2.5 ms controllers/home.php

SELECT id FROM leagues WHERE categoryId=2469 AND `year`=2025 ORDER BY id ASC
16 611 us 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=2469 and rp.year=2025 and rp.player_id=dp.id WHERE e.league_id in (76668,76670,76671,76672,76673) AND e.action<31 AND (e.action IN (1,2,11,12,13,26)) AND dt.id=672 GROUP BY e.player_id ORDER BY total DESC, e.player_id DESC LIMIT 50
17 1.6 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 = 2469 and d.year=2025 AND dp.id in (171030,168520,191574,759953,192465,293489,874829,425267,339856,282634,170198,951734,1023382,374921,996558,3455709,35171,886905,1024367,338264,185968,915701,3184293) GROUP BY d.playerId
18 12.6 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=2469 and rp.year=2025 and rp.player_id=dp.id WHERE e.league_id in (76668,76670,76671,76672,76673) AND e.action<31 AND e.action=3 AND dt.id=672 GROUP BY e.player_id ORDER BY total DESC, e.player_id DESC LIMIT 50
19 2.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 = 2469 and d.year=2025 AND dp.id in (480564,874829,374921,35171) GROUP BY d.playerId
20 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=2469 and rp.year=2025 and rp.player_id=dp.id WHERE e.league_id in (76668,76670,76671,76672,76673) AND e.action<31 AND e.action=4 AND dt.id=672 GROUP BY e.player_id ORDER BY total DESC, e.player_id DESC LIMIT 50
21 1.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=2469 and rp.year=2025 and rp.player_id=dp.id WHERE e.league_id in (76668,76670,76671,76672,76673) AND e.action<31 AND e.action=5 AND dt.id=672 GROUP BY e.player_id ORDER BY total DESC, e.player_id DESC LIMIT 50
22 2.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 = 2469 and d.year=2025 AND dp.id in (192465,168520,425267,951734,191574,170198,1023382,951772,886905,480564,356375,339856,282634,171030,874829,759953,618163,338264,3455709,3183694,293489,35171) GROUP BY d.playerId
23 10.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=2469 and rp.year=2025 and rp.player_id=dp.id WHERE e.league_id in (76668,76670,76671,76672,76673) AND e.action<31 AND e.action=22 AND dt.id=672 GROUP BY e.player_id ORDER BY total DESC, e.player_id DESC LIMIT 50
24 10.6 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 = 2469 and d.year=2025 AND dp.id in (293489,168520,374921,192465,170198) GROUP BY d.playerId
25 3.1 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=2469 and rp.year=2025 and rp.player_id=dp.id WHERE e.league_id in (76668,76670,76671,76672,76673) AND e.action<31 AND e.action=2 AND dt.id=672 GROUP BY e.player_id ORDER BY total DESC, e.player_id DESC LIMIT 50
26 3.6 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 = 2469 and d.year=2025 AND dp.id in (480564,168520) GROUP BY d.playerId
27 1.1 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=2469 and rp.year=2025 and rp.player_id=dp.id WHERE e.league_id in (76668,76670,76671,76672,76673) AND e.action<31 AND e.action=15 AND dt.id=672 GROUP BY e.player_id ORDER BY total DESC, e.player_id DESC LIMIT 50
28 971 us 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 = 2469 and d.year=2025 AND dp.id in (170198) GROUP BY d.playerId
29 1 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=2469 and rp.year=2025 and rp.player_id=dp.id WHERE e.league_id in (76668,76670,76671,76672,76673) AND e.action<31 AND e.action=16 AND dt.id=672 GROUP BY e.player_id ORDER BY total DESC, e.player_id DESC LIMIT 50
30 893 us 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 = 2469 and d.year=2025 AND dp.id in (996558) GROUP BY d.playerId
31 802 us controllers/home.php

SELECT ct.location as cc,ct.id, ct.name as name,ct.id AS categotyId,ct.alias,ct.active_year,l.total_group,l.tables,l.current_round,l.group_code, l.year, l.id AS league_id, t.id AS team_id ,ct.ctype, ct.cat, l.table_suffix,t.conference,l.playoff,l.extraName FROM teams AS t INNER JOIN leagues AS l ON t.league_id=l.id INNER JOIN categories AS ct ON ct.id=l.categoryId WHERE t.teamId=672 AND l.year=2025 ORDER BY ct.active_year DESC, ct.troncal=1 DESC, ct.coefficient DESC, ct.id DESC, l.group_code ASC
32 2.3 ms controllers/home.php

SELECT position FROM tables2025 WHERE team=6648501 AND league_id=76670 AND round=26
33 288 us controllers/home.php

SELECT * FROM ( (SELECT c.shedule AS sheduleBBDD,c.minute as mminute,c.prorroga,c.finished,c.status, c.id,c.penaltis1,c.penaltis2,c.extra,rel.media_id, dt1.id AS t1_id, dt2.id AS t2_id,dt1.short_name as short_name1,dt2.short_name as short_name2, dt1.nameShow AS t1_name, dt2.nameShow AS t2_name,dt1.basealias as basealias1,dt2.basealias as basealias2, 0 AS numc, c.league_id, c.shedule AS shedule, IF(TIME(c.shedule)='00:00:00',1,0) AS no_hour, c.r1, c.r2,2025 as year, CONVERT_TZ(NOW(), 'Europe/Madrid', 'Europe/Madrid') AS cur_date , dt1.translate AS team1_translate, dt2.translate AS team2_translate, c.round,c.stadium as stadium_id,dt1.CountryCode as cc1, dt2.CountryCode as cc2,lea.playoff,lea.total_rounds FROM calendars2025 AS c INNER JOIN teams AS t1 ON c.team1=t1.id INNER JOIN teams AS t2 ON c.team2=t2.id INNER JOIN datateams AS dt1 ON t1.teamId=dt1.id INNER JOIN datateams AS dt2 ON t2.teamId=dt2.id LEFT JOIN rel_media_match rel ON rel.cid = c.id AND rel.year = 2025 LEFT JOIN leagues lea on lea.id=c.league_id WHERE t1.id IN (6648501,6645131,6667102) OR t2.id IN (6648501,6645131,6667102) GROUP BY c.id)) a ORDER BY league_id ASC, shedule ASC
34 3.4 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 RIGHT JOIN datastadiums AS ds ON ds.id = rs.stadium_id WHERE rs.teamId = 4657 AND rs.active = 1
35 1.3 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='387cbee66567b9dc5d3ceb743ec4aa75'
36 237 us 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 RIGHT JOIN datastadiums AS ds ON ds.id = rs.stadium_id WHERE rs.teamId = 10133 AND rs.active = 1
37 1.3 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 RIGHT JOIN datastadiums AS ds ON ds.id = rs.stadium_id WHERE rs.teamId = 427 AND rs.active = 1
38 1.3 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='387cbee66567b9dc5d3ceb743ec4aa75'
39 203 us 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 RIGHT JOIN datastadiums AS ds ON ds.id = rs.stadium_id WHERE rs.teamId = 2137 AND rs.active = 1
40 1.2 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='3165471793ef5bc01c33c8eee8de4aca'
41 197 us 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 RIGHT JOIN datastadiums AS ds ON ds.id = rs.stadium_id WHERE rs.teamId = 1578 AND rs.active = 1
42 1.2 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='3165471793ef5bc01c33c8eee8de4aca'
43 207 us controllers/home.php

SELECT rel.media_id, m.name, m.id as id FROM rel_media_match as rel INNER JOIN media AS m ON rel.media_id = m.id WHERE m.type=10 AND m.location='es' AND rel.cid = 68806 AND rel.year = 2025 AND rel.media_id < 90000 GROUP BY rel.media_id
44 461 us controllers/home.php

SELECT rel.media_id, m.name, m.id as id FROM rel_media_match as rel INNER JOIN media AS m ON rel.media_id = m.id WHERE m.type=10 AND m.location='es' AND rel.cid = 69222 AND rel.year = 2025 AND rel.media_id < 90000 GROUP BY rel.media_id
45 355 us 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 RIGHT JOIN datastadiums AS ds ON ds.id = rs.stadium_id WHERE rs.teamId = 2637 AND rs.active = 1
46 1.2 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='387cbee66567b9dc5d3ceb743ec4aa75'
47 194 us 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 RIGHT JOIN datastadiums AS ds ON ds.id = rs.stadium_id WHERE rs.teamId = 4823 AND rs.active = 1
48 1.2 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='3165471793ef5bc01c33c8eee8de4aca'
49 205 us 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 RIGHT JOIN datastadiums AS ds ON ds.id = rs.stadium_id WHERE rs.teamId = 225 AND rs.active = 1
50 1.1 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='3165471793ef5bc01c33c8eee8de4aca'
51 175 us 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 RIGHT JOIN datastadiums AS ds ON ds.id = rs.stadium_id WHERE rs.teamId = 2434 AND rs.active = 1
52 1.1 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='387cbee66567b9dc5d3ceb743ec4aa75'
53 201 us 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 RIGHT JOIN datastadiums AS ds ON ds.id = rs.stadium_id WHERE rs.teamId = 667 AND rs.active = 1
54 1.1 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='3165471793ef5bc01c33c8eee8de4aca'
55 161 us controllers/home.php

SELECT rel.media_id, m.name, m.id as id FROM rel_media_match as rel INNER JOIN media AS m ON rel.media_id = m.id WHERE m.type=10 AND m.location='es' AND rel.cid = 69469 AND rel.year = 2025 AND rel.media_id < 90000 GROUP BY rel.media_id
56 274 us 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 RIGHT JOIN datastadiums AS ds ON ds.id = rs.stadium_id WHERE rs.teamId = 4734 AND rs.active = 1
57 1.2 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='3165471793ef5bc01c33c8eee8de4aca'
58 166 us 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 RIGHT JOIN datastadiums AS ds ON ds.id = rs.stadium_id WHERE rs.teamId = 1216 AND rs.active = 1
59 1.1 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='387cbee66567b9dc5d3ceb743ec4aa75'
60 180 us 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 RIGHT JOIN datastadiums AS ds ON ds.id = rs.stadium_id WHERE rs.teamId = 958 AND rs.active = 1
61 1.1 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='387cbee66567b9dc5d3ceb743ec4aa75'
62 200 us 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 RIGHT JOIN datastadiums AS ds ON ds.id = rs.stadium_id WHERE rs.teamId = 2485 AND rs.active = 1
63 1.1 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='3165471793ef5bc01c33c8eee8de4aca'
64 209 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='a587736f77f430a8754d5bc5997f4c74'
65 208 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='36606e85840bb85db6521cd308082a21'
66 170 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='79b6ae4ce99e33b634a24499333a04bc'
67 177 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='6b8decc79ce0bf36a7baba7d3fa57e10'
68 168 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='71249081f8b767253cd8841324288b1c'
69 190 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='531a9e10f15396b097aa1513d4e89bd0'
70 140 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='d2db8a610f8c7c0785d2d92a6e8c450e'
71 136 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2469 or sonId=2469 LIMIT 1
72 122 us 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 = 2469 AND l.year=2025 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
73 276 us 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 = 76668 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
74 680 us controllers/home.php

SELECT team, position, round FROM futbol.tables2025 WHERE league_id=76668 AND round=25 ORDER BY team ASC;
75 186 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='4e385e8aec65064e7b6b8f7357785c15'
76 210 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='731f3222d5f00c116376fec2d09c3339'
77 193 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
78 148 us controllers/home.php

TOTAL TIME 112.4 ms QUERIES 76 FILE controllers/home.php