Connection to sql... 869 us

SELECT type FROM routes WHERE alias = 'segunda2020'
1 150 us config/routes_file.php

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

SELECT l.table_suffix, ct.id, ct.alias, ct.name AS name,ct.logo, ct.CountryCode, l.year, ct.location, ct.continent, l.extraName, ct.competition_type, ct.troncal, ct.coefficient, ct.ctype, l.id AS league_id, l.year, l.total_teams, l.current_round,l.current_table_round, l.total_rounds, l.total_group, l.group_code, l.legend, l.legendExtra, l.playoff, l.end_prev, l.start_date, l.end_date, l.table_suffix,l.start_date,l.end_date, ct.parentId FROM futbol.categories AS ct INNER JOIN leagues_besoccer AS l ON ct.id=l.categoryId WHERE ct.id=2 AND l.year=2020 ORDER BY l.group_code
2 1.5 ms controllers/category.php

SELECT year AS title, year FROM leagues WHERE (group_code = 0 OR total_num_tablesR>=1 OR total_teamsR >=1 OR text_mode > 0) AND categoryId=2 GROUP BY year ORDER BY year DESC
3 657 us controllers/category.php

SELECT type,categoryId,year FROM historical_resume WHERE (categoryId = 2 and (year = 2020 OR year = 0))
4 337 us controllers/category.php

SELECT total FROM bs_rel_resume_items WHERE itemId=2 AND type_rel=3 AND ln='es'
5 322 us controllers/category.php

SELECT ct.id, ct.alias, ct.name AS name, ct.active_year as year, ct.CountryCode as cc FROM futbol.categories AS ct WHERE ct.parentId in (2,2)
6 341 us controllers/category.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
7 290 us controllers/category.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 = 2 AND l.year=2020 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
8 406 us controllers/category.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.tables2020 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 = 50064 AND t.round = 42 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
9 1.2 ms controllers/category.php

SELECT team, position, round FROM futbol.tables2020 WHERE league_id=50064 AND round=41 ORDER BY team ASC;
10 384 us controllers/category.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 50064 LIMIT 1
11 7.9 ms controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='4e385e8aec65064e7b6b8f7357785c15'
12 335 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
13 266 us controllers/category.php

SELECT c.isVideo, c.id,c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars2020` 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` = 50064 AND c.`round` = 2 ORDER BY shedule ASC LIMIT 200
14 717 us controllers/category.php

SELECT c.id, 2020 as year, ev.match_id,dp.alias,ev.minute,ev.action,ev.player_id,e.name,e.classf,dp.nick,rel.squadNumber,rel.player_id as playerId,rel.team_id,rel.teamId FROM events2020 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2020 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 50064 AND (ev.team1id=rel.team_id OR ev.team2id=rel.team_id) INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE ev.match_id IN (46670,46688,46691,46680,46671,46683,46686,46695,46677,46692,46674) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
15 2 ms controllers/category.php

SELECT rel.media_id, rel.team1, rel.team2, m.name, m.type, m.lang, m.location, rel.id AS rel_id, m.url FROM rel_media_match AS rel INNER JOIN media AS m ON m.id=rel.media_id WHERE (m.lang='es' OR m.language='spanish') AND rel.active=1 AND rel.league_id=50064 AND rel.round=2
16 1.2 ms controllers/category.php

SELECT l.id, l.current_round, l.year, l.playoff, l.group_code, l.total_group, l.total_rounds, c.coefficient as coefficient, c.name AS competition_name, c.ctype, c.cat, l.table_suffix, c.competition_type, l.categoryId,l.split_league,l.extraName FROM categories AS c INNER JOIN leagues AS l ON c.id = l.categoryId WHERE categoryId = 2 AND l.year='2020' AND l.group_code=1 ORDER BY l.end_prev ASC, l.group_code DESC
17 320 us controllers/category.php

SELECT 2020 as year, c.round, c.stadium AS stadium_id,c.isVideo,rel.media_id,c.id, dt1.id as datateam1, dt2.id as datateam2,c.league_id,c.extra,dt1.basealias as basealias1,dt2.basealias as basealias2, dt1.nameShow AS team1_name, dt2.nameShow AS team2_name, dt1.translate AS translate1, dt2.translate AS translate2, dt1.short_name AS local_abbr, dt2.short_name AS visitor_abbr,c.shedule as sheduleb, c.shedule AS shedule, CONVERT_TZ(NOW(), 'Europe/Madrid', 'Europe/Madrid') AS cur_date, c.r1, c.r2, c.team1, c.team2, 0 AS numc, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.finished, c.minute, IF(TIME(c.shedule)='00:00:00',1,0) AS no_hour , dt1.CountryCode AS CountryCode_local,dt2.CountryCode AS CountryCode_visitor, t1.conference as conference1, t2.conference as conference2, dt1.ctype FROM calendars2020 AS c INNER JOIN datateams as dt1 ON c.datateam1=dt1.id INNER JOIN datateams AS dt2 ON c.datateam2=dt2.id INNER JOIN teams t1 on t1.id = c.team1 INNER JOIN teams t2 on t2.id = c.team2 LEFT JOIN rel_media_match rel ON rel.cid = c.id AND rel.year = 2020 WHERE c.league_id = 50064 AND c.round =2 GROUP BY c.id ORDER BY c.shedule ASC, t1.conference ASC, field(CountryCode_local,'ES') DESC, field(CountryCode_visitor,'ES') DESC
18 878 us controllers/category.php

SELECT * FROM datastadiums as s LEFT JOIN rel_stadiums rs ON rs.stadium_id = s.id WHERE s.id IN (1043,546,659,1412,553,20,1260,262,471,584,1739) GROUP BY s.id;
19 507 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='a587736f77f430a8754d5bc5997f4c74'
20 315 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='36606e85840bb85db6521cd308082a21'
21 363 us controllers/category.php

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

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='6b8decc79ce0bf36a7baba7d3fa57e10'
23 279 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='71249081f8b767253cd8841324288b1c'
24 288 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='531a9e10f15396b097aa1513d4e89bd0'
25 336 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='212a0488abf6c0d52971d8e90bf314f9'
26 424 us controllers/category.php

SELECT rel.media_id, m.name FROM rel_media_match as rel INNER JOIN media AS m ON rel.media_id = m.id WHERE m.type in(10,11) AND rel.cid = 46670 AND m.location='es' AND rel.year = 2020 GROUP BY rel.media_id
27 608 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='a587736f77f430a8754d5bc5997f4c74'
28 223 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='36606e85840bb85db6521cd308082a21'
29 218 us controllers/category.php

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

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='6b8decc79ce0bf36a7baba7d3fa57e10'
31 225 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='71249081f8b767253cd8841324288b1c'
32 223 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='531a9e10f15396b097aa1513d4e89bd0'
33 250 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='212a0488abf6c0d52971d8e90bf314f9'
34 228 us controllers/category.php

SELECT rel.media_id, m.name FROM rel_media_match as rel INNER JOIN media AS m ON rel.media_id = m.id WHERE m.type in(10,11) AND rel.cid = 46691 AND m.location='es' AND rel.year = 2020 GROUP BY rel.media_id
35 361 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='a587736f77f430a8754d5bc5997f4c74'
36 183 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='36606e85840bb85db6521cd308082a21'
37 285 us controllers/category.php

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

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='6b8decc79ce0bf36a7baba7d3fa57e10'
39 151 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='71249081f8b767253cd8841324288b1c'
40 175 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='531a9e10f15396b097aa1513d4e89bd0'
41 538 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='212a0488abf6c0d52971d8e90bf314f9'
42 262 us controllers/category.php

SELECT rel.media_id, m.name FROM rel_media_match as rel INNER JOIN media AS m ON rel.media_id = m.id WHERE m.type in(10,11) AND rel.cid = 46688 AND m.location='es' AND rel.year = 2020 GROUP BY rel.media_id
43 410 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='a587736f77f430a8754d5bc5997f4c74'
44 160 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='36606e85840bb85db6521cd308082a21'
45 221 us controllers/category.php

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

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='6b8decc79ce0bf36a7baba7d3fa57e10'
47 289 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='71249081f8b767253cd8841324288b1c'
48 167 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='531a9e10f15396b097aa1513d4e89bd0'
49 210 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='212a0488abf6c0d52971d8e90bf314f9'
50 180 us controllers/category.php

SELECT rel.media_id, m.name FROM rel_media_match as rel INNER JOIN media AS m ON rel.media_id = m.id WHERE m.type in(10,11) AND rel.cid = 46680 AND m.location='es' AND rel.year = 2020 GROUP BY rel.media_id
51 344 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='a587736f77f430a8754d5bc5997f4c74'
52 218 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='36606e85840bb85db6521cd308082a21'
53 145 us controllers/category.php

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

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

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='71249081f8b767253cd8841324288b1c'
56 175 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='531a9e10f15396b097aa1513d4e89bd0'
57 168 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='212a0488abf6c0d52971d8e90bf314f9'
58 153 us controllers/category.php

SELECT rel.media_id, m.name FROM rel_media_match as rel INNER JOIN media AS m ON rel.media_id = m.id WHERE m.type in(10,11) AND rel.cid = 46671 AND m.location='es' AND rel.year = 2020 GROUP BY rel.media_id
59 360 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='a587736f77f430a8754d5bc5997f4c74'
60 240 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='36606e85840bb85db6521cd308082a21'
61 215 us controllers/category.php

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

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='6b8decc79ce0bf36a7baba7d3fa57e10'
63 246 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='71249081f8b767253cd8841324288b1c'
64 170 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='531a9e10f15396b097aa1513d4e89bd0'
65 164 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='212a0488abf6c0d52971d8e90bf314f9'
66 138 us controllers/category.php

SELECT rel.media_id, m.name FROM rel_media_match as rel INNER JOIN media AS m ON rel.media_id = m.id WHERE m.type in(10,11) AND rel.cid = 46683 AND m.location='es' AND rel.year = 2020 GROUP BY rel.media_id
67 288 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='a587736f77f430a8754d5bc5997f4c74'
68 148 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='36606e85840bb85db6521cd308082a21'
69 162 us controllers/category.php

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

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='6b8decc79ce0bf36a7baba7d3fa57e10'
71 172 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='71249081f8b767253cd8841324288b1c'
72 136 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='531a9e10f15396b097aa1513d4e89bd0'
73 168 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='212a0488abf6c0d52971d8e90bf314f9'
74 135 us controllers/category.php

SELECT rel.media_id, m.name FROM rel_media_match as rel INNER JOIN media AS m ON rel.media_id = m.id WHERE m.type in(10,11) AND rel.cid = 46686 AND m.location='es' AND rel.year = 2020 GROUP BY rel.media_id
75 276 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='a587736f77f430a8754d5bc5997f4c74'
76 141 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='36606e85840bb85db6521cd308082a21'
77 167 us controllers/category.php

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

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

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='71249081f8b767253cd8841324288b1c'
80 120 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='531a9e10f15396b097aa1513d4e89bd0'
81 180 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='212a0488abf6c0d52971d8e90bf314f9'
82 136 us controllers/category.php

SELECT rel.media_id, m.name FROM rel_media_match as rel INNER JOIN media AS m ON rel.media_id = m.id WHERE m.type in(10,11) AND rel.cid = 46695 AND m.location='es' AND rel.year = 2020 GROUP BY rel.media_id
83 273 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='a587736f77f430a8754d5bc5997f4c74'
84 140 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='36606e85840bb85db6521cd308082a21'
85 167 us controllers/category.php

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

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='6b8decc79ce0bf36a7baba7d3fa57e10'
87 212 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='71249081f8b767253cd8841324288b1c'
88 120 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='531a9e10f15396b097aa1513d4e89bd0'
89 189 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='212a0488abf6c0d52971d8e90bf314f9'
90 158 us controllers/category.php

SELECT rel.media_id, m.name FROM rel_media_match as rel INNER JOIN media AS m ON rel.media_id = m.id WHERE m.type in(10,11) AND rel.cid = 46677 AND m.location='es' AND rel.year = 2020 GROUP BY rel.media_id
91 314 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='a587736f77f430a8754d5bc5997f4c74'
92 168 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='36606e85840bb85db6521cd308082a21'
93 184 us controllers/category.php

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

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='6b8decc79ce0bf36a7baba7d3fa57e10'
95 196 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='71249081f8b767253cd8841324288b1c'
96 121 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='531a9e10f15396b097aa1513d4e89bd0'
97 179 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='212a0488abf6c0d52971d8e90bf314f9'
98 136 us controllers/category.php

SELECT rel.media_id, m.name FROM rel_media_match as rel INNER JOIN media AS m ON rel.media_id = m.id WHERE m.type in(10,11) AND rel.cid = 46692 AND m.location='es' AND rel.year = 2020 GROUP BY rel.media_id
99 277 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='a587736f77f430a8754d5bc5997f4c74'
100 222 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='36606e85840bb85db6521cd308082a21'
101 233 us controllers/category.php

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

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='6b8decc79ce0bf36a7baba7d3fa57e10'
103 195 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='71249081f8b767253cd8841324288b1c'
104 122 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='531a9e10f15396b097aa1513d4e89bd0'
105 203 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='212a0488abf6c0d52971d8e90bf314f9'
106 167 us controllers/category.php

SELECT rel.media_id, m.name FROM rel_media_match as rel INNER JOIN media AS m ON rel.media_id = m.id WHERE m.type in(10,11) AND rel.cid = 46674 AND m.location='es' AND rel.year = 2020 GROUP BY rel.media_id
107 308 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='ee89e028576abbdb8f5e2922ffa6612b'
108 172 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='5281601ba9e69765f3cc9698bdb672f2'
109 171 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='3151090b16fde9e7ff044d7e165a7412'
110 124 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='5e60b5ec40e89b36af60305c59be3a00'
111 212 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='4ec3b69ed63112f7e8865f1e94706f35'
112 120 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='10baa8b2e5f6bd44d6fc3845578df5e3'
113 213 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='a084288bc6a0f07728af01f6b4dfe6d3'
114 119 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='1df861fe51f457b17d0c4508e5cd42b6'
115 214 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='6decc7a13941fd42daa4fbd69e65935f'
116 119 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='7db10ce56f99e5425a2d429c7d394bdf'
117 214 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='1a2a1340f3741e963834f82a364b3fee'
118 120 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='748935a7655467c0132a01f4cc051685'
119 216 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='4b1ddd643fea47e16092ebf093f63004'
120 127 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='739134fed84a79ca4f9ed5eb1349cb76'
121 213 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='8605c790e31dc4f7b2b68c6cf4d99c2e'
122 149 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='943a1bcc4ff4b6c24273f8b6dfa34585'
123 216 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='99e3c77bd9b8b06a5cbec5ca7ed00a7f'
124 125 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='003e4a381cf8b16be461e334072c0fe0'
125 217 us controllers/category.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='ef48f94260867a2a9fdad53362cd24a0'
126 172 us controllers/category.php

TOTAL TIME 40.5 ms QUERIES 124 FILE controllers/category.php