A. Torra, Olot - Olot - Temporada 2022/2023

Has elegido rechazar las cookies basadas en consentimiento que utilizamos principalmente para gestionar la publicidad y las recomendaciones de contenido.

En adelante, para aceder a nuestra web tienes que elegir alguna de las siguientes opciones.

Has cambiado de idea y quieres
NAVEGAR GRATIS Y CON PUBLICIDAD...

Navega por besoccer.com y resultados-futbol.com con publicidad personalizada, seguimiento y cookies de forma gratuita.

Optar por esta opción te permitirá mantener tu experiencia de navegación como hasta ahora. Al aceptar las cookies y tecnologías similares, estás dando tu consentimiento para que recopilemos y utilicemos tu información de navegación con el propósito de adaptar la publicidad y la personalización según tus intereses. La presencia de esta publicidad es crucial para continuar proporcionando contenido de calidad, sevicios eficientes a los usuarios y mejorar la experiencia general de uso.

Nosotros y nuestros socios hacemos el siguiente tratamiento de datos: almacenamiento y acceso a información de geolocalización con propósitos de publicidad dirigida, almacenamiento y acceso a información de geolocalización para realizar estudios de mercado, almacenar o acceder a información en un dispositivo, analizar activamente las características del dispositivo para su identificación, compartir tus análisis de navegación y grupos de interés con terceros, crear un perfil para la personalización de contenidos, crear un perfil publicitario personalizado, desarrollar y mejorar productos, enriquecer el perfil con información de terceros, medir el rendimiento de los anuncios, medir el rendimiento del contenido, seleccionar anuncios básicos, seleccionar anuncios personalizados, seleccionar contenido personalizado, utilizar datos de localización geográfica precisa, utilizar estudios de mercado a fin de generar información sobre el público.

Aceptar y continuar gratis

...O sigues prefiriendo rechazar las cookies y entonces
CONTINÚA REGISTRÁNDOTE Y SUSCRIBIÉNDOTE

Navega por besoccer.com y resultados-futbol.com sin publicidad ni seguimiento suscribiéndote a nuestra web por 0,50 € al día.

Además de abonar la suscripción, es necesario realizar un registro previo para acceder. El mismo perfil de usuario es compartido entre los sitios besoccer.com y resultados-futbol.com

Accede por 0,50 € al día

Para saber más, consulta nuestra Política de Cookies.

USO DE MEMORIA

5,801,304 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Player / Images )	0.2958
Total Execution Time	0.2971

CADENA URL

/fotos/jugador/A-Torra-423407

GET DATOS

$_GET['/fotos/jugador/A-Torra-423407']

POST DATOS

No hay datos POST existentes

CONSULTAS (80)

0.0003	SELECT COUNT(DISTINCT c.`id`) AS num FROM comments AS c WHERE c.`active` = 1 AND c.device = 'web' AND c.to_review=0 AND c.comment_id!=0 AND c.lang = '1' AND c.`playerId` = '423407'
0.0046	SELECT p.,rp.,dt.,p.id as playerId,c.Name,'' as buy_url, p.twitter AS player_twitter FROM* `dataplayers` p INNER JOIN `rel_players` rp ON rp.player_id = p.id AND rp.year = 2024 INNER JOIN `datateams` dt ON dt.id = rp.teamId LEFT JOIN country c ON c.code2 = p.CountryCode INNER JOIN categories AS ct ON rp.category_id=ct.id WHERE p.alias = 'A-Torra-423407' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0247	SELECT p.,rp.,dt.,p.id as playerId,c.Name,'' as buy_url, p.twitter AS player_twitter FROM* `dataplayers` p INNER JOIN `rel_players` rp ON rp.player_id = p.id INNER JOIN `datateams` dt ON dt.id = rp.teamId LEFT JOIN country c ON c.code2 = p.CountryCode INNER JOIN categories AS ct ON rp.category_id=ct.id WHERE p.alias = 'A-Torra-423407' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0047	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 = 67509
0.0049	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 = 58610
0.0048	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 = 59286
0.0045	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 = 59872
0.0045	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 = 59973
0.0045	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 = 61739
0.0045	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 = 50267
0.0046	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 = 50597
0.0047	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 = 50622
0.0044	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 = 51355
0.0045	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 = 38808
0.0046	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 = 39150
0.0020	SELECT man.action_value, man.stocks, man.sparks, man.points, man.variation, man.valor, man.ini_valor, man.wage FROM games.manager_players man WHERE man.playerId = '423407'
0.0325	SELECT p.id,p.nick,p.role,p.side,p.alias,rp.squadNumber FROM `rel_players` rp INNER JOIN `dataplayers` p ON p.id = rp.player_id WHERE rp.league_id = 67320 AND rp.teamId = 4781 AND rp.in_squad=1 ORDER BY p.role>0 DESC, p.role ASC, rp.squadNumber ASC
0.0027	SELECT t.nameShow,t.basealias,rp.year,c.name FROM `rel_players` rp INNER JOIN `datateams` t ON t.id = rp.teamId INNER JOIN categories c ON c.id = rp.category_id WHERE rp.player_id = 423407 ORDER BY rp.year DESC
0.0019	SELECT p.title,p.totalcomments,p.downloads,p.views,p.id,p.author_id FROM `pictures` as p INNER JOIN `rel_pictures` as rp ON p.id = rp.id_picture WHERE rp.id_content = '423407' and rp.type = 3 ORDER BY p.id DESC LIMIT 0, 24
0.0018	SELECT COUNT(DISTINCT(p.id)) as total FROM `pictures` p INNER JOIN `rel_pictures` as rp ON p.id = rp.id_picture WHERE rp.id_content = '423407' and rp.type = 3
0.0018	SELECT e.* FROM `events2023` e WHERE e.player_id = 423407 AND league_id = 67320 ORDER BY e.date ASC
0.0021	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 67320 AND rel.player_id=423407
0.0018	SELECT action,minute FROM events2023 WHERE player_id = 423407 AND league_id = 67320 AND action = 18
0.0018	SELECT action,minute FROM events2023 WHERE player_id = 423407 AND league_id = 67320 AND action = 19
0.0018	SELECT e.* FROM `events2022` e WHERE e.player_id = 423407 AND league_id = 62389 ORDER BY e.date ASC
0.0019	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 62389 AND rel.player_id=423407
0.0018	SELECT action,minute FROM events2022 WHERE player_id = 423407 AND league_id = 62389 AND action = 18
0.0017	SELECT action,minute FROM events2022 WHERE player_id = 423407 AND league_id = 62389 AND action = 19
0.0019	SELECT e.* FROM `events2022` e WHERE e.player_id = 423407 AND league_id = 62807 ORDER BY e.date ASC
0.0019	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 62807 AND rel.player_id=423407
0.0019	SELECT action,minute FROM events2022 WHERE player_id = 423407 AND league_id = 62807 AND action = 18
0.0019	SELECT action,minute FROM events2022 WHERE player_id = 423407 AND league_id = 62807 AND action = 19
0.0021	SELECT e.* FROM `events2022` e WHERE e.player_id = 423407 AND league_id = 67509 ORDER BY e.date ASC
0.0023	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 67509 AND rel.player_id=423407
0.0021	SELECT action,minute FROM events2022 WHERE player_id = 423407 AND league_id = 67509 AND action = 18
0.0022	SELECT action,minute FROM events2022 WHERE player_id = 423407 AND league_id = 67509 AND action = 19
0.0022	SELECT e.* FROM `events2021` e WHERE e.player_id = 423407 AND league_id = 58610 ORDER BY e.date ASC
0.0023	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 58610 AND rel.player_id=423407
0.0019	SELECT action,minute FROM events2021 WHERE player_id = 423407 AND league_id = 58610 AND action = 18
0.0019	SELECT action,minute FROM events2021 WHERE player_id = 423407 AND league_id = 58610 AND action = 19
0.0018	SELECT e.* FROM `events2021` e WHERE e.player_id = 423407 AND league_id = 59286 ORDER BY e.date ASC
0.0021	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 59286 AND rel.player_id=423407
0.0018	SELECT action,minute FROM events2021 WHERE player_id = 423407 AND league_id = 59286 AND action = 18
0.0018	SELECT action,minute FROM events2021 WHERE player_id = 423407 AND league_id = 59286 AND action = 19
0.0018	SELECT e.* FROM `events2021` e WHERE e.player_id = 423407 AND league_id = 59872 ORDER BY e.date ASC
0.0019	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 59872 AND rel.player_id=423407
0.0019	SELECT action,minute FROM events2021 WHERE player_id = 423407 AND league_id = 59872 AND action = 18
0.0019	SELECT action,minute FROM events2021 WHERE player_id = 423407 AND league_id = 59872 AND action = 19
0.0022	SELECT e.* FROM `events2021` e WHERE e.player_id = 423407 AND league_id = 59973 ORDER BY e.date ASC
0.0021	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 59973 AND rel.player_id=423407
0.0019	SELECT action,minute FROM events2021 WHERE player_id = 423407 AND league_id = 59973 AND action = 18
0.0019	SELECT action,minute FROM events2021 WHERE player_id = 423407 AND league_id = 59973 AND action = 19
0.0019	SELECT e.* FROM `events2021` e WHERE e.player_id = 423407 AND league_id = 61739 ORDER BY e.date ASC
0.0024	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 61739 AND rel.player_id=423407
0.0018	SELECT action,minute FROM events2021 WHERE player_id = 423407 AND league_id = 61739 AND action = 18
0.0018	SELECT action,minute FROM events2021 WHERE player_id = 423407 AND league_id = 61739 AND action = 19
0.0018	SELECT e.* FROM `events2020` e WHERE e.player_id = 423407 AND league_id = 50267 ORDER BY e.date ASC
0.0019	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 50267 AND rel.player_id=423407
0.0018	SELECT action,minute FROM events2020 WHERE player_id = 423407 AND league_id = 50267 AND action = 18
0.0018	SELECT action,minute FROM events2020 WHERE player_id = 423407 AND league_id = 50267 AND action = 19
0.0032	SELECT e.* FROM `events2020` e WHERE e.player_id = 423407 AND league_id = 50597 ORDER BY e.date ASC
0.0019	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 50597 AND rel.player_id=423407
0.0018	SELECT action,minute FROM events2020 WHERE player_id = 423407 AND league_id = 50597 AND action = 18
0.0018	SELECT action,minute FROM events2020 WHERE player_id = 423407 AND league_id = 50597 AND action = 19
0.0018	SELECT e.* FROM `events2020` e WHERE e.player_id = 423407 AND league_id = 50622 ORDER BY e.date ASC
0.0020	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 50622 AND rel.player_id=423407
0.0017	SELECT action,minute FROM events2020 WHERE player_id = 423407 AND league_id = 50622 AND action = 18
0.0018	SELECT action,minute FROM events2020 WHERE player_id = 423407 AND league_id = 50622 AND action = 19
0.0019	SELECT e.* FROM `events2020` e WHERE e.player_id = 423407 AND league_id = 51355 ORDER BY e.date ASC
0.0020	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 51355 AND rel.player_id=423407
0.0018	SELECT action,minute FROM events2020 WHERE player_id = 423407 AND league_id = 51355 AND action = 18
0.0018	SELECT action,minute FROM events2020 WHERE player_id = 423407 AND league_id = 51355 AND action = 19
0.0018	SELECT e.* FROM `events2018` e WHERE e.player_id = 423407 AND league_id = 38808 ORDER BY e.date ASC
0.0019	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 38808 AND rel.player_id=423407
0.0018	SELECT action,minute FROM events2018 WHERE player_id = 423407 AND league_id = 38808 AND action = 18
0.0018	SELECT action,minute FROM events2018 WHERE player_id = 423407 AND league_id = 38808 AND action = 19
0.0019	SELECT e.* FROM `events2018` e WHERE e.player_id = 423407 AND league_id = 39150 ORDER BY e.date ASC
0.0023	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 39150 AND rel.player_id=423407
0.0018	SELECT action,minute FROM events2018 WHERE player_id = 423407 AND league_id = 39150 AND action = 18
0.0018	SELECT action,minute FROM events2018 WHERE player_id = 423407 AND league_id = 39150 AND action = 19

Olot

A. Torra2022/2023

Subir imagen de A. Torra


	¡Vas a denunciar un contenido! x Denuncia sólo contenidos que incumplan nuestras Normas de uso o conducta. Aunque revisamos todas las denuncias que nos llegan, sólo respondemos si procede. El uso indebido de esta herramienta también incumple las normas de conducta. Elige una de las siguientes opciones: Incumplimiento de las normas: Otra: