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

Časté dotazy

Kategorie dotazů

  • Cvičení pro děti od 4 měsíců - 2,5 roku
  • Cvičení 2,5 roku - 6 let
  • Kroužky
  • Cvičení pro maminky
  • Tábory

Cvičení pro děti od 4 měsíců - 2,5 roku

Důležité je vycházet nejen z věku dítěte, ale také z toho, co již dítě umí. Samozřejmě se dítě neustále vyvíjí a posouvá, s čímž se v průběhu kurzu počítá. Pokud se ale Vaše dítě posune již před zahájením kurzu neváhejte se na nás obrátit a vyřešíme případně individuálně po domluvě přesun do jiné kategorie.

Pokud máte zájem se na kurz přihlásit s dvojčaty, prosíme, abyste nás předem kontaktovali. Je to možné pouze na určité lokality k určitým instruktorkám. Za přihlášení do kurzu s dvojčaty se platí plná cena za jedno dítě a za druhé dítě 50% ceny kurzovného.

Ano, v týdnu před zahájením kurzů, je možné si lekci vyzkoušet, ale na tuto zkušební lekci je nutné se přihlásit. Tato zkušební lekce mi negarantuje místo v kurzu.

Je potřeba vyplnit přihlášku, poté přijdou potvrzení na email včetně přihlašovacích údajů. Nadále je možné spravovat své rezervace a přihlášky v tzv. klubu (rezervačním systému)

Ano, po přihlášení do klubu (přihlašovací údaje dorazí na email se zasláním přihlášky), je možné si omluvit lekci, která nebude využita a je možné si vybrat náhradní lekci i v jiné lokalitě, ale pro stejnou věkovou kategorii.

Rodiče vemte si pro sebe i dítě vhodné oblečení na cvičení. Nedoporučujeme dupačky. Dále si vemte jednorázovou přebalovací podložku, bavlněnou plenu, oblíbenou hračku. Další pomůcky máme na místě. U chodících dětí není potřeba přezutí (bačkůrky, protiskluzové ponožky), cvičíme totiž bosy.

Na lekci přijďte o 15 min dříve, abyste se stihli převléct a připravit.Je dobré si lekci vybrat tak, aby vyhovovala dennímu režimu vašeho dítěte. Je důležité, aby bylo spokojené, takže ideálně minimálně 30 min po jídle a nemělo by být těsně před spánkem.

Cvičení 2,5 roku - 6 let

Děti cvičí bez svých rodičů, učí se samostatnosti, objevují různé druhy pohybů a zdokonalují všestranné pohybové dovednosti. Naše skupiny jsou malé max. 10 dětí, takže je zajištěn individuální přístup. Klademe důraz na profesionální vedení lekcí a bezpečnost.

Ano, v týdnu před zahájením kurzů, je možné si lekci vyzkoušet, ale na tuto zkušební lekci je nutné se přihlásit. Tato zkušební lekce mi negarantuje místo v kurzu.

Je potřeba vyplnit přihlášku, poté přijdou potvrzení na email včetně přihlašovacích údajů. Nadále je možné spravovat své rezervace a přihlášky v tzv. klubu (rezervačním systému)

Pohodlné sportovní oblečení, boty do tělocvičny, pití v podepsané lahvi

Ano, po přihlášení do klubu (přihlašovací údaje dorazí na email se zasláním přihlášky), je možné si omluvit lekci, která nebude využita a je možné si vybrat náhradní lekci i v jiné lokalitě, ale pro stejnou věkovou kategorii.

Kroužky

Je možné v prvním týdnu kurzů přijít ještě bez proběhlé platby. Přihlášení je ale na toto vyzkoušení nutné a poté včasná platba, jinak bude dána přednost náhradníkům.

Je nutné vhodné sportovní oblečení včetně obuvi, pití nejlépe v podepsané lahvi.

Při dvou a více zameškaných a řádně omluvených lekcích ze zdravotních důvodů, je po dodání lékařského potvrzení možné vypočítat poměrnou slevu z členských příspěvků v dalším pololetí.

V Klubu se lekce řádně omlouvají. Přihlašovací údaje do klubu Vám dorazily na email po vyplnění přihlášky.

Všechny naše kroužky jsou rekreačního charakteru a závodů se neúčastníme.

Cvičení pro maminky

Vždy je důležité si říct, jaké je od cvičení očekávání. Bolí Vás záda, hlava či zda řešíte nějaké zdravotní problémy, pak je vhodnější výběr z lekcí Pilates či Mamafit bez bolesti. Pokud se chcete při cvičení zapotit a dát si do těla, volte mezi lekcemi Mamafit v kondici, Bosu, Funkční trénink, TRX. Všechny lekce jsou vhodné i pro začátečníky. Není také problém přijít v průběhu roku, lekce nefungují formou kurzu. Rádi Vám s výběrem vhodné lekce poradíme na telefonním čísle +420 777 459 584

Předně doporučujeme konzultaci se svým lékařem. Vhodné lekce poté jsou Mamafit bez bolesti či Pilates, kdy je určitě potřeba před lekcí o svém omezení informovat instruktorku. Rádi Vám poradíme na telefonním čísle +420 777 459 584

Lekce Mamafit probíhají za přítomnosti dětí. Děti si hrají, pokud je potřeba cvičí se společně s dětmi. Na věku dětí nezáleží.

Rezervace na lekce se provádějí na webových stránkách www.1fit.cz Po vybrání lekce v rozvrhu, je potřeba vyplnit on-line přihlášku, poté přijde na zadaný email potvrzení s platebními podmínkami a přihlašovací údaje do Klubu, ve kterém si můžete rezervace spravovat.

Lekce se platí pouze online. Buď platební bránou nebo převodem na účet. Pokud je rezervace provedena 2 dny předem a méně, je možná již pouze platba přes platební bránu.

Je možné zakoupit permanentky, které nabízejí výhodnější ceny za lekci. Po vybrání lekce v rozvrhu Vám systém tuto možnost nabídne. Zakoupení permanentky mi nerezervuje místo na lekci. Rezervace je potřeba nadále provádět, forma úhrady bude formou permanentky.

Z dopoledních lekcí je nutné se omluvit nejpozději do 7.30 hodin stejného dne. Z odpoledních/večerních lekcí je nutné se omluvit nejpozději do 12 hodin. Jinak lekce v rezervačním systému propadá, popř. je nutné pro návštěvu další lekce tuto neomluvenou uhradit.

Tábory

Přihlášení na tábory se provádí přes webové stránky. Po vyplnění přihlášky, Vám na email dorazí potvrzení přihlášení a pokyny k platbě. Zároveň Vám dorazí přihlašovací údaje do klubu, kde své přihlášení uvidíte.

Je nutné napsat do přihlášky druh omezení. Pokud by bylo nutné potvrzení lékaře, kontaktovali bychom Vás. Potravinové alergie u nás nejsou problém.

Před konáním tábora obdržíte email s podrobnými instrukcemi.

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": 1614831045,
                "last": 1614831045,
                "now": 1614831045
            },
            "token": "Zpet3OQz8KkAA1me6iqqd2D8CaqxA6Yo"
        },
        "registry": {
            "com_categories": {
                "categories": {
                    "filter": {
                        "extension": "com_dropfiles"
                    }
                }
            },
            "list": {
                "limit": 100000000
            },
            "com_dropfiles": {
                "categories": {
                    "blog": {
                        "ordercol": null
                    }
                }
            }
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "dropfilesToken": "13cd5ad432811952b19ce87ecb01fd24"
    }
}

Informace o profilu

Čas

Paměť

Čas: 18.10 ms / 18.10 ms Paměť: 1.859 MB / 2.27 MB Application: afterLoad
Čas: 65.06 ms / 83.17 ms Paměť: 5.377 MB / 7.65 MB Application: afterInitialise
Čas: 24.52 ms / 107.68 ms Paměť: 1.566 MB / 9.22 MB Application: afterRoute
Čas: 5.86 ms / 113.55 ms Paměť: 0.191 MB / 9.41 MB Application: beforeRenderComponent com_content
Čas: 5.90 ms / 119.45 ms Paměť: 0.650 MB / 10.06 MB Application: Before Access::preloadComponents (all components)
Čas: 2.40 ms / 121.84 ms Paměť: 0.062 MB / 10.12 MB Application: After Access::preloadComponents (all components)
Čas: 0.03 ms / 121.87 ms Paměť: 0.000 MB / 10.11 MB Application: Before Access::preloadPermissions (com_content)
Čas: 2.27 ms / 124.15 ms Paměť: 0.359 MB / 10.47 MB Application: After Access::preloadPermissions (com_content)
Čas: 0.04 ms / 124.19 ms Paměť: 0.000 MB / 10.45 MB Application: Before Access::getAssetRules (id:27 name:com_content.category.2)
Čas: 0.56 ms / 124.75 ms Paměť: 0.038 MB / 10.49 MB Application: After Access::getAssetRules (id:27 name:com_content.category.2)
Čas: 6.60 ms / 131.35 ms Paměť: 0.323 MB / 10.82 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Čas: 0.06 ms / 131.40 ms Paměť: 0.007 MB / 10.82 MB Application: After Access::getAssetRules (id:8 name:com_content)
Čas: 48.93 ms / 180.33 ms Paměť: 2.392 MB / 13.22 MB Application: Before Access::getAssetRules (id:1254 name:com_dropfiles)
Čas: 0.07 ms / 180.40 ms Paměť: 0.007 MB / 13.22 MB Application: After Access::getAssetRules (id:1254 name:com_dropfiles)
Čas: 18.86 ms / 199.26 ms Paměť: 0.685 MB / 13.91 MB Application: afterRenderComponent com_content
Čas: 3.87 ms / 203.12 ms Paměť: 0.165 MB / 14.07 MB Application: afterDispatch
Čas: 23.02 ms / 226.14 ms Paměť: 0.904 MB / 14.98 MB Application: beforeRenderModule mod_tm_ajax_contact_form (Napište nám)
Čas: 1.94 ms / 228.08 ms Paměť: 0.087 MB / 15.06 MB Application: afterRenderModule mod_tm_ajax_contact_form (Napište nám)
Čas: 0.07 ms / 228.15 ms Paměť: 0.000 MB / 15.06 MB Application: beforeRenderModule mod_menu (Informace)
Čas: 4.13 ms / 232.28 ms Paměť: 0.146 MB / 15.20 MB Application: afterRenderModule mod_menu (Informace)
Čas: 0.06 ms / 232.34 ms Paměť: 0.000 MB / 15.20 MB Application: beforeRenderModule mod_menu (Navigace)
Čas: 1.36 ms / 233.70 ms Paměť: 0.018 MB / 15.22 MB Application: afterRenderModule mod_menu (Navigace)
Čas: 0.06 ms / 233.76 ms Paměť: 0.000 MB / 15.21 MB Application: beforeRenderModule mod_custom (1FIT)
Čas: 0.50 ms / 234.25 ms Paměť: 0.005 MB / 15.22 MB Application: afterRenderModule mod_custom (1FIT)
Čas: 0.06 ms / 234.32 ms Paměť: 0.003 MB / 15.22 MB Application: beforeRenderModule mod_articles_news_adv (Cvičení pro děti od 4 měsíců - 2,5 roku)
Čas: 9.76 ms / 244.08 ms Paměť: 0.329 MB / 15.55 MB Application: afterRenderModule mod_articles_news_adv (Cvičení pro děti od 4 měsíců - 2,5 roku)
Čas: 0.07 ms / 244.14 ms Paměť: 0.000 MB / 15.39 MB Application: beforeRenderModule mod_articles_news_adv (Cvičení 2,5 roku - 6 let)
Čas: 6.76 ms / 250.90 ms Paměť: 0.189 MB / 15.58 MB Application: afterRenderModule mod_articles_news_adv (Cvičení 2,5 roku - 6 let)
Čas: 0.06 ms / 250.96 ms Paměť: 0.000 MB / 15.44 MB Application: beforeRenderModule mod_articles_news_adv (Kroužky)
Čas: 6.98 ms / 257.94 ms Paměť: 0.186 MB / 15.63 MB Application: afterRenderModule mod_articles_news_adv (Kroužky)
Čas: 0.11 ms / 258.06 ms Paměť: 0.000 MB / 15.49 MB Application: beforeRenderModule mod_articles_news_adv (Cvičení pro maminky)
Čas: 8.31 ms / 266.37 ms Paměť: 0.246 MB / 15.74 MB Application: afterRenderModule mod_articles_news_adv (Cvičení pro maminky)
Čas: 0.07 ms / 266.44 ms Paměť: 0.000 MB / 15.55 MB Application: beforeRenderModule mod_articles_news_adv (Tábory)
Čas: 5.98 ms / 272.42 ms Paměť: 0.135 MB / 15.68 MB Application: afterRenderModule mod_articles_news_adv (Tábory)
Čas: 0.09 ms / 272.50 ms Paměť: 0.000 MB / 15.59 MB Application: beforeRenderModule mod_menu (Kategorie dotazů)
Čas: 1.37 ms / 273.87 ms Paměť: 0.016 MB / 15.61 MB Application: afterRenderModule mod_menu (Kategorie dotazů)
Čas: 0.06 ms / 273.93 ms Paměť: 0.000 MB / 15.61 MB Application: beforeRenderModule mod_custom (Časté dotazy)
Čas: 0.24 ms / 274.17 ms Paměť: 0.003 MB / 15.61 MB Application: afterRenderModule mod_custom (Časté dotazy)
Čas: 3.56 ms / 277.73 ms Paměť: 0.240 MB / 15.85 MB Application: afterRender

Celkem dotazů do databáze: 72.79 ms

Využití paměti

16,81 MB (17.629.616 Bytů)

Dotazy do databáze

50 zaznamenaných dotazů 72.79 ms


Nalezeno 6 duplikátů!

2 duplikátů: #20  #21
2 duplikátů: #22  #23
2 duplikátů: #25  #26
  1. Čas pro dotazy: 1.69 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.21 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.01 ms
    Opening tables0.94 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.02 ms
    executing0.23 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
    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: 0.97 ms Po posledním dotazu: 2.43 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 4.728 MB Vráceno řádků: 5
    SELECT id, rules
    
      FROM `jom_viewlevels`
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjom_viewlevelsNULLALLNULLMOHL BY BÝT POUŽIT NO INDEX KEYNULLNULL5100.00NULL
    Profil
    StatusDuration
    starting0.03 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.00 ms
    Opening tables0.64 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 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
    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.20 ms Po posledním dotazu: 0.11 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 4.740 MB Vráceno řádků: 2
    SELECT b.id
    
      FROM jom_usergroups AS a
      LEFT JOIN jom_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.id = 9
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLconstPRIMARYPRIMARY4const1100.00NULL
    1SIMPLEbNULLrangeidx_usergroup_nested_set_lookupidx_usergroup_nested_set_lookup4NULL2100.00Using where; Using index
    Profil
    StatusDuration
    starting0.05 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.80 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.02 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.36 ms Po posledním dotazu: 0.75 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.00 ms
    Opening tables0.03 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.03 ms
    executing0.93 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.03 ms Po posledním dotazu: 27.22 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.11 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables1.25 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.03 ms
    executing1.33 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: 1.95 ms Po posledním dotazu: 12.42 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.57 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    Opening tables0.62 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.03 ms
    statistics0.11 ms
    preparing0.03 ms
    Creating tmp table0.05 ms
    executing0.08 ms
    checking permissions0.08 ms
    checking permissions0.04 ms
    checking permissions0.01 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.46 ms Po posledním dotazu: 0.58 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.17 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 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
    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.45 ms Po posledním dotazu: 6.70 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.00 ms
    Opening tables0.03 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.08 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
    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.93 ms Po posledním dotazu: 0.18 ms Dotaz paměti: 0.006 MB Paměť před dotazem: 9.012 MB
    UPDATE `jom_extensions`
    
      SET `params` = '{\"mediaversion\":\"3897cbc91fa4eb9423ed6d7507cf95d8\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Vysvětlení
    VYSVĚTLENÍ není možné pro dotaz: UPDATE `jom_extensions` SET `params` = '{\"mediaversion\":\"3897cbc91fa4eb9423ed6d7507cf95d8\"}' WHERE `type` = 'library' AND `element` = 'joomla'
    Profil
    StatusDuration
    starting0.05 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.00 ms
    Opening tables0.03 ms
    init0.01 ms
    System lock0.09 ms
    updating0.10 ms
    end0.01 ms
    query end0.00 ms
    waiting for handler commit1.48 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.23 ms Po posledním dotazu: 2.08 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.04 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.00 ms
    Opening tables0.87 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.02 ms
    executing0.06 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
    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.64 ms Po posledním dotazu: 0.29 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.06 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.88 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.10 ms
    preparing0.04 ms
    executing0.30 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.14 ms Po posledním dotazu: 8.57 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.08 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.00 ms
    Opening tables0.95 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.14 ms
    preparing0.02 ms
    executing0.69 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: 1.39 ms Po posledním dotazu: 0.27 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.06 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.02 ms
    executing0.98 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: 3.50 ms Po posledním dotazu: 2.48 ms Dotaz paměti: 0.037 MB Paměť před dotazem: 10.554 MB Vráceno řádků: 2
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`)
      FROM `jom_content` AS `i`
      WHERE i.`catid` = c.id
      AND i.state = 1) AS numitems
      FROM `jom_categories` AS `s`
      INNER JOIN `jom_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) OR (c.lft < s.lft
      AND s.rgt < c.rgt)
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.published = 1
      AND s.id = 2
      ORDER BY c.lft
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1PRIMARYsNULLconstPRIMARY,idx_left_rightPRIMARY4const1100.00NULL
    1PRIMARYcNULLrangecat_idx,idx_left_rightidx_left_right4NULL843.52Using index condition; Using where
    2DEPENDENT SUBQUERYiNULLrefidx_state,idx_catididx_catid4dp_www_1fit.c.id3100.00Using index condition; Using where
    Profil
    StatusDuration
    starting0.16 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables2.64 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.13 ms
    preparing0.03 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.02 ms
    executing0.06 ms
    executing0.04 ms
    executing0.07 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: 7.27 ms Po posledním dotazu: 2.12 ms Dotaz paměti: 0.093 MB Paměť před dotazem: 10.819 MB Vráceno řádků: 12
    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
      FROM jom_content AS a
      LEFT JOIN jom_categories AS c
      ON c.id = a.catid
      LEFT JOIN jom_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN jom_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN jom_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN jom_content_rating AS v
      ON a.id = v.content_id
      WHERE a.access IN (1,1,5)
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND a.state = 1
      AND (a.catid = 2 OR a.catid IN ( SELECT sub.id
      FROM jom_categories as sub
      INNER JOIN jom_categories as this
      ON sub.lft > this.lft
      AND sub.rgt < this.rgt
      WHERE this.id = 2))
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-03-04 04:10:45')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-03-04 04:10:45')
      ORDER BY c.lft, a.ordering, a.created
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1PRIMARYcNULLALLPRIMARY,idx_accessMOHL BY BÝT POUŽIT NO INDEX KEYNULLNULL10810.00Using where; Using temporary; Použití filesort
    1PRIMARYaNULLrefidx_access,idx_state,idx_catididx_catid4dp_www_1fit.c.id316.00Using index condition; Using where
    1PRIMARYuaNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.created_by1100.00Using where
    1PRIMARYuamNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.modified_by1100.00Using where
    1PRIMARYparentNULLeq_refPRIMARYPRIMARY4dp_www_1fit.c.parent_id1100.00Using where
    1PRIMARYvNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.id1100.00Using where
    2DEPENDENT SUBQUERYthisNULLconstPRIMARY,idx_left_rightPRIMARY4const1100.00NULL
    2DEPENDENT SUBQUERYsubNULLeq_refPRIMARY,idx_left_rightPRIMARY4func130.86Using where
    Profil
    StatusDuration
    executing0.02 ms
    executing0.02 ms
    executing0.02 ms
    executing0.01 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.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.02 ms
    executing0.02 ms
    executing0.03 ms
    executing0.02 ms
    executing0.02 ms
    executing0.02 ms
    executing0.02 ms
    executing0.02 ms
    executing0.01 ms
    executing0.02 ms
    executing0.02 ms
    executing0.02 ms
    executing0.02 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.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.02 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.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.02 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.02 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.02 ms
    executing0.14 ms
    end0.00 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    removing tmp table0.01 ms
    waiting for handler commit0.01 ms
    closing tables0.02 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    17JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    16Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/components/com_content/models/articles.php:576
    14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    13ContentModelCategory->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:144
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

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

  17. Čas pro dotazy: 2.24 ms Po posledním dotazu: 1.98 ms Dotaz paměti: 0.035 MB Paměť před dotazem: 11.464 MB Vráceno řádků: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `jom_contentitem_tag_map` AS m
      INNER JOIN `jom_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.category'
      AND `m`.`content_item_id` = 2
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLALLidx_tag_typeMOHL BY BÝT POUŽIT NO INDEX KEYNULLNULL185.56Using where
    1SIMPLEtNULLeq_refPRIMARY,tag_idx,idx_accessPRIMARY4dp_www_1fit.m.tag_id1100.00Using where
    Profil
    StatusDuration
    starting0.07 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables1.74 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.08 ms
    preparing0.02 ms
    executing0.05 ms
    end0.00 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    closing tables0.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: 0.71 ms Po posledním dotazu: 7.48 ms Dotaz paměti: 0.038 MB Paměť před dotazem: 12.094 MB Vráceno řádků: 2
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM `jom_categories` AS `s`
      INNER JOIN `jom_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) OR (c.lft < s.lft
      AND s.rgt < c.rgt)
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND s.id = 2
      ORDER BY c.lft
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEsNULLconstPRIMARY,idx_left_rightPRIMARY4const1100.00NULL
    1SIMPLEcNULLrangecat_idx,idx_access,idx_left_rightidx_left_right4NULL845.37Using index condition; Using where
    Profil
    StatusDuration
    starting0.13 ms
    Executing hook on transaction 0.01 ms
    starting0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.05 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.14 ms
    preparing0.03 ms
    executing0.08 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
    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.52 ms Po posledním dotazu: 0.18 ms Dotaz paměti: 0.037 MB Paměť před dotazem: 12.112 MB Vráceno řádků: 0
    SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM jom_fields AS a
      LEFT JOIN `jom_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN jom_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN jom_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN jom_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN jom_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `jom_fields_categories` AS fc
      ON fc.field_id = a.id
      WHERE a.context = 'com_content.article'
      AND (fc.category_id IS NULL OR fc.category_id IN (2,0))
      AND a.access IN (1,1,5)
      AND (a.group_id = 0 OR g.access IN (1,1,5))
      AND a.state = 1
      AND (a.group_id = 0 OR g.state = 1)
      ORDER BY a.ordering ASC
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLrefidx_state,idx_access,idx_contextidx_state1const1100.00Using where; Using temporary; Použití filesort
    1SIMPLElNULLeq_refidx_langcodeidx_langcode28dp_www_1fit.a.language1100.00Using where
    1SIMPLEucNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.checked_out1100.00NULL
    1SIMPLEagNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.access1100.00Using where
    1SIMPLEuaNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.created_user_id1100.00Using where
    1SIMPLEgNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.group_id1100.00Using where
    1SIMPLEfcNULLrefPRIMARYPRIMARY4dp_www_1fit.a.id1100.00Using where; Using index; Distinct
    Profil
    StatusDuration
    starting0.14 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables2.72 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.03 ms
    statistics0.16 ms
    preparing0.05 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.03 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    17Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    16FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    13PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

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

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

  22. Čas pro dotazy: 0.38 ms Po posledním dotazu: 2.09 ms Dotaz paměti: 0.028 MB Paměť před dotazem: 13.042 MB Vráceno řádků: 1
    Duplicitní dotazy: #23
    SELECT rgt,lft 
      FROM jom_categories
      WHERE id=134
      AND extension='com_dropfiles'
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjom_categoriesNULLconstPRIMARY,cat_idxPRIMARY4const1100.00NULL
    Profil
    StatusDuration
    starting0.05 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.01 ms
    statistics0.05 ms
    preparing0.01 ms
    executing0.01 ms
    end0.00 ms
    query end0.01 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    22JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/database.php:33
    21JDatabase->query()JROOT/administrator/components/com_dropfiles/models/categories.php:121
    20DropfilesModelCategories->getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:133
    19Joomla\CMS\MVC\Model\ListModel->_getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:187
    18Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_categories/models/categories.php:354
    17CategoriesModelCategories->getItems()JROOT/components/com_dropfiles/models/frontcategories.php:99
    16DropfilesModelFrontcategories->getItems()JROOT/plugins/content/dropfiles/dropfiles.php:242
    15PlgContentdropfiles->replace()Stejné jako volání v řádku níže.
    14preg_replace_callback()JROOT/plugins/content/dropfiles/dropfiles.php:55
    13PlgContentdropfiles->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

  23. Čas pro dotazy: 0.37 ms Po posledním dotazu: 0.06 ms Dotaz paměti: 0.028 MB Paměť před dotazem: 13.052 MB Vráceno řádků: 1
    Duplicitní dotazy: #22
    SELECT rgt,lft 
      FROM jom_categories
      WHERE id=134
      AND extension='com_dropfiles'
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjom_categoriesNULLconstPRIMARY,cat_idxPRIMARY4const1100.00NULL
    Profil
    StatusDuration
    starting0.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.02 ms
    statistics0.05 ms
    preparing0.01 ms
    executing0.01 ms
    end0.00 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    22JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    21JDatabaseDriver->loadObject()JROOT/administrator/components/com_dropfiles/models/categories.php:124
    20DropfilesModelCategories->getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:133
    19Joomla\CMS\MVC\Model\ListModel->_getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:187
    18Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_categories/models/categories.php:354
    17CategoriesModelCategories->getItems()JROOT/components/com_dropfiles/models/frontcategories.php:99
    16DropfilesModelFrontcategories->getItems()JROOT/plugins/content/dropfiles/dropfiles.php:242
    15PlgContentdropfiles->replace()Stejné jako volání v řádku níže.
    14preg_replace_callback()JROOT/plugins/content/dropfiles/dropfiles.php:55
    13PlgContentdropfiles->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

  24. Čas pro dotazy: 1.47 ms Po posledním dotazu: 0.10 ms Dotaz paměti: 0.032 MB Paměť před dotazem: 13.064 MB Vráceno řádků: 0
    SELECT a.id, a.title, a.alias, a.note, a.published, a.access, a.checked_out, a.checked_out_time, a.created_user_id, a.path, a.parent_id, a.level, a.lft, a.rgt, a.language,l.title AS language_title,uc.name AS editor,d.type AS type,COUNT(f.id) as files
    
      FROM jom_categories AS a
      LEFT JOIN `jom_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN jom_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN jom_dropfiles AS d
      ON d.id=a.id
      LEFT JOIN jom_dropfiles_files AS f
      ON a.id = f.catid
      WHERE a.extension = 'com_dropfiles'
      AND (a.published IN (0, 1))
      AND a.parent_id = 134
      GROUP BY a.id
      ORDER BY a.lft ASC
      LIMIT 100000000
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLrangePRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_aliascat_idx203NULL210.00Using index condition; Using where; Using temporary; Použití filesort
    1SIMPLElNULLeq_refidx_langcodeidx_langcode28dp_www_1fit.a.language1100.00Using where
    1SIMPLEucNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.checked_out1100.00Using where
    1SIMPLEdNULLeq_refidid4dp_www_1fit.a.id1100.00NULL
    1SIMPLEfNULLrefid_galleryid_gallery4dp_www_1fit.a.id5100.00NULL
    Profil
    StatusDuration
    starting0.13 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.78 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.09 ms
    preparing0.03 ms
    Creating tmp table0.05 ms
    executing0.08 ms
    end0.01 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    removing tmp table0.01 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    20JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    19Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    18Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_categories/models/categories.php:354
    17CategoriesModelCategories->getItems()JROOT/components/com_dropfiles/models/frontcategories.php:99
    16DropfilesModelFrontcategories->getItems()JROOT/plugins/content/dropfiles/dropfiles.php:242
    15PlgContentdropfiles->replace()Stejné jako volání v řádku níže.
    14preg_replace_callback()JROOT/plugins/content/dropfiles/dropfiles.php:55
    13PlgContentdropfiles->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

  25. Čas pro dotazy: 0.27 ms Po posledním dotazu: 0.12 ms Dotaz paměti: 0.027 MB Paměť před dotazem: 13.055 MB Vráceno řádků: 1
    Duplicitní dotazy: #26
    SELECT * 
      FROM jom_dropfiles
      WHERE id = 134
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjom_dropfilesNULLsystemidMOHL BY BÝT POUŽIT NO INDEX KEYNULLNULL1100.00NULL
    Profil
    StatusDuration
    starting0.03 ms
    Executing hook on transaction 0.00 ms
    starting0.01 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    init0.00 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.01 ms
    executing0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.01 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/database.php:33
    17JDatabase->query()JROOT/components/com_dropfiles/models/frontconfig.php:40
    16DropfilesModelFrontconfig->getParams()JROOT/plugins/content/dropfiles/dropfiles.php:243
    15PlgContentdropfiles->replace()Stejné jako volání v řádku níže.
    14preg_replace_callback()JROOT/plugins/content/dropfiles/dropfiles.php:55
    13PlgContentdropfiles->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

  26. Čas pro dotazy: 0.31 ms Po posledním dotazu: 0.05 ms Dotaz paměti: 0.027 MB Paměť před dotazem: 13.064 MB Vráceno řádků: 1
    Duplicitní dotazy: #25
    SELECT * 
      FROM jom_dropfiles
      WHERE id = 134
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjom_dropfilesNULLsystemidMOHL BY BÝT POUŽIT NO INDEX KEYNULLNULL1100.00NULL
    Profil
    StatusDuration
    starting0.04 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    init0.00 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.01 ms
    end0.00 ms
    query end0.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:1662
    17JDatabaseDriver->loadObject()JROOT/components/com_dropfiles/models/frontconfig.php:41
    16DropfilesModelFrontconfig->getParams()JROOT/plugins/content/dropfiles/dropfiles.php:243
    15PlgContentdropfiles->replace()Stejné jako volání v řádku níže.
    14preg_replace_callback()JROOT/plugins/content/dropfiles/dropfiles.php:55
    13PlgContentdropfiles->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

  27. Čas pro dotazy: 1.10 ms Po posledním dotazu: 0.16 ms Dotaz paměti: 0.035 MB Paměť před dotazem: 13.083 MB Vráceno řádků: 5
    SELECT a.id, a.title, a.file, a.ext, a.size, a.hits, a.description, a.version, a.canview, a.catid, a.created_time,a.modified_time,a.custom_icon,c.title AS category_title, c.path AS category_route,
                            c.access AS category_access, c.alias AS category_alias,parent.title as parent_title, parent.id as parent_id,
                            parent.path as parent_route, parent.alias as parent_alias,c.published, c.published AS parents_published
    
      FROM jom_dropfiles_files AS a
      LEFT JOIN jom_categories AS c
      ON c.id = a.catid
      LEFT JOIN jom_categories as parent
      ON parent.id = c.parent_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM jom_categories AS cat JOIN jom_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_dropfiles') AS badcats
      ON badcats.id = c.id
      WHERE c.access IN (1,1,5)
      AND a.catid = 134
      AND (a.publish = '0000-00-00 00:00:00' OR a.publish <= '2021-03-04 04:10:45')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-03-04 04:10:45')
      AND a.state = 1
      GROUP BY a.id, a.title, a.catid, a.state, badcats.id, c.title, c.path, c.access, c.alias, parent.title, parent.id, parent.path, parent.alias, c.published, c.lft, parent.lft, c.id
      ORDER BY ordering asc
      LIMIT 1000
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcNULLconstPRIMARY,idx_accessPRIMARY4const1100.00Using temporary; Použití filesort
    1SIMPLEparentNULLconstPRIMARYPRIMARY4const1100.00NULL
    1SIMPLEaNULLrefid_galleryid_gallery4const420.00Using where
    1SIMPLEcatNULLconstPRIMARY,idx_left_rightPRIMARY4const1100.00NULL
    1SIMPLEparentNULLrefcat_idx,idx_left_rightcat_idx202const12100.00Using where
    Profil
    StatusDuration
    starting0.17 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
    Opening tables0.10 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.04 ms
    statistics0.15 ms
    preparing0.03 ms
    Creating tmp table0.06 ms
    executing0.24 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
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    19JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    18Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    17Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/components/com_dropfiles/models/frontfiles.php:230
    16DropfilesModelFrontfiles->getItems()JROOT/plugins/content/dropfiles/dropfiles.php:328
    15PlgContentdropfiles->replace()Stejné jako volání v řádku níže.
    14preg_replace_callback()JROOT/plugins/content/dropfiles/dropfiles.php:55
    13PlgContentdropfiles->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

  28. Čas pro dotazy: 0.86 ms Po posledním dotazu: 0.94 ms Dotaz paměti: 0.009 MB Paměť před dotazem: 13.206 MB
    DELETE 
      FROM jom_dropfiles_tokens
      WHERE time < 1614827445
    Vysvětlení
    VYSVĚTLENÍ není možné pro dotaz: DELETE FROM jom_dropfiles_tokens WHERE time < 1614827445
    Profil
    StatusDuration
    starting0.05 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.01 ms
    Opening tables0.58 ms
    init0.01 ms
    System lock0.02 ms
    updating0.06 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.01 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/database.php:33
    18JDatabase->query()JROOT/components/com_dropfiles/models/tokens.php:113
    17DropfilesModelTokens->removeTokens()JROOT/administrator/components/com_dropfiles/helpers/files.php:200
    16DropfilesFilesHelper::addInfosToFile()JROOT/plugins/content/dropfiles/dropfiles.php:330
    15PlgContentdropfiles->replace()Stejné jako volání v řádku níže.
    14preg_replace_callback()JROOT/plugins/content/dropfiles/dropfiles.php:55
    13PlgContentdropfiles->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

  29. Čas pro dotazy: 0.39 ms Po posledním dotazu: 0.22 ms Dotaz paměti: 0.009 MB Paměť před dotazem: 13.223 MB
    INSERT INTO jom_dropfiles_tokens (id_user,time,token)  
      values (0,1614831045,'13cd5ad432811952b19ce87ecb01fd24')
    Vysvětlení
    VYSVĚTLENÍ není možné pro dotaz: INSERT INTO jom_dropfiles_tokens (id_user,time,token) values (0,1614831045,'13cd5ad432811952b19ce87ecb01fd24')
    Profil
    StatusDuration
    starting0.05 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.00 ms
    System lock0.01 ms
    update0.04 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.01 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/database.php:33
    18JDatabase->query()JROOT/components/com_dropfiles/models/tokens.php:47
    17DropfilesModelTokens->createToken()JROOT/administrator/components/com_dropfiles/helpers/files.php:205
    16DropfilesFilesHelper::addInfosToFile()JROOT/plugins/content/dropfiles/dropfiles.php:330
    15PlgContentdropfiles->replace()Stejné jako volání v řádku níže.
    14preg_replace_callback()JROOT/plugins/content/dropfiles/dropfiles.php:55
    13PlgContentdropfiles->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

  30. Čas pro dotazy: 0.85 ms Po posledním dotazu: 16.17 ms Dotaz paměti: 0.039 MB Paměť před dotazem: 13.963 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.17 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.08 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.14 ms
    preparing0.03 ms
    Creating tmp table0.07 ms
    executing0.06 ms
    end0.01 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    removing tmp table0.01 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    24JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    23JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    22Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    21FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    20Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    19FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    18PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    17JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    16JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    15Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/templates/theme3703/html/com_content/category/blog.php:18
    14include JROOT/templates/theme3703/html/com_content/category/blog.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
    13Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/libraries/src/MVC/View/HtmlView.php:230
    12Joomla\CMS\MVC\View\HtmlView->display()JROOT/libraries/src/MVC/View/CategoryView.php:245
    11Joomla\CMS\MVC\View\CategoryView->display()JROOT/components/com_content/views/category/view.html.php:250
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

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

  32. Čas pro dotazy: 1.56 ms Po posledním dotazu: 0.50 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 13.927 MB Vráceno řádků: 6
    SHOW FULL COLUMNS 
      FROM `jom_template_styles`
    Vysvětlení
    VYSVĚTLENÍ není možné pro dotaz: SHOW FULL COLUMNS FROM `jom_template_styles`
    Profil
    StatusDuration
    starting0.10 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    Opening tables0.57 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.03 ms
    statistics0.11 ms
    preparing0.04 ms
    Creating tmp table0.05 ms
    executing0.09 ms
    checking permissions0.07 ms
    checking permissions0.05 ms
    checking permissions0.04 ms
    checking permissions0.04 ms
    checking permissions0.04 ms
    checking permissions0.03 ms
    checking permissions0.01 ms
    checking permissions0.04 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.04 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/joomla/database/driver/mysqli.php:445
    12JDatabaseDriverMysqli->getTableColumns()JROOT/libraries/src/Table/Table.php:245
    11Joomla\CMS\Table\Table->getFields()JROOT/libraries/src/Table/Table.php:164
    10Joomla\CMS\Table\Table->__construct()JROOT/administrator/components/com_templates/tables/style.php:30
    9TemplatesTableStyle->__construct()JROOT/libraries/src/Table/Table.php:312
    8Joomla\CMS\Table\Table::getInstance()JROOT/plugins/system/helixultimate/helixultimate.php:41
    7plgSystemHelixultimate->onAfterDispatch()JROOT/libraries/joomla/event/event.php:70
    6JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    5JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    4Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/SiteApplication.php:199
    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.]

  33. Čas pro dotazy: 0.36 ms Po posledním dotazu: 0.14 ms Dotaz paměti: 0.044 MB Paměť před dotazem: 13.953 MB Vráceno řádků: 1
    SELECT *
    
      FROM jom_template_styles
      WHERE `id` = '30'
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjom_template_stylesNULLconstPRIMARYPRIMARY4const1100.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.05 ms
    preparing0.01 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
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1465
    9JDatabaseDriver->loadAssoc()JROOT/libraries/src/Table/Table.php:731
    8Joomla\CMS\Table\Table->load()JROOT/plugins/system/helixultimate/helixultimate.php:42
    7plgSystemHelixultimate->onAfterDispatch()JROOT/libraries/joomla/event/event.php:70
    6JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    5JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    4Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/SiteApplication.php:199
    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.]

  34. Čas pro dotazy: 5.28 ms Po posledním dotazu: 6.00 ms Dotaz paměti: 0.031 MB Paměť před dotazem: 14.598 MB Vráceno řádků: 26
    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:45')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-03-04 04:10:45')
      AND m.access IN (1,1,5)
      AND m.client_id = 0
      AND (mm.menuid = 1078 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.12 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables1.66 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.04 ms
    statistics0.10 ms
    preparing0.05 ms
    executing3.05 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
    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.]

  35. Čas pro dotazy: 1.09 ms Po posledním dotazu: 22.49 ms Dotaz paměti: 0.040 MB Paměť před dotazem: 15.306 MB Vráceno řádků: 6
    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 (138)
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-03-04 04:10:45')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-03-04 04:10:45')
      ORDER BY a.publish_up ASC
      LIMIT 150
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcNULLconstPRIMARY,idx_accessPRIMARY4const1100.00Použití filesort
    1SIMPLEaNULLrefidx_access,idx_state,idx_catididx_catid4const616.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.20 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.10 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.03 ms
    statistics0.15 ms
    preparing0.05 ms
    executing0.27 ms
    end0.01 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    14Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    13Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/components/com_content/models/articles.php:576
    12ContentModelArticles->getItems()JROOT/modules/mod_articles_news_adv/helper.php:110
    11ModArticlesNewsAdvHelper::getList()JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
    10include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:501
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:793
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:567
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1047
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

  36. Čas pro dotazy: 1.05 ms Po posledním dotazu: 0.69 ms Dotaz paměti: 0.040 MB Paměť před dotazem: 15.478 MB Vráceno řádků: 3
    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 = 138
      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 KEYNULLNULL10841.59Using 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.06 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.14 ms
    preparing0.04 ms
    executing0.39 ms
    end0.01 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    24JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
    23Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
    22Joomla\CMS\Categories\Categories->get()JROOT/components/com_content/router.php:72
    21ContentRouter->getCategorySegment()Stejné jako volání v řádku níže.
    20call_user_func_array()JROOT/libraries/src/Component/Router/RouterView.php:120
    19Joomla\CMS\Component\Router\RouterView->getPath()JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    18Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()JROOT/libraries/src/Component/Router/RouterView.php:222
    17Joomla\CMS\Component\Router\RouterView->preprocess()JROOT/libraries/src/Router/SiteRouter.php:672
    16Joomla\CMS\Router\SiteRouter->processBuildRules()JROOT/libraries/src/Router/Router.php:266
    15Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:154
    14Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    13Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    12Joomla\CMS\Router\Route::_()JROOT/modules/mod_articles_news_adv/helper.php:124
    11ModArticlesNewsAdvHelper::getList()JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
    10include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:501
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:793
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:567
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1047
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

  37. Čas pro dotazy: 0.80 ms Po posledním dotazu: 0.49 ms Dotaz paměti: 0.039 MB Paměť před dotazem: 15.506 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.15 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.07 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.14 ms
    preparing0.03 ms
    Creating tmp table0.06 ms
    executing0.06 ms
    end0.01 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    removing tmp table0.01 ms
    waiting for handler commit0.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.]

  38. Čas pro dotazy: 0.81 ms Po posledním dotazu: 0.32 ms Dotaz paměti: 0.038 MB Paměť před dotazem: 15.518 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 (138,0,137))
      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.16 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.03 ms
    statistics0.15 ms
    preparing0.04 ms
    Creating tmp table0.06 ms
    executing0.06 ms
    end0.01 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    removing tmp table0.01 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    22JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    21JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    20Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    19FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    18Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    17FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:404
    16PlgSystemFields->display()JROOT/plugins/system/fields/fields.php:358
    15PlgSystemFields->onContentAfterDisplay()JROOT/libraries/joomla/event/event.php:70
    14JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    13JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    12Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/modules/mod_articles_news_adv/helper.php:144
    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.]

  39. Čas pro dotazy: 0.97 ms Po posledním dotazu: 3.87 ms Dotaz paměti: 0.039 MB Paměť před dotazem: 15.429 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 (139)
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-03-04 04:10:45')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-03-04 04:10:45')
      ORDER BY a.publish_up ASC
      LIMIT 150
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcNULLconstPRIMARY,idx_accessPRIMARY4const1100.00Použití filesort
    1SIMPLEaNULLrefidx_access,idx_state,idx_catididx_catid4const616.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.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
    Opening tables0.09 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.03 ms
    statistics0.14 ms
    preparing0.05 ms
    executing0.24 ms
    end0.01 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    14Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    13Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/components/com_content/models/articles.php:576
    12ContentModelArticles->getItems()JROOT/modules/mod_articles_news_adv/helper.php:110
    11ModArticlesNewsAdvHelper::getList()JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
    10include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:501
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:793
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:567
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1047
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

  40. Čas pro dotazy: 1.02 ms Po posledním dotazu: 0.65 ms Dotaz paměti: 0.040 MB Paměť před dotazem: 15.574 MB Vráceno řádků: 3
    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 = 139
      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 KEYNULLNULL10842.01Using 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.05 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.14 ms
    preparing0.04 ms
    executing0.38 ms
    end0.01 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    24JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
    23Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
    22Joomla\CMS\Categories\Categories->get()JROOT/components/com_content/router.php:72
    21ContentRouter->getCategorySegment()Stejné jako volání v řádku níže.
    20call_user_func_array()JROOT/libraries/src/Component/Router/RouterView.php:120
    19Joomla\CMS\Component\Router\RouterView->getPath()JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    18Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()JROOT/libraries/src/Component/Router/RouterView.php:222
    17Joomla\CMS\Component\Router\RouterView->preprocess()JROOT/libraries/src/Router/SiteRouter.php:672
    16Joomla\CMS\Router\SiteRouter->processBuildRules()JROOT/libraries/src/Router/Router.php:266
    15Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:154
    14Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    13Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    12Joomla\CMS\Router\Route::_()JROOT/modules/mod_articles_news_adv/helper.php:124
    11ModArticlesNewsAdvHelper::getList()JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
    10include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:501
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:793
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:567
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1047
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

  41. Čas pro dotazy: 0.85 ms Po posledním dotazu: 0.49 ms Dotaz paměti: 0.038 MB Paměť před dotazem: 15.587 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 (139,0,137))
      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.16 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.08 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.03 ms
    statistics0.16 ms
    preparing0.04 ms
    Creating tmp table0.06 ms
    executing0.06 ms
    end0.01 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    removing tmp table0.01 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    22JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    21JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    20Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    19FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    18Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    17FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:404
    16PlgSystemFields->display()JROOT/plugins/system/fields/fields.php:358
    15PlgSystemFields->onContentAfterDisplay()JROOT/libraries/joomla/event/event.php:70
    14JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    13JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    12Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/modules/mod_articles_news_adv/helper.php:144
    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.]

  42. Čas pro dotazy: 1.04 ms Po posledním dotazu: 2.81 ms Dotaz paměti: 0.039 MB Paměť před dotazem: 15.478 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 (140)
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-03-04 04:10:45')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-03-04 04:10:45')
      ORDER BY a.publish_up ASC
      LIMIT 150
    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.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
    Opening tables0.09 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.03 ms
    statistics0.14 ms
    preparing0.05 ms
    executing0.24 ms
    end0.01 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    14Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    13Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/components/com_content/models/articles.php:576
    12ContentModelArticles->getItems()JROOT/modules/mod_articles_news_adv/helper.php:110
    11ModArticlesNewsAdvHelper::getList()JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
    10include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:501
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:793
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:567
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1047
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

  43. Čas pro dotazy: 1.08 ms Po posledním dotazu: 0.63 ms Dotaz paměti: 0.040 MB Paměť před dotazem: 15.623 MB Vráceno řádků: 3
    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 = 140
      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 KEYNULLNULL10842.43Using 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.06 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.15 ms
    preparing0.04 ms
    executing0.40 ms
    end0.01 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.02 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    24JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
    23Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
    22Joomla\CMS\Categories\Categories->get()JROOT/components/com_content/router.php:72
    21ContentRouter->getCategorySegment()Stejné jako volání v řádku níže.
    20call_user_func_array()JROOT/libraries/src/Component/Router/RouterView.php:120
    19Joomla\CMS\Component\Router\RouterView->getPath()JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    18Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()JROOT/libraries/src/Component/Router/RouterView.php:222
    17Joomla\CMS\Component\Router\RouterView->preprocess()JROOT/libraries/src/Router/SiteRouter.php:672
    16Joomla\CMS\Router\SiteRouter->processBuildRules()JROOT/libraries/src/Router/Router.php:266
    15Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:154
    14Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    13Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    12Joomla\CMS\Router\Route::_()JROOT/modules/mod_articles_news_adv/helper.php:124
    11ModArticlesNewsAdvHelper::getList()JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
    10include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:501
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:793
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:567
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1047
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

  44. Čas pro dotazy: 0.88 ms Po posledním dotazu: 0.49 ms Dotaz paměti: 0.038 MB Paměť před dotazem: 15.636 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 (140,0,137))
      AND a.access IN (1,1,5)
      AND (a.group_id = 0 OR g.access IN (1,1,5))
      AND a.state = 1
      AND (a.group_id = 0 OR g.state = 1)
      ORDER BY a.ordering ASC
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLrefidx_state,idx_access,idx_contextidx_state1const1100.00Using where; Using temporary; Použití filesort
    1SIMPLElNULLeq_refidx_langcodeidx_langcode28dp_www_1fit.a.language1100.00Using where
    1SIMPLEucNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.checked_out1100.00NULL
    1SIMPLEagNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.access1100.00Using where
    1SIMPLEuaNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.created_user_id1100.00Using where
    1SIMPLEgNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.group_id1100.00Using where
    1SIMPLEfcNULLrefPRIMARYPRIMARY4dp_www_1fit.a.id1100.00Using where; Using index; Distinct
    Profil
    StatusDuration
    starting0.17 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.08 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.03 ms
    statistics0.16 ms
    preparing0.04 ms
    Creating tmp table0.06 ms
    executing0.06 ms
    end0.01 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    removing tmp table0.01 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    22JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    21JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    20Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    19FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    18Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    17FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:404
    16PlgSystemFields->display()JROOT/plugins/system/fields/fields.php:358
    15PlgSystemFields->onContentAfterDisplay()JROOT/libraries/joomla/event/event.php:70
    14JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    13JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    12Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/modules/mod_articles_news_adv/helper.php:144
    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.]

  45. Čas pro dotazy: 1.12 ms Po posledním dotazu: 3.00 ms Dotaz paměti: 0.044 MB Paměť před dotazem: 15.528 MB Vráceno řádků: 7
    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 (141)
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-03-04 04:10:45')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-03-04 04:10:45')
      ORDER BY a.publish_up ASC
      LIMIT 150
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcNULLconstPRIMARY,idx_accessPRIMARY4const1100.00Použití filesort
    1SIMPLEaNULLrefidx_access,idx_state,idx_catididx_catid4const716.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.20 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.10 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.04 ms
    statistics0.15 ms
    preparing0.05 ms
    executing0.30 ms
    end0.01 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    14Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    13Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/components/com_content/models/articles.php:576
    12ContentModelArticles->getItems()JROOT/modules/mod_articles_news_adv/helper.php:110
    11ModArticlesNewsAdvHelper::getList()JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
    10include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:501
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:793
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:567
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1047
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

  46. Čas pro dotazy: 1.13 ms Po posledním dotazu: 0.83 ms Dotaz paměti: 0.040 MB Paměť před dotazem: 15.725 MB Vráceno řádků: 3
    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 = 141
      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 KEYNULLNULL10842.85Using 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.06 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.03 ms
    statistics0.16 ms
    preparing0.04 ms
    executing0.47 ms
    end0.01 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    24JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
    23Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
    22Joomla\CMS\Categories\Categories->get()JROOT/components/com_content/router.php:72
    21ContentRouter->getCategorySegment()Stejné jako volání v řádku níže.
    20call_user_func_array()JROOT/libraries/src/Component/Router/RouterView.php:120
    19Joomla\CMS\Component\Router\RouterView->getPath()JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    18Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()JROOT/libraries/src/Component/Router/RouterView.php:222
    17Joomla\CMS\Component\Router\RouterView->preprocess()JROOT/libraries/src/Router/SiteRouter.php:672
    16Joomla\CMS\Router\SiteRouter->processBuildRules()JROOT/libraries/src/Router/Router.php:266
    15Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:154
    14Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    13Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    12Joomla\CMS\Router\Route::_()JROOT/modules/mod_articles_news_adv/helper.php:124
    11ModArticlesNewsAdvHelper::getList()JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
    10include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:501
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:793
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:567
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1047
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

  47. Čas pro dotazy: 0.91 ms Po posledním dotazu: 0.51 ms Dotaz paměti: 0.038 MB Paměť před dotazem: 15.738 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 (141,0,137))
      AND a.access IN (1,1,5)
      AND (a.group_id = 0 OR g.access IN (1,1,5))
      AND a.state = 1
      AND (a.group_id = 0 OR g.state = 1)
      ORDER BY a.ordering ASC
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLrefidx_state,idx_access,idx_contextidx_state1const1100.00Using where; Using temporary; Použití filesort
    1SIMPLElNULLeq_refidx_langcodeidx_langcode28dp_www_1fit.a.language1100.00Using where
    1SIMPLEucNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.checked_out1100.00NULL
    1SIMPLEagNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.access1100.00Using where
    1SIMPLEuaNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.created_user_id1100.00Using where
    1SIMPLEgNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.group_id1100.00Using where
    1SIMPLEfcNULLrefPRIMARYPRIMARY4dp_www_1fit.a.id1100.00Using where; Using index; Distinct
    Profil
    StatusDuration
    starting0.17 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.08 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.03 ms
    statistics0.17 ms
    preparing0.04 ms
    Creating tmp table0.07 ms
    executing0.07 ms
    end0.01 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    removing tmp table0.01 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    22JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    21JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    20Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    19FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    18Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    17FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:404
    16PlgSystemFields->display()JROOT/plugins/system/fields/fields.php:358
    15PlgSystemFields->onContentAfterDisplay()JROOT/libraries/joomla/event/event.php:70
    14JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    13JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    12Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/modules/mod_articles_news_adv/helper.php:144
    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.]

  48. Čas pro dotazy: 1.05 ms Po posledním dotazu: 3.87 ms Dotaz paměti: 0.038 MB Paměť před dotazem: 15.587 MB Vráceno řádků: 3
    SELECT a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
      FROM jom_content AS a
      LEFT JOIN jom_categories AS c
      ON c.id = a.catid
      LEFT JOIN jom_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN jom_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN jom_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN jom_content_rating AS v
      ON a.id = v.content_id
      WHERE a.access IN (1,1,5)
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND a.state = 1
      AND a.catid IN (142)
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-03-04 04:10:45')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-03-04 04:10:45')
      ORDER BY a.publish_up ASC
      LIMIT 150
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcNULLconstPRIMARY,idx_accessPRIMARY4const1100.00Použití filesort
    1SIMPLEaNULLrefidx_access,idx_state,idx_catididx_catid4const316.00Using where
    1SIMPLEuaNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.created_by1100.00Using where
    1SIMPLEuamNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.modified_by1100.00Using where; Using index
    1SIMPLEparentNULLconstPRIMARYPRIMARY4const1100.00Using where
    1SIMPLEvNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.id1100.00Using where
    Profil
    StatusDuration
    starting0.20 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.10 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.04 ms
    statistics0.15 ms
    preparing0.05 ms
    executing0.21 ms
    end0.01 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    14Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    13Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/components/com_content/models/articles.php:576
    12ContentModelArticles->getItems()JROOT/modules/mod_articles_news_adv/helper.php:110
    11ModArticlesNewsAdvHelper::getList()JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
    10include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:501
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:793
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:567
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1047
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

  49. Čas pro dotazy: 1.10 ms Po posledním dotazu: 0.48 ms Dotaz paměti: 0.040 MB Paměť před dotazem: 15.680 MB Vráceno řádků: 3
    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 = 142
      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 KEYNULLNULL10843.27Using 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.06 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.03 ms
    statistics0.16 ms
    preparing0.04 ms
    executing0.43 ms
    end0.01 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    24JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
    23Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
    22Joomla\CMS\Categories\Categories->get()JROOT/components/com_content/router.php:72
    21ContentRouter->getCategorySegment()Stejné jako volání v řádku níže.
    20call_user_func_array()JROOT/libraries/src/Component/Router/RouterView.php:120
    19Joomla\CMS\Component\Router\RouterView->getPath()JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    18Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()JROOT/libraries/src/Component/Router/RouterView.php:222
    17Joomla\CMS\Component\Router\RouterView->preprocess()JROOT/libraries/src/Router/SiteRouter.php:672
    16Joomla\CMS\Router\SiteRouter->processBuildRules()JROOT/libraries/src/Router/Router.php:266
    15Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:154
    14Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    13Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    12Joomla\CMS\Router\Route::_()JROOT/modules/mod_articles_news_adv/helper.php:124
    11ModArticlesNewsAdvHelper::getList()JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
    10include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:501
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:793
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:567
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1047
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:61
    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

  50. Čas pro dotazy: 0.87 ms Po posledním dotazu: 0.49 ms Dotaz paměti: 0.038 MB Paměť před dotazem: 15.693 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 (142,0,137))
      AND a.access IN (1,1,5)
      AND (a.group_id = 0 OR g.access IN (1,1,5))
      AND a.state = 1
      AND (a.group_id = 0 OR g.state = 1)
      ORDER BY a.ordering ASC
    Vysvětlení
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLrefidx_state,idx_access,idx_contextidx_state1const1100.00Using where; Using temporary; Použití filesort
    1SIMPLElNULLeq_refidx_langcodeidx_langcode28dp_www_1fit.a.language1100.00Using where
    1SIMPLEucNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.checked_out1100.00NULL
    1SIMPLEagNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.access1100.00Using where
    1SIMPLEuaNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.created_user_id1100.00Using where
    1SIMPLEgNULLeq_refPRIMARYPRIMARY4dp_www_1fit.a.group_id1100.00Using where
    1SIMPLEfcNULLrefPRIMARYPRIMARY4dp_www_1fit.a.id1100.00Using where; Using index; Distinct
    Profil
    StatusDuration
    starting0.17 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.08 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.03 ms
    statistics0.16 ms
    preparing0.04 ms
    Creating tmp table0.06 ms
    executing0.06 ms
    end0.01 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    removing tmp table0.01 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Stack volání
    #VolajícíSoubor a číslo řádku
    22JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    21JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    20Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    19FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    18Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    17FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:404
    16PlgSystemFields->display()JROOT/plugins/system/fields/fields.php:358
    15PlgSystemFields->onContentAfterDisplay()JROOT/libraries/joomla/event/event.php:70
    14JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    13JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    12Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/modules/mod_articles_news_adv/helper.php:144
    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.]

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

VYBRANÉ tabulky:
  1. 7 × 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
  2. 6 × 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)
  3. 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
  4. 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
  5. 2 × SELECT * 
      FROM jom_dropfiles
  6. 2 × SELECT rgt,lft 
      FROM jom_categories
  7. 2 × SELECT a.level, a.id, a.title, a.parent_id, a.access, a.created_user_id,b.title as parent_title,b.id as parent_id,c.type, c.cloud_id 
      FROM jom_categories as a
      LEFT
      OUTER JOIN jom_categories AS b
      ON b.id=a.parent_id
      AND b.extension='com_dropfiles'
      LEFT
      OUTER JOIN jom_dropfiles AS c
      ON c.id=a.id
  8. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
      FROM `jom_extensions`
  9. 2 × SELECT `id`,`name`,`rules`,`parent_id` 
      FROM `jom_assets`
  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 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
  12. 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
  13. 1 × SELECT id, rules 
      FROM `jom_viewlevels
  14. 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
  15. 1 × SELECT * 
      FROM jom_languages
  16. 1 × SELECT * 
      FROM jom_komento_configs
  17. 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
  18. 1 × SELECT a.id, a.title, a.alias, a.note, a.published, a.access, a.checked_out, a.checked_out_time, a.created_user_id, a.path, a.parent_id, a.level, a.lft, a.rgt, a.language,l.title AS language_title,uc.name AS editor,d.type AS type,COUNT(f.id) as files 
      FROM jom_categories AS a
      LEFT JOIN `jom_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN jom_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN jom_dropfiles AS d
      ON d.id=a.id
      LEFT JOIN jom_dropfiles_files AS f
      ON a.id = f.catid
  19. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
      FROM jom_extensions