Connection to sql... 1.1 ms

SELECT c.*, c.stadium as real_stadium, 2025 AS year, dt1.id AS dteam1_id, dt1.nameShow as team1_name, dt1.basealias AS team1_basealias, dt1.fullName as team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow as team2_name, dt2.basealias AS team2_basealias, dt2.fullName as team2_fullName, dt2.color1 AS team2_color1, t1.name as team1_Oname, t2.name as team2_Oname, s.id as stadium_id, rs.teamId as stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2, l.categoryId FROM calendars2025 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN futbol.rel_stadiums as rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id INNER JOIN leagues AS l ON l.id = c.league_id AND dt1.basealias = 'Pontedera' AND dt2.basealias = 'Pescara-Calcio' ORDER BY c.shedule DESC
1 13.7 ms controllers/news.php

SELECT c.team1, c.team2, c.round, c.shedule, c.league_id, c.team1_name AS local_name, c.team2_name AS visitor_name, c.referee, c.datateam1, c.datateam2, cat.name AS competition_name FROM futbol.calendars2025 AS c INNER JOIN futbol.leagues AS l ON l.id = c.league_id INNER JOIN futbol.categories AS cat ON cat.id = l.categoryId WHERE c.id = 39992;
2 555 us controllers/news.php

SELECT c.id, c.league_id, c.date,c.rating1,c.rating2 FROM calendars_elo c WHERE c.id = 39992 AND c.year = 2025
3 529 us controllers/news.php

SELECT c.r1,c.r2, c.id, l.categoryId,c.shedule,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2, c.datateam1, c.datateam2, c.round, c.league_id FROM calendars2025 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 INNER JOIN leagues l ON l.id = c.league_id WHERE c.id = 39992
4 632 us controllers/news.php

SELECT id,r1,r2,expected,date FROM calendars_elo WHERE date >= '2025-03-11' - INTERVAL 1 YEAR AND date < '2025-03-11' AND datateam1 = 6910 AND r1 < 90 AND r2 < 90 ORDER BY date DESC LIMIT 20
5 1.3 ms controllers/news.php

SELECT id,r1,r2,expected,date FROM calendars_elo WHERE date >= '2025-03-11' - INTERVAL 1 YEAR AND date < '2025-03-11' AND datateam2 = 1956 AND r1 < 90 AND r2 < 90 ORDER BY date DESC LIMIT 20
6 1.9 ms controllers/news.php

SELECT c.id, c.shedule AS shedule, ct.ctype, ct.cat, l.id as league_id,l.current_table_round, l.playoff,c.team1,c.team2,l.year FROM calendars2025 AS c INNER JOIN leagues_besoccer AS l ON c.league_id = l.id INNER JOIN categories_besoccer AS ct ON ct.id = l.categoryId WHERE c.id = 39992
7 501 us controllers/news.php

SELECT c.id, c.datateam1, c.datateam2, c.team1, c.team2, c.r1, c.r2, c.round, c.year, c.shedule AS shedule, c.league_id, c.comments,dt.basealias as basealias1,dt2.basealias as basealias2,dt.CountryCode as cc1, dt2.CountryCode as cc2 FROM calendars_editor c INNER JOIN datateams dt on dt.id=c.datateam1 INNER JOIN datateams dt2 on dt2.id=c.datateam2 WHERE ((c.datateam1=6910 AND c.datateam2= 1956) OR (c.datateam1= 1956 AND c.datateam2=6910)) AND c.shedule < '2025-03-07 10:07:57' AND c.year >= 1991 AND c.r1 <98 AND c.r2<98 AND c.id!=39992 ORDER BY c.shedule DESC
8 974 us controllers/news.php

SELECT l.id AS league_id, ct.id AS category_id, ct.name as name, l.year, ct.coefficient, l.group_code, l.total_group, l.total_rounds, l.playoff, ct.logo FROM leagues_mobile AS l INNER JOIN categories_mobile AS ct ON l.categoryId=ct.id WHERE l.id IN (76624,75937,72300,63825)
9 520 us controllers/news.php

SELECT id, nameShow, translate AS team_translate, short_name, basealias FROM datateams WHERE id IN (1956,6910)
10 343 us controllers/news.php

SELECT id, year, shedule AS shedule FROM calendars_all WHERE datateam1=6910 AND shedule <'2025-03-07 10:07:57' AND r1 < 90 AND r2 < 90 ORDER BY shedule DESC LIMIT 5
11 668 us controllers/news.php

SELECT id, year, shedule AS shedule FROM calendars_all WHERE datateam2=6910 AND shedule <'2025-03-07 10:07:57' AND r1 < 90 AND r2 < 90 ORDER BY shedule DESC LIMIT 5
12 663 us controllers/news.php

SELECT id, year, shedule AS shedule FROM calendars_all WHERE datateam1= 1956 AND shedule <'2025-03-07 10:07:57' AND r1 < 90 AND r2 < 90 ORDER BY shedule DESC LIMIT 5
13 604 us controllers/news.php

SELECT id, year, shedule AS shedule FROM calendars_all WHERE datateam2= 1956 AND shedule <'2025-03-07 10:07:57' AND r1 < 90 AND r2 < 90 ORDER BY shedule DESC LIMIT 5
14 630 us controllers/news.php

SELECT c.id, c.datateam1, c.datateam2, c.team1, c.team2, c.r1, c.r2, c.round, c.shedule AS shedule, c.league_id, c.prorroga, c.penaltis1, c.penaltis2, c.status, c.minute, c.finished, c.comments,dt.basealias as basealias1,dt2.basealias as basealias2,dt.CountryCode as cc1, dt2.CountryCode as cc2 FROM calendars2025 c INNER JOIN datateams dt on dt.id=c.datateam1 INNER JOIN datateams dt2 on dt2.id=c.datateam2 WHERE c.id IN (39972,39961,39952,39936,39932,39916,39969,39955,39949,39934,39927,39920) ORDER BY c.shedule DESC
15 786 us controllers/news.php

SELECT l.id AS league_id, ct.id AS category_id, ct.name as name, l.year, ct.coefficient, l.group_code, l.total_group, l.total_rounds, l.playoff, ct.logo FROM leagues_mobile AS l INNER JOIN categories_mobile AS ct ON l.categoryId=ct.id WHERE l.id IN (76624)
16 484 us controllers/news.php

SELECT id, nameShow, translate AS team_translate, short_name, basealias FROM datateams WHERE id IN (1956,2376,6910,277,10744,163909,290,6387,6513,6503,90188,31,1954)
17 427 us controllers/news.php

SELECT id, year, datateam1 as datateamstreak, shedule AS shedule, r1, r2 FROM calendars_all WHERE datateam1=6910 AND shedule <'2025-03-07 10:07:57' AND r1 < 90 AND r2 < 90 AND year = 2025 ORDER BY shedule DESC
18 645 us controllers/news.php

SELECT id, year, datateam2 as datateamstreak, shedule AS shedule, r1, r2 FROM calendars_all WHERE datateam2=6910 AND shedule <'2025-03-07 10:07:57' AND r1 < 90 AND r2 < 90 AND year = 2025 ORDER BY shedule DESC
19 629 us controllers/news.php

SELECT id, year, datateam1 as datateamstreak, shedule AS shedule, r1, r2 FROM calendars_all WHERE datateam1= 1956 AND shedule <'2025-03-07 10:07:57' AND r1 < 90 AND r2 < 90 AND year = 2025 ORDER BY shedule DESC
20 675 us controllers/news.php

SELECT id, year, datateam2 as datateamstreak, shedule AS shedule, r1, r2 FROM calendars_all WHERE datateam2= 1956 AND shedule <'2025-03-07 10:07:57' AND r1 < 90 AND r2 < 90 AND year = 2025 ORDER BY shedule DESC
21 671 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 1 AND team = 6647526
22 395 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 1 AND team = 6647524
23 350 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 2 AND team = 6647526
24 401 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 2 AND team = 6647524
25 353 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 3 AND team = 6647526
26 300 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 3 AND team = 6647524
27 324 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 4 AND team = 6647526
28 308 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 4 AND team = 6647524
29 315 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 5 AND team = 6647526
30 285 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 5 AND team = 6647524
31 286 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 6 AND team = 6647526
32 292 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 6 AND team = 6647524
33 206 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 7 AND team = 6647526
34 196 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 7 AND team = 6647524
35 193 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 8 AND team = 6647526
36 191 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 8 AND team = 6647524
37 189 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 9 AND team = 6647526
38 288 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 9 AND team = 6647524
39 288 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 10 AND team = 6647526
40 208 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 10 AND team = 6647524
41 198 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 11 AND team = 6647526
42 193 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 11 AND team = 6647524
43 212 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 12 AND team = 6647526
44 204 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 12 AND team = 6647524
45 188 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 13 AND team = 6647526
46 193 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 13 AND team = 6647524
47 190 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 14 AND team = 6647526
48 190 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 14 AND team = 6647524
49 189 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 15 AND team = 6647526
50 189 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 15 AND team = 6647524
51 190 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 16 AND team = 6647526
52 216 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 16 AND team = 6647524
53 192 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 17 AND team = 6647526
54 193 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 17 AND team = 6647524
55 203 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 18 AND team = 6647526
56 164 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 18 AND team = 6647524
57 194 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 19 AND team = 6647526
58 180 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 19 AND team = 6647524
59 204 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 20 AND team = 6647526
60 234 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 20 AND team = 6647524
61 249 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 21 AND team = 6647526
62 242 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 21 AND team = 6647524
63 242 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 22 AND team = 6647526
64 178 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 22 AND team = 6647524
65 207 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 23 AND team = 6647526
66 167 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 23 AND team = 6647524
67 241 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 24 AND team = 6647526
68 167 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 24 AND team = 6647524
69 209 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 25 AND team = 6647526
70 164 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 25 AND team = 6647524
71 218 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 26 AND team = 6647526
72 162 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 26 AND team = 6647524
73 219 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 27 AND team = 6647526
74 188 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 27 AND team = 6647524
75 244 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 28 AND team = 6647526
76 279 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 28 AND team = 6647524
77 224 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 29 AND team = 6647526
78 217 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 29 AND team = 6647524
79 224 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 30 AND team = 6647526
80 183 us controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76624 AND round = 30 AND team = 6647524
81 226 us controllers/news.php

SELECT c.r1, c.r2, c.team1_name, c.team2_name, c.datateam1, c.datateam2, c.shedule FROM futbol.calendars2025 AS c WHERE c.r1 < 98 AND (datateam1 = 6910 OR datateam2 = 6910) ORDER BY c.shedule DESC LIMIT 12;
82 447 us controllers/news.php

SELECT c.r1, c.r2, c.team1_name, c.team2_name, c.datateam1, c.datateam2, c.shedule FROM futbol.calendars2025 AS c WHERE c.r1 < 98 AND (datateam1 = 1956 OR datateam2 = 1956) ORDER BY c.shedule DESC LIMIT 12;
83 446 us controllers/news.php

SELECT team.teamId, t.points, t.gf, t.ga, t.win_h, t.draw_h, t.lose_h, t.win_a, t.draw_a, t.lose_a, t.position, dt.short_name FROM futbol.tables2025 AS t INNER JOIN futbol.teams AS team ON t.team = team.id INNER JOIN futbol.datateams AS dt ON dt.id = team.teamId WHERE t.team IN (6647526, 6647524) AND t.league_id = 76624 AND t.round = 31;
84 477 us controllers/news.php

SELECT l.game,c.id,c.shedule AS sheduleBBDD, cat.name AS league_name,c.isLive, cat.alias, cat.id AS category_id, cat.logo, cat.cat, cat.level, cat.ctype, l.year, l.current_round,cat.active_year,c.datateam1,c.datateam2,c.round, c.extra_data, c.stadium AS stadium_id, CONVERT_TZ(c.shedule, 'Europe/Madrid', 'Europe/Madrid') AS shedule,CONVERT_TZ(c.shedule, 'Europe/Madrid', 'Europe/Madrid') AS sheduleb, CONVERT_TZ(NOW(), 'Europe/Madrid', 'Europe/Madrid') AS cur_date, dt1.seats, c.referee, c.league_id,c.attendance, c.team1, c.team2, c.r1, c.r2, l.group_code,l.total_group, c.last_comment, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.finished, c.minute, c.isDpstats, l.total_rounds, dt1.nameShow AS nameShow1, dt2.nameShow AS nameShow2, dt1.id AS dt1id, dt2.id AS dt2id, dt1.translate AS translate1, dt2.translate AS translate2, dt1.stadium, dt1.twitter AS team1_twitter, dt2.twitter AS team2_twitter, dt1.short_name AS local_abbr, dt2.short_name AS visitor_abbr,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.chairman as chairman1,dt2.chairman as chairman2,dt1.typefield,dt1.seats,dt1.fans,dt1.yearBuilt,dt1.fax,dt1.phone,dt1.address,dt1.size, c.betId, c.betId_wh, c.betId_bwin, c.betId_marca, 0 AS comments, IF(TIME(c.shedule)='00:00:00',1,0) AS no_hour , c.weather, c.temperature, dp1.nick as local_coach, dp2.nick as visitor_coach, cat.alerts_available AS alerts_available, c.isVideo, c.isLineup, c.acta, c.csb, cat.top, dt1.CountryCode as cc1, dt2.CountryCode as cc2 FROM calendars2025 c INNER JOIN leagues l ON l.id = c.league_id INNER JOIN categories cat ON cat.id = l.categoryId INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams_basics dtb1 ON dt1.id = dtb1.id INNER JOIN datateams dt2 ON dt2.id = c.datateam2 INNER JOIN datateams_basics dtb2 ON dt2.id = dtb2.id LEFT JOIN datapeople AS dp1 ON c.coach1 = dp1.id LEFT JOIN datapeople AS dp2 ON c.coach2 = dp2.id WHERE c.id = 39992
85 763 us controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e34ebc2143fce3bf838c9d9091521114'
86 639 us controllers/news.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 = 6910 AND active = 1
87 2 ms controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='2bd8ab451a35759c5737128e35c8011a'
88 255 us controllers/news.php

SELECT data1 FROM stats2025 t WHERE league_id = 76624 AND teamId = 6647526 AND type = 33 ORDER BY groupId ASC, type
89 139 us controllers/news.php

SELECT data1 FROM stats2025 t WHERE league_id = 76624 AND teamId = 6647524 AND type = 33 ORDER BY groupId ASC, type
90 156 us controllers/news.php

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

SELECT * FROM calendars2025_times WHERE id = 39992
92 198 us controllers/news.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=6647526 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC
93 1.4 ms controllers/news.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=6647524 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC
94 1.2 ms controllers/news.php

SELECT type, data1, data2, data3, data4 FROM stats2025 WHERE league_id=76624 AND teamId=6647526 AND ((type>=1 AND type<=9) OR (type>=29 AND type<=32)) ORDER BY type ASC
95 174 us controllers/news.php

SELECT type, data1, data2, data3, data4 FROM stats2025 WHERE league_id=76624 AND teamId=6647524 AND ((type>=1 AND type<=9) OR (type>=29 AND type<=32)) ORDER BY type ASC
96 149 us controllers/news.php

SELECT round, team1, team2, extra_data, r1, r2 FROM calendars2025 WHERE league_id=76624 AND extra_data IS NOT NULL AND (team1=6647526 OR team2=6647526) ORDER BY round ASC
97 459 us controllers/news.php

SELECT round, team1, team2, extra_data, r1, r2 FROM calendars2025 WHERE league_id=76624 AND extra_data IS NOT NULL AND (team1=6647524 OR team2=6647524) ORDER BY round ASC
98 487 us controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='a39186b6a4106dea8024028c16b70ae6'
99 233 us controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='cfdbcc33fe4236534bfcf4b1cb55d8ed'
100 200 us controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='d25ea7259e1c989a118a00450fe74ae7'
101 190 us controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='aeccc29e9af073cb8018173cdb889fb3'
102 188 us controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='331715d18c12d88e52ca894ec0905117'
103 188 us controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='ec7263db79b0039a12705ba90208f30e'
104 179 us controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='3568bd1a163ab39ff9eee47b2f6bf12e'
105 182 us controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e4d54b76d3b91c936d0c520f5afa488c'
106 184 us controllers/news.php

SELECT dt.id,dt.nameShow,dt.translate,dt.basealias, t.points, t.gf, t.ga, t.win_h+t.win_a as wins, t.draw_h+t.draw_a as draws, t.lose_h+t.lose_a as loses, (t.win_h+t.win_a+t.draw_h+t.draw_a+t.lose_h+t.lose_a) AS mp,(cast(t.gf as signed) - cast(t.ga as signed)) AS diff,team.teamId FROM tables2025 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id WHERE t.league_id = 76624 AND t.round = 31 ORDER BY t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
107 639 us controllers/news.php

SELECT t.team,t.round,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff FROM tables2025 AS t WHERE t.league_id = 76624 AND t.round<=31 ORDER BY t.round ASC,t.points DESC, diff DESC, t.ga DESC
108 1.4 ms controllers/news.php

SELECT dr.id, dr.fullname as name, dr.nick as showName,rc.role, dr.birthdate,dr.birthplace FROM rel_calendars_referee rc LEFT JOIN datapeople dr ON dr.id=rc.referee_id WHERE rc.match_id=39992 AND rc.year=2025
109 175 us controllers/news.php

SELECT ev.id, ev.player_id, ev.action, ev.minute, ev.teamId, date, period FROM events2025 AS ev WHERE ev.match_id=39992 AND ev.action<31 ORDER BY ev.minute ASC, ev.date ASC, ev.id ASC
110 201 us controllers/news.php

SELECT id, team_id, tactica AS tactic FROM dreamteam_data_real WHERE league_id = 76624 AND id_match = 39992
111 311 us controllers/news.php

SELECT c.id, c.r1, c.r2, c.shedule, l.year FROM calendars_all AS c INNER JOIN futbol.leagues AS l ON c.league_id=l.id INNER JOIN teams AS t1 ON c.team1=t1.id INNER JOIN teams AS t2 ON c.team2=t2.id WHERE l.categoryId=90 AND t1.teamId=6910 AND t2.teamId=1956 AND r1 < 99 AND c.shedule < NOW() - INTERVAL 1 DAY ORDER BY c.shedule DESC LIMIT 10
112 1.5 ms controllers/news.php

SELECT * FROM forecast WHERE matchId = 39992 AND year = 2025
113 184 us controllers/news.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.id=6910 LIMIT 1
114 61.9 ms controllers/news.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=6910 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
115 501 us controllers/news.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=6910 AND role_id=2 ORDER BY rp.date_ini DESC LIMIT 1
116 413 us controllers/news.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 = 6910 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
117 1.4 ms controllers/news.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=6910 AND ct.ctype!=12 AND ct.status=1 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC
118 804 us controllers/news.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=6910 and l.id=t.league_id WHERE ct.id IN (90,1668) ORDER BY ct.coefficient DESC, ct.id ASC, l.group_code ASC
119 864 us controllers/news.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 = 76624 AND tab.round = 30 ORDER BY tab.points DESC, diff DESC, tab.ga DESC, dt.nameShow ASC
120 1.1 ms controllers/news.php

SELECT total FROM bs_rel_resume_items WHERE itemId=6910 AND type_rel=2 AND ln='es'
121 293 us controllers/news.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 (6910) OR rb.destination_team_id IN (6910)) AND rb.year = 2025 AND rb.active = 1 LIMIT 1
122 1.2 ms controllers/news.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=6910 LIMIT 1
123 279 us controllers/news.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.id=1956 LIMIT 1
124 74.3 ms controllers/news.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=1956 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
125 360 us controllers/news.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 = 1956 AND active = 1
126 1.3 ms controllers/news.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 = 1956 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
127 1.4 ms controllers/news.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=1956 AND ct.ctype!=12 AND ct.status=1 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC
128 1.1 ms controllers/news.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=1956 and l.id=t.league_id WHERE ct.id IN (90,1668) ORDER BY ct.coefficient DESC, ct.id ASC, l.group_code ASC
129 976 us controllers/news.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 = 76624 AND tab.round = 30 ORDER BY tab.points DESC, diff DESC, tab.ga DESC, dt.nameShow ASC
130 789 us controllers/news.php

SELECT total FROM bs_rel_resume_items WHERE itemId=1956 AND type_rel=2 AND ln='es'
131 276 us controllers/news.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 (1956) OR rb.destination_team_id IN (1956)) AND rb.year = 2025 AND rb.active = 1 LIMIT 1
132 793 us controllers/news.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=1956 LIMIT 1
133 282 us controllers/news.php

SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 76624
134 804 us controllers/news.php

SELECT SQL_NO_CACHE ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2025 AS ev WHERE ev.match_id=39992 ORDER BY (ev.action=1 OR ev.action=2 OR ev.action=6 OR ev.action=11 OR ev.action=12 OR ev.action=13 OR ev.action=25) DESC,(ev.action=3 OR ev.action=4 OR ev.action=5) DESC,(ev.action=14 OR ev.action=15 OR ev.action=16 OR ev.action=17 OR ev.action=21) DESC,(ev.action=18 OR ev.action=19) DESC,(ev.action=20 OR ev.action=22) DESC, minute ASC, ev.real_date ASC, ev.id DESC, ev.action DESC
135 262 us controllers/news.php

SELECT SQL_NO_CACHE ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2025 AS ev WHERE ev.match_id=39992 ORDER BY ev.minute ASC, ev.real_date ASC, ev.id DESC
136 244 us controllers/news.php

SELECT data1 FROM stats2025 t WHERE league_id = 76624 AND teamId = 6647526 and type = 33
137 199 us controllers/news.php

SELECT data1 FROM stats2025 t WHERE league_id = 76624 AND teamId = 6647524 and type = 33
138 139 us controllers/news.php

SELECT rating1, rating2 FROM calendars_elo WHERE id=39992 AND league_id=76624 AND year=2025
139 201 us controllers/news.php

SELECT position FROM tables2025 WHERE team=6647526 AND league_id=76624 AND round=31
140 158 us controllers/news.php

SELECT position FROM tables2025 WHERE team=6647524 AND league_id=76624 AND round=31
141 161 us controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='a587736f77f430a8754d5bc5997f4c74'
142 224 us controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='36606e85840bb85db6521cd308082a21'
143 204 us controllers/news.php

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

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='6b8decc79ce0bf36a7baba7d3fa57e10'
145 169 us controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='71249081f8b767253cd8841324288b1c'
146 133 us controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='531a9e10f15396b097aa1513d4e89bd0'
147 124 us controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e34ebc2143fce3bf838c9d9091521114'
148 171 us controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='2bd8ab451a35759c5737128e35c8011a'
149 209 us controllers/news.php

SELECT data1 FROM stats2025 t WHERE league_id = 76624 AND teamId = 6647526 AND type = 33 ORDER BY groupId ASC, type
150 107 us controllers/news.php

SELECT data1 FROM stats2025 t WHERE league_id = 76624 AND teamId = 6647524 AND type = 33 ORDER BY groupId ASC, type
151 91 us controllers/news.php

SELECT * FROM calendars2025_times WHERE id = 39992
152 190 us controllers/news.php

SELECT type, data1, data2, data3, data4 FROM stats2025 WHERE league_id=76624 AND teamId=6647526 AND ((type>=1 AND type<=9) OR (type>=29 AND type<=32)) ORDER BY type ASC
153 137 us controllers/news.php

SELECT type, data1, data2, data3, data4 FROM stats2025 WHERE league_id=76624 AND teamId=6647524 AND ((type>=1 AND type<=9) OR (type>=29 AND type<=32)) ORDER BY type ASC
154 156 us controllers/news.php

SELECT dr.id, dr.fullname as name, dr.nick as showName,rc.role, dr.birthdate,dr.birthplace FROM rel_calendars_referee rc LEFT JOIN datapeople dr ON dr.id=rc.referee_id WHERE rc.match_id=39992 AND rc.year=2025
155 182 us controllers/news.php

SELECT ev.id, ev.player_id, ev.action, ev.minute, ev.teamId, date, period FROM events2025 AS ev WHERE ev.match_id=39992 AND ev.action<31 ORDER BY ev.minute ASC, ev.date ASC, ev.id ASC
156 248 us controllers/news.php

SELECT id, team_id, tactica AS tactic FROM dreamteam_data_real WHERE league_id = 76624 AND id_match = 39992
157 314 us controllers/news.php

SELECT * FROM forecast WHERE matchId = 39992 AND year = 2025
158 167 us controllers/news.php

SELECT *,rel.id as rel_id FROM `rel_media_match` rel LEFT JOIN media m ON m.id = rel.media_id WHERE m.type='10' AND rel.active = 1 AND rel.league_id = 76624 AND rel.team1 = 6647526 AND rel.team2 = 6647524 ORDER BY FIELD(m.location,'es','en') DESC
159 837 us controllers/news.php

SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 76624 AND id_match = 39992
160 249 us controllers/news.php

SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='76624' AND relp.team_id=6647526 WHERE mp.`match_id` = '39992' AND mp.year='2025' ORDER BY mp.`team` ASC, p.`role` ASC
161 6.8 ms controllers/news.php

SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='76624' AND relp.team_id=6647524 WHERE mp.`match_id` = '39992' AND mp.year='2025' ORDER BY mp.`team` ASC, p.`role` ASC
162 9.1 ms controllers/news.php

SELECT rl.* FROM futbol.rel_live_commentaries AS rl WHERE rl.match_id = 39992 AND rl.year = 2025 AND rl.active = 1 AND rl.ln = 'es';
163 185 us controllers/news.php

SELECT * FROM futbol.live_commentaries2025 WHERE match_id = 39992 AND ln = 'es' AND type = 1 AND owner = '1' ORDER BY minute DESC, creation_date DESC, id DESC;
164 280 us controllers/news.php

SELECT * FROM futbol.live_commentaries2025 WHERE match_id = 39992 AND ln = 'es' AND type = 1 AND owner = 1 ORDER BY minute DESC, extra_minute DESC, creation_date DESC, id DESC;
165 197 us controllers/news.php

SELECT * FROM calendars2025 AS c WHERE c.id=39992
166 197 us controllers/news.php

SELECT * FROM events2025 AS e WHERE e.match_id=39992 ORDER BY minute DESC
167 161 us controllers/news.php

SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=39992 AND extraId = 76624 AND type_rel = 4
168 135 us controllers/news.php

SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=90 AND type_rel = 3
169 160 us controllers/news.php

SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2, c.shedule,c.id, c.r1, c.r2, c.round, c.minute, c.status, c.penaltis1, c.penaltis2, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.comments,c.league_id FROM `calendars2025` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 76624 AND c.`round` = 31 ORDER BY shedule ASC LIMIT 12
170 733 us controllers/news.php

SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2025` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 76624 AND t.round = 31 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
171 693 us controllers/news.php

SELECT t.points,t.team,t.round FROM `tables2025` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 76624 AND t.round >= 15 AND t.round <= 30 ORDER BY t.round ASC, t.points DESC, t.ga DESC, dt.nameShow ASC
172 3.6 ms controllers/news.php

SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 76624 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
173 423 us controllers/news.php

TOTAL TIME 237 ms QUERIES 173 FILE controllers/news.php