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

Ceník

MamaFit

MamaFit bez bolesti 200 Kč / 1 lekce
800 Kč / 5 lekcí
1400 Kč / 10 lekcí
MamaFit v kondici 200 Kč / 1 lekce
800 Kč / 5 lekcí
1400 Kč / 10 lekcí
Pilates 100 Kč / 1 lekce
450 Kč / 5 lekcí
850 Kč / 10 lekcí
Bosu 100 Kč / 1 lekce
450 Kč / 5 lekcí
850 Kč / 10 lekcí
Funkční kruhový trénink 150 Kč
TRX® 150 Kč
  • Na lekce MamaFit je nutné se rezervovat a platbu provést předem na účet.
  • Je možné využít jednorázových lekcí nebo výhodnějších předplacených permanentek.
  • Na lekce Pilates a Bosu se vztahují podmínky organizace Sportýna, více zde
  • Časová platnost permanentek: 5 lekcí = 2 měsíce, 10 lekcí = 4 měsíce
  • Platnost permanentek je prodloužena o dobu zrušených lekcí z důvodu svátku, prázdnin, nemoci instruktorky, vyšší moci, apod.
  • Na lekce TRX a funkční kruhový trénink se vztahují podmínky Sportcentra Eden, více zde

Kroužky

Sportovky 1500 Kč/ 1x týdně/ 15 lekcí  
Pohybovky 1400 Kč/ 1x týdně/ 15 lekcí 2600 Kč/ 2x týdně / 30 lekcí
  • 15 lekcí za pololetí + 1. zkušební týden od 13. 9. 2021
  • Částka se hradí převodem na účet nejpozději do 20. 9. 2021

Cvičení pro děti od 4. měs. do 2,5 let

4 - 6 měs, 7 - 10 měs, 11 - 17 měs, 1,5 - 2,5 let 2950 Kč/ 16 lekcí / 45 minut

Cena za pololetí 2950 Kč / 16 lekcí

1 lekce 45 minut + 15 minut povídání a hraní si

Částka se hradí předem převodem na účet.

Včas omluvené lekce lze nahradit. Jak na to? - více informací ZDE

Kurzy cvičení pro děti s rodiči - 2. pololetí 2021 začínáme v týdnu od 18. 1. 2021 jednorázovými zkušebními lekcemi, které nerezervují místo v kurzu. Místo v kurzu je zajištěno potvrzeným a zaplaceným přihlášením. Samotný kurz začíná v týdnu od 1. 2. 2021

Cvičení pro děti od 2,5 do 6 let

2,5 let-4 roky 4 roky-6 let 2950 Kč/ 16 lekcí / 45 minut

Cena za pololetí 2950 Kč / 16 lekcí

1 lekce 45 minut + 15 minut povídání a hraní si

Částka se hradí předem převodem na účet.

Včas omluvené lekce lze nahradit. Jak na to? - více informací ZDE

Kurzy cvičení pro děti s rodiči - zatím připravujeme od září 2021

Příměstské tábory

Sportjoy 2950 Kč/ 1 dítě 2750 Kč/ sourozenci
Babyjoy 2950 Kč/ 1 dítě 2750 Kč/ sourozenci
Sportýna 2990 Kč/ 1 dítě  

Více informací, platební podmínky a co cena zahrnuje naleznete na stránkách organizátorů www.sportjoy.cz nebo www.sportyna.cz.

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": 1614831020,
                "last": 1614831020,
                "now": 1614831020
            }
        },
        "registry": {},
        "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
        }
    }
}

Informace o profilu

Čas

Paměť

Čas: 17.12 ms / 17.12 ms Paměť: 1.859 MB / 2.27 MB Application: afterLoad
Čas: 68.78 ms / 85.90 ms Paměť: 5.377 MB / 7.65 MB Application: afterInitialise
Čas: 23.67 ms / 109.57 ms Paměť: 1.566 MB / 9.22 MB Application: afterRoute
Čas: 6.19 ms / 115.76 ms Paměť: 0.191 MB / 9.41 MB Application: beforeRenderComponent com_content
Čas: 5.50 ms / 121.26 ms Paměť: 0.650 MB / 10.06 MB Application: Before Access::preloadComponents (all components)
Čas: 2.65 ms / 123.90 ms Paměť: 0.062 MB / 10.12 MB Application: After Access::preloadComponents (all components)
Čas: 0.03 ms / 123.93 ms Paměť: 0.000 MB / 10.11 MB Application: Before Access::preloadPermissions (com_content)
Čas: 2.85 ms / 126.78 ms Paměť: 0.359 MB / 10.47 MB Application: After Access::preloadPermissions (com_content)
Čas: 0.04 ms / 126.82 ms Paměť: 0.000 MB / 10.45 MB Application: Before Access::getAssetRules (id:1054 name:com_content.category.101)
Čas: 0.53 ms / 127.35 ms Paměť: 0.038 MB / 10.49 MB Application: After Access::getAssetRules (id:1054 name:com_content.category.101)
Čas: 7.60 ms / 134.96 ms Paměť: 0.323 MB / 10.82 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Čas: 0.02 ms / 134.98 ms Paměť: 0.002 MB / 10.82 MB Application: After Access::getAssetRules (id:8 name:com_content)
Čas: 44.17 ms / 179.15 ms Paměť: 1.808 MB / 12.63 MB Application: afterRenderComponent com_content
Čas: 1.44 ms / 180.59 ms Paměť: 0.119 MB / 12.74 MB Application: afterDispatch
Čas: 24.36 ms / 204.95 ms Paměť: 1.002 MB / 13.75 MB Application: beforeRenderModule mod_tm_ajax_contact_form (Napište nám)
Čas: 1.85 ms / 206.80 ms Paměť: 0.086 MB / 13.83 MB Application: afterRenderModule mod_tm_ajax_contact_form (Napište nám)
Čas: 0.07 ms / 206.87 ms Paměť: 0.000 MB / 13.83 MB Application: beforeRenderModule mod_menu (Informace)
Čas: 3.78 ms / 210.65 ms Paměť: 0.148 MB / 13.97 MB Application: afterRenderModule mod_menu (Informace)
Čas: 0.06 ms / 210.71 ms Paměť: 0.000 MB / 13.97 MB Application: beforeRenderModule mod_menu (Navigace)
Čas: 1.39 ms / 212.11 ms Paměť: 0.018 MB / 13.99 MB Application: afterRenderModule mod_menu (Navigace)
Čas: 0.06 ms / 212.16 ms Paměť: 0.000 MB / 13.98 MB Application: beforeRenderModule mod_custom (1FIT)
Čas: 0.41 ms / 212.57 ms Paměť: 0.005 MB / 13.99 MB Application: afterRenderModule mod_custom (1FIT)
Čas: 0.06 ms / 212.63 ms Paměť: 0.003 MB / 13.99 MB Application: beforeRenderModule mod_articles_news_adv (Ceník služeb)
Čas: 7.68 ms / 220.31 ms Paměť: 0.268 MB / 14.26 MB Application: afterRenderModule mod_articles_news_adv (Ceník služeb)
Čas: 0.08 ms / 220.39 ms Paměť: 0.000 MB / 14.12 MB Application: beforeRenderModule mod_custom (Ceník)
Čas: 0.20 ms / 220.59 ms Paměť: 0.003 MB / 14.13 MB Application: afterRenderModule mod_custom (Ceník)
Čas: 1.89 ms / 222.48 ms Paměť: 0.151 MB / 14.28 MB Application: afterRender

Celkem dotazů do databáze: 60.10 ms

Využití paměti

14,75 MB (15.468.360 Bytů)

Dotazy do databáze

24 zaznamenaných dotazů 60.10 ms


  1. Čas pro dotazy: 1.99 ms Dotaz paměti: 0.036 MB Paměť před dotazem: 4.422 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
    StatusDuration
    starting0.06 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.01 ms
    Opening tables1.36 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.06 ms
    preparing0.02 ms
    executing0.32 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
    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.10 ms Po posledním dotazu: 2.44 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 4.727 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
    StatusDuration
    starting0.04 ms
    Executing hook on transaction 0.00 ms
    starting0.01 ms
    checking permissions0.00 ms
    Opening tables0.84 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.02 ms
    executing0.04 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
    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.37 ms Po posledním dotazu: 0.11 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 4.739 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
    StatusDuration
    starting0.06 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables1.06 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.02 ms
    executing0.03 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
    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.88 ms Po posledním dotazu: 0.71 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
    StatusDuration
    starting0.06 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.06 ms
    preparing0.03 ms
    executing1.50 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
    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.74 ms Po posledním dotazu: 26.96 ms Dotaz paměti: 0.150 MB Paměť před dotazem: 7.012 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
    StatusDuration
    starting0.10 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables1.60 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.03 ms
    executing1.76 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
    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: 2.24 ms Po posledním dotazu: 12.25 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
    StatusDuration
    starting0.63 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    Opening tables0.81 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.04 ms
    statistics0.14 ms
    preparing0.04 ms
    Creating tmp table0.06 ms
    executing0.11 ms
    checking permissions0.10 ms
    checking permissions0.05 ms
    checking permissions0.02 ms
    checking permissions0.01 ms
    checking permissions0.03 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.02 ms
    freeing items0.04 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/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.57 ms Po posledním dotazu: 0.56 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
    StatusDuration
    starting0.04 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.00 ms
    Opening tables0.24 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.02 ms
    executing0.05 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
    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.35 ms Po posledním dotazu: 6.43 ms Dotaz paměti: 0.027 MB Paměť před dotazem: 9.018 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
    StatusDuration
    starting0.05 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.07 ms
    preparing0.02 ms
    executing0.04 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
    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: 1.20 ms Po posledním dotazu: 0.17 ms Dotaz paměti: 0.006 MB Paměť před dotazem: 9.012 MB
    UPDATE `jom_extensions`

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

      WHERE `type` = 'library' 
      AND `element` = 'joomla'
    Vysvětlení
    VYSVĚTLENÍ není možné pro dotaz: UPDATE `jom_extensions` SET `params` = '{\"mediaversion\":\"e1c3f8be2c3cb10b7d97f9658210ebf1\"}' WHERE `type` = 'library' AND `element` = 'joomla'
    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.07 ms
    updating0.07 ms
    end0.01 ms
    query end0.00 ms
    waiting for handler commit0.85 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    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: 1.45 ms Po posledním dotazu: 2.03 ms Dotaz paměti: 0.025 MB Paměť před dotazem: 9.295 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
    StatusDuration
    starting0.05 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.01 ms
    Opening tables1.17 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.02 ms
    executing0.05 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
    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: 1.74 ms Po posledním dotazu: 0.32 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
    StatusDuration
    starting0.07 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.98 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.11 ms
    preparing0.03 ms
    executing0.32 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
    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.39 ms Po posledním dotazu: 8.14 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.09 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.01 ms
    Opening tables1.17 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.25 ms
    preparing0.02 ms
    executing0.65 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: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: 2.06 ms Po posledním dotazu: 0.23 ms Dotaz paměti: 0.084 MB Paměť před dotazem: 10.115 MB Vráceno řádků: 456
    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 KEYNULLNULL77020.73Using where
    Profil
    StatusDuration
    starting0.08 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.00 ms
    Opening tables0.03 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.08 ms
    preparing0.03 ms
    executing1.56 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: 4.60 ms Po posledním dotazu: 2.34 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 = 101

      ORDER BY c.lft
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1PRIMARYsNULLconstPRIMARY,idx_left_rightPRIMARY4const1100.00Použití filesort
    1PRIMARYcNULLALLcat_idx,idx_left_rightMOHL BY BÝT POUŽIT NO INDEX KEYNULLNULL10827.40Using where
    2DEPENDENT SUBQUERYiNULLrefidx_state,idx_catididx_catid4dp_www_1fit.c.id3100.00Using index condition; Using where
    Profil
    StatusDuration
    starting0.19 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables3.18 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.17 ms
    preparing0.05 ms
    optimizing0.02 ms
    statistics0.05 ms
    preparing0.03 ms
    executing0.57 ms
    executing0.05 ms
    executing0.06 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
    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: 9.20 ms Po posledním dotazu: 2.05 ms Dotaz paměti: 0.042 MB Paměť před dotazem: 10.814 MB Vráceno řádků: 5
    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 = 101 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 = 101)) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-03-04 04:10:20') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-03-04 04:10:20')

      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_rightPRIMARY4func112.34Using 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.01 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.01 ms
    executing0.01 ms
    executing0.01 ms
    executing0.03 ms
    executing0.02 ms
    executing0.01 ms
    executing0.03 ms
    executing0.03 ms
    executing0.04 ms
    executing0.03 ms
    executing0.03 ms
    executing0.03 ms
    executing0.03 ms
    executing0.03 ms
    executing0.04 ms
    executing0.03 ms
    executing0.03 ms
    executing0.03 ms
    executing0.03 ms
    executing0.09 ms
    executing0.03 ms
    executing0.03 ms
    executing0.03 ms
    executing0.03 ms
    executing0.04 ms
    executing0.03 ms
    executing0.02 ms
    executing0.02 ms
    executing0.02 ms
    executing0.02 ms
    executing0.02 ms
    executing0.03 ms
    executing0.03 ms
    executing0.02 ms
    executing0.03 ms
    executing0.03 ms
    executing0.02 ms
    executing0.02 ms
    executing0.03 ms
    executing0.02 ms
    executing0.02 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.02 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.02 ms
    freeing items0.04 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: 6.51 ms Po posledním dotazu: 1.80 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 11.073 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 = 101 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 = 101)) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-03-04 04:10:20') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-03-04 04:10:20')
    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_rightPRIMARY4func112.34Using where
    Profil
    StatusDuration
    executing0.02 ms
    executing0.01 ms
    executing0.05 ms
    executing0.02 ms
    executing0.01 ms
    executing0.01 ms
    executing0.04 ms
    executing0.02 ms
    executing0.01 ms
    executing0.01 ms
    executing0.03 ms
    executing0.05 ms
    executing0.02 ms
    executing0.05 ms
    executing0.02 ms
    executing0.04 ms
    executing0.07 ms
    executing0.02 ms
    executing0.02 ms
    executing0.06 ms
    executing0.02 ms
    executing0.02 ms
    executing0.02 ms
    executing0.06 ms
    executing0.02 ms
    executing0.02 ms
    executing0.02 ms
    executing0.07 ms
    executing0.02 ms
    executing0.06 ms
    executing0.02 ms
    executing0.02 ms
    executing0.02 ms
    executing0.05 ms
    executing0.02 ms
    executing0.02 ms
    executing0.02 ms
    executing0.04 ms
    executing0.02 ms
    executing0.02 ms
    executing0.06 ms
    executing0.02 ms
    executing0.02 ms
    executing0.02 ms
    executing0.03 ms
    executing0.02 ms
    executing0.07 ms
    executing0.02 ms
    executing0.02 ms
    executing0.02 ms
    executing0.03 ms
    executing0.09 ms
    executing0.03 ms
    executing0.02 ms
    executing0.02 ms
    executing0.03 ms
    executing0.02 ms
    executing0.06 ms
    executing0.02 ms
    executing0.02 ms
    executing0.02 ms
    executing0.03 ms
    executing0.06 ms
    executing0.02 ms
    executing0.02 ms
    executing0.02 ms
    executing0.03 ms
    executing0.06 ms
    executing0.02 ms
    executing0.02 ms
    executing0.02 ms
    executing0.04 ms
    executing0.02 ms
    executing0.02 ms
    executing0.05 ms
    executing0.02 ms
    executing0.02 ms
    executing0.03 ms
    executing0.06 ms
    executing0.02 ms
    executing0.02 ms
    executing0.06 ms
    executing0.02 ms
    executing0.02 ms
    executing0.02 ms
    executing0.05 ms
    executing0.02 ms
    executing0.02 ms
    executing0.02 ms
    executing0.03 ms
    executing0.05 ms
    executing0.02 ms
    executing0.02 ms
    executing0.03 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
    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: 2.61 ms Po posledním dotazu: 1.63 ms Dotaz paměti: 0.035 MB Paměť před dotazem: 11.241 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` = 101 
      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.07 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables2.18 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.07 ms
    preparing0.02 ms
    executing0.04 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
    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: 1.17 ms Po posledním dotazu: 6.77 ms Dotaz paměti: 0.038 MB Paměť před dotazem: 11.871 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 = 101

      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 KEYNULLNULL10828.57Using where
    Profil
    StatusDuration
    starting0.15 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.07 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.03 ms
    statistics0.19 ms
    preparing0.05 ms
    executing0.52 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: 3.79 ms Po posledním dotazu: 0.16 ms Dotaz paměti: 0.037 MB Paměť před dotazem: 11.889 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 (101,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.15 ms
    Executing hook on transaction 0.00 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 tables3.02 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.03 ms
    statistics0.18 ms
    preparing0.04 ms
    Creating tmp table0.07 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.01 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/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: 0.78 ms Po posledním dotazu: 8.39 ms Dotaz paměti: 0.039 MB Paměť před dotazem: 12.681 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.11 ms
    Executing hook on transaction 0.00 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.07 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.03 ms
    statistics0.19 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.01 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/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.]
  21. Čas pro dotazy: 0.75 ms Po posledním dotazu: 0.33 ms Dotaz paměti: 0.039 MB Paměť před dotazem: 12.695 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 (101,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.19 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.13 ms
    preparing0.03 ms
    Creating tmp table0.05 ms
    executing0.05 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.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.]
  22. Čas pro dotazy: 6.39 ms Po posledním dotazu: 7.00 ms Dotaz paměti: 0.030 MB Paměť před dotazem: 13.336 MB Vráceno řádků: 21
    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-03-04 04:10:20') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-03-04 04:10:20') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 1035 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.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables1.81 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.05 ms
    statistics0.11 ms
    preparing0.05 ms
    executing4.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
    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.]
  23. Čas pro dotazy: 1.29 ms Po posledním dotazu: 21.34 ms Dotaz paměti: 0.039 MB Paměť před dotazem: 14.077 MB Vráceno řádků: 5
    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 (101) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-03-04 04:10:20') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-03-04 04:10:20')

      ORDER BY a.publish_up ASC 
      LIMIT 20
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcNULLconstPRIMARY,idx_accessPRIMARY4const1100.00Použití filesort
    1SIMPLEaNULLrefidx_access,idx_state,idx_catididx_catid4const516.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.23 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.13 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.06 ms
    statistics0.20 ms
    preparing0.06 ms
    executing0.38 ms
    end0.01 ms
    query end0.00 ms
    waiting for handler commit0.02 ms
    closing tables0.02 ms
    freeing items0.04 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.]
  24. Čas pro dotazy: 0.94 ms Po posledním dotazu: 0.91 ms Dotaz paměti: 0.039 MB Paměť před dotazem: 14.231 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.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.01 ms
    Opening tables0.10 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.03 ms
    statistics0.20 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.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/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.]

20 zaznamenaných typů dotazu, řazeno dle výskytu

VYBRANÉ tabulky:
  1. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
      FROM `jom_extensions`
  2. 2 × 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
  3. 2 × 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
  4. 2 × SELECT `id`,`name`,`rules`,`parent_id` 
      FROM `jom_assets`
  5. 1 × 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
  6. 1 × 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
  7. 1 × 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)
  8. 1 × SELECT `m`.`tag_id`,`t`.* 
      FROM `jom_contentitem_tag_map` AS m  
      INNER JOIN `jom_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
  9. 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
  10. 1 × 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`
  11. 1 × SELECT id, rules 
      FROM `jom_viewlevels
  12. 1 × 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
  13. 1 × SELECT * 
      FROM jom_languages
  14. 1 × SELECT * 
      FROM jom_komento_configs
  15. 1 × 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
  16. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
      FROM jom_extensions
  17. 1 × SELECT b.id 
      FROM jom_usergroups AS a 
      LEFT JOIN jom_usergroups AS b 
      ON b.lft <= a.lft 
      AND b.rgt >= a.rgt
  18. 1 × 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
JINÉ tabulky:
  1. 1 × SHOW FULL COLUMNS 
      FROM `jom_komento_configs
  2. 1 × UPDATE `jom_extensions` 
      SET `params` = '{\"mediaversion\":\"e1c3f8be2c3cb10b7d97f9658210ebf1\"}'