Array ( [0] => Array ( [id] => 448396 [year] => 2024 [match_id] => 448396 [alias] => l-petrovic-3557445 [minute] => 8 [action] => 1 [player_id] => 3557445 [name] => Gol [classf] => event_gol [nick] => L. Petrovic [squadNumber] => 17 [playerId] => 3557445 [team_id] => 6600884 [teamId] => 10886 ) [1] => Array ( [id] => 448392 [year] => 2024 [match_id] => 448392 [alias] => j-ceberio-3515319 [minute] => 8 [action] => 1 [player_id] => 3515319 [name] => Gol [classf] => event_gol [nick] => J. Ceberio [squadNumber] => 11 [playerId] => 3515319 [team_id] => 6600894 [teamId] => 3316 ) [2] => Array ( [id] => 448392 [year] => 2024 [match_id] => 448392 [alias] => x-arregi-3456486 [minute] => 15 [action] => 1 [player_id] => 3456486 [name] => Gol [classf] => event_gol [nick] => X. Arregi [squadNumber] => 18 [playerId] => 3456486 [team_id] => 6600896 [teamId] => 154053 ) [3] => Array ( [id] => 448395 [year] => 2024 [match_id] => 448395 [alias] => aner-manterola-3451718 [minute] => 19 [action] => 1 [player_id] => 3451718 [name] => Gol [classf] => event_gol [nick] => Aner Manterola [squadNumber] => 20 [playerId] => 3451718 [team_id] => 6600881 [teamId] => 4980 ) [4] => Array ( [id] => 448395 [year] => 2024 [match_id] => 448395 [alias] => aner-alberdi-3451551 [minute] => 26 [action] => 1 [player_id] => 3451551 [name] => Gol [classf] => event_gol [nick] => Aner Alberdi [squadNumber] => 23 [playerId] => 3451551 [team_id] => 6600882 [teamId] => 143363 ) [5] => Array ( [id] => 448396 [year] => 2024 [match_id] => 448396 [alias] => h-goni-3456434 [minute] => 27 [action] => 1 [player_id] => 3456434 [name] => Gol [classf] => event_gol [nick] => H. Goñi [squadNumber] => 10 [playerId] => 3456434 [team_id] => 6600884 [teamId] => 10886 ) [6] => Array ( [id] => 448399 [year] => 2024 [match_id] => 448399 [alias] => a-encinas-3314065 [minute] => 29 [action] => 1 [player_id] => 3314065 [name] => Gol [classf] => event_gol [nick] => Alain Encinas [squadNumber] => 19 [playerId] => 3314065 [team_id] => 6600893 [teamId] => 4981 ) [7] => Array ( [id] => 448391 [year] => 2024 [match_id] => 448391 [alias] => oier-menika-3451352 [minute] => 33 [action] => 1 [player_id] => 3451352 [name] => Gol [classf] => event_gol [nick] => Oier Meñika [squadNumber] => 8 [playerId] => 3451352 [team_id] => 6600898 [teamId] => 143700 ) [8] => Array ( [id] => 448391 [year] => 2024 [match_id] => 448391 [alias] => markel-arroyo-3451353 [minute] => 37 [action] => 1 [player_id] => 3451353 [name] => Gol [classf] => event_gol [nick] => Markel Arroyo [squadNumber] => 7 [playerId] => 3451353 [team_id] => 6600898 [teamId] => 143700 ) [9] => Array ( [id] => 448398 [year] => 2024 [match_id] => 448398 [alias] => n-ismael-3313916 [minute] => 40 [action] => 1 [player_id] => 3313916 [name] => Gol [classf] => event_gol [nick] => N. Ismael [squadNumber] => 7 [playerId] => 3313916 [team_id] => 6600891 [teamId] => 10890 ) [10] => Array ( [id] => 448393 [year] => 2024 [match_id] => 448393 [alias] => e-apaolaza-3249411 [minute] => 42 [action] => 1 [player_id] => 3249411 [name] => Gol [classf] => event_gol [nick] => E. Apaolaza [squadNumber] => 10 [playerId] => 3249411 [team_id] => 6600892 [teamId] => 3302 ) [11] => Array ( [id] => 448399 [year] => 2024 [match_id] => 448399 [alias] => e-duran-3313797 [minute] => 43 [action] => 1 [player_id] => 3313797 [name] => Gol [classf] => event_gol [nick] => E. Duran [squadNumber] => 7 [playerId] => 3313797 [team_id] => 6600889 [teamId] => 10888 ) [12] => Array ( [id] => 448391 [year] => 2024 [match_id] => 448391 [alias] => alain-albizu-3451431 [minute] => 44 [action] => 1 [player_id] => 3451431 [name] => Gol [classf] => event_gol [nick] => Alain Albizu [squadNumber] => 17 [playerId] => 3451431 [team_id] => 6600890 [teamId] => 4976 ) [13] => Array ( [id] => 448397 [year] => 2024 [match_id] => 448397 [alias] => a-enrique-3314030 [minute] => 44 [action] => 1 [player_id] => 3314030 [name] => Gol [classf] => event_gol [nick] => A. Aranguren [squadNumber] => 7 [playerId] => 3314030 [team_id] => 6600886 [teamId] => 6237 ) [14] => Array ( [id] => 448399 [year] => 2024 [match_id] => 448399 [alias] => aimar-parte-3451586 [minute] => 45 [action] => 1 [player_id] => 3451586 [name] => Gol [classf] => event_gol [nick] => Aimar Parte [squadNumber] => 17 [playerId] => 3451586 [team_id] => 6600889 [teamId] => 10888 ) [15] => Array ( [id] => 448395 [year] => 2024 [match_id] => 448395 [alias] => j-oreol-3314010 [minute] => 51 [action] => 3 [player_id] => 3314010 [name] => T. Roja [classf] => event_tr [nick] => J. Oreol [squadNumber] => 16 [playerId] => 3314010 [team_id] => 6600882 [teamId] => 143363 ) [16] => Array ( [id] => 448395 [year] => 2024 [match_id] => 448395 [alias] => a-aranburu-3399636 [minute] => 52 [action] => 1 [player_id] => 3399636 [name] => Gol [classf] => event_gol [nick] => A. Aranburu [squadNumber] => 14 [playerId] => 3399636 [team_id] => 6600881 [teamId] => 4980 ) [17] => Array ( [id] => 448397 [year] => 2024 [match_id] => 448397 [alias] => raul-perez-3451374 [minute] => 53 [action] => 1 [player_id] => 3451374 [name] => Gol [classf] => event_gol [nick] => Raúl Pérez [squadNumber] => 11 [playerId] => 3451374 [team_id] => 6600886 [teamId] => 6237 ) [18] => Array ( [id] => 448397 [year] => 2024 [match_id] => 448397 [alias] => u-ariza-3456714 [minute] => 54 [action] => 1 [player_id] => 3456714 [name] => Gol [classf] => event_gol [nick] => U. Ariza [squadNumber] => 16 [playerId] => 3456714 [team_id] => 6600886 [teamId] => 6237 ) [19] => Array ( [id] => 448395 [year] => 2024 [match_id] => 448395 [alias] => benat-alejo-3451533 [minute] => 59 [action] => 1 [player_id] => 3451533 [name] => Gol [classf] => event_gol [nick] => Beñat Alejo [squadNumber] => 10 [playerId] => 3451533 [team_id] => 6600882 [teamId] => 143363 ) [20] => Array ( [id] => 448396 [year] => 2024 [match_id] => 448396 [alias] => d-acosta-3456447 [minute] => 59 [action] => 1 [player_id] => 3456447 [name] => Gol [classf] => event_gol [nick] => D. Acosta [squadNumber] => 15 [playerId] => 3456447 [team_id] => 6600884 [teamId] => 10886 ) [21] => Array ( [id] => 448395 [year] => 2024 [match_id] => 448395 [alias] => h-unanue-3313931 [minute] => 60 [action] => 1 [player_id] => 3313931 [name] => Gol [classf] => event_gol [nick] => H. Unanue [squadNumber] => 10 [playerId] => 3313931 [team_id] => 6600881 [teamId] => 4980 ) [22] => Array ( [id] => 448392 [year] => 2024 [match_id] => 448392 [alias] => j-ceberio-3515319 [minute] => 60 [action] => 1 [player_id] => 3515319 [name] => Gol [classf] => event_gol [nick] => J. Ceberio [squadNumber] => 11 [playerId] => 3515319 [team_id] => 6600894 [teamId] => 3316 ) [23] => Array ( [id] => 448391 [year] => 2024 [match_id] => 448391 [alias] => alain-albizu-3451431 [minute] => 61 [action] => 1 [player_id] => 3451431 [name] => Gol [classf] => event_gol [nick] => Alain Albizu [squadNumber] => 17 [playerId] => 3451431 [team_id] => 6600890 [teamId] => 4976 ) [24] => Array ( [id] => 448399 [year] => 2024 [match_id] => 448399 [alias] => n-amarika-3314064 [minute] => 62 [action] => 1 [player_id] => 3314064 [name] => Gol [classf] => event_gol [nick] => N. Amarika [squadNumber] => 12 [playerId] => 3314064 [team_id] => 6600893 [teamId] => 4981 ) [25] => Array ( [id] => 448398 [year] => 2024 [match_id] => 448398 [alias] => joel-martinez-3451335 [minute] => 63 [action] => 1 [player_id] => 3451335 [name] => Gol [classf] => event_gol [nick] => Joel Martinez [squadNumber] => 2 [playerId] => 3451335 [team_id] => 6600887 [teamId] => 90950 ) [26] => Array ( [id] => 448398 [year] => 2024 [match_id] => 448398 [alias] => l-gastesi-3313823 [minute] => 65 [action] => 1 [player_id] => 3313823 [name] => Gol [classf] => event_gol [nick] => L. Gastesi [squadNumber] => 11 [playerId] => 3313823 [team_id] => 6600887 [teamId] => 90950 ) [27] => Array ( [id] => 448399 [year] => 2024 [match_id] => 448399 [alias] => inigo-oteo-3451647 [minute] => 65 [action] => 1 [player_id] => 3451647 [name] => Gol [classf] => event_gol [nick] => Iñigo Oteo [squadNumber] => 14 [playerId] => 3451647 [team_id] => 6600893 [teamId] => 4981 ) [28] => Array ( [id] => 448392 [year] => 2024 [match_id] => 448392 [alias] => o-cueva-3456466 [minute] => 65 [action] => 1 [player_id] => 3456466 [name] => Gol [classf] => event_gol [nick] => O. Cueva [squadNumber] => 11 [playerId] => 3456466 [team_id] => 6600896 [teamId] => 154053 ) [29] => Array ( [id] => 448394 [year] => 2024 [match_id] => 448394 [alias] => o-ramos-3313893 [minute] => 66 [action] => 1 [player_id] => 3313893 [name] => Gol [classf] => event_gol [nick] => Oinatz Ramos [squadNumber] => 24 [playerId] => 3313893 [team_id] => 6600879 [teamId] => 4840 ) [30] => Array ( [id] => 448393 [year] => 2024 [match_id] => 448393 [alias] => u-de-juan-3451323 [minute] => 69 [action] => 1 [player_id] => 3451323 [name] => Gol [classf] => event_gol [nick] => U. López [squadNumber] => 19 [playerId] => 3451323 [team_id] => 6600885 [teamId] => 10308 ) [31] => Array ( [id] => 448395 [year] => 2024 [match_id] => 448395 [alias] => m-tabe-3314026 [minute] => 70 [action] => 1 [player_id] => 3314026 [name] => Gol [classf] => event_gol [nick] => M. Tabe [squadNumber] => 9 [playerId] => 3314026 [team_id] => 6600882 [teamId] => 143363 ) [32] => Array ( [id] => 448395 [year] => 2024 [match_id] => 448395 [alias] => inigo-iriondo-3451717 [minute] => 73 [action] => 1 [player_id] => 3451717 [name] => Gol [classf] => event_gol [nick] => Iñigo Iriondo [squadNumber] => 21 [playerId] => 3451717 [team_id] => 6600881 [teamId] => 4980 ) [33] => Array ( [id] => 448394 [year] => 2024 [match_id] => 448394 [alias] => o-barrios-3410611 [minute] => 73 [action] => 1 [player_id] => 3410611 [name] => Gol [classf] => event_gol [nick] => O. Barrios [squadNumber] => 24 [playerId] => 3410611 [team_id] => 6600883 [teamId] => 90952 ) [34] => Array ( [id] => 448399 [year] => 2024 [match_id] => 448399 [alias] => e-duran-3313797 [minute] => 77 [action] => 1 [player_id] => 3313797 [name] => Gol [classf] => event_gol [nick] => E. Duran [squadNumber] => 7 [playerId] => 3313797 [team_id] => 6600889 [teamId] => 10888 ) [35] => Array ( [id] => 448394 [year] => 2024 [match_id] => 448394 [alias] => o-barrios-3410611 [minute] => 81 [action] => 1 [player_id] => 3410611 [name] => Gol [classf] => event_gol [nick] => O. Barrios [squadNumber] => 24 [playerId] => 3410611 [team_id] => 6600883 [teamId] => 90952 ) [36] => Array ( [id] => 448399 [year] => 2024 [match_id] => 448399 [alias] => e-calderon-3320483 [minute] => 87 [action] => 1 [player_id] => 3320483 [name] => Gol [classf] => event_gol [nick] => E. Calderon [squadNumber] => 22 [playerId] => 3320483 [team_id] => 6600893 [teamId] => 4981 ) [37] => Array ( [id] => 448393 [year] => 2024 [match_id] => 448393 [alias] => y-fatau-3313901 [minute] => 89 [action] => 1 [player_id] => 3313901 [name] => Gol [classf] => event_gol [nick] => Y. Fatau [squadNumber] => 9 [playerId] => 3313901 [team_id] => 6600885 [teamId] => 10308 ) [38] => Array ( [id] => 448391 [year] => 2024 [match_id] => 448391 [alias] => manex-lozano-3451421 [minute] => 89 [action] => 1 [player_id] => 3451421 [name] => Gol [classf] => event_gol [nick] => Manex Lozano [squadNumber] => 19 [playerId] => 3451421 [team_id] => 6600890 [teamId] => 4976 ) [39] => Array ( [id] => 448396 [year] => 2024 [match_id] => 448396 [alias] => unai-rodriguez-3451699 [minute] => 90 [action] => 4 [player_id] => 3451699 [name] => 2a Amarilla/Roja [classf] => event_tar [nick] => Unai Rodríguez [squadNumber] => 6 [playerId] => 3451699 [team_id] => 6600880 [teamId] => 138966 ) )
1% | 11.22 kb | /var/www/rf-desktop/rf/resultados-futbol/besoccer/index.php |
1% | 7.83 kb | /var/www/rf-desktop/rf/resultados-futbol/besoccer/system/application/config/routes_static.php |
0% | 5.59 kb | index.php |
39% | 434.32 kb | kint.phar |
0% | 1.71 kb | phar://kint.phar/init_phar.php |
0% | 2.73 kb | phar://kint.phar/init.php |
2% | 22.07 kb | phar://kint.phar/src/Kint.php |
0% | 1.77 kb | phar://kint.phar/src/FacadeInterface.php |
1% | 9.02 kb | phar://kint.phar/src/Utils.php |
0% | 2.54 kb | phar://kint.phar/init_helpers.php |
2% | 19.45 kb | phar://kint.phar/src/Renderer/RichRenderer.php |
0% | 4.87 kb | phar://kint.phar/src/Renderer/AbstractRenderer.php |
0% | 1.85 kb | phar://kint.phar/src/Renderer/RendererInterface.php |
0% | 3.29 kb | application/config/pre_config.php |
0% | 1.79 kb | application/config/section_routes.php |
1% | 16.85 kb | application/config/config.php |
0% | 37 b | /var/www/rf-desktop/rf/resultados-futbol/besoccer/system/application/config/numcache.txt |
0% | 969 b | application/config/config_db.php |
0% | 1.83 kb | /var/www/rf-desktop/config_db_slave.php |
1% | 6.69 kb | system/db.php |
1% | 6.73 kb | system/dbm.php |
0% | 1018 b | system/view.php |
0% | 1.2 kb | system/controller.php |
0% | 256 b | system/model.php |
0% | 5.53 kb | system/router.php |
0% | 1.88 kb | system/phponrf.php |
0% | 354 b | application/config/routes.php |
1% | 9.11 kb | application/config/routes_file.php |
4% | 48.09 kb | application/controllers/category.php |
0% | 1.69 kb | application/helpers/convert_helper.php |
0% | 1.62 kb | application/helpers/lang_helper.php |
1% | 12.87 kb | application/helpers/date_helper.php |
1% | 7.14 kb | application/helpers/render_helper.php |
1% | 12.79 kb | application/helpers/url_helper.php |
0% | 1.29 kb | application/helpers/string_helper.php |
4% | 42.07 kb | application/helpers/normalize_responses.php |
5% | 53.1 kb | application/lib/lib.php |
2% | 23.23 kb | application/models/result_model.php |
3% | 38.9 kb | application/models/event_model.php |
4% | 43.53 kb | application/models/category_model.php |
1% | 6.95 kb | application/req/competition.php |
2% | 19.64 kb | application/req/tables.php |
5% | 52.24 kb | application/req/matchs.php |
1% | 6.03 kb | application/req/news_categories.php |
0% | 1.32 kb | application/req/competition_text.php |
0% | 3.1 kb | application/mods/exec_mods.php |
0% | 2.39 kb | application/mods/common/menu.php |
1% | 10.36 kb | application/models/common_model.php |
4% | 40.73 kb | application/models/match_model.php |
1% | 15.79 kb | application/mods/common/menu/menu_static_content.php |
1% | 10.99 kb | application/mods/common/menu/menu_mini_header.php |
0% | 1.72 kb | application/mods/common/menu/menu_data.php |
1% | 6.32 kb | application/mods/common/menu/menu_min_leagues.php |
1% | 7.62 kb | application/mods/common/menu/menu_esp_navbar.php |
0% | 5.27 kb | application/mods/common/menu/menu_mobile.php |
1% | 5.63 kb | application/mods/category/migrated/category_header.php |
0% | 3.51 kb | application/mods/category/migrated/category_menu.php |
2% | 22.33 kb | application/mods/category/migrated/category_results2.php |
0% | 2.89 kb | application/mods/category/migrated/category_news_related.php |
0% | 1.39 kb | application/mods/category/migrated/category_information.php |
1% | 12.97 kb | application/views/common/header_view.php |
0% | 4.08 kb | application/views/common/quantcast/cfv3.php |
0% | 4.93 kb | application/mods/home/banner_cookies.php |
0% | 197 b | application/views/common/menu_view.php |
0% | 124 b | application/views/common/main_view_fw.php |
0% | 161 b | application/views/common/main_view.php |
0% | 191 b | application/views/common/sidebar_view.php |
1% | 7.38 kb | application/views/common/footer_view.php |
1.1 mb | Total |
Connection to sql... 8.8 ms
SELECT type FROM routes WHERE alias = 'nacional_juvenil2024'
1 1.8 ms config/routes_file.php
TOTAL TIME 5.1 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=112 AND l.year=2024 ORDER BY l.group_code
2 3.3 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=112 GROUP BY year ORDER BY year DESC
3 2.9 ms controllers/category.php
SELECT type,categoryId,year FROM historical_resume WHERE (categoryId = 112 and (year = 2024 OR year = 0))
4 1.9 ms controllers/category.php
SELECT total FROM bs_rel_resume_items WHERE itemId=112 AND type_rel=3 AND ln='es'
5 1.9 ms 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 (112)
6 1.8 ms controllers/category.php
SELECT * FROM futbol.categories_coef WHERE parentId=112 or sonId=112 LIMIT 1
7 1.8 ms 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 = 112 AND l.year=2024 AND l.group_code>=1 AND l.group_code = 4 ORDER BY l.group_code ASC
8 1.9 ms 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.tables2024 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 = 73381 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
9 4.3 ms controllers/category.php
SELECT team, position, round FROM futbol.tables2024 WHERE league_id=73381 AND round=33 ORDER BY team ASC;
10 1.9 ms controllers/category.php
SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 73381 LIMIT 1
11 11.6 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='4e385e8aec65064e7b6b8f7357785c15'
12 1.9 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
13 1.9 ms 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 `calendars2024` 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` = 73381 AND c.`round` = 28 ORDER BY shedule ASC LIMIT 200
14 2.4 ms controllers/category.php
SELECT c.id, 2024 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 events2024 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2024 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 73381 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 (448399,448394,448391,448397,448393,448398,448392,448395,448396) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
15 3.6 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=73381 AND rel.round=28
16 2.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 = 112 AND l.year='2024' AND l.group_code=4 ORDER BY l.end_prev ASC, l.group_code DESC
17 1.9 ms controllers/category.php
SELECT 2024 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 calendars2024 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 = 2024 WHERE c.league_id = 73381 AND c.round =28 GROUP BY c.id ORDER BY c.shedule ASC, t1.conference ASC, field(CountryCode_local,'ES') DESC, field(CountryCode_visitor,'ES') DESC
18 2.6 ms controllers/category.php
SELECT ds.name as stadium FROM rel_stadiums AS rs INNER JOIN datastadiums AS ds ON ds.id = rs.stadium_id WHERE rs.teamId = 10888 AND active = 1
19 3.8 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='a587736f77f430a8754d5bc5997f4c74'
20 1.9 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='36606e85840bb85db6521cd308082a21'
21 1.8 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='79b6ae4ce99e33b634a24499333a04bc'
22 1.8 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='6b8decc79ce0bf36a7baba7d3fa57e10'
23 1.8 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='71249081f8b767253cd8841324288b1c'
24 1.8 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='531a9e10f15396b097aa1513d4e89bd0'
25 2 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='212a0488abf6c0d52971d8e90bf314f9'
26 1.9 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='a587736f77f430a8754d5bc5997f4c74'
27 2 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='36606e85840bb85db6521cd308082a21'
28 1.8 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='79b6ae4ce99e33b634a24499333a04bc'
29 1.8 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='6b8decc79ce0bf36a7baba7d3fa57e10'
30 1.8 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='71249081f8b767253cd8841324288b1c'
31 1.8 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='531a9e10f15396b097aa1513d4e89bd0'
32 1.8 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='212a0488abf6c0d52971d8e90bf314f9'
33 1.9 ms controllers/category.php
SELECT ds.name as stadium FROM rel_stadiums AS rs INNER JOIN datastadiums AS ds ON ds.id = rs.stadium_id WHERE rs.teamId = 4976 AND active = 1
34 3.7 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='a587736f77f430a8754d5bc5997f4c74'
35 1.8 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='36606e85840bb85db6521cd308082a21'
36 1.9 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='79b6ae4ce99e33b634a24499333a04bc'
37 1.8 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='6b8decc79ce0bf36a7baba7d3fa57e10'
38 1.8 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='71249081f8b767253cd8841324288b1c'
39 1.8 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='531a9e10f15396b097aa1513d4e89bd0'
40 1.8 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='212a0488abf6c0d52971d8e90bf314f9'
41 1.8 ms controllers/category.php
SELECT ds.name as stadium FROM rel_stadiums AS rs INNER JOIN datastadiums AS ds ON ds.id = rs.stadium_id WHERE rs.teamId = 6237 AND active = 1
42 3.2 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='a587736f77f430a8754d5bc5997f4c74'
43 1.9 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='36606e85840bb85db6521cd308082a21'
44 1.8 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='79b6ae4ce99e33b634a24499333a04bc'
45 1.9 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='6b8decc79ce0bf36a7baba7d3fa57e10'
46 1.9 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='71249081f8b767253cd8841324288b1c'
47 1.9 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='531a9e10f15396b097aa1513d4e89bd0'
48 1.8 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='212a0488abf6c0d52971d8e90bf314f9'
49 1.9 ms controllers/category.php
SELECT ds.name as stadium FROM rel_stadiums AS rs INNER JOIN datastadiums AS ds ON ds.id = rs.stadium_id WHERE rs.teamId = 3302 AND active = 1
50 3.6 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='a587736f77f430a8754d5bc5997f4c74'
51 1.9 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='36606e85840bb85db6521cd308082a21'
52 2 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='79b6ae4ce99e33b634a24499333a04bc'
53 1.9 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='6b8decc79ce0bf36a7baba7d3fa57e10'
54 1.9 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='71249081f8b767253cd8841324288b1c'
55 1.9 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='531a9e10f15396b097aa1513d4e89bd0'
56 1.9 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='212a0488abf6c0d52971d8e90bf314f9'
57 1.8 ms controllers/category.php
SELECT ds.name as stadium FROM rel_stadiums AS rs INNER JOIN datastadiums AS ds ON ds.id = rs.stadium_id WHERE rs.teamId = 90950 AND active = 1
58 3.2 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='a587736f77f430a8754d5bc5997f4c74'
59 1.9 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='36606e85840bb85db6521cd308082a21'
60 1.9 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='79b6ae4ce99e33b634a24499333a04bc'
61 1.9 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='6b8decc79ce0bf36a7baba7d3fa57e10'
62 1.9 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='71249081f8b767253cd8841324288b1c'
63 1.9 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='531a9e10f15396b097aa1513d4e89bd0'
64 1.9 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='212a0488abf6c0d52971d8e90bf314f9'
65 1.9 ms controllers/category.php
SELECT ds.name as stadium FROM rel_stadiums AS rs INNER JOIN datastadiums AS ds ON ds.id = rs.stadium_id WHERE rs.teamId = 154053 AND active = 1
66 3.5 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='a587736f77f430a8754d5bc5997f4c74'
67 1.9 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='36606e85840bb85db6521cd308082a21'
68 1.9 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='79b6ae4ce99e33b634a24499333a04bc'
69 1.9 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='6b8decc79ce0bf36a7baba7d3fa57e10'
70 1.9 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='71249081f8b767253cd8841324288b1c'
71 1.9 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='531a9e10f15396b097aa1513d4e89bd0'
72 1.9 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='212a0488abf6c0d52971d8e90bf314f9'
73 1.8 ms controllers/category.php
SELECT ds.name as stadium FROM rel_stadiums AS rs INNER JOIN datastadiums AS ds ON ds.id = rs.stadium_id WHERE rs.teamId = 143363 AND active = 1
74 3.5 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='a587736f77f430a8754d5bc5997f4c74'
75 1.9 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='36606e85840bb85db6521cd308082a21'
76 1.9 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='79b6ae4ce99e33b634a24499333a04bc'
77 1.9 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='6b8decc79ce0bf36a7baba7d3fa57e10'
78 2.1 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='71249081f8b767253cd8841324288b1c'
79 2 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='531a9e10f15396b097aa1513d4e89bd0'
80 1.8 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='212a0488abf6c0d52971d8e90bf314f9'
81 1.8 ms controllers/category.php
SELECT ds.name as stadium FROM rel_stadiums AS rs INNER JOIN datastadiums AS ds ON ds.id = rs.stadium_id WHERE rs.teamId = 10886 AND active = 1
82 3.4 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='a587736f77f430a8754d5bc5997f4c74'
83 1.8 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='36606e85840bb85db6521cd308082a21'
84 1.8 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='9ae6e063e269320735c1f470d68c4179'
85 1.8 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='6b8decc79ce0bf36a7baba7d3fa57e10'
86 1.8 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='71249081f8b767253cd8841324288b1c'
87 1.8 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='531a9e10f15396b097aa1513d4e89bd0'
88 1.9 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='212a0488abf6c0d52971d8e90bf314f9'
89 1.8 ms controllers/category.php
SELECT rel.newId, rel.typeId, cat.name
FROM bs_news_rel rel INNER JOIN categories cat ON cat.id=rel.typeId
WHERE rel.type_rel=3 AND rel.typeId in(112) AND rel.ln='es'
ORDER BY rel.cover_points DESC, rel.newId DESC
LIMIT 1,20
90 2.3 ms controllers/category.php
SELECT e.name as author,n.id, n.alias, n.media, n.headline, n.teaser, n.subheadline, n.live_headline, n.update_date, n.other_media, n.views, n.teaser, n.comments FROM bs_news n LEFT JOIN bs_editors e ON e.id=n.author_id AND n.ln=e.ln WHERE n.status = 1 AND n.ln='es' AND n.id IN (1233227,1223087,1219000,1197928,1193383,1164585,1159322,1070805,1068014,1065436,1055009,1048936,1032295,1026123,1023905,1021274,1014882,1014725,1005424,993535) ORDER BY n.cover_points DESC, n.creation_date DESC
91 2.5 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='ee89e028576abbdb8f5e2922ffa6612b'
92 1.8 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='5281601ba9e69765f3cc9698bdb672f2'
93 1.8 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='3151090b16fde9e7ff044d7e165a7412'
94 1.8 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='5e60b5ec40e89b36af60305c59be3a00'
95 1.8 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='4ec3b69ed63112f7e8865f1e94706f35'
96 1.8 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='10baa8b2e5f6bd44d6fc3845578df5e3'
97 1.8 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='a084288bc6a0f07728af01f6b4dfe6d3'
98 1.9 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='1df861fe51f457b17d0c4508e5cd42b6'
99 1.8 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='6decc7a13941fd42daa4fbd69e65935f'
100 1.8 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='7db10ce56f99e5425a2d429c7d394bdf'
101 1.9 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='1a2a1340f3741e963834f82a364b3fee'
102 1.9 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='748935a7655467c0132a01f4cc051685'
103 1.9 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='4b1ddd643fea47e16092ebf093f63004'
104 1.9 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='739134fed84a79ca4f9ed5eb1349cb76'
105 1.9 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='8605c790e31dc4f7b2b68c6cf4d99c2e'
106 1.8 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='943a1bcc4ff4b6c24273f8b6dfa34585'
107 1.8 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='99e3c77bd9b8b06a5cbec5ca7ed00a7f'
108 1.8 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='003e4a381cf8b16be461e334072c0fe0'
109 1.8 ms controllers/category.php
SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='ef48f94260867a2a9fdad53362cd24a0'
110 1.8 ms controllers/category.php
SELECT `type`, `order`,`rule` as rtext FROM futbol.rules WHERE categoryId=112 ORDER BY `order` ASC
111 1.8 ms controllers/category.php
TOTAL TIME 233 ms QUERIES 109 FILE controllers/category.php
Memcache Server version: | |
Process id of this server process | |
Number of seconds this server has been running | |
Accumulated user time for this process | seconds |
Accumulated system time for this process | seconds |
Total number of items stored by this server ever since it started | |
Number of open connections | |
Total number of connections opened since the server started running | |
Number of connection structures allocated by the server | |
Cumulative number of retrieval requests | |
Cumulative number of storage requests |