Loading color scheme

SPORTUJEME S DĚTMI

Sportovní aktivity pro celou rodinu.

19 let zkušeností v oblasti pořádání cvičení pro děti a dospělé, sportovních soustředění, zájezdů, kroužků a příměstských táborů.

Plno pohybu a zábavy pro děti i rodiče.

S námi bude FIT celá rodina.

CVIČENÍ PRO DĚTI OD 4 MĚS. DO 3 LET

Podpora všestranného rozvoje pohybových schopností a dovedností.

CVIČENÍ PRO MAMINKY S DĚTMI

Maminky, bolí vás záda? Chcete se dostat do kondice, zhubnout a zpevnit tělo?

SPORTOVNÍ ZÁJEZDY ČR/EU

Rodiče, chcete si při dovolené odpočinout? Zajistíme pro vaše děti celodenní program, plný pohybu a zábavy.

SPORTOVNÍ KROUŽKY

Sportovní kroužky “SPORTOVKA” a "POHYBOVKA". Všestranný rozvoj pohybových dovedností a sportovních schopností.

PŘÍMĚSTSKÉ TÁBORY

Sportovní příměstské tábory pro děti od 3 do 15 let pro děti z Prahy a Středočeského kraje.

mini — /cviceni-pro-deti/od-2-5-do-6-let

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

1FIT Klub

V našem klubu získáte mnoho výhod a slev. Můžete využít lekci zdarma na cvičení. Získáte first minute akční nabídky na zájezdy a tábory. Obdržíte slevy na sportovní vybavení a služby pro děti i dospělé. Klub zároveň slouží jako administrační portál pro správu vašich rezervací.

Zaregistrovat se

Řekli o nás

“Dcera chodila na Petřinách na kroužek aerobiku Sportýna. Doporučuji! Výborná komunikace s vedením klubu. Super parta cvičitelek, které naučily holky nejen aerobik, ale i soudržnost a podporu týmového ducha.”

Martina H.

"Tábor byl bezvadný. Opravdu mi domů chodil syn nadšený a plný zážitků. Trenéři byli profíci, myslím. Již Vás všude doporučuji. Určitě se budeme těšit na další akce od Vás. Přeji mnoho dalších úspěchů."

Jana

"Děkujeme moc za tábor! Syn byl hrozně nadšený, celý týden nám povídal pravidla všech tech sportů, které si vyzkoušel, a úplně se zbláznil do baseballu. Příští rok určitě se zase přihlásíme."

Julie

“S lektorkou Vendy se mi velice dobře cvičí. Vyhovuje mi, jak sestavuje sestavy i její rychlejší tempo. Každá hodina je originální, nikdy se neopakuje. Líbí se mi i hudba, kterou pouští nahlas (to mám ráda) a i při té hlasité hudbě je velmi dobře slyšet. Nikdy nepřišla se špatnou náladou a pořád se jen usmívá. Po úraze s nohou jsem se nemohla dočkat, až se zase k ní vrátím.“

Lucie B., klientka skupinových lekcí Vendy

Více z našich referencí

Partneři

Přihlaste se k odběru novinek a získejte plno slev a výhod.

Joomla! konzole ladění chyb

Sezení

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1611537038,
                "last": 1611537038,
                "now": 1611537038
            },
            "token": "2MRBBsFBFgJ29GZXcGgHEtFEdutaXqtr"
        },
        "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": "1a5d9d0972a72c42df2edd9ddc31e8b9"
    }
}

Informace o profilu

Čas

Paměť

Čas: 19.41 ms / 19.41 ms Paměť: 1.860 MB / 2.27 MB Application: afterLoad

Čas: 77.34 ms / 96.76 ms Paměť: 5.376 MB / 7.65 MB Application: afterInitialise

Čas: 28.15 ms / 124.90 ms Paměť: 1.499 MB / 9.15 MB Application: afterRoute

Čas: 5.41 ms / 130.31 ms Paměť: 0.132 MB / 9.28 MB Application: beforeRenderComponent com_content

Čas: 5.47 ms / 135.78 ms Paměť: 0.780 MB / 10.06 MB Application: Before Access::preloadComponents (all components)

Čas: 1.85 ms / 137.63 ms Paměť: 0.062 MB / 10.12 MB Application: After Access::preloadComponents (all components)

Čas: 0.03 ms / 137.66 ms Paměť: 0.000 MB / 10.12 MB Application: Before Access::preloadPermissions (com_content)

Čas: 1.91 ms / 139.58 ms Paměť: 0.358 MB / 10.48 MB Application: After Access::preloadPermissions (com_content)

Čas: 0.04 ms / 139.62 ms Paměť: 0.000 MB / 10.46 MB Application: Before Access::getAssetRules (id:27 name:com_content.category.2)

Čas: 0.47 ms / 140.09 ms Paměť: 0.038 MB / 10.50 MB Application: After Access::getAssetRules (id:27 name:com_content.category.2)

Čas: 5.91 ms / 146.00 ms Paměť: 0.323 MB / 10.82 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Čas: 0.05 ms / 146.06 ms Paměť: 0.007 MB / 10.82 MB Application: After Access::getAssetRules (id:8 name:com_content)

Čas: 44.85 ms / 190.90 ms Paměť: 2.399 MB / 13.22 MB Application: Before Access::getAssetRules (id:1254 name:com_dropfiles)

Čas: 0.10 ms / 191.00 ms Paměť: 0.007 MB / 13.23 MB Application: After Access::getAssetRules (id:1254 name:com_dropfiles)

Čas: 23.52 ms / 214.52 ms Paměť: 0.686 MB / 13.92 MB Application: afterRenderComponent com_content

Čas: 4.00 ms / 218.52 ms Paměť: 0.165 MB / 14.08 MB Application: afterDispatch

Čas: 27.25 ms / 245.77 ms Paměť: 0.904 MB / 14.99 MB Application: beforeRenderModule mod_tm_ajax_contact_form (Napište nám)

Čas: 1.72 ms / 247.49 ms Paměť: 0.087 MB / 15.07 MB Application: afterRenderModule mod_tm_ajax_contact_form (Napište nám)

Čas: 0.09 ms / 247.58 ms Paměť: 0.000 MB / 15.07 MB Application: beforeRenderModule mod_menu (Informace)

Čas: 4.03 ms / 251.61 ms Paměť: 0.155 MB / 15.22 MB Application: afterRenderModule mod_menu (Informace)

Čas: 0.06 ms / 251.67 ms Paměť: 0.000 MB / 15.22 MB Application: beforeRenderModule mod_menu (Navigace)

Čas: 1.37 ms / 253.04 ms Paměť: 0.018 MB / 15.24 MB Application: afterRenderModule mod_menu (Navigace)

Čas: 0.06 ms / 253.09 ms Paměť: 0.000 MB / 15.23 MB Application: beforeRenderModule mod_custom (1FIT)

Čas: 0.43 ms / 253.53 ms Paměť: 0.005 MB / 15.24 MB Application: afterRenderModule mod_custom (1FIT)

Čas: 0.06 ms / 253.59 ms Paměť: 0.001 MB / 15.24 MB Application: beforeRenderModule mod_acym (Přihlaste se k odběru novinek a získejte plno slev a výhod.)

Čas: 15.65 ms / 269.24 ms Paměť: 1.378 MB / 16.62 MB Application: afterRenderModule mod_acym (Přihlaste se k odběru novinek a získejte plno slev a výhod.)

Čas: 0.08 ms / 269.31 ms Paměť: 0.000 MB / 16.61 MB Application: beforeRenderModule mod_articles_news_adv (Partneři)

Čas: 15.49 ms / 284.80 ms Paměť: 0.463 MB / 17.07 MB Application: afterRenderModule mod_articles_news_adv (Partneři)

Čas: 0.12 ms / 284.92 ms Paměť: 0.000 MB / 16.78 MB Application: beforeRenderModule mod_articles_news_adv (Řekli o nás)

Čas: 7.20 ms / 292.12 ms Paměť: 0.168 MB / 16.95 MB Application: afterRenderModule mod_articles_news_adv (Řekli o nás)

Čas: 0.08 ms / 292.20 ms Paměť: 0.000 MB / 16.83 MB Application: beforeRenderModule mod_articles_single (1FIT Klub)

Čas: 1.14 ms / 293.34 ms Paměť: 0.098 MB / 16.93 MB Application: Before Access::getAssetRules (id:974 name:com_content.article.232)

Čas: 0.07 ms / 293.41 ms Paměť: 0.007 MB / 16.93 MB Application: After Access::getAssetRules (id:974 name:com_content.article.232)

Čas: 5.93 ms / 299.34 ms Paměť: 0.084 MB / 17.02 MB Application: afterRenderModule mod_articles_single (1FIT Klub)

Čas: 0.07 ms / 299.41 ms Paměť: 0.000 MB / 16.98 MB Application: beforeRenderModule mod_custom (Logo)

Čas: 0.23 ms / 299.64 ms Paměť: 0.003 MB / 16.99 MB Application: afterRenderModule mod_custom (Logo)

Čas: 0.05 ms / 299.69 ms Paměť: 0.004 MB / 16.99 MB Application: beforeRenderModule mod_articles_news_adv (Sportovní aktivity pro celou rodinu.)

Čas: 7.02 ms / 306.71 ms Paměť: 0.210 MB / 17.20 MB Application: afterRenderModule mod_articles_news_adv (Sportovní aktivity pro celou rodinu.)

Čas: 0.09 ms / 306.80 ms Paměť: 0.000 MB / 17.04 MB Application: beforeRenderModule mod_articles_single (SPORTUJEME S DĚTMI)

Čas: 0.24 ms / 307.04 ms Paměť: 0.033 MB / 17.07 MB Application: Before Access::getAssetRules (id:1035 name:com_content.article.271)

Čas: 0.02 ms / 307.07 ms Paměť: 0.002 MB / 17.07 MB Application: After Access::getAssetRules (id:1035 name:com_content.article.271)

Čas: 4.61 ms / 311.68 ms Paměť: 0.060 MB / 17.13 MB Application: afterRenderModule mod_articles_single (SPORTUJEME S DĚTMI)

Čas: 3.79 ms / 315.46 ms Paměť: 0.151 MB / 17.28 MB Application: afterRender

Celkem dotazů do databáze: 82.37 ms

Využití paměti

Dotazy do databáze

59 zaznamenaných dotazů 82.37 ms

Nalezeno 6 duplikátů!

2 duplikátů: #20 #21

2 duplikátů: #22 #23

2 duplikátů: #25 #26

Čas pro dotazy: 1.67 ms Dotaz paměti: 0.036 MB Paměť před dotazem: 4.421 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í

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jom_extensions	NULL	ref	extension	extension	82	const	43	1.00	Using where

Profil

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.94 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.26 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Stejné jako volání v řádku níže.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\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.]

Čas pro dotazy: 1.14 ms Po posledním dotazu: 2.18 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 4.727 MB Vráceno řádků: 5

SELECT id, rules

  FROM `jom_viewlevels`

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jom_viewlevels	NULL	ALL	NULL	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	5	100.00	NULL

Profil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.81 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.04 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\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.]

Čas pro dotazy: 1.44 ms Po posledním dotazu: 0.13 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 4.739 MB Vráceno řádků: 2

SELECT b.id

  FROM jom_usergroups AS a

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

  WHERE a.id = 9

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	b	NULL	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	100.00	Using where; Using index

Profil

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.93 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.03 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\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.]

Čas pro dotazy: 1.10 ms Po posledním dotazu: 0.72 ms Dotaz paměti: 0.035 MB Paměť před dotazem: 4.810 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í

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jom_extensions	NULL	ref	extension	extension	82	const	164	0.60	Using where; Použití filesort

Profil

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.73 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Stejné jako volání v řádku níže.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\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.]

Čas pro dotazy: 3.83 ms Po posledním dotazu: 29.81 ms Dotaz paměti: 0.150 MB Paměť před dotazem: 7.011 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í

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_client_id_parent_id_alias_language	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	230	6.48	Using where; Použití filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.m.component_id	1	100.00	Using where

Profil

Status	Duration
starting	0.13 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	1.50 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.05 ms
executing	1.76 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Stejné jako volání v řádku níže.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/dropfiles/dropfiles.php:37
8	PlgSystemDropfiles->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\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.]

Čas pro dotazy: 2.31 ms Po posledním dotazu: 12.20 ms Dotaz paměti: 0.029 MB Paměť před dotazem: 8.581 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

Status	Duration
starting	0.69 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.72 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.17 ms
preparing	0.04 ms
Creating tmp table	0.07 ms
executing	0.09 ms
checking permissions	0.09 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.07 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
removing tmp table	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_komento/tables/parent.php:18
14	KomentoParentTable->__construct()	JROOT/administrator/components/com_komento/tables/configs.php:40
13	KomentoTableConfigs->__construct()	JROOT/libraries/src/Table/Table.php:312
12	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_komento/tables/parent.php:49
11	KomentoParentTable::getInstance()	JROOT/components/com_komento/helpers/helper.php:99
10	Komento::getTable()	JROOT/components/com_komento/helpers/helper.php:228
9	Komento::getKonfig()	JROOT/components/com_komento/bootstrap.php:30
8	require_once JROOT/components/com_komento/bootstrap.php	JROOT/components/com_komento/router.php:16
7	require_once JROOT/components/com_komento/router.php	JROOT/libraries/src/Router/SiteRouter.php:775
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:130
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1077
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\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.]

Čas pro dotazy: 0.61 ms Po posledním dotazu: 0.58 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 8.614 MB Vráceno řádků: 1

SELECT *

  FROM jom_komento_configs

  WHERE `component` = 'com_komento'

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jom_komento_configs	NULL	ALL	NULL	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	5	20.00	Using where

Profil

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.22 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.05 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
10	Joomla\CMS\Table\Table->load()	JROOT/components/com_komento/helpers/helper.php:229
9	Komento::getKonfig()	JROOT/components/com_komento/bootstrap.php:30
8	require_once JROOT/components/com_komento/bootstrap.php	JROOT/components/com_komento/router.php:16
7	require_once JROOT/components/com_komento/router.php	JROOT/libraries/src/Router/SiteRouter.php:775
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:130
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1077
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\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.]

Čas pro dotazy: 0.51 ms Po posledním dotazu: 5.89 ms Dotaz paměti: 0.027 MB Paměť před dotazem: 8.950 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í

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jom_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Profil

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.05 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Stejné jako volání v řádku níže.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/helixultimate/helixultimate.php:134
8	plgSystemHelixultimate->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1125
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\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.]

Čas pro dotazy: 5.86 ms Po posledním dotazu: 0.20 ms Dotaz paměti: 0.006 MB Paměť před dotazem: 8.943 MB

UPDATE `jom_extensions`

  SET `params` = '{\"mediaversion\":\"6fa61c6fc7fd4aa0a52afa418a4449a2\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Vysvětlení

VYSVĚTLENÍ není možné pro dotaz: UPDATE `jom_extensions` SET `params` = '{\"mediaversion\":\"6fa61c6fc7fd4aa0a52afa418a4449a2\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profil

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.09 ms
updating	0.19 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	5.21 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/helixultimate/helixultimate.php:134
8	plgSystemHelixultimate->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1125
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\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.]

Čas pro dotazy: 1.51 ms Po posledním dotazu: 2.18 ms Dotaz paměti: 0.025 MB Paměť před dotazem: 9.165 MB Vráceno řádků: 1

SELECT *

  FROM jom_languages

  WHERE published=1

  ORDER BY ordering ASC

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jom_languages	NULL	ALL	NULL	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	1	100.00	Using where; Použití filesort

Profil

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	1.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.03 ms
executing	0.07 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\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.]

Čas pro dotazy: 1.44 ms Po posledním dotazu: 0.31 ms Dotaz paměti: 0.143 MB Paměť před dotazem: 9.183 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í

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	6	1.00	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	dp_www_1fit.e.element	2	85.71	Using index condition; Using where

Profil

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.79 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.23 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\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.]

Čas pro dotazy: 1.63 ms Po posledním dotazu: 7.55 ms Dotaz paměti: 0.032 MB Paměť před dotazem: 10.064 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í

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jom_assets	NULL	range	idx_asset_name	idx_asset_name	202	NULL	44	100.00	Using index condition

Profil

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.72 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.12 ms
preparing	0.02 ms
executing	0.47 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
18	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
13	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\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.]

Čas pro dotazy: 1.13 ms Po posledním dotazu: 0.21 ms Dotaz paměti: 0.084 MB Paměť před dotazem: 10.118 MB Vráceno řádků: 455

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `jom_assets`

  WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jom_assets	NULL	ALL	idx_asset_name,idx_parent_id	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	769	20.73	Using where

Profil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.74 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
18	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
13	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\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.]

Čas pro dotazy: 2.80 ms Po posledním dotazu: 2.56 ms Dotaz paměti: 0.037 MB Paměť před dotazem: 10.555 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í

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	c	NULL	range	cat_idx,idx_left_right	idx_left_right	4	NULL	8	43.52	Using index condition; Using where
2	DEPENDENT SUBQUERY	i	NULL	ref	idx_state,idx_catid	idx_catid	4	dp_www_1fit.c.id	3	100.00	Using index condition; Using where

Profil

Status	Duration
starting	0.14 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	2.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.03 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.05 ms
executing	0.04 ms
executing	0.06 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
15	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
14	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/models/category.php:355
13	ContentModelCategory->getCategory()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:122
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\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.]

Čas pro dotazy: 6.57 ms Po posledním dotazu: 1.91 ms Dotaz paměti: 0.093 MB Paměť před dotazem: 10.821 MB Vráceno řádků: 12

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

  FROM jom_content AS a

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

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

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

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

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

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

  FROM jom_categories as sub

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

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

  ORDER BY  c.lft,  a.ordering,  a.created

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	c	NULL	ALL	PRIMARY,idx_access	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	108	10.00	Using where; Using temporary; Použití filesort
1	PRIMARY	a	NULL	ref	idx_access,idx_state,idx_catid	idx_catid	4	dp_www_1fit.c.id	3	16.00	Using index condition; Using where
1	PRIMARY	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.created_by	1	100.00	Using where
1	PRIMARY	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.modified_by	1	100.00	Using where
1	PRIMARY	parent	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.c.parent_id	1	100.00	Using where
1	PRIMARY	v	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.id	1	100.00	Using where
2	DEPENDENT SUBQUERY	this	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	NULL
2	DEPENDENT SUBQUERY	sub	NULL	eq_ref	PRIMARY,idx_left_right	PRIMARY	4	func	1	30.86	Using where

Profil

Status	Duration
executing	0.02 ms
executing	0.01 ms
executing	0.01 ms
executing	0.01 ms
executing	0.01 ms
executing	0.01 ms
executing	0.01 ms
executing	0.01 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.03 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.03 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.08 ms
executing	0.02 ms
executing	0.02 ms
executing	0.03 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.03 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.16 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
removing tmp table	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\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.]

Čas pro dotazy: 4.79 ms Po posledním dotazu: 2.47 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 11.305 MB Vráceno řádků: 1

SELECT COUNT(*)

  FROM jom_content AS a

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

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

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

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

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

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

  FROM jom_categories as sub

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

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

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	c	NULL	ALL	PRIMARY,idx_access	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	108	10.00	Using where
1	PRIMARY	a	NULL	ref	idx_access,idx_state,idx_catid	idx_catid	4	dp_www_1fit.c.id	3	16.00	Using index condition; Using where
1	PRIMARY	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.created_by	1	100.00	Using where; Using index
1	PRIMARY	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.modified_by	1	100.00	Using where; Using index
1	PRIMARY	parent	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.c.parent_id	1	100.00	Using where; Using index
1	PRIMARY	v	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.id	1	100.00	Using where; Using index
2	DEPENDENT SUBQUERY	this	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	NULL
2	DEPENDENT SUBQUERY	sub	NULL	eq_ref	PRIMARY,idx_left_right	PRIMARY	4	func	1	30.86	Using where

Profil

Status	Duration
executing	0.01 ms
executing	0.01 ms
executing	0.03 ms
executing	0.01 ms
executing	0.01 ms
executing	0.01 ms
executing	0.03 ms
executing	0.01 ms
executing	0.01 ms
executing	0.01 ms
executing	0.02 ms
executing	0.03 ms
executing	0.01 ms
executing	0.02 ms
executing	0.01 ms
executing	0.02 ms
executing	0.04 ms
executing	0.01 ms
executing	0.01 ms
executing	0.04 ms
executing	0.01 ms
executing	0.01 ms
executing	0.01 ms
executing	0.03 ms
executing	0.01 ms
executing	0.01 ms
executing	0.01 ms
executing	0.04 ms
executing	0.01 ms
executing	0.03 ms
executing	0.01 ms
executing	0.01 ms
executing	0.01 ms
executing	0.03 ms
executing	0.01 ms
executing	0.01 ms
executing	0.01 ms
executing	0.03 ms
executing	0.01 ms
executing	0.01 ms
executing	0.04 ms
executing	0.01 ms
executing	0.01 ms
executing	0.01 ms
executing	0.02 ms
executing	0.01 ms
executing	0.04 ms
executing	0.01 ms
executing	0.01 ms
executing	0.01 ms
executing	0.02 ms
executing	0.04 ms
executing	0.01 ms
executing	0.01 ms
executing	0.01 ms
executing	0.02 ms
executing	0.01 ms
executing	0.04 ms
executing	0.01 ms
executing	0.01 ms
executing	0.01 ms
executing	0.02 ms
executing	0.04 ms
executing	0.01 ms
executing	0.01 ms
executing	0.01 ms
executing	0.02 ms
executing	0.04 ms
executing	0.01 ms
executing	0.01 ms
executing	0.01 ms
executing	0.03 ms
executing	0.01 ms
executing	0.01 ms
executing	0.06 ms
executing	0.02 ms
executing	0.01 ms
executing	0.02 ms
executing	0.04 ms
executing	0.02 ms
executing	0.01 ms
executing	0.03 ms
executing	0.01 ms
executing	0.01 ms
executing	0.01 ms
executing	0.03 ms
executing	0.01 ms
executing	0.01 ms
executing	0.01 ms
executing	0.01 ms
executing	0.03 ms
executing	0.01 ms
executing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
15	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
14	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/components/com_content/models/category.php:265
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\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.]

Čas pro dotazy: 2.12 ms Po posledním dotazu: 1.57 ms Dotaz paměti: 0.035 MB Paměť před dotazem: 11.473 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í

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	18	5.56	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	dp_www_1fit.m.tag_id	1	100.00	Using where

Profil

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	1.65 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.08 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/libraries/src/MVC/View/CategoryView.php:229
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\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.]

Čas pro dotazy: 0.75 ms Po posledním dotazu: 7.26 ms Dotaz paměti: 0.038 MB Paměť před dotazem: 12.103 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í

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	range	cat_idx,idx_access,idx_left_right	idx_left_right	4	NULL	8	45.37	Using index condition; Using where

Profil

Status	Duration
starting	0.14 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.16 ms
preparing	0.04 ms
executing	0.09 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
18	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
17	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\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.]

Čas pro dotazy: 3.00 ms Po posledním dotazu: 0.16 ms Dotaz paměti: 0.037 MB Paměť před dotazem: 12.121 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í

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using temporary; Použití filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	dp_www_1fit.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.group_id	1	100.00	Using where
1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.id	1	100.00	Using where; Using index; Distinct

Profil

Status	Duration
starting	0.13 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	2.26 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.15 ms
preparing	0.03 ms
Creating tmp table	0.07 ms
executing	0.07 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
removing tmp table	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\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.]

Čas pro dotazy: 0.91 ms Po posledním dotazu: 7.05 ms Dotaz paměti: 0.028 MB Paměť před dotazem: 12.834 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í

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY,cat_idx	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	b	NULL	const	PRIMARY,cat_idx	PRIMARY	4	const	1	100.00	Impossible ON condition
1	SIMPLE	c	NULL	system	id	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	1	100.00	NULL

Profil

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.53 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
17	JDatabase->query()	JROOT/components/com_dropfiles/models/frontcategory.php:57
16	DropfilesModelFrontcategory->getCategory()	JROOT/plugins/content/dropfiles/dropfiles.php:237
15	PlgContentdropfiles->replace()	Stejné jako volání v řádku níže.
14	preg_replace_callback()	JROOT/plugins/content/dropfiles/dropfiles.php:55
13	PlgContentdropfiles->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\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.]

Čas pro dotazy: 0.38 ms Po posledním dotazu: 0.05 ms Dotaz paměti: 0.028 MB Paměť před dotazem: 12.842 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í

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY,cat_idx	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	b	NULL	const	PRIMARY,cat_idx	PRIMARY	4	const	1	100.00	Impossible ON condition
1	SIMPLE	c	NULL	system	id	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	1	100.00	NULL

Profil

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/components/com_dropfiles/models/frontcategory.php:58
16	DropfilesModelFrontcategory->getCategory()	JROOT/plugins/content/dropfiles/dropfiles.php:237
15	PlgContentdropfiles->replace()	Stejné jako volání v řádku níže.
14	preg_replace_callback()	JROOT/plugins/content/dropfiles/dropfiles.php:55
13	PlgContentdropfiles->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\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.]

Čas pro dotazy: 0.33 ms Po posledním dotazu: 1.77 ms Dotaz paměti: 0.028 MB Paměť před dotazem: 13.051 MB Vráceno řádků: 1

Duplicitní dotazy: #23

SELECT rgt,lft 
  FROM jom_categories 
  WHERE id=134 
  AND extension='com_dropfiles'

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jom_categories	NULL	const	PRIMARY,cat_idx	PRIMARY	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
21	JDatabase->query()	JROOT/administrator/components/com_dropfiles/models/categories.php:121
20	DropfilesModelCategories->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
19	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_categories/models/categories.php:354
17	CategoriesModelCategories->getItems()	JROOT/components/com_dropfiles/models/frontcategories.php:99
16	DropfilesModelFrontcategories->getItems()	JROOT/plugins/content/dropfiles/dropfiles.php:242
15	PlgContentdropfiles->replace()	Stejné jako volání v řádku níže.
14	preg_replace_callback()	JROOT/plugins/content/dropfiles/dropfiles.php:55
13	PlgContentdropfiles->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\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.]

Čas pro dotazy: 0.28 ms Po posledním dotazu: 0.05 ms Dotaz paměti: 0.028 MB Paměť před dotazem: 13.061 MB Vráceno řádků: 1

Duplicitní dotazy: #22

SELECT rgt,lft 
  FROM jom_categories 
  WHERE id=134 
  AND extension='com_dropfiles'

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jom_categories	NULL	const	PRIMARY,cat_idx	PRIMARY	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
21	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_dropfiles/models/categories.php:124
20	DropfilesModelCategories->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
19	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_categories/models/categories.php:354
17	CategoriesModelCategories->getItems()	JROOT/components/com_dropfiles/models/frontcategories.php:99
16	DropfilesModelFrontcategories->getItems()	JROOT/plugins/content/dropfiles/dropfiles.php:242
15	PlgContentdropfiles->replace()	Stejné jako volání v řádku níže.
14	preg_replace_callback()	JROOT/plugins/content/dropfiles/dropfiles.php:55
13	PlgContentdropfiles->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\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.]

Čas pro dotazy: 1.23 ms Po posledním dotazu: 0.09 ms Dotaz paměti: 0.032 MB Paměť před dotazem: 13.074 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í

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	range	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	cat_idx	203	NULL	2	10.00	Using index condition; Using where; Using temporary; Použití filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	dp_www_1fit.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.checked_out	1	100.00	Using where
1	SIMPLE	d	NULL	eq_ref	id	id	4	dp_www_1fit.a.id	1	100.00	NULL
1	SIMPLE	f	NULL	ref	id_gallery	id_gallery	4	dp_www_1fit.a.id	5	100.00	NULL

Profil

Status	Duration
starting	0.10 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.67 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.02 ms
Creating tmp table	0.05 ms
executing	0.08 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
removing tmp table	0.01 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
19	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_categories/models/categories.php:354
17	CategoriesModelCategories->getItems()	JROOT/components/com_dropfiles/models/frontcategories.php:99
16	DropfilesModelFrontcategories->getItems()	JROOT/plugins/content/dropfiles/dropfiles.php:242
15	PlgContentdropfiles->replace()	Stejné jako volání v řádku níže.
14	preg_replace_callback()	JROOT/plugins/content/dropfiles/dropfiles.php:55
13	PlgContentdropfiles->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\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.]

Čas pro dotazy: 0.26 ms Po posledním dotazu: 0.09 ms Dotaz paměti: 0.027 MB Paměť před dotazem: 13.064 MB Vráceno řádků: 1

Duplicitní dotazy: #26

SELECT * 
  FROM jom_dropfiles 
  WHERE id = 134

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jom_dropfiles	NULL	system	id	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	1	100.00	NULL

Profil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
17	JDatabase->query()	JROOT/components/com_dropfiles/models/frontconfig.php:40
16	DropfilesModelFrontconfig->getParams()	JROOT/plugins/content/dropfiles/dropfiles.php:243
15	PlgContentdropfiles->replace()	Stejné jako volání v řádku níže.
14	preg_replace_callback()	JROOT/plugins/content/dropfiles/dropfiles.php:55
13	PlgContentdropfiles->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\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.]

Čas pro dotazy: 0.26 ms Po posledním dotazu: 0.04 ms Dotaz paměti: 0.027 MB Paměť před dotazem: 13.073 MB Vráceno řádků: 1

Duplicitní dotazy: #25

SELECT * 
  FROM jom_dropfiles 
  WHERE id = 134

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jom_dropfiles	NULL	system	id	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	1	100.00	NULL

Profil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/components/com_dropfiles/models/frontconfig.php:41
16	DropfilesModelFrontconfig->getParams()	JROOT/plugins/content/dropfiles/dropfiles.php:243
15	PlgContentdropfiles->replace()	Stejné jako volání v řádku níže.
14	preg_replace_callback()	JROOT/plugins/content/dropfiles/dropfiles.php:55
13	PlgContentdropfiles->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\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.]

Čas pro dotazy: 0.86 ms Po posledním dotazu: 0.16 ms Dotaz paměti: 0.035 MB Paměť před dotazem: 13.092 MB Vráceno řádků: 5

SELECT a.id, a.title, a.file, a.ext, a.size, a.hits, a.description, a.version, a.canview, a.catid, a.created_time,a.modified_time,a.custom_icon,c.title AS category_title, c.path AS category_route,
                        c.access AS category_access, c.alias AS category_alias,parent.title as parent_title, parent.id as parent_id,
                        parent.path as parent_route, parent.alias as parent_alias,c.published, c.published AS parents_published

  FROM jom_dropfiles_files AS a

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

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

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

  WHERE c.access IN (1,1,5) 
  AND a.catid = 134 
  AND (a.publish = '0000-00-00 00:00:00' OR a.publish <= '2021-01-25 01:10:38') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-25 01:10:38') 
  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í

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Using temporary; Použití filesort
1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	a	NULL	ref	id_gallery	id_gallery	4	const	4	20.00	Using where
1	SIMPLE	cat	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	parent	NULL	ref	cat_idx,idx_left_right	cat_idx	202	const	12	100.00	Using where

Profil

Status	Duration
starting	0.13 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.09 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.03 ms
Creating tmp table	0.04 ms
executing	0.20 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
removing tmp table	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
17	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_dropfiles/models/frontfiles.php:230
16	DropfilesModelFrontfiles->getItems()	JROOT/plugins/content/dropfiles/dropfiles.php:328
15	PlgContentdropfiles->replace()	Stejné jako volání v řádku níže.
14	preg_replace_callback()	JROOT/plugins/content/dropfiles/dropfiles.php:55
13	PlgContentdropfiles->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\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.]

Čas pro dotazy: 0.85 ms Po posledním dotazu: 1.27 ms Dotaz paměti: 0.009 MB Paměť před dotazem: 13.215 MB

DELETE 
  FROM jom_dropfiles_tokens 
  WHERE time < 1611533438

Vysvětlení

VYSVĚTLENÍ není možné pro dotaz: DELETE FROM jom_dropfiles_tokens WHERE time < 1611533438

Profil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.61 ms
init	0.01 ms
System lock	0.03 ms
updating	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
18	JDatabase->query()	JROOT/components/com_dropfiles/models/tokens.php:113
17	DropfilesModelTokens->removeTokens()	JROOT/administrator/components/com_dropfiles/helpers/files.php:200
16	DropfilesFilesHelper::addInfosToFile()	JROOT/plugins/content/dropfiles/dropfiles.php:330
15	PlgContentdropfiles->replace()	Stejné jako volání v řádku níže.
14	preg_replace_callback()	JROOT/plugins/content/dropfiles/dropfiles.php:55
13	PlgContentdropfiles->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\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.]

Čas pro dotazy: 3.78 ms Po posledním dotazu: 0.33 ms Dotaz paměti: 0.009 MB Paměť před dotazem: 13.232 MB

INSERT INTO jom_dropfiles_tokens (id_user,time,token)  
  values (0,1611537038,'1a5d9d0972a72c42df2edd9ddc31e8b9')

Vysvětlení

VYSVĚTLENÍ není možné pro dotaz: INSERT INTO jom_dropfiles_tokens (id_user,time,token) values (0,1611537038,'1a5d9d0972a72c42df2edd9ddc31e8b9')

Profil

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
update	0.10 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	3.38 ms
closing tables	0.03 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
18	JDatabase->query()	JROOT/components/com_dropfiles/models/tokens.php:47
17	DropfilesModelTokens->createToken()	JROOT/administrator/components/com_dropfiles/helpers/files.php:205
16	DropfilesFilesHelper::addInfosToFile()	JROOT/plugins/content/dropfiles/dropfiles.php:330
15	PlgContentdropfiles->replace()	Stejné jako volání v řádku níže.
14	preg_replace_callback()	JROOT/plugins/content/dropfiles/dropfiles.php:55
13	PlgContentdropfiles->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\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.]

Čas pro dotazy: 0.89 ms Po posledním dotazu: 17.26 ms Dotaz paměti: 0.039 MB Paměť před dotazem: 13.973 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í

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using temporary; Použití filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	dp_www_1fit.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.group_id	1	100.00	Using where

Profil

Status	Duration
starting	0.16 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.09 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.17 ms
preparing	0.04 ms
Creating tmp table	0.08 ms
executing	0.07 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
removing tmp table	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
19	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
18	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
15	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/templates/theme3703/html/com_content/category/blog.php:18
14	include JROOT/templates/theme3703/html/com_content/category/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\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.]

Čas pro dotazy: 0.79 ms Po posledním dotazu: 0.49 ms Dotaz paměti: 0.039 MB Paměť před dotazem: 13.987 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í

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using temporary; Použití filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	dp_www_1fit.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.group_id	1	100.00	Using where
1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.id	1	100.00	Using where; Using index; Distinct

Profil

Status	Duration
starting	0.17 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.08 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	0.03 ms
Creating tmp table	0.06 ms
executing	0.05 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
removing tmp table	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
23	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
22	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
21	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
20	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:404
19	PlgSystemFields->display()	JROOT/plugins/system/fields/fields.php:324
18	PlgSystemFields->onContentAfterTitle()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
15	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/templates/theme3703/html/com_content/category/blog.php:21
14	include JROOT/templates/theme3703/html/com_content/category/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\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.]

Čas pro dotazy: 1.52 ms Po posledním dotazu: 0.52 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 13.937 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

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.55 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	0.03 ms
Creating tmp table	0.04 ms
executing	0.07 ms
checking permissions	0.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.06 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
removing tmp table	0.01 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
12	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
11	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
10	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_templates/tables/style.php:30
9	TemplatesTableStyle->__construct()	JROOT/libraries/src/Table/Table.php:312
8	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/helixultimate/helixultimate.php:41
7	plgSystemHelixultimate->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\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.]

Čas pro dotazy: 0.37 ms Po posledním dotazu: 0.12 ms Dotaz paměti: 0.044 MB Paměť před dotazem: 13.964 MB Vráceno řádků: 1

SELECT *

  FROM jom_template_styles

  WHERE `id` = '22'

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jom_template_styles	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
9	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
8	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/helixultimate/helixultimate.php:42
7	plgSystemHelixultimate->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\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.]

Čas pro dotazy: 5.17 ms Po posledním dotazu: 7.16 ms Dotaz paměti: 0.031 MB Paměť před dotazem: 14.609 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-01-25 01:10:38') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-01-25 01:10:38') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 101 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	PRIMARY,published,newsfeeds	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	191	1.11	Using where; Použití filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	dp_www_1fit.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	dp_www_1fit.m.id	1	40.00	Using where; Using index

Profil

Status	Duration
starting	0.12 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	1.69 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.04 ms
executing	3.02 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	Stejné jako volání v řádku níže.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/theme3703/index.php:196
7	require JROOT/templates/theme3703/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1033
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\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.]

Čas pro dotazy: 1.50 ms Po posledním dotazu: 33.93 ms Dotaz paměti: 0.033 MB Paměť před dotazem: 16.424 MB Vráceno řádků: 109

SELECT * 
  FROM jom_acym_configuration

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jom_acym_configuration	NULL	ALL	NULL	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	109	100.00	NULL

Profil

Status	Duration
starting	0.14 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.81 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.20 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/library/joomla.php:530
15	acym_loadObjectList()	JROOT/administrator/components/com_acym/classes/configuration.php:21
14	acymconfigurationClass->load()	JROOT/administrator/components/com_acym/helpers/helper.php:1969
13	acym_config()	JROOT/administrator/components/com_acym/helpers/helper.php:506
12	acym_getEmailRegex()	JROOT/administrator/components/com_acym/helpers/helper.php:2003
11	acym_initModule()	JROOT/modules/mod_acym/mod_acym.php:19
10	include JROOT/modules/mod_acym/mod_acym.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1047
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\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.]

Čas pro dotazy: 1.18 ms Po posledním dotazu: 1.56 ms Dotaz paměti: 0.027 MB Paměť před dotazem: 16.639 MB Vráceno řádků: 1

SELECT * 
  FROM jom_acym_list

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jom_acym_list	NULL	ALL	NULL	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	1	100.00	NULL

Profil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.86 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.04 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/library/joomla.php:530
12	acym_loadObjectList()	JROOT/administrator/components/com_acym/classes/list.php:353
11	acymlistClass->getAll()	JROOT/modules/mod_acym/mod_acym.php:42
10	include JROOT/modules/mod_acym/mod_acym.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1047
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\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.]

Čas pro dotazy: 1.25 ms Po posledním dotazu: 0.09 ms Dotaz paměti: 0.029 MB Paměť před dotazem: 16.648 MB Vráceno řádků: 1

SELECT * 
  FROM jom_acym_field 
  WHERE `id` IN(2) 
  ORDER BY `ordering` ASC

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jom_acym_field	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.86 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/library/joomla.php:530
12	acym_loadObjectList()	JROOT/administrator/components/com_acym/classes/field.php:38
11	acymfieldClass->getFieldsByID()	JROOT/modules/mod_acym/mod_acym.php:45
10	include JROOT/modules/mod_acym/mod_acym.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1047
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\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.]

Čas pro dotazy: 1.33 ms Po posledním dotazu: 1.79 ms Dotaz paměti: 0.044 MB Paměť před dotazem: 16.694 MB Vráceno řádků: 11

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 (133) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-01-25 01:10:38') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-25 01:10:38')

  ORDER BY a.publish_up DESC 
  LIMIT 100

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Použití filesort
1	SIMPLE	a	NULL	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	11	16.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.created_by	1	100.00	Using where
1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.modified_by	1	100.00	Using where; Using index
1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where
1	SIMPLE	v	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.id	1	100.00	Using where

Profil

Status	Duration
starting	0.22 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.11 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.20 ms
preparing	0.06 ms
executing	0.45 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_news_adv/helper.php:110
11	ModArticlesNewsAdvHelper::getList()	JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
10	include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1047
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\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.]

Čas pro dotazy: 1.05 ms Po posledním dotazu: 1.10 ms Dotaz paměti: 0.040 MB Paměť před dotazem: 16.996 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 = 133

  ORDER BY c.lft

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Použití filesort
1	SIMPLE	c	NULL	ALL	cat_idx,idx_access,idx_left_right	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	108	39.91	Using where

Profil

Status	Duration
starting	0.15 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.16 ms
preparing	0.05 ms
executing	0.39 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
21	ContentRouter->getCategorySegment()	Stejné jako volání v řádku níže.
20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_news_adv/helper.php:124
11	ModArticlesNewsAdvHelper::getList()	JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
10	include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1047
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\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.]

Čas pro dotazy: 0.92 ms Po posledním dotazu: 0.50 ms Dotaz paměti: 0.039 MB Paměť před dotazem: 17.019 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í

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using temporary; Použití filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	dp_www_1fit.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.group_id	1	100.00	Using where

Profil

Status	Duration
starting	0.15 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.08 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.15 ms
preparing	0.03 ms
Creating tmp table	0.07 ms
executing	0.07 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
removing tmp table	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
19	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
18	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
15	JHtmlContent::prepare()	Stejné jako volání v řádku níže.
14	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
13	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
12	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_articles_news_adv/helper.php:134
11	ModArticlesNewsAdvHelper::getList()	JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
10	include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1047
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\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.]

Čas pro dotazy: 0.91 ms Po posledním dotazu: 0.41 ms Dotaz paměti: 0.038 MB Paměť před dotazem: 17.030 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 (133,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í

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using temporary; Použití filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	dp_www_1fit.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.group_id	1	100.00	Using where
1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.id	1	100.00	Using where; Using index; Distinct

Profil

Status	Duration
starting	0.18 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.08 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.16 ms
preparing	0.04 ms
Creating tmp table	0.06 ms
executing	0.06 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
removing tmp table	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
19	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
17	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:404
16	PlgSystemFields->display()	JROOT/plugins/system/fields/fields.php:358
15	PlgSystemFields->onContentAfterDisplay()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/modules/mod_articles_news_adv/helper.php:144
11	ModArticlesNewsAdvHelper::getList()	JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
10	include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1047
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\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.]

Čas pro dotazy: 0.97 ms Po posledním dotazu: 8.63 ms Dotaz paměti: 0.039 MB Paměť před dotazem: 16.816 MB Vráceno řádků: 4

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 (103) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-01-25 01:10:38') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-25 01:10:38')

  ORDER BY a.ordering DESC 
  LIMIT 4

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Použití filesort
1	SIMPLE	a	NULL	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	4	16.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.created_by	1	100.00	Using where
1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.modified_by	1	100.00	Using where; Using index
1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where
1	SIMPLE	v	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.id	1	100.00	Using where

Profil

Status	Duration
starting	0.19 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.09 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.14 ms
preparing	0.05 ms
executing	0.21 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_news_adv/helper.php:110
11	ModArticlesNewsAdvHelper::getList()	JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
10	include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1047
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\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.]

Čas pro dotazy: 1.13 ms Po posledním dotazu: 0.55 ms Dotaz paměti: 0.040 MB Paměť před dotazem: 16.938 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 = 103

  ORDER BY c.lft

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Použití filesort
1	SIMPLE	c	NULL	ALL	cat_idx,idx_access,idx_left_right	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	108	29.41	Using where

Profil

Status	Duration
starting	0.15 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.15 ms
preparing	0.04 ms
executing	0.46 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
21	ContentRouter->getCategorySegment()	Stejné jako volání v řádku níže.
20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_news_adv/helper.php:124
11	ModArticlesNewsAdvHelper::getList()	JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
10	include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1047
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\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.]

Čas pro dotazy: 0.93 ms Po posledním dotazu: 0.47 ms Dotaz paměti: 0.038 MB Paměť před dotazem: 16.955 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 (103,0,102)) 
  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í

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using temporary; Použití filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	dp_www_1fit.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.group_id	1	100.00	Using where
1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.id	1	100.00	Using where; Using index; Distinct

Profil

Status	Duration
starting	0.18 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.09 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.18 ms
preparing	0.04 ms
Creating tmp table	0.07 ms
executing	0.07 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
removing tmp table	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
19	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
17	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:404
16	PlgSystemFields->display()	JROOT/plugins/system/fields/fields.php:358
15	PlgSystemFields->onContentAfterDisplay()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/modules/mod_articles_news_adv/helper.php:144
11	ModArticlesNewsAdvHelper::getList()	JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
10	include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1047
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\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.]

Čas pro dotazy: 0.79 ms Po posledním dotazu: 4.11 ms Dotaz paměti: 0.036 MB Paměť před dotazem: 16.938 MB Vráceno řádků: 1

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM jom_content AS a

  INNER JOIN jom_categories AS c 
  on c.id = a.catid

  LEFT JOIN jom_users AS u 
  on u.id = a.created_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.id = 232 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-01-25 01:10:38') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-25 01:10:38')

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY,idx_catid	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	u	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found
1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	v	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found

Profil

Status	Duration
starting	0.19 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.09 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.15 ms
preparing	0.02 ms
executing	0.04 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
12	ContentModelArticle->getItem()	JROOT/modules/mod_articles_single/helper.php:26
11	modArticlesSingleHelper::getItem()	JROOT/modules/mod_articles_single/mod_articles_single.php:13
10	include JROOT/modules/mod_articles_single/mod_articles_single.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1047
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\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.]

Čas pro dotazy: 0.38 ms Po posledním dotazu: 0.23 ms Dotaz paměti: 0.028 MB Paměť před dotazem: 16.972 MB Vráceno řádků: 1

SELECT `alias`

  FROM `jom_content`

  WHERE id = '232'

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jom_content	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
22	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
21	ContentRouter->getArticleSegment()	Stejné jako volání v řádku níže.
20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_single/helper.php:30
11	modArticlesSingleHelper::getItem()	JROOT/modules/mod_articles_single/mod_articles_single.php:13
10	include JROOT/modules/mod_articles_single/mod_articles_single.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1047
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\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.]

Čas pro dotazy: 1.06 ms Po posledním dotazu: 0.16 ms Dotaz paměti: 0.041 MB Paměť před dotazem: 16.986 MB Vráceno řádků: 4

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 = 8

  ORDER BY c.lft

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	range	cat_idx,idx_access,idx_left_right	idx_left_right	4	NULL	28	45.37	Using index condition; Using where

Profil

Status	Duration
starting	0.15 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.27 ms
preparing	0.04 ms
executing	0.18 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
21	ContentRouter->getCategorySegment()	Stejné jako volání v řádku níže.
20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_single/helper.php:30
11	modArticlesSingleHelper::getItem()	JROOT/modules/mod_articles_single/mod_articles_single.php:13
10	include JROOT/modules/mod_articles_single/mod_articles_single.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1047
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\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.]

Čas pro dotazy: 0.35 ms Po posledním dotazu: 0.21 ms Dotaz paměti: 0.027 MB Paměť před dotazem: 17.007 MB Vráceno řádků: 1

SELECT alias

  FROM jom_content

  WHERE id=232

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jom_content	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
20	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
19	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
18	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:528
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_single/helper.php:30
11	modArticlesSingleHelper::getItem()	JROOT/modules/mod_articles_single/mod_articles_single.php:13
10	include JROOT/modules/mod_articles_single/mod_articles_single.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1047
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\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.]

Čas pro dotazy: 0.87 ms Po posledním dotazu: 0.27 ms Dotaz paměti: 0.039 MB Paměť před dotazem: 17.018 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_single.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í

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using temporary; Použití filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	dp_www_1fit.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.group_id	1	100.00	Using where

Profil

Status	Duration
starting	0.17 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.08 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.16 ms
preparing	0.04 ms
Creating tmp table	0.07 ms
executing	0.07 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
removing tmp table	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
19	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
18	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
15	JHtmlContent::prepare()	Stejné jako volání v řádku níže.
14	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
13	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
12	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_articles_single/helper.php:33
11	modArticlesSingleHelper::getItem()	JROOT/modules/mod_articles_single/mod_articles_single.php:13
10	include JROOT/modules/mod_articles_single/mod_articles_single.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1047
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\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.]

Čas pro dotazy: 0.35 ms Po posledním dotazu: 0.13 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 17.024 MB Vráceno řádků: 1