Connection to sql... 9.2 ms

SELECT c.*, c.stadium as real_stadium, 2023 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 calendars2023 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 = 'Real-Potosi' AND dt2.basealias = 'Ciudad-Nueva-Santa-Cruz-Fc' ORDER BY c.shedule DESC
1 10.5 ms 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 calendars2023 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 = 901489
2 2.3 ms controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='212a0488abf6c0d52971d8e90bf314f9'
3 2 ms 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 = 2116 AND active = 1
4 3.1 ms controllers/news.php

SELECT data1 FROM stats2023 t WHERE league_id = 74455 AND teamId = 6617609 AND type = 33 ORDER BY groupId ASC, type
5 1.8 ms controllers/news.php

SELECT data1 FROM stats2023 t WHERE league_id = 74455 AND teamId = 6617611 AND type = 33 ORDER BY groupId ASC, type
6 1.8 ms 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 = 901489 AND rel.year = 2023 AND rel.media_id < 90000 AND m.location='es' GROUP BY rel.media_id
7 2.2 ms controllers/news.php

SELECT * FROM calendars2023_times WHERE id = 901489
8 1.9 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, 2023 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=2023 and rp.team_id=6617609 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC
9 3.7 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, 2023 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=2023 and rp.team_id=6617611 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC
10 3.4 ms controllers/news.php

SELECT type, data1, data2, data3, data4 FROM stats2023 WHERE league_id=74455 AND teamId=6617609 AND ((type>=1 AND type<=9) OR (type>=29 AND type<=32)) ORDER BY type ASC
11 1.9 ms controllers/news.php

SELECT type, data1, data2, data3, data4 FROM stats2023 WHERE league_id=74455 AND teamId=6617611 AND ((type>=1 AND type<=9) OR (type>=29 AND type<=32)) ORDER BY type ASC
12 1.8 ms controllers/news.php

SELECT round, team1, team2, extra_data, r1, r2 FROM calendars2023 WHERE league_id=74455 AND extra_data IS NOT NULL AND (team1=6617609 OR team2=6617609) ORDER BY round ASC
13 2.1 ms controllers/news.php

SELECT round, team1, team2, extra_data, r1, r2 FROM calendars2023 WHERE league_id=74455 AND extra_data IS NOT NULL AND (team1=6617611 OR team2=6617611) ORDER BY round ASC
14 2 ms controllers/news.php

SELECT t.team,t.round,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff FROM tables2024 AS t WHERE t.league_id = 74455 AND t.round<=2 ORDER BY t.round ASC,t.points DESC, diff DESC, t.ga DESC
15 1.9 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=901489 AND rc.year=2023
16 2 ms controllers/news.php

SELECT ev.id, ev.player_id, ev.action, ev.minute, ev.teamId, date, period FROM events2023 AS ev WHERE ev.match_id=901489 AND ev.action<31 ORDER BY ev.minute ASC, ev.date ASC, ev.id ASC
17 2.1 ms controllers/news.php

SELECT dp.id AS player_id, dp.nick AS player_name, dp.alias, rp.team_id FROM dataplayers AS dp INNER JOIN rel_players AS rp ON dp.id=rp.player_id AND league_id=74455 WHERE dp.id IN (100651,135210,213475,233816,246164,277238,322058,393004,668288,922567,3220436,3222494,3429868,3429921,3429927,3430342,3430345,3499056,3500681) AND (rp.team_id=6617609 OR rp.team_id=6617611)
18 2.9 ms controllers/news.php

SELECT id, team_id, tactica AS tactic FROM dreamteam_data_real WHERE league_id = 74455 AND id_match = 901489
19 2.1 ms controllers/news.php

SELECT relp.squadNumber as num, rel.pos, dp.id AS idplayer, dp.nick, dp.name, dp.last_name, dp.role,dp.alias,relp.year FROM rel_dreamteam_real rel INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id = 74455 AND relp.team_id = 6617609 WHERE rel.team_number = 5079203 ORDER BY pos ASC
20 2.7 ms controllers/news.php

SELECT relp.squadNumber as num, rel.pos, dp.id AS idplayer, dp.nick, dp.name, dp.last_name, dp.role,dp.alias,relp.year FROM rel_dreamteam_real rel INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id = 74455 AND relp.team_id = 6617611 WHERE rel.team_number = 5079205 ORDER BY pos ASC
21 3.2 ms 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=1598 AND t1.teamId=2116 AND t2.teamId=144287 AND r1 < 99 AND c.shedule < NOW() - INTERVAL 1 DAY ORDER BY c.shedule DESC LIMIT 10
22 2.5 ms controllers/news.php

SELECT * FROM forecast WHERE matchId = 901489 AND year = 2023
23 1.9 ms 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=2116 LIMIT 1
24 86.7 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=2116 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
25 2.1 ms 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=2116 AND role_id=2 ORDER BY rp.date_ini DESC LIMIT 1
26 2 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 = 2116 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
27 3.1 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=2116 AND ct.ctype!=12 AND ct.status=1 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC
28 3.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=2116 and l.id=t.league_id WHERE ct.id IN (1598) ORDER BY ct.coefficient DESC, ct.id ASC, l.group_code ASC
29 2.5 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=6669696 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC
30 2.1 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, 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=6669696 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC
31 2.2 ms controllers/news.php

SELECT total FROM bs_rel_resume_items WHERE itemId=2116 AND type_rel=2 AND ln='es'
32 1.9 ms 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 (2116) OR rb.destination_team_id IN (2116)) AND rb.year = 2025 AND rb.active = 1 LIMIT 1
33 2.3 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=2116 LIMIT 1
34 1.9 ms 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=144287 LIMIT 1
35 79.7 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=144287 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
36 1.9 ms 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=144287 AND role_id=2 ORDER BY rp.date_ini DESC LIMIT 1
37 1.9 ms 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 = 144287 AND active = 1
38 3.8 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 = 144287 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
39 2.2 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=144287 AND ct.ctype!=12 AND ct.status=1 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC
40 2.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=144287 and l.id=t.league_id WHERE ct.id IN (1598) ORDER BY ct.coefficient DESC, ct.id ASC, l.group_code ASC
41 2.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=6669692 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC
42 2.7 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, 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=6669692 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC
43 2.2 ms controllers/news.php

SELECT total FROM bs_rel_resume_items WHERE itemId=144287 AND type_rel=2 AND ln='es'
44 1.8 ms 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 (144287) OR rb.destination_team_id IN (144287)) AND rb.year = 2025 AND rb.active = 1 LIMIT 1
45 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=144287 LIMIT 1
46 1.9 ms 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 = 74455
47 4 ms 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 events2023 AS ev WHERE ev.match_id=901489 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
48 2.1 ms controllers/news.php

SELECT dp.id AS player_id, dp.nick, dp.alias, dp.name, dp.last_name, rp.team_id, rp.teamId, rp.squadNumber AS num FROM dataplayers AS dp INNER JOIN rel_players AS rp ON dp.id=rp.player_id AND league_id=74455 WHERE dp.id IN (135210,277238,213475,3222494,3429927,246164,922567,3429921,668288,3499056,3429868,322058,393004,3220436,3430342,3500681,3430345,233816,100651) AND (rp.team_id=6617609 OR rp.team_id=6617611)
49 3 ms 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 events2023 AS ev WHERE ev.match_id=901489 ORDER BY ev.minute ASC, ev.real_date ASC, ev.id DESC
50 2 ms controllers/news.php

SELECT dp.id AS player_id, dp.nick, dp.alias, dp.name, dp.last_name, rp.team_id, rp.teamId, rp.squadNumber AS num FROM dataplayers AS dp INNER JOIN rel_players AS rp ON dp.id=rp.player_id AND league_id=74455 WHERE dp.id IN (213475,322058,393004,3220436,3430342,3222494,3500681,3430345,3429927,922567,233816,246164,100651,3429921,668288,135210,3499056,3429868,277238) AND (rp.team_id=6617609 OR rp.team_id=6617611)
51 2.7 ms controllers/news.php

SELECT data1 FROM stats2023 t WHERE league_id = 74455 AND teamId = 6617609 and type = 33
52 1.8 ms controllers/news.php

SELECT data1 FROM stats2023 t WHERE league_id = 74455 AND teamId = 6617611 and type = 33
53 1.8 ms controllers/news.php

SELECT rating1, rating2 FROM calendars_elo WHERE id=901489 AND league_id=74455 AND year=2023
54 1.9 ms controllers/news.php

SELECT position FROM tables2023 WHERE team=6617609 AND league_id=74455 AND round=2
55 1.9 ms controllers/news.php

SELECT position FROM tables2023 WHERE team=6617611 AND league_id=74455 AND round=2
56 1.8 ms controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='aa15457d671c87e3ebd6367a0ed022b9'
57 2 ms controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='36606e85840bb85db6521cd308082a21'
58 1.9 ms controllers/news.php

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

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='6b8decc79ce0bf36a7baba7d3fa57e10'
60 1.9 ms controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='c04d94cfa036529812da2a3a9dffc408'
61 1.9 ms controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='531a9e10f15396b097aa1513d4e89bd0'
62 1.9 ms controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='212a0488abf6c0d52971d8e90bf314f9'
63 2 ms controllers/news.php

SELECT data1 FROM stats2023 t WHERE league_id = 74455 AND teamId = 6617609 AND type = 33 ORDER BY groupId ASC, type
64 1.8 ms controllers/news.php

SELECT data1 FROM stats2023 t WHERE league_id = 74455 AND teamId = 6617611 AND type = 33 ORDER BY groupId ASC, type
65 1.8 ms controllers/news.php

SELECT * FROM calendars2023_times WHERE id = 901489
66 1.8 ms controllers/news.php

SELECT type, data1, data2, data3, data4 FROM stats2023 WHERE league_id=74455 AND teamId=6617609 AND ((type>=1 AND type<=9) OR (type>=29 AND type<=32)) ORDER BY type ASC
67 1.9 ms controllers/news.php

SELECT type, data1, data2, data3, data4 FROM stats2023 WHERE league_id=74455 AND teamId=6617611 AND ((type>=1 AND type<=9) OR (type>=29 AND type<=32)) ORDER BY type ASC
68 1.9 ms controllers/news.php

SELECT t.team,t.round,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff FROM tables2024 AS t WHERE t.league_id = 74455 AND t.round<=2 ORDER BY t.round ASC,t.points DESC, diff DESC, t.ga DESC
69 2 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=901489 AND rc.year=2023
70 2 ms controllers/news.php

SELECT * FROM forecast WHERE matchId = 901489 AND year = 2023
71 1.9 ms 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 = 74455 AND rel.team1 = 6617609 AND rel.team2 = 6617611 ORDER BY FIELD(m.location,'es','en') DESC
72 2.3 ms controllers/news.php

SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 74455 AND id_match = 901489
73 2.1 ms controllers/news.php

SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='74455' AND relp.team_id = drea.team_id WHERE rel.team_number=5079203 GROUP BY dp.id ORDER BY role ASC, pos ASC
74 2.7 ms controllers/news.php

SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='74455' AND relp.team_id = drea.team_id WHERE rel.team_number=5079205 GROUP BY dp.id ORDER BY role ASC, pos ASC
75 2.9 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='74455' AND relp.team_id=6617609 WHERE mp.`match_id` = '901489' AND mp.year='2023' AND p.id NOT IN (135210,3220436,277238,233816,817349,391915,3139478,3500681,3502344,3222494,233867,100653,380734,3429868,381593,3429921,322058,3499056,3429928,246164,3429927,668288) ORDER BY mp.`team` ASC, p.`role` ASC
76 4.4 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='74455' AND relp.team_id=6617611 WHERE mp.`match_id` = '901489' AND mp.year='2023' AND p.id NOT IN (135210,3220436,277238,233816,817349,391915,3139478,3500681,3502344,3222494,233867,100653,380734,3429868,381593,3429921,322058,3499056,3429928,246164,3429927,668288) ORDER BY mp.`team` ASC, p.`role` ASC
77 3.4 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='74455' AND relp.team_id=6617609 WHERE mp.`match_id` = '901489' AND mp.year='2023' ORDER BY mp.`team` ASC, p.`role` ASC
78 3.5 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='74455' AND relp.team_id=6617611 WHERE mp.`match_id` = '901489' AND mp.year='2023' ORDER BY mp.`team` ASC, p.`role` ASC
79 3.4 ms controllers/news.php

SELECT rl.* FROM futbol.rel_live_commentaries AS rl WHERE rl.match_id = 901489 AND rl.year = 2023 AND rl.active = 1 AND rl.ln = 'es';
80 1.9 ms controllers/news.php

SELECT * FROM futbol.live_commentaries2023 WHERE match_id = 901489 AND ln = 'es' AND type = 1 AND owner = '1' ORDER BY minute DESC, creation_date DESC, id DESC;
81 2 ms controllers/news.php

SELECT * FROM futbol.live_commentaries2023 WHERE match_id = 901489 AND ln = 'es' AND type = 1 AND owner = 1 ORDER BY minute DESC, extra_minute DESC, creation_date DESC, id DESC;
82 2 ms controllers/news.php

SELECT * FROM calendars2023 AS c WHERE c.id=901489
83 2 ms controllers/news.php

SELECT * FROM events2023 AS e WHERE e.match_id=901489 ORDER BY minute DESC
84 2 ms controllers/news.php

SELECT * FROM events
85 1.9 ms controllers/news.php

SELECT dp.id AS player_id, dp.nick AS player_name FROM dataplayers AS dp WHERE dp.id IN (3429868,277238,3429927,213475,135210,3499056,668288,3429921,100651,246164,922567,233816,3222494,3500681,3430345,3220436,3430342,322058,393004)
86 2.3 ms controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='8e778530a7400b8308175604d9f0ee40'
87 2 ms controllers/news.php

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

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='63914c305d74ef2076a97243aa3e95b7'
89 1.9 ms controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='f1a7136069abf1b22be17e30e99fa539'
90 2 ms controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='cdbb1df8d91a2094a829cfaeb180e034'
91 2.1 ms controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='852bdcad4742c89c438f3972d26389d8'
92 2 ms controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='852bdcad4742c89c438f3972d26389d8'
93 1.9 ms controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='852bdcad4742c89c438f3972d26389d8'
94 1.9 ms controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='f1a7136069abf1b22be17e30e99fa539'
95 1.9 ms controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='63914c305d74ef2076a97243aa3e95b7'
96 1.9 ms controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='852bdcad4742c89c438f3972d26389d8'
97 1.9 ms controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='852bdcad4742c89c438f3972d26389d8'
98 1.9 ms controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='f1a7136069abf1b22be17e30e99fa539'
99 1.9 ms controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='63914c305d74ef2076a97243aa3e95b7'
100 2 ms controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='852bdcad4742c89c438f3972d26389d8'
101 1.9 ms controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='852bdcad4742c89c438f3972d26389d8'
102 1.9 ms controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='63914c305d74ef2076a97243aa3e95b7'
103 1.9 ms controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='f1a7136069abf1b22be17e30e99fa539'
104 1.9 ms controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='63914c305d74ef2076a97243aa3e95b7'
105 1.9 ms controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='f1a7136069abf1b22be17e30e99fa539'
106 1.9 ms controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='63914c305d74ef2076a97243aa3e95b7'
107 1.9 ms controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='f1a7136069abf1b22be17e30e99fa539'
108 1.9 ms controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='852bdcad4742c89c438f3972d26389d8'
109 1.9 ms controllers/news.php

SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=901489 AND extraId = 74455 AND type_rel = 4
110 1.8 ms controllers/news.php

SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1598 AND type_rel = 3
111 1.9 ms controllers/news.php

SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1598 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
112 2.2 ms controllers/news.php

SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1159502,840595,723495,237645) ORDER BY n.cover_points DESC, update_date DESC
113 2.2 ms 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 `calendars2023` 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` = 74455 AND c.`round` = 2 ORDER BY shedule ASC LIMIT 12
114 2.3 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 = 74455 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
115 2 ms controllers/news.php

TOTAL TIME 423.9 ms QUERIES 115 FILE controllers/news.php