Loading color scheme

  • Úvod
  • Cvičení pro děti
    • Od 4 měsíců do 2,5 let
    • Od 2,5 do 6 let
  • Cvičení pro maminky
  • Tábory
  • Klub 1FIT
  • Rezervace

Sportovní příměstské tábory pro děti od 3 do 15 let

Jarní, letní a podzimní příměstské tábory pro děti z Prahy a Středočeského kraje.

5 denní nabitý program plný zábavy, her a radosti z pohybu.

Klademe důraz na rozvoj pohybových dovedností, týmového ducha a smysl pro fair play.

Skupiny jsou rozděleny podle věku dětí.

Náš profesionální tým zajistí celodenní péči o vaše dítě.

Tábory organizují naše spolky Sportýna, z.s. a SPORTJOY, z.s.

Sportýna

Více informací

Sportjoy

Více informací

Babyjoy

Více informací

Lokality

Praha 4

Praha 5

Praha 7

Praha 10

Praha 11

Praha 13

Roztoky

Králův Dvůr

Hořovice

Termíny

Naše tábory

sportjoy

IMG25201
120461
26BA55C1-3700-4B92-A34E-D040B45CD311

SPORTJOY

Děti si vyzkouší 25 tradičních a netradičních sportů. Zažijí plno zábavy a her!

Sportovní tábor pro děti ve věku od 5 do 15 let. Program je zaměřen na různé sporty, zajímavé hry, soutěže a to vše zábavnou a hravou formou. Děti si vyzkouší 25 tradičních i netradičních sportů, dozvědí se zajímavosti ze sportovního světa a poučí se o základech zdravého stravování, to vše pod vedením našich zkušených trenérů. Děti jsou rozděleny do skupin dle věku a rotují od lekce k lekci.

více informací a program naleznete na stránkách organizátora www.sportjoy.cz

Přihlásit na tábor

Jedno dítě

2950 Kč/os

Přihlásit

Sourozenci

2750 Kč/os

Přihlásit

babyjoy

F791EAA1-2293-4487-A419-8B1D0CAAD893
B61AA28D-089C-4000-A1B4-4DCE6B4D32B2
babyhry

BABYJOY

Házej, chytej, běhej! Děti si vyzkouší 15 různých sportů a naučí se mnoho nových pohybových dovedností.

Speciální sportovní tábor, plný pohybu, her a dobrodružství pro děti ve věku od 3 do 5 let. Tento kemp je určen pro děti bez předchozí sportovní a pohybové průpravy. Děti si vyzkouší v průběhu týdne 15 různých sportů a naučí se mnoho nových pohybových dovedností.Kemp není fyzicky náročný, je brán ohled na věk a pohybové schopnosti dětí. Skupinka dětí je malá a vždy se o ně starají dvě osoby.

více informací a program naleznete na stránkách organizátora www.sportjoy.cz

Přihlásit na tábor

Jedno dítě

2950 Kč/os

Přihlásit

Sourozenci

2750 Kč/os

Přihlásit

sportyna

sportyna-galerie-3
sportyna-galerie-2
sportyna-galerie-1

Sportýna

Děti si užijí 5 dní plných radosti z pohybu, vyzkouší si mnoho sportů a rodičům sdělíme jejich sportovní předpoklady.

Tábor je zaměřený všestranně. Děti si vyzkouší spoustu sportů (atletika, gymnastika, bojové umění, sportovní hry od fotbalu až po basketbal, tanec a další...). Hlavním cílem táborů je vytvořit dítěti kladný vztah ke sportu v přátelském prostředí, poznat nové kamarády, naučit se spoustu nových dovedností a strávit prázdniny aktivně. Sportovní příměstské tábory jsou určeny pro děti ve věku od 5 do 15 let, které jsou pak rozděleny dle věku do jednotlivých skupin. Součástí táborů je i sportovní testování, ze kterého je vyhodnocena nejvhodnější skupina sportů, pro kterou má konkrétní dítě předpoklady. Hlavním úkolem trenérů je u dětí najít jejich silné stránky a motivovat je k pohybu nebo přímo sportu, který jej bude bavit.

Více informací a program naleznete na stránkách organizátora www.sportyna.cz

Jedno dítě

2990 Kč/os

1 FIT nabízí sportovní aktivity pro celou rodinu. Zakladatelky Adéla a Vendy mají společně 19 let zkušeností v oblasti pořádání sportovních soustředění, zájezdů, kroužků, cvičení a příměstských táborů.
S námi bude FIT celá rodina.

Navigace
  • Úvod
  • Cvičení pro děti
  • Cvičení pro maminky
  • Tábory
  • Klub 1FIT
  • Rezervace
Informace
  • O nás
  • Náš tým
  • Reference
  • Všeobecné podmínky
  • Zásady zpracování a ochrany osobních údajů
  • Platební podmínky
  • Omluvy a náhrady
  • Blog
  • Kontakt
  • Ceník
  • Ke stažení
  • Časté dotazy
Napište nám
Děkujeme! Zpráva byla odeslána. Něco se pokazilo. Zkuste to prosím znovu. Please enter a correct Captcha answer.
© 2021 1FIT. All rights reserved.

Publish modules to the "offcanvs" position.

Joomla! konzole ladění chyb

Sezení

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1611539312,
                "last": 1611539312,
                "now": 1611539312
            },
            "token": "1FofDbAXBJNOIAbg0k4RZBErgZ0XYLzP"
        },
        "registry": {
            "com_categories": {
                "categories": {
                    "filter": {
                        "extension": "com_dropfiles"
                    }
                }
            },
            "list": {
                "limit": 100000000
            },
            "com_dropfiles": {
                "categories": {
                    "blog": {
                        "ordercol": null
                    }
                }
            }
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "dropfilesToken": "b1f65e4c1dec534d8cfb71f05f66cfac"
    }
}

Informace o profilu

Čas

Paměť

Čas: 15.16 ms / 15.16 ms Paměť: 1.860 MB / 2.27 MB Application: afterLoad
Čas: 66.57 ms / 81.73 ms Paměť: 5.377 MB / 7.65 MB Application: afterInitialise
Čas: 26.17 ms / 107.89 ms Paměť: 1.566 MB / 9.22 MB Application: afterRoute
Čas: 7.16 ms / 115.06 ms Paměť: 0.191 MB / 9.41 MB Application: beforeRenderComponent com_content
Čas: 5.63 ms / 120.69 ms Paměť: 0.650 MB / 10.06 MB Application: Before Access::preloadComponents (all components)
Čas: 2.48 ms / 123.16 ms Paměť: 0.062 MB / 10.12 MB Application: After Access::preloadComponents (all components)
Čas: 0.03 ms / 123.19 ms Paměť: 0.000 MB / 10.12 MB Application: Before Access::preloadPermissions (com_content)
Čas: 2.04 ms / 125.23 ms Paměť: 0.358 MB / 10.47 MB Application: After Access::preloadPermissions (com_content)
Čas: 0.04 ms / 125.28 ms Paměť: 0.000 MB / 10.45 MB Application: Before Access::getAssetRules (id:27 name:com_content.category.2)
Čas: 0.54 ms / 125.82 ms Paměť: 0.038 MB / 10.49 MB Application: After Access::getAssetRules (id:27 name:com_content.category.2)
Čas: 9.19 ms / 135.01 ms Paměť: 0.323 MB / 10.82 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Čas: 0.06 ms / 135.08 ms Paměť: 0.007 MB / 10.82 MB Application: After Access::getAssetRules (id:8 name:com_content)
Čas: 59.41 ms / 194.49 ms Paměť: 2.392 MB / 13.21 MB Application: Before Access::getAssetRules (id:1254 name:com_dropfiles)
Čas: 0.07 ms / 194.56 ms Paměť: 0.007 MB / 13.22 MB Application: After Access::getAssetRules (id:1254 name:com_dropfiles)
Čas: 19.81 ms / 214.37 ms Paměť: 0.685 MB / 13.91 MB Application: afterRenderComponent com_content
Čas: 1.60 ms / 215.97 ms Paměť: 0.119 MB / 14.03 MB Application: afterDispatch
Čas: 25.65 ms / 241.62 ms Paměť: 0.912 MB / 14.94 MB Application: beforeRenderModule mod_tm_ajax_contact_form (Napište nám)
Čas: 1.79 ms / 243.40 ms Paměť: 0.087 MB / 15.02 MB Application: afterRenderModule mod_tm_ajax_contact_form (Napište nám)
Čas: 0.07 ms / 243.47 ms Paměť: 0.000 MB / 15.02 MB Application: beforeRenderModule mod_menu (Informace)
Čas: 3.91 ms / 247.38 ms Paměť: 0.156 MB / 15.17 MB Application: afterRenderModule mod_menu (Informace)
Čas: 0.06 ms / 247.44 ms Paměť: 0.000 MB / 15.17 MB Application: beforeRenderModule mod_menu (Navigace)
Čas: 1.38 ms / 248.82 ms Paměť: 0.018 MB / 15.19 MB Application: afterRenderModule mod_menu (Navigace)
Čas: 0.06 ms / 248.88 ms Paměť: 0.000 MB / 15.18 MB Application: beforeRenderModule mod_custom (1FIT)
Čas: 0.44 ms / 249.32 ms Paměť: 0.005 MB / 15.19 MB Application: afterRenderModule mod_custom (1FIT)
Čas: 0.06 ms / 249.38 ms Paměť: 0.003 MB / 15.19 MB Application: beforeRenderModule mod_articles_news_adv (Naše tábory)
Čas: 8.20 ms / 257.58 ms Paměť: 0.367 MB / 15.56 MB Application: beforeRenderModule mod_articles_single (Sportjoy galerie)
Čas: 1.59 ms / 259.17 ms Paměť: 0.097 MB / 15.66 MB Application: Before Access::getAssetRules (id:1187 name:com_content.article.341)
Čas: 0.03 ms / 259.20 ms Paměť: 0.002 MB / 15.66 MB Application: After Access::getAssetRules (id:1187 name:com_content.article.341)
Čas: 29.90 ms / 289.09 ms Paměť: 1.506 MB / 17.16 MB Application: afterRenderModule mod_articles_single (Sportjoy galerie)
Čas: 0.27 ms / 289.37 ms Paměť: 0.000 MB / 17.13 MB Application: beforeRenderModule mod_articles_news_adv (Sportjoy ceník)
Čas: 4.55 ms / 293.92 ms Paměť: 0.103 MB / 17.24 MB Application: afterRenderModule mod_articles_news_adv (Sportjoy ceník)
Čas: 0.57 ms / 294.48 ms Paměť: 0.000 MB / 17.17 MB Application: beforeRenderModule mod_articles_single (Babyjoy galerie)
Čas: 0.29 ms / 294.77 ms Paměť: 0.033 MB / 17.21 MB Application: Before Access::getAssetRules (id:1188 name:com_content.article.342)
Čas: 0.03 ms / 294.80 ms Paměť: 0.004 MB / 17.21 MB Application: After Access::getAssetRules (id:1188 name:com_content.article.342)
Čas: 10.58 ms / 305.38 ms Paměť: 0.357 MB / 17.57 MB Application: afterRenderModule mod_articles_single (Babyjoy galerie)
Čas: 0.22 ms / 305.60 ms Paměť: 0.000 MB / 17.54 MB Application: beforeRenderModule mod_articles_news_adv (Babyjoy ceník)
Čas: 4.73 ms / 310.33 ms Paměť: 0.102 MB / 17.64 MB Application: afterRenderModule mod_articles_news_adv (Babyjoy ceník)
Čas: 0.55 ms / 310.88 ms Paměť: 0.000 MB / 17.57 MB Application: beforeRenderModule mod_articles_single (Sportýna galerie)
Čas: 0.25 ms / 311.13 ms Paměť: 0.031 MB / 17.61 MB Application: Before Access::getAssetRules (id:1189 name:com_content.article.343)
Čas: 0.03 ms / 311.16 ms Paměť: 0.002 MB / 17.61 MB Application: After Access::getAssetRules (id:1189 name:com_content.article.343)
Čas: 10.37 ms / 321.53 ms Paměť: 0.343 MB / 17.95 MB Application: afterRenderModule mod_articles_single (Sportýna galerie)
Čas: 0.20 ms / 321.73 ms Paměť: 0.000 MB / 17.92 MB Application: beforeRenderModule mod_articles_news_adv (Sportýna ceník)
Čas: 3.89 ms / 325.62 ms Paměť: 0.074 MB / 17.99 MB Application: afterRenderModule mod_articles_news_adv (Sportýna ceník)
Čas: 0.11 ms / 325.73 ms Paměť: 0.000 MB / 17.88 MB Application: afterRenderModule mod_articles_news_adv (Naše tábory)
Čas: 0.11 ms / 325.84 ms Paměť: 0.000 MB / 17.80 MB Application: beforeRenderModule mod_custom (Termíny)
Čas: 0.22 ms / 326.06 ms Paměť: 0.003 MB / 17.80 MB Application: afterRenderModule mod_custom (Termíny)
Čas: 0.07 ms / 326.12 ms Paměť: 0.004 MB / 17.80 MB Application: beforeRenderModule mod_articles_news_adv (Lokality Tábory)
Čas: 9.64 ms / 335.76 ms Paměť: 0.274 MB / 18.08 MB Application: afterRenderModule mod_articles_news_adv (Lokality Tábory)
Čas: 0.14 ms / 335.91 ms Paměť: 0.000 MB / 17.84 MB Application: beforeRenderModule mod_tm_google_map (Lokality)
Čas: 0.52 ms / 336.43 ms Paměť: 0.027 MB / 17.87 MB Application: afterRenderModule mod_tm_google_map (Lokality)
Čas: 0.06 ms / 336.49 ms Paměť: 0.000 MB / 17.85 MB Application: beforeRenderModule mod_menu (Menu tábory)
Čas: 0.55 ms / 337.05 ms Paměť: 0.012 MB / 17.86 MB Application: afterRenderModule mod_menu (Menu tábory)
Čas: 0.06 ms / 337.11 ms Paměť: 0.000 MB / 17.86 MB Application: beforeRenderModule mod_articles_single (Tábory [intro])
Čas: 0.25 ms / 337.36 ms Paměť: 0.031 MB / 17.89 MB Application: Before Access::getAssetRules (id:1041 name:com_content.article.272)
Čas: 0.03 ms / 337.39 ms Paměť: 0.002 MB / 17.89 MB Application: After Access::getAssetRules (id:1041 name:com_content.article.272)
Čas: 3.08 ms / 340.46 ms Paměť: 0.046 MB / 17.94 MB Application: afterRenderModule mod_articles_single (Tábory [intro])
Čas: 3.26 ms / 343.73 ms Paměť: 0.145 MB / 18.09 MB Application: afterRender

Celkem dotazů do databáze: 113.16 ms

Využití paměti

19,71 MB (20.670.856 Bytů)

Dotazy do databáze

110 zaznamenaných dotazů 113.16 ms


Nalezeno 54 duplikátů!

2 duplikátů: #20  #21
2 duplikátů: #22  #23
2 duplikátů: #25  #26
2 duplikátů: #41  #42
2 duplikátů: #43  #44
2 duplikátů: #45  #46
2 duplikátů: #47  #48
2 duplikátů: #49  #50
3 duplikátů: #51  #52  #53
2 duplikátů: #54  #55
3 duplikátů: #57  #79  #101
2 duplikátů: #63  #64
2 duplikátů: #65  #66
2 duplikátů: #67  #68
2 duplikátů: #69  #70
2 duplikátů: #71  #72
3 duplikátů: #73  #74  #75
2 duplikátů: #76  #77
2 duplikátů: #85  #86
2 duplikátů: #87  #88
2 duplikátů: #89  #90
2 duplikátů: #91  #92
2 duplikátů: #93  #94
3 duplikátů: #95  #96  #97
2 duplikátů: #98  #99
  1. Čas pro dotazy: 2.07 ms Dotaz paměti: 0.036 MB Paměť před dotazem: 4.423 MB Vráceno řádků: 43
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

      FROM `jom_extensions`

      WHERE `type` = 'component' 
      AND `state` = 0 
      AND `enabled` = 1
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjom_extensionsNULLrefextensionextension82const431.00Using where
    Profil
    Bez ZOBRAZENÍ PROFILU (třeba proto, že existuje více než 100 dotazů)
    Stack volání
    #VolajícíSoubor a číslo řádku
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    11JDatabaseDriver->loadObjectList()JROOT/libraries/src/Component/ComponentHelper.php:445
    10Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()Stejné jako volání v řádku níže.
    9call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    8Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Component/ComponentHelper.php:453
    7Joomla\CMS\Component\ComponentHelper::load()JROOT/libraries/src/Component/ComponentHelper.php:519
    6Joomla\CMS\Component\ComponentHelper::getComponents()JROOT/libraries/src/Component/ComponentHelper.php:44
    5Joomla\CMS\Component\ComponentHelper::getComponent()JROOT/libraries/src/Component/ComponentHelper.php:103
    4Joomla\CMS\Component\ComponentHelper::getParams()JROOT/libraries/src/Application/SiteApplication.php:594
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]
  2. Čas pro dotazy: 1.60 ms Po posledním dotazu: 2.22 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 4.728 MB Vráceno řádků: 5
    SELECT id, rules

      FROM `jom_viewlevels`
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjom_viewlevelsNULLALLNULLMOHL BY BÝT POUŽIT NO INDEX KEYNULLNULL5100.00NULL
    Profil
    Bez ZOBRAZENÍ PROFILU (třeba proto, že existuje více než 100 dotazů)
    Stack volání
    #VolajícíSoubor a číslo řádku
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1506
    9JDatabaseDriver->loadAssocList()JROOT/libraries/src/Access/Access.php:1063
    8Joomla\CMS\Access\Access::getAuthorisedViewLevels()JROOT/libraries/src/User/User.php:458
    7Joomla\CMS\User\User->getAuthorisedViewLevels()JROOT/libraries/src/Plugin/PluginHelper.php:321
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]
  3. Čas pro dotazy: 1.97 ms Po posledním dotazu: 0.10 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 4.740 MB Vráceno řádků: 2
    SELECT b.id

      FROM jom_usergroups AS a

      LEFT JOIN jom_usergroups AS b 
      ON b.lft <= a.lft 
      AND b.rgt >= a.rgt

      WHERE a.id = 9
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLconstPRIMARYPRIMARY4const1100.00NULL
    1SIMPLEbNULLrangeidx_usergroup_nested_set_lookupidx_usergroup_nested_set_lookup4NULL2100.00Using where; Using index
    Profil
    Bez ZOBRAZENÍ PROFILU (třeba proto, že existuje více než 100 dotazů)
    Stack volání
    #VolajícíSoubor a číslo řádku
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1550
    10JDatabaseDriver->loadColumn()JROOT/libraries/src/Access/Access.php:980
    9Joomla\CMS\Access\Access::getGroupsByUser()JROOT/libraries/src/Access/Access.php:1095
    8Joomla\CMS\Access\Access::getAuthorisedViewLevels()JROOT/libraries/src/User/User.php:458
    7Joomla\CMS\User\User->getAuthorisedViewLevels()JROOT/libraries/src/Plugin/PluginHelper.php:321
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]
  4. Čas pro dotazy: 1.32 ms Po posledním dotazu: 0.69 ms Dotaz paměti: 0.035 MB Paměť před dotazem: 4.811 MB Vráceno řádků: 113
    SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

      FROM jom_extensions

      WHERE enabled = 1 
      AND type = 'plugin' 
      AND state IN (0,1) 
      AND access IN (1,1,5)

      ORDER BY ordering
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjom_extensionsNULLrefextensionextension82const1640.60Using where; Použití filesort
    Profil
    Bez ZOBRAZENÍ PROFILU (třeba proto, že existuje více než 100 dotazů)
    Stack volání
    #VolajícíSoubor a číslo řádku
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    10JDatabaseDriver->loadObjectList()JROOT/libraries/src/Plugin/PluginHelper.php:354
    9Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()Stejné jako volání v řádku níže.
    8call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    7Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Plugin/PluginHelper.php:359
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]
  5. Čas pro dotazy: 3.89 ms Po posledním dotazu: 27.09 ms Dotaz paměti: 0.150 MB Paměť před dotazem: 7.013 MB Vráceno řádků: 116
    SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

      FROM jom_menu AS m

      LEFT JOIN jom_extensions AS e 
      ON m.component_id = e.extension_id

      WHERE m.published = 1 
      AND m.parent_id > 0 
      AND m.client_id = 0

      ORDER BY m.lft
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLALLidx_client_id_parent_id_alias_languageMOHL BY BÝT POUŽIT NO INDEX KEYNULLNULL2306.48Using where; Použití filesort
    1SIMPLEeNULLeq_refPRIMARYPRIMARY4dp_www_1fit.m.component_id1100.00Using where
    Profil
    Bez ZOBRAZENÍ PROFILU (třeba proto, že existuje více než 100 dotazů)
    Stack volání
    #VolajícíSoubor a číslo řádku
    23JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    22JDatabaseDriver->loadObjectList()JROOT/libraries/src/Menu/SiteMenu.php:93
    21Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()Stejné jako volání v řádku níže.
    20call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    19Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Menu/SiteMenu.php:101
    18Joomla\CMS\Menu\SiteMenu->load()JROOT/libraries/src/Menu/AbstractMenu.php:76
    17Joomla\CMS\Menu\AbstractMenu->__construct()JROOT/libraries/src/Menu/SiteMenu.php:62
    16Joomla\CMS\Menu\SiteMenu->__construct()JROOT/libraries/src/Menu/AbstractMenu.php:131
    15Joomla\CMS\Menu\AbstractMenu::getInstance()JROOT/libraries/src/Application/CMSApplication.php:375
    14Joomla\CMS\Application\CMSApplication->getMenu()JROOT/libraries/src/Application/SiteApplication.php:275
    13Joomla\CMS\Application\SiteApplication->getMenu()JROOT/libraries/src/Router/SiteRouter.php:64
    12Joomla\CMS\Router\SiteRouter->__construct()JROOT/libraries/src/Router/Router.php:189
    11Joomla\CMS\Router\Router::getInstance()JROOT/libraries/src/Application/CMSApplication.php:491
    10Joomla\CMS\Application\CMSApplication::getRouter()JROOT/libraries/src/Application/SiteApplication.php:403
    9Joomla\CMS\Application\SiteApplication::getRouter()JROOT/plugins/system/dropfiles/dropfiles.php:37
    8PlgSystemDropfiles->onAfterInitialise()JROOT/libraries/joomla/event/event.php:70
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    6JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    5Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:626
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]
  6. Čas pro dotazy: 1.77 ms Po posledním dotazu: 12.16 ms Dotaz paměti: 0.029 MB Paměť před dotazem: 8.582 MB Vráceno řádků: 2
    SHOW FULL COLUMNS 
      FROM `jom_komento_configs`
    Vysvětlení
    VYSVĚTLENÍ není možné pro dotaz: SHOW FULL COLUMNS FROM `jom_komento_configs`
    Profil
    Bez ZOBRAZENÍ PROFILU (třeba proto, že existuje více než 100 dotazů)
    Stack volání
    #VolajícíSoubor a číslo řádku
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/database/driver/mysqli.php:445
    17JDatabaseDriverMysqli->getTableColumns()JROOT/libraries/src/Table/Table.php:245
    16Joomla\CMS\Table\Table->getFields()JROOT/libraries/src/Table/Table.php:164
    15Joomla\CMS\Table\Table->__construct()JROOT/administrator/components/com_komento/tables/parent.php:18
    14KomentoParentTable->__construct()JROOT/administrator/components/com_komento/tables/configs.php:40
    13KomentoTableConfigs->__construct()JROOT/libraries/src/Table/Table.php:312
    12Joomla\CMS\Table\Table::getInstance()JROOT/administrator/components/com_komento/tables/parent.php:49
    11KomentoParentTable::getInstance()JROOT/components/com_komento/helpers/helper.php:99
    10Komento::getTable()JROOT/components/com_komento/helpers/helper.php:228
    9Komento::getKonfig()JROOT/components/com_komento/bootstrap.php:30
    8require_once JROOT/components/com_komento/bootstrap.phpJROOT/components/com_komento/router.php:16
    7require_once JROOT/components/com_komento/router.phpJROOT/libraries/src/Router/SiteRouter.php:775
    6Joomla\CMS\Router\SiteRouter->getComponentRouter()JROOT/libraries/src/Router/SiteRouter.php:130
    5Joomla\CMS\Router\SiteRouter->parse()JROOT/libraries/src/Application/CMSApplication.php:1077
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:796
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]
  7. Čas pro dotazy: 0.94 ms Po posledním dotazu: 0.59 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 8.615 MB Vráceno řádků: 1
    SELECT *

      FROM jom_komento_configs

      WHERE `component` = 'com_komento'
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjom_komento_configsNULLALLNULLMOHL BY BÝT POUŽIT NO INDEX KEYNULLNULL520.00Using where
    Profil
    Bez ZOBRAZENÍ PROFILU (třeba proto, že existuje více než 100 dotazů)
    Stack volání
    #VolajícíSoubor a číslo řádku
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1465
    11JDatabaseDriver->loadAssoc()JROOT/libraries/src/Table/Table.php:731
    10Joomla\CMS\Table\Table->load()JROOT/components/com_komento/helpers/helper.php:229
    9Komento::getKonfig()JROOT/components/com_komento/bootstrap.php:30
    8require_once JROOT/components/com_komento/bootstrap.phpJROOT/components/com_komento/router.php:16
    7require_once JROOT/components/com_komento/router.phpJROOT/libraries/src/Router/SiteRouter.php:775
    6Joomla\CMS\Router\SiteRouter->getComponentRouter()JROOT/libraries/src/Router/SiteRouter.php:130
    5Joomla\CMS\Router\SiteRouter->parse()JROOT/libraries/src/Application/CMSApplication.php:1077
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:796
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]
  8. Čas pro dotazy: 0.42 ms Po posledním dotazu: 6.66 ms Dotaz paměti: 0.027 MB Paměť před dotazem: 9.019 MB Vráceno řádků: 1
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

      FROM `jom_extensions`

      WHERE `type` = 'library' 
      AND `element` = 'joomla'
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjom_extensionsNULLrefelement_clientid,element_folder_clientid,extensionextension484const,const1100.00NULL
    Profil
    Bez ZOBRAZENÍ PROFILU (třeba proto, že existuje více než 100 dotazů)
    Stack volání
    #VolajícíSoubor a číslo řádku
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    18JDatabaseDriver->loadObject()JROOT/libraries/src/Helper/LibraryHelper.php:167
    17Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()Stejné jako volání v řádku níže.
    16call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/LibraryHelper.php:175
    14Joomla\CMS\Helper\LibraryHelper::loadLibrary()JROOT/libraries/src/Helper/LibraryHelper.php:43
    13Joomla\CMS\Helper\LibraryHelper::getLibrary()JROOT/libraries/src/Helper/LibraryHelper.php:90
    12Joomla\CMS\Helper\LibraryHelper::getParams()JROOT/libraries/src/Version.php:321
    11Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    10Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    9Joomla\CMS\Factory::getDocument()JROOT/plugins/system/helixultimate/helixultimate.php:134
    8plgSystemHelixultimate->onAfterRoute()JROOT/libraries/joomla/event/event.php:70
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    6JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    5Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:1125
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:796
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]
  9. Čas pro dotazy: 3.61 ms Po posledním dotazu: 0.18 ms Dotaz paměti: 0.006 MB Paměť před dotazem: 9.012 MB
    UPDATE `jom_extensions`

      SET `params` = '{\"mediaversion\":\"dbae32351c7973b898f6b8b2cc4f447d\"}'

      WHERE `type` = 'library' 
      AND `element` = 'joomla'
    Vysvětlení
    VYSVĚTLENÍ není možné pro dotaz: UPDATE `jom_extensions` SET `params` = '{\"mediaversion\":\"dbae32351c7973b898f6b8b2cc4f447d\"}' WHERE `type` = 'library' AND `element` = 'joomla'
    Profil
    Bez ZOBRAZENÍ PROFILU (třeba proto, že existuje více než 100 dotazů)
    Stack volání
    #VolajícíSoubor a číslo řádku
    14JDatabaseDriverMysqli->execute()JROOT/libraries/src/Helper/LibraryHelper.php:117
    13Joomla\CMS\Helper\LibraryHelper::saveParams()JROOT/libraries/src/Version.php:372
    12Joomla\CMS\Version->setMediaVersion()JROOT/libraries/src/Version.php:331
    11Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    10Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    9Joomla\CMS\Factory::getDocument()JROOT/plugins/system/helixultimate/helixultimate.php:134
    8plgSystemHelixultimate->onAfterRoute()JROOT/libraries/joomla/event/event.php:70
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    6JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    5Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:1125
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:796
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]
  10. Čas pro dotazy: 2.39 ms Po posledním dotazu: 2.11 ms Dotaz paměti: 0.025 MB Paměť před dotazem: 9.296 MB Vráceno řádků: 1
    SELECT *

      FROM jom_languages

      WHERE published=1

      ORDER BY ordering ASC
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjom_languagesNULLALLNULLMOHL BY BÝT POUŽIT NO INDEX KEYNULLNULL1100.00Using where; Použití filesort
    Profil
    Bez ZOBRAZENÍ PROFILU (třeba proto, že existuje více než 100 dotazů)
    Stack volání
    #VolajícíSoubor a číslo řádku
    7JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    6JDatabaseDriver->loadObjectList()JROOT/libraries/src/Language/LanguageHelper.php:150
    5Joomla\CMS\Language\LanguageHelper::getLanguages()JROOT/libraries/src/Application/SiteApplication.php:330
    4Joomla\CMS\Application\SiteApplication->getParams()JROOT/libraries/src/Application/SiteApplication.php:138
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]
  11. Čas pro dotazy: 2.06 ms Po posledním dotazu: 0.30 ms Dotaz paměti: 0.143 MB Paměť před dotazem: 9.314 MB Vráceno řádků: 11
    SELECT id, home, template, s.params

      FROM jom_template_styles as s

      LEFT JOIN jom_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id

      WHERE s.client_id = 0 
      AND e.enabled = 1
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEeNULLrefelement_clientid,element_folder_clientid,extensionextension82const61.00Using index condition; Using where
    1SIMPLEsNULLrefidx_template,idx_client_id,idx_client_id_homeidx_template202dp_www_1fit.e.element285.71Using index condition; Using where
    Profil
    Bez ZOBRAZENÍ PROFILU (třeba proto, že existuje více než 100 dotazů)
    Stack volání
    #VolajícíSoubor a číslo řádku
    6JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    5JDatabaseDriver->loadObjectList()JROOT/libraries/src/Application/SiteApplication.php:486
    4Joomla\CMS\Application\SiteApplication->getTemplate()JROOT/libraries/src/Application/SiteApplication.php:168
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]
  12. Čas pro dotazy: 2.21 ms Po posledním dotazu: 7.97 ms Dotaz paměti: 0.032 MB Paměť před dotazem: 10.061 MB Vráceno řádků: 43
    SELECT `id`,`name`,`rules`,`parent_id`

      FROM `jom_assets`

      WHERE `name` IN ('root.1','com_actionlogs','com_acym','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_dropfiles','com_droppics','com_fields','com_finder','com_installer','com_jce','com_joomgallery','com_joomlaupdate','com_komento','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_slogin','com_tags','com_templates','com_users','com_weblinks','com_wrapper')
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjom_assetsNULLrangeidx_asset_nameidx_asset_name202NULL44100.00Using index condition
    Profil
    StatusDuration
    starting0.07 ms
    Executing hook on transaction 0.00 ms
    starting0.01 ms
    checking permissions0.00 ms
    Opening tables1.21 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.14 ms
    preparing0.02 ms
    executing0.53 ms
    end0.01 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    closing tables0.02 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    19JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:429
    18Joomla\CMS\Access\Access::preloadComponents()JROOT/libraries/src/Access/Access.php:213
    17Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:531
    16Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
    15Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
    14Joomla\CMS\User\User->authorise()JROOT/components/com_content/models/category.php:139
    13ContentModelCategory->populateState()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
    12Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()JROOT/libraries/src/MVC/View/CategoryView.php:116
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]
  13. Čas pro dotazy: 1.18 ms Po posledním dotazu: 0.24 ms Dotaz paměti: 0.084 MB Paměť před dotazem: 10.116 MB Vráceno řádků: 455
    SELECT `id`,`name`,`rules`,`parent_id`

      FROM `jom_assets`

      WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjom_assetsNULLALLidx_asset_name,idx_parent_idMOHL BY BÝT POUŽIT NO INDEX KEYNULLNULL76920.73Using where
    Profil
    StatusDuration
    starting0.04 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.02 ms
    executing0.78 ms
    end0.01 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    19JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:359
    18Joomla\CMS\Access\Access::preloadPermissions()JROOT/libraries/src/Access/Access.php:226
    17Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:540
    16Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
    15Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
    14Joomla\CMS\User\User->authorise()JROOT/components/com_content/models/category.php:139
    13ContentModelCategory->populateState()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
    12Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()JROOT/libraries/src/MVC/View/CategoryView.php:116
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]
  14. Čas pro dotazy: 6.05 ms Po posledním dotazu: 2.47 ms Dotaz paměti: 0.037 MB Paměť před dotazem: 10.553 MB Vráceno řádků: 2
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,(
SELECT COUNT(i.`id`)

      FROM `jom_content` AS `i`

      WHERE i.`catid` = c.id 
      AND i.state = 1) AS numitems

      FROM `jom_categories` AS `s`

      INNER JOIN `jom_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)

      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.published = 1 
      AND s.id = 2

      ORDER BY c.lft
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1PRIMARYsNULLconstPRIMARY,idx_left_rightPRIMARY4const1100.00NULL
    1PRIMARYcNULLrangecat_idx,idx_left_rightidx_left_right4NULL843.52Using index condition; Using where
    2DEPENDENT SUBQUERYiNULLrefidx_state,idx_catididx_catid4dp_www_1fit.c.id3100.00Using index condition; Using where
    Profil
    StatusDuration
    starting0.14 ms
    Executing hook on transaction 0.00 ms
    starting0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables5.03 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.12 ms
    preparing0.03 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.02 ms
    executing0.06 ms
    executing0.04 ms
    executing0.11 ms
    end0.01 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    closing tables0.16 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    16JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
    15Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
    14Joomla\CMS\Categories\Categories->get()JROOT/components/com_content/models/category.php:355
    13ContentModelCategory->getCategory()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:122
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]
  15. Čas pro dotazy: 8.88 ms Po posledním dotazu: 2.19 ms Dotaz paměti: 0.093 MB Paměť před dotazem: 10.819 MB Vráceno řádků: 12
    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

      FROM jom_content AS a

      LEFT JOIN jom_categories AS c 
      ON c.id = a.catid

      LEFT JOIN jom_users AS ua 
      ON ua.id = a.created_by

      LEFT JOIN jom_users AS uam 
      ON uam.id = a.modified_by

      LEFT JOIN jom_categories as parent 
      ON parent.id = c.parent_id

      LEFT JOIN jom_content_rating AS v 
      ON a.id = v.content_id

      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND (a.catid = 2 OR a.catid IN (
SELECT sub.id

      FROM jom_categories as sub

      INNER JOIN jom_categories as this 
      ON sub.lft > this.lft 
      AND sub.rgt < this.rgt

      WHERE this.id = 2)) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-01-25 01:48:32') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-25 01:48:32')

      ORDER BY  c.lft,  a.ordering,  a.created
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1PRIMARYcNULLALLPRIMARY,idx_accessMOHL BY BÝT POUŽIT NO INDEX KEYNULLNULL10810.00Using where; Using temporary; Použití filesort
    1PRIMARYaNULLrefidx_access,idx_state,idx_catididx_catid4dp_www_1fit.c.id316.00Using index condition; Using where
    1PRIMARYuaNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.created_by1100.00Using where
    1PRIMARYuamNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.modified_by1100.00Using where
    1PRIMARYparentNULLeq_refPRIMARYPRIMARY4dp_www_1fit.c.parent_id1100.00Using where
    1PRIMARYvNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.id1100.00Using where
    2DEPENDENT SUBQUERYthisNULLconstPRIMARY,idx_left_rightPRIMARY4const1100.00NULL
    2DEPENDENT SUBQUERYsubNULLeq_refPRIMARY,idx_left_rightPRIMARY4func130.86Using where
    Profil
    StatusDuration
    executing0.02 ms
    executing0.02 ms
    executing0.01 ms
    executing0.01 ms
    executing0.01 ms
    executing0.01 ms
    executing0.01 ms
    executing0.01 ms
    executing0.02 ms
    executing0.02 ms
    executing0.02 ms
    executing0.02 ms
    executing0.02 ms
    executing0.02 ms
    executing0.03 ms
    executing0.02 ms
    executing0.01 ms
    executing0.02 ms
    executing0.02 ms
    executing0.02 ms
    executing0.02 ms
    executing0.02 ms
    executing0.02 ms
    executing0.01 ms
    executing0.01 ms
    executing0.03 ms
    executing0.02 ms
    executing0.02 ms
    executing0.02 ms
    executing0.01 ms
    executing0.01 ms
    executing0.01 ms
    executing0.01 ms
    executing0.01 ms
    executing0.02 ms
    executing0.02 ms
    executing0.01 ms
    executing0.01 ms
    executing0.02 ms
    executing0.02 ms
    executing0.01 ms
    executing0.02 ms
    executing0.01 ms
    executing0.01 ms
    executing0.03 ms
    executing0.02 ms
    executing0.01 ms
    executing0.01 ms
    executing0.01 ms
    executing0.02 ms
    executing0.02 ms
    executing0.01 ms
    executing0.01 ms
    executing0.01 ms
    executing0.01 ms
    executing0.02 ms
    executing0.02 ms
    executing0.02 ms
    executing0.01 ms
    executing0.01 ms
    executing0.02 ms
    executing0.02 ms
    executing0.02 ms
    executing0.01 ms
    executing0.02 ms
    executing0.02 ms
    executing0.02 ms
    executing0.01 ms
    executing0.01 ms
    executing0.01 ms
    executing0.01 ms
    executing0.01 ms
    executing0.02 ms
    executing0.02 ms
    executing0.02 ms
    executing0.02 ms
    executing0.02 ms
    executing0.02 ms
    executing0.01 ms
    executing0.02 ms
    executing0.02 ms
    executing0.01 ms
    executing0.01 ms
    executing0.01 ms
    executing0.02 ms
    executing0.02 ms
    executing0.01 ms
    executing0.02 ms
    executing0.02 ms
    executing0.02 ms
    executing0.01 ms
    executing0.14 ms
    end0.00 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    removing tmp table0.01 ms
    waiting for handler commit0.01 ms
    closing tables0.05 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    17JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    16Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/components/com_content/models/articles.php:576
    14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    13ContentModelCategory->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:144
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]
  16. Čas pro dotazy: 4.64 ms Po posledním dotazu: 2.57 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 11.296 MB Vráceno řádků: 1
    SELECT COUNT(*)

      FROM jom_content AS a

      LEFT JOIN jom_categories AS c 
      ON c.id = a.catid

      LEFT JOIN jom_users AS ua 
      ON ua.id = a.created_by

      LEFT JOIN jom_users AS uam 
      ON uam.id = a.modified_by

      LEFT JOIN jom_categories as parent 
      ON parent.id = c.parent_id

      LEFT JOIN jom_content_rating AS v 
      ON a.id = v.content_id

      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND (a.catid = 2 OR a.catid IN (
SELECT sub.id

      FROM jom_categories as sub

      INNER JOIN jom_categories as this 
      ON sub.lft > this.lft 
      AND sub.rgt < this.rgt

      WHERE this.id = 2)) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-01-25 01:48:32') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-25 01:48:32')
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1PRIMARYcNULLALLPRIMARY,idx_accessMOHL BY BÝT POUŽIT NO INDEX KEYNULLNULL10810.00Using where
    1PRIMARYaNULLrefidx_access,idx_state,idx_catididx_catid4dp_www_1fit.c.id316.00Using index condition; Using where
    1PRIMARYuaNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.created_by1100.00Using where; Using index
    1PRIMARYuamNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.modified_by1100.00Using where; Using index
    1PRIMARYparentNULLeq_refPRIMARYPRIMARY4dp_www_1fit.c.parent_id1100.00Using where; Using index
    1PRIMARYvNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.id1100.00Using where; Using index
    2DEPENDENT SUBQUERYthisNULLconstPRIMARY,idx_left_rightPRIMARY4const1100.00NULL
    2DEPENDENT SUBQUERYsubNULLeq_refPRIMARY,idx_left_rightPRIMARY4func130.86Using where
    Profil
    StatusDuration
    executing0.01 ms
    executing0.01 ms
    executing0.03 ms
    executing0.01 ms
    executing0.01 ms
    executing0.01 ms
    executing0.03 ms
    executing0.01 ms
    executing0.01 ms
    executing0.01 ms
    executing0.02 ms
    executing0.03 ms
    executing0.01 ms
    executing0.02 ms
    executing0.01 ms
    executing0.02 ms
    executing0.04 ms
    executing0.01 ms
    executing0.01 ms
    executing0.03 ms
    executing0.01 ms
    executing0.01 ms
    executing0.01 ms
    executing0.03 ms
    executing0.01 ms
    executing0.01 ms
    executing0.01 ms
    executing0.04 ms
    executing0.01 ms
    executing0.03 ms
    executing0.01 ms
    executing0.01 ms
    executing0.01 ms
    executing0.03 ms
    executing0.01 ms
    executing0.01 ms
    executing0.01 ms
    executing0.02 ms
    executing0.01 ms
    executing0.01 ms
    executing0.03 ms
    executing0.01 ms
    executing0.01 ms
    executing0.01 ms
    executing0.02 ms
    executing0.01 ms
    executing0.04 ms
    executing0.01 ms
    executing0.01 ms
    executing0.01 ms
    executing0.01 ms
    executing0.03 ms
    executing0.01 ms
    executing0.01 ms
    executing0.01 ms
    executing0.02 ms
    executing0.01 ms
    executing0.03 ms
    executing0.01 ms
    executing0.01 ms
    executing0.01 ms
    executing0.02 ms
    executing0.03 ms
    executing0.01 ms
    executing0.01 ms
    executing0.01 ms
    executing0.02 ms
    executing0.03 ms
    executing0.01 ms
    executing0.01 ms
    executing0.01 ms
    executing0.02 ms
    executing0.01 ms
    executing0.01 ms
    executing0.03 ms
    executing0.01 ms
    executing0.01 ms
    executing0.02 ms
    executing0.03 ms
    executing0.01 ms
    executing0.01 ms
    executing0.03 ms
    executing0.01 ms
    executing0.01 ms
    executing0.01 ms
    executing0.03 ms
    executing0.01 ms
    executing0.01 ms
    executing0.01 ms
    executing0.02 ms
    executing0.03 ms
    executing0.01 ms
    executing0.01 ms
    executing0.02 ms
    end0.00 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    17JDatabaseDriver->loadResult()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340
    16Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()JROOT/libraries/src/MVC/Model/ListModel.php:282
    15Joomla\CMS\MVC\Model\ListModel->getTotal()JROOT/libraries/src/MVC/Model/ListModel.php:232
    14Joomla\CMS\MVC\Model\ListModel->getPagination()JROOT/components/com_content/models/category.php:265
    13ContentModelCategory->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:144
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]
  17. Čas pro dotazy: 5.09 ms Po posledním dotazu: 1.87 ms Dotaz paměti: 0.035 MB Paměť před dotazem: 11.463 MB Vráceno řádků: 0
    SELECT `m`.`tag_id`,`t`.*

      FROM `jom_contentitem_tag_map` AS m 

      INNER JOIN `jom_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`

      WHERE `m`.`type_alias` = 'com_content.category' 
      AND `m`.`content_item_id` = 2 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLALLidx_tag_typeMOHL BY BÝT POUŽIT NO INDEX KEYNULLNULL185.56Using where
    1SIMPLEtNULLeq_refPRIMARY,tag_idx,idx_accessPRIMARY4dp_www_1fit.m.tag_id1100.00Using where
    Profil
    StatusDuration
    starting0.06 ms
    Executing hook on transaction 0.00 ms
    starting0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables4.54 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.08 ms
    preparing0.02 ms
    executing0.05 ms
    end0.00 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    closing tables0.10 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    13JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    12Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/libraries/src/MVC/View/CategoryView.php:229
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]
  18. Čas pro dotazy: 0.69 ms Po posledním dotazu: 6.91 ms Dotaz paměti: 0.038 MB Paměť před dotazem: 12.094 MB Vráceno řádků: 2
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

      FROM `jom_categories` AS `s`

      INNER JOIN `jom_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)

      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 2

      ORDER BY c.lft
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEsNULLconstPRIMARY,idx_left_rightPRIMARY4const1100.00NULL
    1SIMPLEcNULLrangecat_idx,idx_access,idx_left_rightidx_left_right4NULL845.37Using index condition; Using where
    Profil
    StatusDuration
    starting0.12 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.06 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.15 ms
    preparing0.04 ms
    executing0.08 ms
    end0.01 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    20JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
    19Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
    18Joomla\CMS\Categories\Categories->get()JROOT/administrator/components/com_fields/models/fields.php:203
    17FieldsModelFields->getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:133
    16Joomla\CMS\MVC\Model\ListModel->_getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:187
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    13PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]
  19. Čas pro dotazy: 7.10 ms Po posledním dotazu: 0.17 ms Dotaz paměti: 0.037 MB Paměť před dotazem: 12.111 MB Vráceno řádků: 0
    SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

      FROM jom_fields AS a

      LEFT JOIN `jom_languages` AS l 
      ON l.lang_code = a.language

      LEFT JOIN jom_users AS uc 
      ON uc.id=a.checked_out

      LEFT JOIN jom_viewlevels AS ag 
      ON ag.id = a.access

      LEFT JOIN jom_users AS ua 
      ON ua.id = a.created_user_id

      LEFT JOIN jom_fields_groups AS g 
      ON g.id = a.group_id

      LEFT JOIN `jom_fields_categories` AS fc 
      ON fc.field_id = a.id

      WHERE a.context = 'com_content.article' 
      AND (fc.category_id IS NULL OR fc.category_id IN (2,0)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)

      ORDER BY a.ordering ASC
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLrefidx_state,idx_access,idx_contextidx_state1const1100.00Using where; Using temporary; Použití filesort
    1SIMPLElNULLeq_refidx_langcodeidx_langcode28dp_www_1fit.a.language1100.00Using where
    1SIMPLEucNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.checked_out1100.00NULL
    1SIMPLEagNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.access1100.00Using where
    1SIMPLEuaNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.created_user_id1100.00Using where
    1SIMPLEgNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.group_id1100.00Using where
    1SIMPLEfcNULLrefPRIMARYPRIMARY4dp_www_1fit.a.id1100.00Using where; Using index; Distinct
    Profil
    StatusDuration
    starting0.17 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables6.19 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.03 ms
    statistics0.17 ms
    preparing0.04 ms
    Creating tmp table0.07 ms
    executing0.07 ms
    end0.01 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    removing tmp table0.01 ms
    waiting for handler commit0.01 ms
    closing tables0.10 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    17Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    16FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    13PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]
  20. Čas pro dotazy: 1.43 ms Po posledním dotazu: 8.26 ms Dotaz paměti: 0.028 MB Paměť před dotazem: 12.824 MB Vráceno řádků: 1
    Duplicitní dotazy: #21
    SELECT a.level, a.id, a.title, a.parent_id, a.access, a.created_user_id,b.title as parent_title,b.id as parent_id,c.type, c.cloud_id

      FROM jom_categories as a

      LEFT 
      OUTER JOIN jom_categories AS b 
      ON b.id=a.parent_id 
      AND b.extension='com_dropfiles'

      LEFT 
      OUTER JOIN jom_dropfiles AS c 
      ON c.id=a.id

      WHERE a.published=1 
      AND a.extension='com_dropfiles' 
      AND a.id=134
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLconstPRIMARY,cat_idxPRIMARY4const1100.00NULL
    1SIMPLEbNULLconstPRIMARY,cat_idxPRIMARY4const1100.00Impossible ON condition
    1SIMPLEcNULLsystemidMOHL BY BÝT POUŽIT NO INDEX KEYNULLNULL1100.00NULL
    Profil
    StatusDuration
    starting0.08 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.97 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.10 ms
    preparing0.01 ms
    executing0.01 ms
    end0.00 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    closing tables0.02 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/database.php:33
    17JDatabase->query()JROOT/components/com_dropfiles/models/frontcategory.php:57
    16DropfilesModelFrontcategory->getCategory()JROOT/plugins/content/dropfiles/dropfiles.php:237
    15PlgContentdropfiles->replace()Stejné jako volání v řádku níže.
    14preg_replace_callback()JROOT/plugins/content/dropfiles/dropfiles.php:55
    13PlgContentdropfiles->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]
  21. Čas pro dotazy: 0.41 ms Po posledním dotazu: 0.07 ms Dotaz paměti: 0.028 MB Paměť před dotazem: 12.833 MB Vráceno řádků: 1
    Duplicitní dotazy: #20
    SELECT a.level, a.id, a.title, a.parent_id, a.access, a.created_user_id,b.title as parent_title,b.id as parent_id,c.type, c.cloud_id

      FROM jom_categories as a

      LEFT 
      OUTER JOIN jom_categories AS b 
      ON b.id=a.parent_id 
      AND b.extension='com_dropfiles'

      LEFT 
      OUTER JOIN jom_dropfiles AS c 
      ON c.id=a.id

      WHERE a.published=1 
      AND a.extension='com_dropfiles' 
      AND a.id=134
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLconstPRIMARY,cat_idxPRIMARY4const1100.00NULL
    1SIMPLEbNULLconstPRIMARY,cat_idxPRIMARY4const1100.00Impossible ON condition
    1SIMPLEcNULLsystemidMOHL BY BÝT POUŽIT NO INDEX KEYNULLNULL1100.00NULL
    Profil
    StatusDuration
    starting0.07 ms
    Executing hook on transaction 0.00 ms
    starting0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.03 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.07 ms
    preparing0.01 ms
    executing0.01 ms
    end0.00 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    17JDatabaseDriver->loadObject()JROOT/components/com_dropfiles/models/frontcategory.php:58
    16DropfilesModelFrontcategory->getCategory()JROOT/plugins/content/dropfiles/dropfiles.php:237
    15PlgContentdropfiles->replace()Stejné jako volání v řádku níže.
    14preg_replace_callback()JROOT/plugins/content/dropfiles/dropfiles.php:55
    13PlgContentdropfiles->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]
  22. Čas pro dotazy: 0.32 ms Po posledním dotazu: 1.98 ms Dotaz paměti: 0.028 MB Paměť před dotazem: 13.042 MB Vráceno řádků: 1
    Duplicitní dotazy: #23
    SELECT rgt,lft 
      FROM jom_categories 
      WHERE id=134 
      AND extension='com_dropfiles'
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjom_categoriesNULLconstPRIMARY,cat_idxPRIMARY4const1100.00NULL
    Profil
    StatusDuration
    starting0.04 ms
    Executing hook on transaction 0.00 ms
    starting0.01 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.01 ms
    executing0.01 ms
    end0.00 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    22JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/database.php:33
    21JDatabase->query()JROOT/administrator/components/com_dropfiles/models/categories.php:121
    20DropfilesModelCategories->getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:133
    19Joomla\CMS\MVC\Model\ListModel->_getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:187
    18Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_categories/models/categories.php:354
    17CategoriesModelCategories->getItems()JROOT/components/com_dropfiles/models/frontcategories.php:99
    16DropfilesModelFrontcategories->getItems()JROOT/plugins/content/dropfiles/dropfiles.php:242
    15PlgContentdropfiles->replace()Stejné jako volání v řádku níže.
    14preg_replace_callback()JROOT/plugins/content/dropfiles/dropfiles.php:55
    13PlgContentdropfiles->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]
  23. Čas pro dotazy: 0.31 ms Po posledním dotazu: 0.05 ms Dotaz paměti: 0.028 MB Paměť před dotazem: 13.052 MB Vráceno řádků: 1
    Duplicitní dotazy: #22
    SELECT rgt,lft 
      FROM jom_categories 
      WHERE id=134 
      AND extension='com_dropfiles'
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjom_categoriesNULLconstPRIMARY,cat_idxPRIMARY4const1100.00NULL
    Profil
    StatusDuration
    starting0.04 ms
    Executing hook on transaction 0.00 ms
    starting0.01 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.01 ms
    end0.00 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    22JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    21JDatabaseDriver->loadObject()JROOT/administrator/components/com_dropfiles/models/categories.php:124
    20DropfilesModelCategories->getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:133
    19Joomla\CMS\MVC\Model\ListModel->_getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:187
    18Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_categories/models/categories.php:354
    17CategoriesModelCategories->getItems()JROOT/components/com_dropfiles/models/frontcategories.php:99
    16DropfilesModelFrontcategories->getItems()JROOT/plugins/content/dropfiles/dropfiles.php:242
    15PlgContentdropfiles->replace()Stejné jako volání v řádku níže.
    14preg_replace_callback()JROOT/plugins/content/dropfiles/dropfiles.php:55
    13PlgContentdropfiles->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]
  24. Čas pro dotazy: 2.11 ms Po posledním dotazu: 0.10 ms Dotaz paměti: 0.032 MB Paměť před dotazem: 13.064 MB Vráceno řádků: 0
    SELECT a.id, a.title, a.alias, a.note, a.published, a.access, a.checked_out, a.checked_out_time, a.created_user_id, a.path, a.parent_id, a.level, a.lft, a.rgt, a.language,l.title AS language_title,uc.name AS editor,d.type AS type,COUNT(f.id) as files

      FROM jom_categories AS a

      LEFT JOIN `jom_languages` AS l 
      ON l.lang_code = a.language

      LEFT JOIN jom_users AS uc 
      ON uc.id=a.checked_out

      LEFT JOIN jom_dropfiles AS d 
      ON d.id=a.id

      LEFT JOIN jom_dropfiles_files AS f 
      ON a.id = f.catid

      WHERE a.extension = 'com_dropfiles' 
      AND (a.published IN (0, 1)) 
      AND a.parent_id = 134

      GROUP BY a.id

      ORDER BY a.lft ASC 
      LIMIT 100000000
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLrangePRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_aliascat_idx203NULL210.00Using index condition; Using where; Using temporary; Použití filesort
    1SIMPLElNULLeq_refidx_langcodeidx_langcode28dp_www_1fit.a.language1100.00Using where
    1SIMPLEucNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.checked_out1100.00Using where
    1SIMPLEdNULLeq_refidid4dp_www_1fit.a.id1100.00NULL
    1SIMPLEfNULLrefid_galleryid_gallery4dp_www_1fit.a.id5100.00NULL
    Profil
    StatusDuration
    starting0.10 ms
    Executing hook on transaction 0.00 ms
    starting0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables1.49 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.09 ms
    preparing0.03 ms
    Creating tmp table0.05 ms
    executing0.08 ms
    end0.01 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    removing tmp table0.01 ms
    waiting for handler commit0.00 ms
    closing tables0.04 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    20JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    19Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    18Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_categories/models/categories.php:354
    17CategoriesModelCategories->getItems()JROOT/components/com_dropfiles/models/frontcategories.php:99
    16DropfilesModelFrontcategories->getItems()JROOT/plugins/content/dropfiles/dropfiles.php:242
    15PlgContentdropfiles->replace()Stejné jako volání v řádku níže.
    14preg_replace_callback()JROOT/plugins/content/dropfiles/dropfiles.php:55
    13PlgContentdropfiles->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]
  25. Čas pro dotazy: 0.23 ms Po posledním dotazu: 0.11 ms Dotaz paměti: 0.027 MB Paměť před dotazem: 13.055 MB Vráceno řádků: 1
    Duplicitní dotazy: #26
    SELECT * 
      FROM jom_dropfiles 
      WHERE id = 134
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjom_dropfilesNULLsystemidMOHL BY BÝT POUŽIT NO INDEX KEYNULLNULL1100.00NULL
    Profil
    StatusDuration
    starting0.03 ms
    Executing hook on transaction 0.00 ms
    starting0.01 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    init0.00 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.01 ms
    executing0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.01 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/database.php:33
    17JDatabase->query()JROOT/components/com_dropfiles/models/frontconfig.php:40
    16DropfilesModelFrontconfig->getParams()JROOT/plugins/content/dropfiles/dropfiles.php:243
    15PlgContentdropfiles->replace()Stejné jako volání v řádku níže.
    14preg_replace_callback()JROOT/plugins/content/dropfiles/dropfiles.php:55
    13PlgContentdropfiles->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]
  26. Čas pro dotazy: 0.26 ms Po posledním dotazu: 0.04 ms Dotaz paměti: 0.027 MB Paměť před dotazem: 13.063 MB Vráceno řádků: 1
    Duplicitní dotazy: #25
    SELECT * 
      FROM jom_dropfiles 
      WHERE id = 134
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjom_dropfilesNULLsystemidMOHL BY BÝT POUŽIT NO INDEX KEYNULLNULL1100.00NULL
    Profil
    StatusDuration
    starting0.04 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    init0.00 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.01 ms
    executing0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.01 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    17JDatabaseDriver->loadObject()JROOT/components/com_dropfiles/models/frontconfig.php:41
    16DropfilesModelFrontconfig->getParams()JROOT/plugins/content/dropfiles/dropfiles.php:243
    15PlgContentdropfiles->replace()Stejné jako volání v řádku níže.
    14preg_replace_callback()JROOT/plugins/content/dropfiles/dropfiles.php:55
    13PlgContentdropfiles->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]
  27. Čas pro dotazy: 0.89 ms Po posledním dotazu: 0.18 ms Dotaz paměti: 0.035 MB Paměť před dotazem: 13.083 MB Vráceno řádků: 5
    SELECT a.id, a.title, a.file, a.ext, a.size, a.hits, a.description, a.version, a.canview, a.catid, a.created_time,a.modified_time,a.custom_icon,c.title AS category_title, c.path AS category_route,
                        c.access AS category_access, c.alias AS category_alias,parent.title as parent_title, parent.id as parent_id,
                        parent.path as parent_route, parent.alias as parent_alias,c.published, c.published AS parents_published

      FROM jom_dropfiles_files AS a

      LEFT JOIN jom_categories AS c 
      ON c.id = a.catid

      LEFT JOIN jom_categories as parent 
      ON parent.id = c.parent_id

      LEFT 
      OUTER JOIN (SELECT cat.id as id 
      FROM jom_categories AS cat JOIN jom_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_dropfiles') AS badcats 
      ON badcats.id = c.id

      WHERE c.access IN (1,1,5) 
      AND a.catid = 134 
      AND (a.publish = '0000-00-00 00:00:00' OR a.publish <= '2021-01-25 01:48:32') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-25 01:48:32') 
      AND a.state = 1

      GROUP BY a.id, a.title, a.catid,  a.state, badcats.id, c.title, c.path, c.access, c.alias,
                        parent.title, parent.id, parent.path, parent.alias, c.published, c.lft, parent.lft, c.id

      ORDER BY ordering asc 
      LIMIT 1000
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcNULLconstPRIMARY,idx_accessPRIMARY4const1100.00Using temporary; Použití filesort
    1SIMPLEparentNULLconstPRIMARYPRIMARY4const1100.00NULL
    1SIMPLEaNULLrefid_galleryid_gallery4const420.00Using where
    1SIMPLEcatNULLconstPRIMARY,idx_left_rightPRIMARY4const1100.00NULL
    1SIMPLEparentNULLrefcat_idx,idx_left_rightcat_idx202const12100.00Using where
    Profil
    StatusDuration
    starting0.14 ms
    Executing hook on transaction 0.00 ms
    starting0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.09 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.03 ms
    statistics0.13 ms
    preparing0.03 ms
    Creating tmp table0.04 ms
    executing0.21 ms
    end0.01 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    removing tmp table0.01 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    19JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    18Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    17Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/components/com_dropfiles/models/frontfiles.php:230
    16DropfilesModelFrontfiles->getItems()JROOT/plugins/content/dropfiles/dropfiles.php:328
    15PlgContentdropfiles->replace()Stejné jako volání v řádku níže.
    14preg_replace_callback()JROOT/plugins/content/dropfiles/dropfiles.php:55
    13PlgContentdropfiles->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]
  28. Čas pro dotazy: 3.65 ms Po posledním dotazu: 0.92 ms Dotaz paměti: 0.009 MB Paměť před dotazem: 13.206 MB
    DELETE 
      FROM jom_dropfiles_tokens 
      WHERE time < 1611535712
    Vysvětlení
    VYSVĚTLENÍ není možné pro dotaz: DELETE FROM jom_dropfiles_tokens WHERE time < 1611535712
    Profil
    StatusDuration
    starting0.03 ms
    Executing hook on transaction 0.00 ms
    starting0.01 ms
    checking permissions0.00 ms
    Opening tables0.75 ms
    init0.01 ms
    System lock0.02 ms
    updating0.09 ms
    end0.00 ms
    query end0.00 ms
    waiting for handler commit2.55 ms
    closing tables0.04 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/database.php:33
    18JDatabase->query()JROOT/components/com_dropfiles/models/tokens.php:113
    17DropfilesModelTokens->removeTokens()JROOT/administrator/components/com_dropfiles/helpers/files.php:200
    16DropfilesFilesHelper::addInfosToFile()JROOT/plugins/content/dropfiles/dropfiles.php:330
    15PlgContentdropfiles->replace()Stejné jako volání v řádku níže.
    14preg_replace_callback()JROOT/plugins/content/dropfiles/dropfiles.php:55
    13PlgContentdropfiles->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]
  29. Čas pro dotazy: 1.17 ms Po posledním dotazu: 0.24 ms Dotaz paměti: 0.009 MB Paměť před dotazem: 13.223 MB
    INSERT INTO jom_dropfiles_tokens (id_user,time,token)  
      values (0,1611539312,'b1f65e4c1dec534d8cfb71f05f66cfac')
    Vysvětlení
    VYSVĚTLENÍ není možné pro dotaz: INSERT INTO jom_dropfiles_tokens (id_user,time,token) values (0,1611539312,'b1f65e4c1dec534d8cfb71f05f66cfac')
    Profil
    StatusDuration
    starting0.04 ms
    Executing hook on transaction 0.00 ms
    starting0.01 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    init0.00 ms
    System lock0.01 ms
    update0.05 ms
    end0.00 ms
    query end0.00 ms
    waiting for handler commit0.88 ms
    closing tables0.02 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/database.php:33
    18JDatabase->query()JROOT/components/com_dropfiles/models/tokens.php:47
    17DropfilesModelTokens->createToken()JROOT/administrator/components/com_dropfiles/helpers/files.php:205
    16DropfilesFilesHelper::addInfosToFile()JROOT/plugins/content/dropfiles/dropfiles.php:330
    15PlgContentdropfiles->replace()Stejné jako volání v řádku níže.
    14preg_replace_callback()JROOT/plugins/content/dropfiles/dropfiles.php:55
    13PlgContentdropfiles->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]
  30. Čas pro dotazy: 0.85 ms Po posledním dotazu: 16.37 ms Dotaz paměti: 0.039 MB Paměť před dotazem: 13.962 MB Vráceno řádků: 0
    SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

      FROM jom_fields AS a

      LEFT JOIN `jom_languages` AS l 
      ON l.lang_code = a.language

      LEFT JOIN jom_users AS uc 
      ON uc.id=a.checked_out

      LEFT JOIN jom_viewlevels AS ag 
      ON ag.id = a.access

      LEFT JOIN jom_users AS ua 
      ON ua.id = a.created_user_id

      LEFT JOIN jom_fields_groups AS g 
      ON g.id = a.group_id

      WHERE a.context = 'com_content.categories' 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)

      ORDER BY a.ordering ASC
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLrefidx_state,idx_access,idx_contextidx_state1const1100.00Using where; Using temporary; Použití filesort
    1SIMPLElNULLeq_refidx_langcodeidx_langcode28dp_www_1fit.a.language1100.00Using where
    1SIMPLEucNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.checked_out1100.00NULL
    1SIMPLEagNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.access1100.00Using where
    1SIMPLEuaNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.created_user_id1100.00Using where
    1SIMPLEgNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.group_id1100.00Using where
    Profil
    StatusDuration
    starting0.14 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.09 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.19 ms
    preparing0.04 ms
    Creating tmp table0.07 ms
    executing0.06 ms
    end0.01 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    removing tmp table0.01 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    24JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    23JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    22Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    21FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    20Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    19FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    18PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    17JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    16JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    15Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/templates/theme3703/html/com_content/category/blog.php:18
    14include JROOT/templates/theme3703/html/com_content/category/blog.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
    13Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/libraries/src/MVC/View/HtmlView.php:230
    12Joomla\CMS\MVC\View\HtmlView->display()JROOT/libraries/src/MVC/View/CategoryView.php:245
    11Joomla\CMS\MVC\View\CategoryView->display()JROOT/components/com_content/views/category/view.html.php:250
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]
  31. Čas pro dotazy: 0.79 ms Po posledním dotazu: 0.32 ms Dotaz paměti: 0.039 MB Paměť před dotazem: 13.976 MB Vráceno řádků: 0
    SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

      FROM jom_fields AS a

      LEFT JOIN `jom_languages` AS l 
      ON l.lang_code = a.language

      LEFT JOIN jom_users AS uc 
      ON uc.id=a.checked_out

      LEFT JOIN jom_viewlevels AS ag 
      ON ag.id = a.access

      LEFT JOIN jom_users AS ua 
      ON ua.id = a.created_user_id

      LEFT JOIN jom_fields_groups AS g 
      ON g.id = a.group_id

      LEFT JOIN `jom_fields_categories` AS fc 
      ON fc.field_id = a.id

      WHERE a.context = 'com_content.categories' 
      AND (fc.category_id IS NULL OR fc.category_id IN (2,0)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)

      ORDER BY a.ordering ASC
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLrefidx_state,idx_access,idx_contextidx_state1const1100.00Using where; Using temporary; Použití filesort
    1SIMPLElNULLeq_refidx_langcodeidx_langcode28dp_www_1fit.a.language1100.00Using where
    1SIMPLEucNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.checked_out1100.00NULL
    1SIMPLEagNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.access1100.00Using where
    1SIMPLEuaNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.created_user_id1100.00Using where
    1SIMPLEgNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.group_id1100.00Using where
    1SIMPLEfcNULLrefPRIMARYPRIMARY4dp_www_1fit.a.id1100.00Using where; Using index; Distinct
    Profil
    StatusDuration
    starting0.13 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.07 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.16 ms
    preparing0.04 ms
    Creating tmp table0.06 ms
    executing0.06 ms
    end0.01 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    removing tmp table0.01 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    24JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    23Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    22FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    21Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    20FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:404
    19PlgSystemFields->display()JROOT/plugins/system/fields/fields.php:324
    18PlgSystemFields->onContentAfterTitle()JROOT/libraries/joomla/event/event.php:70
    17JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    16JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    15Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/templates/theme3703/html/com_content/category/blog.php:21
    14include JROOT/templates/theme3703/html/com_content/category/blog.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
    13Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/libraries/src/MVC/View/HtmlView.php:230
    12Joomla\CMS\MVC\View\HtmlView->display()JROOT/libraries/src/MVC/View/CategoryView.php:245
    11Joomla\CMS\MVC\View\CategoryView->display()JROOT/components/com_content/views/category/view.html.php:250
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]
  32. Čas pro dotazy: 6.02 ms Po posledním dotazu: 7.25 ms Dotaz paměti: 0.035 MB Paměť před dotazem: 14.553 MB Vráceno řádků: 31
    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

      FROM jom_modules AS m

      LEFT JOIN jom_modules_menu AS mm 
      ON mm.moduleid = m.id

      LEFT JOIN jom_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id

      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2021-01-25 01:48:32') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-01-25 01:48:32') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 1018 OR mm.menuid <= 0)

      ORDER BY m.position, m.ordering
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLALLPRIMARY,published,newsfeedsMOHL BY BÝT POUŽIT NO INDEX KEYNULLNULL1911.11Using where; Použití filesort
    1SIMPLEeNULLrefelement_clientid,element_folder_clientidelement_clientid403dp_www_1fit.m.module,const110.00Using index condition; Using where
    1SIMPLEmmNULLrefPRIMARYPRIMARY4dp_www_1fit.m.id140.00Using where; Using index
    Profil
    StatusDuration
    starting0.09 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables2.81 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.03 ms
    statistics0.09 ms
    preparing0.04 ms
    executing2.75 ms
    end0.01 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    closing tables0.05 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    14JDatabaseDriver->loadObjectList()Stejné jako volání v řádku níže.
    13call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/ModuleHelper.php:432
    11Joomla\CMS\Helper\ModuleHelper::getModuleList()JROOT/libraries/src/Helper/ModuleHelper.php:362
    10Joomla\CMS\Helper\ModuleHelper::load()JROOT/libraries/src/Helper/ModuleHelper.php:87
    9Joomla\CMS\Helper\ModuleHelper::getModules()JROOT/libraries/src/Document/HtmlDocument.php:591
    8Joomla\CMS\Document\HtmlDocument->countModules()JROOT/templates/theme3703/index.php:196
    7require JROOT/templates/theme3703/index.phpJROOT/libraries/src/Document/HtmlDocument.php:668
    6Joomla\CMS\Document\HtmlDocument->_loadTemplate()JROOT/libraries/src/Document/HtmlDocument.php:730
    5Joomla\CMS\Document\HtmlDocument->_fetchTemplate()JROOT/libraries/src/Document/HtmlDocument.php:545
    4Joomla\CMS\Document\HtmlDocument->parse()JROOT/libraries/src/Application/CMSApplication.php:1033
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]
  33. Čas pro dotazy: 0.96 ms Po posledním dotazu: 23.10 ms Dotaz paměti: 0.039 MB Paměť před dotazem: 15.284 MB Vráceno řádků: 3
    SELECT a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

      FROM jom_content AS a

      LEFT JOIN jom_categories AS c 
      ON c.id = a.catid

      LEFT JOIN jom_users AS ua 
      ON ua.id = a.created_by

      LEFT JOIN jom_users AS uam 
      ON uam.id = a.modified_by

      LEFT JOIN jom_categories as parent 
      ON parent.id = c.parent_id

      LEFT JOIN jom_content_rating AS v 
      ON a.id = v.content_id

      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.catid IN (117) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-01-25 01:48:32') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-25 01:48:32')

      ORDER BY a.publish_up ASC 
      LIMIT 10
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcNULLconstPRIMARY,idx_accessPRIMARY4const1100.00Použití filesort
    1SIMPLEaNULLrefidx_access,idx_state,idx_catididx_catid4const316.00Using where
    1SIMPLEuaNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.created_by1100.00Using where
    1SIMPLEuamNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.modified_by1100.00Using where; Using index
    1SIMPLEparentNULLconstPRIMARYPRIMARY4const1100.00Using where
    1SIMPLEvNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.id1100.00Using where
    Profil
    StatusDuration
    starting0.18 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.10 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.03 ms
    statistics0.17 ms
    preparing0.05 ms
    executing0.18 ms
    end0.01 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    14Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    13Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/components/com_content/models/articles.php:576
    12ContentModelArticles->getItems()JROOT/modules/mod_articles_news_adv/helper.php:110
    11ModArticlesNewsAdvHelper::getList()JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
    10include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:501
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:793
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:567
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1047
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]
  34. Čas pro dotazy: 1.02 ms Po posledním dotazu: 0.48 ms Dotaz paměti: 0.043 MB Paměť před dotazem: 15.381 MB Vráceno řádků: 8
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

      FROM `jom_categories` AS `s`

      INNER JOIN `jom_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)

      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 117

      ORDER BY c.lft
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEsNULLconstPRIMARY,idx_left_rightPRIMARY4const1100.00Použití filesort
    1SIMPLEcNULLALLcat_idx,idx_access,idx_left_rightMOHL BY BÝT POUŽIT NO INDEX KEYNULLNULL10837.39Using where
    Profil
    StatusDuration
    starting0.15 ms
    Executing hook on transaction 0.00 ms
    starting0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.05 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.14 ms
    preparing0.04 ms
    executing0.38 ms
    end0.01 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    24JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
    23Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
    22Joomla\CMS\Categories\Categories->get()JROOT/components/com_content/router.php:72
    21ContentRouter->getCategorySegment()Stejné jako volání v řádku níže.
    20call_user_func_array()JROOT/libraries/src/Component/Router/RouterView.php:120
    19Joomla\CMS\Component\Router\RouterView->getPath()JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    18Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()JROOT/libraries/src/Component/Router/RouterView.php:222
    17Joomla\CMS\Component\Router\RouterView->preprocess()JROOT/libraries/src/Router/SiteRouter.php:672
    16Joomla\CMS\Router\SiteRouter->processBuildRules()JROOT/libraries/src/Router/Router.php:266
    15Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:154
    14Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    13Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    12Joomla\CMS\Router\Route::_()JROOT/modules/mod_articles_news_adv/helper.php:124
    11ModArticlesNewsAdvHelper::getList()JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
    10include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:501
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:793
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:567
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1047
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]
  35. Čas pro dotazy: 0.76 ms Po posledním dotazu: 0.56 ms Dotaz paměti: 0.039 MB Paměť před dotazem: 15.432 MB Vráceno řádků: 0
    SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

      FROM jom_fields AS a

      LEFT JOIN `jom_languages` AS l 
      ON l.lang_code = a.language

      LEFT JOIN jom_users AS uc 
      ON uc.id=a.checked_out

      LEFT JOIN jom_viewlevels AS ag 
      ON ag.id = a.access

      LEFT JOIN jom_users AS ua 
      ON ua.id = a.created_user_id

      LEFT JOIN jom_fields_groups AS g 
      ON g.id = a.group_id

      WHERE a.context = 'mod_articles_news.content' 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)

      ORDER BY a.ordering ASC
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLrefidx_state,idx_access,idx_contextidx_state1const1100.00Using where; Using temporary; Použití filesort
    1SIMPLElNULLeq_refidx_langcodeidx_langcode28dp_www_1fit.a.language1100.00Using where
    1SIMPLEucNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.checked_out1100.00NULL
    1SIMPLEagNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.access1100.00Using where
    1SIMPLEuaNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.created_user_id1100.00Using where
    1SIMPLEgNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.group_id1100.00Using where
    Profil
    StatusDuration
    starting0.12 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.08 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.13 ms
    preparing0.03 ms
    Creating tmp table0.06 ms
    executing0.06 ms
    end0.01 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    removing tmp table0.01 ms
    waiting for handler commit0.00 ms
    closing tables0.02 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    24JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    23JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    22Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    21FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    20Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    19FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    18PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    17JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    16JEventDispatcher->trigger()JROOT/libraries/cms/html/content.php:41
    15JHtmlContent::prepare()Stejné jako volání v řádku níže.
    14call_user_func_array()JROOT/libraries/src/HTML/HTMLHelper.php:239
    13Joomla\CMS\HTML\HTMLHelper::call()JROOT/libraries/src/HTML/HTMLHelper.php:146
    12Joomla\CMS\HTML\HTMLHelper::_()JROOT/modules/mod_articles_news_adv/helper.php:134
    11ModArticlesNewsAdvHelper::getList()JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
    10include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:501
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:793
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:567
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1047
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]
  36. Čas pro dotazy: 0.99 ms Po posledním dotazu: 0.39 ms Dotaz paměti: 0.038 MB Paměť před dotazem: 15.443 MB Vráceno řádků: 0