Jornada 1
23 Jul 21 HavířovHavířov 2 - 3 FC VratimovVratimov ...
23 Jul 21 Havlíčkův BrodHavlíčků 0 - 3 Velké MeziříčíVelké ...
23 Jul 21 BzenecBzenec 1 - 3 Uhersky BrodUhersky ...
23 Jul 21 SlavičínSlavičín 3 - 1 HolešovHolešov ...
24 Jul 21 Nový JičínNový 0 - 1 Valašské MeziříčíValašské ...
24 Jul 21 Jiskra RýmařovJiskra 2 - 4 UničovUničov 1
24 Jul 21 Nove SadyNove Sady 2 - 3 PřerovPřerov ...
24 Jul 21 FrýdlantFrýdlant 0 - 1 VitkoviceVitkovice ...
24 Jul 21 Žďár nad SázavouŽďár 5 - 2 Ždírec nad DroubravouŽdírec ...
24 Jul 21 Sokol TasoviceSokol 0 - 1 Start BrnoStart Brno ...
24 Jul 21 SkašticeSkaštice 2 - 1 HFK OlomoucOlomouc ...
24 Jul 21 Beskyd FrenstatBeskyd 2 - 3 Frýdek-MístekFrýdek-Mí ...
24 Jul 21 Sokol LanzhotSokol 1 - 2 Hodonín-ŠardiceHodonín-Š ...
24 Jul 21 HraniceHranice 6 - 1 Tatran VšechoviceTatran ...
24 Jul 21 Spartak Velká BítešSpartak 1 - 3 BlanskoBlansko ...
25 Jul 21 FC StraniFC Strani 3 - 2 BřeclavBřeclav ...
25 Jul 21 HumpolecHumpolec 1 - 1 Slavoj PolnáSlavoj 1
25 Jul 21 KozloviceKozlovice 4 - 0 Heřmanice SlezskáHeřmanice ...
25 Jul 21 Stará ŘíšeStará 0 - 5 ZnojmoZnojmo ...
25 Jul 21 Bohumin BosporBohumin 1 - 0 SK DetmaroviceDetmarovice ...
25 Jul 21 Polanka nad OdrouPolanka 3 - 0 Dolní BenešovDolní ...
25 Jul 21 BruntalBruntal 1 - 3 ŠumperkŠumperk 1
31 Jul 21 FC VsetínFC Vsetín 0 - 1 BílovecBílovec ...
Jornada 2
11 Ago 21 Olympie BrezovaOlympie 3 - 0 Králův DvůrKrálův ...
11 Ago 21 Sokol SrbiceSokol Apl Slavoj VyšehradSlavoj ...
11 Ago 21 SK TochoviceTochovice 1 - 1 Baník MostBaník Most ...
11 Ago 21 Tatran SedlčanyTatran 3 - 3 FC TáborskoTáborsko ...
11 Ago 21 Admira PrahaAdmira 0 - 1 PribramPribram 2
11 Ago 21 Brandýs nad LabemBrandýs 0 - 5 Chlumec nad CidlinouChlumec ...
11 Ago 21 LibcanyLibcany 1 - 4 FK ZbuzanyFK Zbuzany ...
11 Ago 21 LetohradLetohrad 0 - 4 PreperePrepere ...
11 Ago 21 NáchodNáchod 0 - 2 ChrudimChrudim ...
11 Ago 21 SlanýSlaný 1 - 4 VelvaryVelvary ...
10 Ago 21 Spartak SobeslavSpartak 1 - 2 BenešovBenešov ...
11 Ago 21 DobrisDobris 1 - 3 Sokol HostouňSokol ...
18 Ago 21 Velke HamryVelke Hamry 1 - 2 FK Viagem Ústí nad LabemViagem 3
11 Ago 21 Český BrodČeský 1 - 4 Loko VltavinLoko ...
11 Ago 21 Mariánské LázněMariánské 1 - 1 PísekPísek 1
11 Ago 21 Cesky Lev - Union BerounCesky Union 0 - 11 VlašimVlašim ...
11 Ago 21 Aritma PrahaAritma 0 - 1 Povltavská FAPovltavská ...
11 Ago 21 Dvůr KrálovéDvůr 0 - 5 Sokol ZápySokol Zápy ...
11 Ago 21 SK KladnoSK Kladno 0 - 7 Jiskra DomažliceJiskra ...
10 Ago 21 ChomutovChomutov 3 - 2 Motorlet PrahaMotorlet 3
11 Ago 21 Neratovice-ByškoviceNeratovice- 0 - 4 VarnsdorfVarnsdorf ...
11 Ago 21 KosmonosyKosmonosy 1 - 3 FK Dukla PrahaDukla Praha ...
11 Ago 21 FK KomárovKomárov 1 - 8 Viktoria ŽižkovViktoria ...
11 Ago 21 Vysoké MýtoVysoké 0 - 2 Ústí nad OrlicíÚstí ...
11 Ago 21 Meteor PrahaMeteor 2 - 3 Baník SokolovBaník ...
11 Ago 21 FK KolínFK Kolín 1 - 0 Karlovy VaryKarlovy ...
11 Ago 21 SFC OpavaSFC Opava 9 - 0 Bohumin BosporBohumin 1
11 Ago 21 ZnojmoZnojmo 1 - 6 SK LíšeňLíšeň 1
11 Ago 21 BílovecBílovec 1 - 4 UničovUničov ...
11 Ago 21 Slavoj PolnáSlavoj 0 - 4 Vysocina JihlavaVysocina ...
11 Ago 21 SlavičínSlavičín 3 - 2 Frýdek-MístekFrýdek-Mí ...
11 Ago 21 VitkoviceVitkovice 2 - 2 HraniceHranice ...
11 Ago 21 Start BrnoStart Brno 0 - 2 BlanskoBlansko ...
11 Ago 21 Valašské MeziříčíValašské 4 - 2 SkašticeSkaštice ...
11 Ago 21 Hodonín-ŠardiceHodonín-Š 1 - 2 VyškovVyškov ...
11 Ago 21 KozloviceKozlovice 1 - 8 HlučínHlučín ...
11 Ago 21 ŠumperkŠumperk 0 - 7 TřinecTřinec ...
11 Ago 21 FC StraniFC Strani 2 - 4 SK HanáckáHanácká ...
11 Ago 21 Velké MeziříčíVelké 4 - 2 Slovan RosiceSlovan ...
11 Ago 21 Žďár nad SázavouŽďár 0 - 4 Zbrojovka BrnoZbrojovka ...
11 Ago 21 Uhersky BrodUhersky 2 - 1 FC ZlínskoZlínsko ...
11 Ago 21 PřerovPřerov 5 - 0 Polanka nad OdrouPolanka ...
18 Ago 21 FC VratimovVratimov 2 - 3 ProstějovProstějov 4
Jornada 3
24 Ago 21 Uhersky BrodUhersky 1 - 2 Vysocina JihlavaVysocina 3
24 Ago 21 PreperePrepere 6 - 0 PísekPísek 8
25 Ago 21 Ústí nad OrlicíÚstí 0 - 2 VyškovVyškov ...
02 Sep 21 Sokol ZápySokol Zápy 1 - 1 Viktoria ŽižkovViktoria 13
25 Ago 21 Povltavská FAPovltavská 0 - 5 VarnsdorfVarnsdorf ...
01 Sep 21 FK KolínFK Kolín 1 - 2 FK Dukla PrahaDukla Praha 8
08 Sep 21 VitkoviceVitkovice 0 - 3 TřinecTřinec ...
14 Sep 21 Velké MeziříčíVelké 0 - 5 SFC OpavaSFC Opava ...
08 Sep 21 Chlumec nad CidlinouChlumec 0 - 1 ChrudimChrudim ...
25 Ago 21 Jiskra DomažliceJiskra 1 - 7 VlašimVlašim ...
25 Ago 21 SK HanáckáHanácká 2 - 2 Zbrojovka BrnoZbrojovka ...
25 Ago 21 VelvaryVelvary 3 - 1 ChomutovChomutov ...
25 Ago 21 Valašské MeziříčíValašské 0 - 3 ProstějovProstějov ...
08 Sep 21 Loko VltavinLoko 3 - 2 FK Viagem Ústí nad LabemViagem ...
25 Ago 21 Sokol HostouňSokol 0 - 1 PardubicePardubice 2
25 Ago 21 SlavičínSlavičín 1 - 5 KarvináKarviná ...
25 Ago 21 Slovan LiberecSlovan 1 - 2 FK ZbuzanyFK Zbuzany 3
25 Ago 21 BenešovBenešov 0 - 1 TepliceTeplice 2
25 Ago 21 Tatran SedlčanyTatran 0 - 6 České BudějoviceČeské ...
25 Ago 21 HlučínHlučín 0 - 1 Baník OstravaBaník 2
25 Ago 21 Baník SokolovBaník 0 - 6 Bohemians 1905Bohemians ...
25 Ago 21 UničovUničov 2 - 4 Sigma OlomoucSigma 1
24 Ago 21 Mladá BoleslavMladá 3 - 0 Slavoj VyšehradSlavoj 3
01 Sep 21 PřerovPřerov 0 - 2 SK LíšeňLíšeň 1
01 Sep 21 BlanskoBlansko 1 - 4 FC Trinity ZlínTrinity 3
01 Sep 21 Olympie BrezovaOlympie 0 - 2 Hradec KrálovéHradec 2
07 Sep 21 Baník SoušBaník 0 - 1 PribramPribram 2
Jornada 4
21 Sep 21 Viktoria PlzeňViktoria 2 - 1 PribramPribram 8
22 Sep 21 Loko VltavinLoko 2 - 5 Baník OstravaBaník 1
22 Sep 21 Sokol ZápySokol Zápy 0 - 4 Hradec KrálovéHradec ...
06 Oct 21 FK Dukla PrahaDukla Praha 1 - 3 České BudějoviceČeské 13
21 Sep 21 Vysocina JihlavaVysocina 2 - 0 PardubicePardubice ...
22 Sep 21 TřinecTřinec 0 - 1 TepliceTeplice ...
06 Oct 21 VarnsdorfVarnsdorf 4 - 2 Zbrojovka BrnoZbrojovka 5
22 Sep 21 ProstějovProstějov 0 - 4 Bohemians 1905Bohemians ...
22 Sep 21 KarvináKarviná 1 - 0 ChrudimChrudim ...
07 Oct 21 VyškovVyškov 1 - 2 FC Trinity ZlínTrinity 12
22 Sep 21 VelvaryVelvary 2 - 4 Slavia PrahaSlavia 8
22 Sep 21 FK ZbuzanyFK Zbuzany 1 - 2 SlováckoSlovácko ...
22 Sep 21 PreperePrepere 0 - 1 JablonecJablonec ...
21 Sep 21 VlašimVlašim 1 - 2 Sigma OlomoucSigma ...
22 Sep 21 SK LíšeňLíšeň 0 - 3 Sparta PrahaSparta 1
21 Sep 21 SFC OpavaSFC Opava 2 - 4 Mladá BoleslavMladá ...
Jornada 5
27 Oct 21 Mladá BoleslavMladá 2 - 0 Viktoria PlzeňViktoria 15
11 Nov 21 JablonecJablonec 4 - 0 VarnsdorfVarnsdorf 9
27 Oct 21 TepliceTeplice 0 - 2 Sparta PrahaSparta 4
12 Nov 21 SlováckoSlovácko 3 - 1 KarvináKarviná 19
27 Oct 21 Baník OstravaBaník 1 - 2 Hradec KrálovéHradec 4
23 Nov 21 České BudějoviceČeské 1 - 1 Sigma OlomoucSigma 2
26 Oct 21 Bohemians 1905Bohemians 1 - 0 Vysocina JihlavaVysocina 7
15 Dic 21 Slavia PrahaSlavia 3 - 1 FC Trinity ZlínTrinity 27
Jornada 6
09 Feb 22 Sigma OlomoucSigma 0 - 0 SlováckoSlovácko 3
15 Feb 22 Hradec KrálovéHradec 2 - 1 Bohemians 1905Bohemians 37
09 Feb 22 Slavia PrahaSlavia 0 - 2 Sparta PrahaSparta 31
16 Feb 22 JablonecJablonec 4 - 0 Mladá BoleslavMladá 4
Jornada 7
25 Mar 22 Hradec KrálovéHradec 0 - 1 SlováckoSlovácko 9
02 Mar 22 Sparta PrahaSparta 4 - 3 JablonecJablonec 48
Jornada 8
18 May 22 SlováckoSlovácko 3 - 1 Sparta PrahaSparta 130

  USO DE MEMORIA  
5,148,952 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1241
Total Execution Time  0.1259
  CADENA URL  
/copa_republica_checa2022/grupo0/calendario
  GET DATOS  
$_GET['/copa_republica_checa2022/grupo0/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0020  SELECT type FROM routes WHERE alias = 'copa_republica_checa2022'
0.0047  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa_republica_checa' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=642 AND type_rel = 3
0.0033  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 642 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0032  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 (1194015,1140203,962816,854403,851992) ORDER BY n.cover_points DESC, update_date DESC
0.0021  SELECT id,name,alias,stepParent FROM categories WHERE parentId=642 ORDER BY order_id ASC
0.0028  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 642 GROUP BY l.categoryId
0.0030  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=642 GROUP BY l.year ORDER BY l.year DESC
0.0054  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 = 63448 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0050  SELECT 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, dt1.stadium as stadium_name FROM calendars2022 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 63448 ORDER BY round ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-19 10:40:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-19 10:40:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-19 10:40:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-19 10:40:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 642 AND l.year = 2022
0.0032  SELECT e.action, count(e.action) as total, e.player_id FROM events2022 e WHERE e.league_id IN (63448) 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.0029  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 (63448) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (332198,289518,213355,294023,609065,879126,144140,222571,251443,286244) ORDER BY rp.in_squad = 1 DESC
0.0021  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 642 AND l.year = 2022
0.0029  SELECT e.action, count(e.action) as total, e.player_id FROM events2022 e WHERE e.league_id IN (63448) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0028  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 (63448) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (13838,291721,71336,112301,164740,172958,205971,206450,285752,291755) ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 642 AND l.year = 2022
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events2022 e WHERE e.league_id IN (63448) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0025  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 (63448) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (71336,112301,162079,206450,291721,348662,350548,350559,352249,650589) ORDER BY rp.in_squad = 1 DESC