Ver equipo
Torpedo Kutaisi Torpedo
Datos equipo
Nombre Torpedo Kutaisi
Nombre completo Football Club Torpedo Kutaisi
Nombre corto FTK
País
Año fundación 1946
Total plantilla 31
Estadio
Nombre estadio Kolkhidis Stadioni
Capacidad estadio 19400
Tipo césped Natural
Internet
Sitio web http://www.fctorpedo.ge
Información
Dirección 1 Khorava Str. 4600 Kutaisi. Georgia
Ver equipo
Gagra Gagra
Datos equipo
Nombre Gagra
Nombre corto GAG
País
Total plantilla 27
Ver equipo
Merani Martvili Merani
Datos equipo
Nombre Merani Martvili
Nombre completo Football Club Merani Martvili
Nombre corto MER
País
Total plantilla 34
Estadio
Nombre estadio Municipal Stadium
Capacidad estadio 25000
Tipo césped Natural
Ver equipo
Shukura Shukura
Datos equipo
Nombre Shukura
Nombre completo FC Shukura Kobuleti
Nombre corto SHU
País
Total plantilla 39

Equipos de esta liga

4

  USO DE MEMORIA  
4,280,920 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0032
Controller Execution Time ( Home / Category )  0.3208
Total Execution Time  0.3240
  CADENA URL  
/liga_georgia_playoffs_ascenso2021/grupo0/equipos
  GET DATOS  
$_GET['/liga_georgia_playoffs_ascenso2021/grupo0/equipos']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0108  SELECT type FROM routes WHERE alias = 'liga_georgia_playoffs_ascenso2021'
0.0226  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_georgia_playoffs_ascenso' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2405 AND type_rel = 3
0.0114  SELECT c.id, c.name, c.alias, l.id AS league_id, l.year, l.group_code, l.total_group, c.id AS categoryId, c.stepParent FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND c.active_year=l.year WHERE c.id=301 ORDER BY l.group_code ASC
0.0107  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 2405 GROUP BY l.categoryId
0.0107  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=2405 GROUP BY l.year ORDER BY l.year DESC
0.0107  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 = 66108 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0111  SELECT t.id,t.teamId,t.total_players,dt.* FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 66108 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0107  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-19 18:17:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0107  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-19 18:17:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0109  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-19 18:17:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-19 18:17:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0112  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2405 AND l.year = 2021
0.0109  SELECT e.action, count(e.action) as total, e.player_id FROM events2021 e WHERE e.league_id IN (66108) AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0113  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (66108) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (153712,191939,303149,305591,467524,955564) ORDER BY rp.in_squad = 1 DESC
0.0106  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2405 AND l.year = 2021
0.0106  SELECT e.action, count(e.action) as total, e.player_id FROM events2021 e WHERE e.league_id IN (66108) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0111  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (66108) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (85204,448431,459638,867274,955564,153582,153982,153983,178137,286688) ORDER BY rp.in_squad = 1 DESC
0.0105  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2405 AND l.year = 2021
0.0106  SELECT e.action, count(e.action) as total, e.player_id FROM events2021 e WHERE e.league_id IN (66108) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0108  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (66108) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (85204,448431) ORDER BY rp.in_squad = 1 DESC