Connection to sql... 659 us

SELECT type FROM routes WHERE alias = 'southampton-sub23'
1 159 us config/routes_file.php

TOTAL TIME 61.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='southampton-sub23' LIMIT 1
2 61.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=102933 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
3 390 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=102933 AND role_id=2 ORDER BY rp.date_ini DESC LIMIT 1
4 374 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='f5a72a870eb34fb7354c70b3bbe9be64'
5 388 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 = 102933 AND active = 1
6 1.3 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 = 102933 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
7 600 us 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=102933 AND ct.ctype!=12 AND ct.status=1 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC
8 463 us 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=102933 and l.id=t.league_id WHERE 1 ORDER BY ct.coefficient DESC, ct.id ASC, l.group_code ASC
9 527 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 tables2022 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 = 63585 AND tab.round = 19 ORDER BY tab.points DESC, diff DESC, tab.ga DESC, dt.nameShow ASC
10 806 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=6456380 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC
11 506 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, 2024 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=2024 and rp.team_id=6456380 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC
12 468 us controllers/home.php

SELECT total FROM bs_rel_resume_items WHERE itemId=102933 AND type_rel=2 AND ln='es'
13 243 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 (102933) OR rb.destination_team_id IN (102933)) AND rb.year = 2025 AND rb.active = 1 LIMIT 1
14 798 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=102933 LIMIT 1
15 330 us controllers/home.php

SELECT player_id FROM rel_players rp WHERE rp.category_id=1978 and rp.year=2022 AND rp.in_squad=1 AND teamId=102933
16 1.2 ms controllers/home.php

SELECT id FROM leagues WHERE categoryId=1978 AND `year`=2022 ORDER BY id ASC
17 559 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 events2022 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=1978 and rp.year=2022 and rp.player_id=dp.id WHERE e.league_id in (63585,67501) AND e.action<31 AND (e.action IN (1,2,11,12,13,26)) AND dt.id=102933 GROUP BY e.player_id ORDER BY total DESC, e.player_id DESC LIMIT 50
18 1.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 = 1978 and d.year=2022 AND dp.id in (919214,428058,973835,47499,427888,919213,874514,924874,455605,849730,875703,833595,3215239,973833,3132634,754281,334208,3134194,3132632,857916,3134193,807154,356045,759660,369727,317505,833593,907212,753969,3134190,3134192,3132631,3210531,3233322,3245929,973834,3240732,3240733,3179380,973832,3249188,3185249,878206,920935,47891,3270457) GROUP BY d.playerId
19 12.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 events2022 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=1978 and rp.year=2022 and rp.player_id=dp.id WHERE e.league_id in (63585,67501) AND e.action<31 AND e.action=3 AND dt.id=102933 GROUP BY e.player_id ORDER BY total DESC, e.player_id DESC LIMIT 50
20 482 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 = 1978 and d.year=2022 AND dp.id in (849730,427888,334208) GROUP BY d.playerId
21 1.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 events2022 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=1978 and rp.year=2022 and rp.player_id=dp.id WHERE e.league_id in (63585,67501) AND e.action<31 AND e.action=4 AND dt.id=102933 GROUP BY e.player_id ORDER BY total DESC, e.player_id DESC LIMIT 50
22 480 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 events2022 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=1978 and rp.year=2022 and rp.player_id=dp.id WHERE e.league_id in (63585,67501) AND e.action<31 AND e.action=5 AND dt.id=102933 GROUP BY e.player_id ORDER BY total DESC, e.player_id DESC LIMIT 50
23 1.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 = 1978 and d.year=2022 AND dp.id in (919213,754279,923357,807154,477388,973835,833595,973833,874421,47499,3132632,907212,875703,875702,753969,427888,369727,356045) GROUP BY d.playerId
24 5.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 events2022 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=1978 and rp.year=2022 and rp.player_id=dp.id WHERE e.league_id in (63585,67501) AND e.action<31 AND e.action=22 AND dt.id=102933 GROUP BY e.player_id ORDER BY total DESC, e.player_id DESC LIMIT 50
25 9 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 = 1978 and d.year=2022 AND dp.id in (874421,919213,754279,3132634,907212,849730,3233322,923357,833593,753969,427888,356045) GROUP BY d.playerId
26 3.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 events2022 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=1978 and rp.year=2022 and rp.player_id=dp.id WHERE e.league_id in (63585,67501) AND e.action<31 AND e.action=2 AND dt.id=102933 GROUP BY e.player_id ORDER BY total DESC, e.player_id DESC LIMIT 50
27 3.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 = 1978 and d.year=2022 AND dp.id in (874421,369727) GROUP BY d.playerId
28 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 events2022 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=1978 and rp.year=2022 and rp.player_id=dp.id WHERE e.league_id in (63585,67501) AND e.action<31 AND e.action=15 AND dt.id=102933 GROUP BY e.player_id ORDER BY total DESC, e.player_id DESC LIMIT 50
29 716 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 events2022 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=1978 and rp.year=2022 and rp.player_id=dp.id WHERE e.league_id in (63585,67501) AND e.action<31 AND e.action=16 AND dt.id=102933 GROUP BY e.player_id ORDER BY total DESC, e.player_id DESC LIMIT 50
30 477 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=102933 AND l.year=2022 ORDER BY ct.active_year DESC, ct.troncal=1 DESC, ct.coefficient DESC, ct.id DESC, l.group_code ASC
31 1 ms controllers/home.php

SELECT position FROM tables2023 WHERE team=6456380 AND league_id=63585 AND round=19
32 242 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,2022 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 calendars2022 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 = 2022 LEFT JOIN leagues lea on lea.id=c.league_id WHERE t1.id IN (6456380) OR t2.id IN (6456380) GROUP BY c.id)) a ORDER BY league_id ASC, shedule ASC
33 1.4 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='f5a72a870eb34fb7354c70b3bbe9be64'
34 317 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='c1d14b5ea848b7c29b7e320304fb609a'
35 256 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 = 102933 AND rs.active = 1
36 1.2 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='9bd49a45f8935f38b8fa1be721ae3b28'
37 217 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='f5a72a870eb34fb7354c70b3bbe9be64'
38 240 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 = 141685 AND rs.active = 1
39 1.2 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='be12afbc69293a3792a1c07fa8266d1c'
40 184 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='f5a72a870eb34fb7354c70b3bbe9be64'
41 206 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 = 102929 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='6aba66de58aa6c4cec1ae42b4057dcf8'
43 193 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='f5a72a870eb34fb7354c70b3bbe9be64'
44 149 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 = 102928 AND rs.active = 1
45 1.1 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='f5a72a870eb34fb7354c70b3bbe9be64'
46 205 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='b72c30a80849b6e4e0804a1d201d393c'
47 190 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 = 102933 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='c8138c501b8fe309b3295dffed3fdc8e'
49 377 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='f5a72a870eb34fb7354c70b3bbe9be64'
50 249 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 = 102073 AND rs.active = 1
51 1.1 ms controllers/home.php

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

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='dbdacca8a71b3dabff08931c60e854bf'
53 158 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 = 102933 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='df5d2bbe280828501cb4241a493de4d9'
55 277 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='f5a72a870eb34fb7354c70b3bbe9be64'
56 145 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 = 91438 AND rs.active = 1
57 1.1 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='7c241c9fb654199f4de75fe6bffbd360'
58 155 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='f5a72a870eb34fb7354c70b3bbe9be64'
59 141 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 = 102932 AND rs.active = 1
60 1.1 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='f5a72a870eb34fb7354c70b3bbe9be64'
61 203 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='eb34610b8a560feac71a9271e2a21cfc'
62 213 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 = 102933 AND rs.active = 1
63 1.2 ms controllers/home.php

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

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='12677235aa122ac6a0b7d1741864da57'
65 226 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 = 102933 AND rs.active = 1
66 1.2 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='499e13125fb6efde88d5c0875c6181f7'
67 218 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='f5a72a870eb34fb7354c70b3bbe9be64'
68 176 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 = 102922 AND rs.active = 1
69 1.1 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='f5a72a870eb34fb7354c70b3bbe9be64'
70 151 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='8ccb6e579be542764e238571db218a1d'
71 193 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 = 102933 AND rs.active = 1
72 1.2 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='dbdacca8a71b3dabff08931c60e854bf'
73 151 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='f5a72a870eb34fb7354c70b3bbe9be64'
74 178 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 = 102934 AND rs.active = 1
75 1.1 ms controllers/home.php

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

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='f5a72a870eb34fb7354c70b3bbe9be64'
77 179 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 = 102931 AND rs.active = 1
78 1.1 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='f5a72a870eb34fb7354c70b3bbe9be64'
79 147 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='6aba66de58aa6c4cec1ae42b4057dcf8'
80 132 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 = 102933 AND rs.active = 1
81 1.1 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='f5a72a870eb34fb7354c70b3bbe9be64'
82 156 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='be12afbc69293a3792a1c07fa8266d1c'
83 160 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 = 102933 AND rs.active = 1
84 1.2 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='8ccb6e579be542764e238571db218a1d'
85 183 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='f5a72a870eb34fb7354c70b3bbe9be64'
86 198 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 = 91439 AND rs.active = 1
87 1.1 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='f5a72a870eb34fb7354c70b3bbe9be64'
88 205 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='c8138c501b8fe309b3295dffed3fdc8e'
89 199 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 = 102933 AND rs.active = 1
90 1.1 ms controllers/home.php

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

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='9bd49a45f8935f38b8fa1be721ae3b28'
92 212 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 = 102933 AND rs.active = 1
93 1.1 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='eb34610b8a560feac71a9271e2a21cfc'
94 156 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='f5a72a870eb34fb7354c70b3bbe9be64'
95 162 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 = 102925 AND rs.active = 1
96 1.1 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='f5a72a870eb34fb7354c70b3bbe9be64'
97 144 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='7c241c9fb654199f4de75fe6bffbd360'
98 142 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 = 102933 AND rs.active = 1
99 1 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='f5a72a870eb34fb7354c70b3bbe9be64'
100 145 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='df5d2bbe280828501cb4241a493de4d9'
101 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 = 102933 AND rs.active = 1
102 1.1 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='b72c30a80849b6e4e0804a1d201d393c'
103 151 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='f5a72a870eb34fb7354c70b3bbe9be64'
104 148 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 = 138383 AND rs.active = 1
105 1.1 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='12677235aa122ac6a0b7d1741864da57'
106 154 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='f5a72a870eb34fb7354c70b3bbe9be64'
107 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 = 102089 AND rs.active = 1
108 1.1 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='f5a72a870eb34fb7354c70b3bbe9be64'
109 151 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='499e13125fb6efde88d5c0875c6181f7'
110 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 = 102933 AND rs.active = 1
111 1.1 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=1978 or sonId=1978 LIMIT 1
112 123 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 = 1978 AND l.year=2022 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
113 277 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.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 = 63585 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
114 599 us controllers/home.php

SELECT team, position, round FROM futbol.tables2022 WHERE league_id=63585 AND round=18 ORDER BY team ASC;
115 172 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 63585 LIMIT 1
116 8.9 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='4e385e8aec65064e7b6b8f7357785c15'
117 180 us 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=153 AND l.year=2022 AND l.group_code='1' ORDER BY l.group_code, dt.nameShow ASC
118 21 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='a12b6be19f94a9b5fb0c88099cf31828'
119 177 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='33d2a3996b2399465a5529df88b2f631'
120 200 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='3aeaf66d65ec24ee36e9ce4bf9f7dad5'
121 159 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='467561a4122c47802ecbba7411dbf1e8'
122 206 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='373d470a77d3969f8172667f2835124f'
123 254 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='a9bdc7470ad65eebef904f4df0cd6d67'
124 225 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='3e2e5e9661666ac07a76cc1f6b1469a5'
125 211 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='13d4e0931a8de7e8e23411a24f39a10e'
126 231 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='a571c27980bfa9ea5487d121524a77b9'
127 224 us controllers/home.php

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

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='087190e668339d50251d5ec312b64b0b'
129 197 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='77a2f437304a9c5381d372da8259badd'
130 213 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='a272cd6fa96b1ade1e32502bfc4b5504'
131 201 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='12677235aa122ac6a0b7d1741864da57'
132 216 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='d440da69cb9e752ade62196008746e6a'
133 240 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='73101738da81e5cbb87b64cd400a4405'
134 220 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='7c374bfa2a876439da2ee72df3814430'
135 209 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='aff826d8953256b8bc301fad98741816'
136 211 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='79e760d35ca8df6e3f29c5971c1a6ad9'
137 205 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='c3b6397a703fc6ece5cc71635441101f'
138 189 us controllers/home.php

TOTAL TIME 127.7 ms QUERIES 136 FILE controllers/home.php