Interviews

Vedie Homosexualita do tmy?

Podrobnosti: Uverejnené: utorok, 13. október 2015, 20:00

Janka je človek, ktorý má zaujímavý príbeh. Počas jej rozprávania sa človek môže zamyslieť a rozmýšľať: Môžem za to, akú mám sexuálnu orientáciu ? Do akej miery som zodpovedný za svoj stav a do akej miery ma determinuje prostredie, v ktorom vyrastám, výchova ktorú som dostal a podobne.. Zamyslime sa nad tým, ako sa môžeme stavať k ľuďom s podobne komplikovaným osudom a či naša empatia a láska nie sú jedinou odpoveďou.

Spoveď pornoherečky

Podrobnosti: Uverejnené: piatok, 15. august 2014, 11:40

O pornografii všetci vieme. Niektorí k nej majú vrúcnejší vzťah, iní pomenej. Do zákulisia porna ale už nemôže nahliadnuť každý. Nám sa to podarilo. O tom, že to všetko nie je až také "ružové" ako sa zdá, nám porozprávala bývalá pornoherečka z čiech - Johanna.

Samir - o kresťanstve v Azerbajdžane

Podrobnosti: Uverejnené: piatok, 13. december 2013, 13:20

Rozprávali sme sa s pastorom a misionárom z tvrdej moslimskej krajiny. Samir je autentický kresťan, ktorý v Azerbajdžane konvertoval z Islamu na kresťanstvo. Svoju misijnú prácu vykonáva ale v inej krajine (ktorú z bezpečnostných dôvodov nemôžeme menovať). V krajine, kde za kresťanskú misiu chodí poprava obesením a platí prezumpcia viny.

"Keď len prekročíte hranice tejto krajiny, cítite tú temnú, pochmúrnu atmosféru.Cítite to na svojej koži... Ľudia sú tam iný, smutní kultúra je odlišná. Ale nie je to iba problém kultúry, je toho viac. ľudia sa boja."

Daniel Pastirčák - čo sa vlastne stalo pred 2000 rokmi?

Podrobnosti: Uverejnené: sobota, 02. november 2013, 12:12

Rozprávanie sa s kazateľom, výtvarníkom a spisovateľom Danielom Pastirčákom na tému dôveryhodnosti dôkazov odkazujúcich na Ježiša Krista a na tému jeho postoja k nim. Čo sa vlastne pred 2000 rokmi stalo a ako to ovplyvnilo náš postoj voči Bohu?

Juraj Jordán Dovala - o otvorenom srdci

Podrobnosti: Uverejnené: sobota, 02. november 2013, 12:10

Rozhovor so spisovateľom, hudobníkom a teológom Jurajom Jordánom Dovalom o Bohu, o našom vzťahu k nemu a o tom, ako je dôležité mať otvorené srdce

Jaro Tomašovský - o misionárskej práci

Podrobnosti: Uverejnené: sobota, 02. november 2013, 11:15

O misii v rôznych kmeňoch vo svete, aj medzi kanibalmi, alebo prečo necmúľať zabalený cukrík, čo trvá 15 rokov na preložení Biblie a či to má vôbec celé zmysel ..

Ladiaca konzola systému Joomla!

Sedenie

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1566768186,
                "last": 1566768186,
                "now": 1566768186
            },
            "token": "iSz8TB7ZnRn63I1PbBGkGgFGzKTt6OfX"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "gantry-current-template": "rt_sirocco",
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-name": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-logo-type": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-logo-custom-image": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-accent-color1": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-accent-color2": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-top-textcolor": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-top-background": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-header-textcolor": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-header-background": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-header-type": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-showcase-textcolor": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-showcase-background": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-utility-textcolor": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-utility-background": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-feature-textcolor": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-feature-background": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-maintop-textcolor": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-maintop-background": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-expandedtop-textcolor": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-expandedtop-background": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-expandedbottom-textcolor": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-expandedbottom-background": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-mainbottom-textcolor": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-mainbottom-background": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-mainbody-overlay": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-extension-textcolor": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-extension-background": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-bottom-textcolor": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-bottom-background": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-footer-textcolor": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-footer-background": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-copyright-textcolor": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-copyright-background": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-font-family": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-font-size-is": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-menu-type": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-layout-mode": null
    }
}

Informácie o profile

Čas

Pamäť

Čas: 4.23 ms / 4.23 ms Pamäť: 0.576 MB / 0.94 MB Application: afterLoad

Čas: 80.49 ms / 84.72 ms Pamäť: 1.573 MB / 2.52 MB Application: afterInitialise

Čas: 11.22 ms / 95.94 ms Pamäť: 0.349 MB / 2.86 MB Application: afterRoute

Čas: 2.70 ms / 98.64 ms Pamäť: 0.087 MB / 2.95 MB Application: beforeRenderComponent com_content

Čas: 3.23 ms / 101.88 ms Pamäť: 0.312 MB / 3.26 MB Application: Before Access::preloadComponents (all components)

Čas: 0.93 ms / 102.81 ms Pamäť: 0.057 MB / 3.32 MB Application: After Access::preloadComponents (all components)

Čas: 0.03 ms / 102.83 ms Pamäť: 0.000 MB / 3.32 MB Application: Before Access::preloadPermissions (com_content)

Čas: 0.95 ms / 103.78 ms Pamäť: 0.158 MB / 3.48 MB Application: After Access::preloadPermissions (com_content)

Čas: 0.03 ms / 103.81 ms Pamäť: 0.000 MB / 3.47 MB Application: Before Access::getAssetRules (id:95 name:com_content.category.19)

Čas: 0.34 ms / 104.15 ms Pamäť: 0.010 MB / 3.47 MB Application: After Access::getAssetRules (id:95 name:com_content.category.19)

Čas: 3.11 ms / 107.26 ms Pamäť: 0.177 MB / 3.65 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Čas: 0.02 ms / 107.28 ms Pamäť: 0.002 MB / 3.65 MB Application: After Access::getAssetRules (id:8 name:com_content)

Čas: 52.19 ms / 159.48 ms Pamäť: 3.135 MB / 6.79 MB Application: afterRenderComponent com_content

Čas: 23.94 ms / 183.42 ms Pamäť: 0.611 MB / 7.40 MB Application: afterDispatch

Čas: 10.51 ms / 193.93 ms Pamäť: 0.333 MB / 7.73 MB Application: beforeRenderModule mod_roknavmenu ()

Čas: 14.20 ms / 208.13 ms Pamäť: 0.794 MB / 8.53 MB Application: beforeRenderModule mod_search (Menu Search)

Čas: 2.07 ms / 210.20 ms Pamäť: 0.050 MB / 8.58 MB Application: afterRenderModule mod_search (Menu Search)

Čas: 0.07 ms / 210.27 ms Pamäť: 0.000 MB / 8.55 MB Application: afterRenderModule mod_roknavmenu ()

Čas: 4.75 ms / 215.02 ms Pamäť: 0.042 MB / 8.60 MB Application: beforeRenderModule mod_custom (Facebook)

Čas: 0.54 ms / 215.56 ms Pamäť: 0.006 MB / 8.60 MB Application: afterRenderModule mod_custom (Facebook)

Čas: 0.03 ms / 215.59 ms Pamäť: 0.000 MB / 8.60 MB Application: beforeRenderModule mod_whosonline (Who[span class="arialfont"]'[/span]s Online)

Čas: 1.88 ms / 217.47 ms Pamäť: 0.028 MB / 8.63 MB Application: afterRenderModule mod_whosonline (Who[span class="arialfont"]'[/span]s Online)

Čas: 22.82 ms / 240.29 ms Pamäť: 0.218 MB / 8.85 MB Application: afterRender

Celkový počet dotazov na databázu: 61.61 ms

Využitie pamäte

Databázové dotazy

Zaznamenané dotazy: 44 61.61 ms

Bolo nájdených 7 duplicít!

2 duplicít: #8 #9

2 duplicít: #13 #15

3 duplicít: #18 #36 #37

Čas dotazu: 0.47 ms Pamäť pre dotazy: 0.025 MB pamäť pred dotazom: 1.274 MB Vrátené riadky: 0

SELECT `data`

  FROM `pdx79_session`

  WHERE `session_id` = '750797a2895a887c30ad1c3ac6d7dc5f'

Vysvetlenie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pdx79_session	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.03 ms

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Rovnaké, ako volanie o riadok nižšie.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 0.43 ms Po ostatnom dotaze: 0.44 ms Pamäť pre dotazy: 0.022 MB pamäť pred dotazom: 1.289 MB Vrátené riadky: 0

SELECT `session_id`

  FROM `pdx79_session`

  WHERE `session_id` = '750797a2895a887c30ad1c3ac6d7dc5f' 
  LIMIT 1

Vysvetlenie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pdx79_session	const	PRIMARY	PRIMARY	194	const	1	100.00	Using index

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
executing	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 0.45 ms Po ostatnom dotaze: 0.07 ms Pamäť pre dotazy: 0.004 MB pamäť pred dotazom: 1.295 MB

INSERT INTO `pdx79_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('750797a2895a887c30ad1c3ac6d7dc5f', 1, 1566768186, 0, '', 0)

Vysvetlenie

Nie je možné VYSVETLENIE na dotaz: INSERT INTO `pdx79_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('750797a2895a887c30ad1c3ac6d7dc5f', 1, 1566768186, 0, '', 0)

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
update	0.11 ms
Waiting for query cache lock	0.00 ms
update	0.01 ms
end	0.01 ms
query end	0.07 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 0.86 ms Po ostatnom dotaze: 0.69 ms Pamäť pre dotazy: 0.029 MB pamäť pred dotazom: 1.330 MB Vrátené riadky: 39

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `pdx79_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Vysvetlenie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pdx79_extensions	ref	extension	extension	82	const	39	100.00	Using index condition; Using where

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.38 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Rovnaké, ako volanie o riadok nižšie.
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:49

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 0.47 ms Po ostatnom dotaze: 0.63 ms Pamäť pre dotazy: 0.023 MB pamäť pred dotazom: 1.424 MB Vrátené riadky: 5

SELECT id, rules

  FROM `pdx79_viewlevels`

Vysvetlenie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pdx79_viewlevels	ALL	NULL	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	5	100.00	NULL

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
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:49

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 0.47 ms Po ostatnom dotaze: 0.08 ms Pamäť pre dotazy: 0.022 MB pamäť pred dotazom: 1.436 MB Vrátené riadky: 1

SELECT b.id

  FROM pdx79_usergroups AS a

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

  WHERE a.id = 1

Vysvetlenie

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

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
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:49

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 1.51 ms Po ostatnom dotaze: 0.14 ms Pamäť pre dotazy: 0.034 MB pamäť pred dotazom: 1.458 MB Vrátené riadky: 92

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM pdx79_extensions

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

  ORDER BY ordering

Vysvetlenie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pdx79_extensions	ref	extension	extension	82	const	114	100.00	Using index condition; Using where; Pomocou filesort

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
Sorting result	0.00 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	1.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Rovnaké, ako volanie o riadok nižšie.
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:49

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 0.55 ms Po ostatnom dotaze: 6.86 ms Pamäť pre dotazy: 0.024 MB pamäť pred dotazom: 1.878 MB Vrátené riadky: 1

Duplicitné dotazy: #9

SELECT template

  FROM pdx79_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Vysvetlenie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	ALL	idx_home	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	6	100.00	Using where

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
13	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
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:49

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 0.37 ms Po ostatnom dotaze: 0.05 ms Pamäť pre dotazy: 0.025 MB pamäť pred dotazom: 1.886 MB Vrátené riadky: 1

Duplicitné dotazy: #8

SELECT template

  FROM pdx79_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Vysvetlenie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	ALL	idx_home	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	6	100.00	Using where

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
14	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
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:49

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 0.46 ms Po ostatnom dotaze: 1.55 ms Pamäť pre dotazy: 0.023 MB pamäť pred dotazom: 2.063 MB Vrátené riadky: 2

SELECT extension, file, type

  FROM pdx79_rokcommon_configs

  ORDER BY priority

Vysvetlenie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pdx79_rokcommon_configs	ALL	NULL	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	2	100.00	Pomocou filesort

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rokcommon/rokcommon.php:131
8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:75
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
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:49

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 15.40 ms Po ostatnom dotaze: 8.58 ms Pamäť pre dotazy: 0.029 MB pamäť pred dotazom: 2.260 MB Vrátené riadky: 18

SHOW FULL COLUMNS 
  FROM `pdx79_extensions`

Vysvetlenie

Nie je možné VYSVETLENIE na dotaz: SHOW FULL COLUMNS FROM `pdx79_extensions`

Profil

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	11.32 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	3.59 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
13	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
12	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
11	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Extension.php:32
10	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:312
9	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/roksprocket/roksprocket.php:45
8	plgSystemRokSprocket->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:49

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 0.35 ms Po ostatnom dotaze: 0.60 ms Pamäť pre dotazy: 0.022 MB pamäť pred dotazom: 2.305 MB Vrátené riadky: 1

SELECT `extension_id`

  FROM `pdx79_extensions`

  WHERE type = 'component' 
  AND element = 'com_roksprocket'

Vysvetlenie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pdx79_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	100.00	Using index condition; Using where

Profil

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 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

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
10	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
9	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:47
8	plgSystemRokSprocket->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:49

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 0.23 ms Po ostatnom dotaze: 0.09 ms Pamäť pre dotazy: 0.028 MB pamäť pred dotazom: 2.312 MB Vrátené riadky: 1

Duplicitné dotazy: #15

SELECT *

  FROM pdx79_extensions

  WHERE `extension_id` = '10014'

Vysvetlenie

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

Profil

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	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.00 ms

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:54
8	plgSystemRokSprocket->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:49

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 0.23 ms Po ostatnom dotaze: 0.08 ms Pamäť pre dotazy: 0.022 MB pamäť pred dotazom: 2.316 MB Vrátené riadky: 1

SELECT `extension_id`

  FROM `pdx79_extensions`

  WHERE type = 'module' 
  AND element = 'mod_roksprocket'

Vysvetlenie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pdx79_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	100.00	Using index condition; Using where

Profil

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

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
10	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
9	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:70
8	plgSystemRokSprocket->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:49

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 0.20 ms Po ostatnom dotaze: 0.07 ms Pamäť pre dotazy: 0.028 MB pamäť pred dotazom: 2.322 MB Vrátené riadky: 1

Duplicitné dotazy: #13

SELECT *

  FROM pdx79_extensions

  WHERE `extension_id` = '10014'

Vysvetlenie

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

Profil

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	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.00 ms

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:76
8	plgSystemRokSprocket->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:49

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 0.90 ms Po ostatnom dotaze: 33.32 ms Pamäť pre dotazy: 0.038 MB pamäť pred dotazom: 2.608 MB Vrátené riadky: 13

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 pdx79_menu AS m

  LEFT JOIN pdx79_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

Vysvetlenie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	35	100.00	Using index condition; Using where; Pomocou filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	db51003xnewjom.m.component_id	1	100.00	Using where

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.24 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Rovnaké, ako volanie o riadok nižšie.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
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:49

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 0.34 ms Po ostatnom dotaze: 8.04 ms Pamäť pre dotazy: 0.029 MB pamäť pred dotazom: 2.817 MB Vrátené riadky: 11

SELECT * 
  FROM pdx79_rokcandy 
  WHERE published=1

Vysvetlenie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pdx79_rokcandy	ALL	NULL	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	11	100.00	Using where

Profil

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:27
13	RokCandyHelper::getUserMacros()	Rovnaké, ako volanie o riadok nižšie.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
10	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:17
9	RokCandyHelper::getMacros()	JROOT/plugins/system/rokcandy/rokcandy.php:28
8	plgSystemRokCandy->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:1122
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:49

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 0.38 ms Po ostatnom dotaze: 0.24 ms Pamäť pre dotazy: 0.032 MB pamäť pred dotazom: 2.830 MB Vrátené riadky: 4

Duplicitné dotazy: #36 #37

SELECT id, home, template, s.params

  FROM pdx79_template_styles as s

  LEFT JOIN pdx79_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

Vysvetlenie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	ALL	idx_template	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	6	100.00	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	db51003xnewjom.s.template,const	1	100.00	Using index condition; Using where

Profil

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
15	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:53
14	RokCandyHelper::readIniFile()	Rovnaké, ako volanie o riadok nižšie.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
11	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:44
10	RokCandyHelper::getTemplateOverrides()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:18
9	RokCandyHelper::getMacros()	JROOT/plugins/system/rokcandy/rokcandy.php:28
8	plgSystemRokCandy->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:1122
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:49

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 0.33 ms Po ostatnom dotaze: 0.69 ms Pamäť pre dotazy: 0.025 MB pamäť pred dotazom: 2.884 MB Vrátené riadky: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `pdx79_extensions`

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

Vysvetlenie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pdx79_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using index condition

Profil

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	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.02 ms

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Rovnaké, ako volanie o riadok nižšie.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1119
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
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:49

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 0.26 ms Po ostatnom dotaze: 0.14 ms Pamäť pre dotazy: 0.005 MB pamäť pred dotazom: 2.874 MB

UPDATE `pdx79_extensions`

  SET `params` = '{\"mediaversion\":\"4e5d60f8dfeda3305f1c19eab64099cf\"}'

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

Vysvetlenie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pdx79_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profil

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.03 ms
updating	0.03 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.00 ms
query end	0.03 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1119
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
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:49

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 0.27 ms Po ostatnom dotaze: 0.62 ms Pamäť pre dotazy: 0.025 MB pamäť pred dotazom: 2.909 MB Vrátené riadky: 1

SELECT *

  FROM pdx79_languages

  WHERE published=1

  ORDER BY ordering ASC

Vysvetlenie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pdx79_languages	ALL	NULL	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	1	100.00	Using where; Pomocou filesort

Profil

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.03 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

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
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:49

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 0.73 ms Po ostatnom dotaze: 4.15 ms Pamäť pre dotazy: 0.031 MB pamäť pred dotazom: 3.268 MB Vrátené riadky: 39

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

  FROM `pdx79_assets`

  WHERE `name` IN ('root.1','com_actionlogs','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_fields','com_finder','com_gantry','com_installer','com_j2xml','com_joomlaupdate','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_rokcandy','com_roksprocket','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

Vysvetlenie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pdx79_assets	ALL	idx_asset_name	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	224	17.86	Using where

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.34 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

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
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:49

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 0.59 ms Po ostatnom dotaze: 0.19 ms Pamäť pre dotazy: 0.044 MB pamäť pred dotazom: 3.318 MB Vrátené riadky: 161

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

  FROM `pdx79_assets`

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

Vysvetlenie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pdx79_assets	ALL	idx_asset_name,idx_parent_id	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	224	100.00	Using where

Profil

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.27 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

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
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:49

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 0.70 ms Po ostatnom dotaze: 1.36 ms Pamäť pre dotazy: 0.038 MB pamäť pred dotazom: 3.473 MB Vrátené riadky: 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,(
SELECT COUNT(i.`id`)

  FROM `pdx79_content` AS `i`

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

  FROM `pdx79_categories` AS `s`

  INNER JOIN `pdx79_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 = 19

  ORDER BY c.lft

Vysvetlenie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Pomocou filesort
1	PRIMARY	c	ALL	cat_idx,idx_left_right	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	23	60.87	Using where
2	DEPENDENT SUBQUERY	i	ref	idx_state,idx_catid	idx_catid	4	db51003xnewjom.c.id	5	100.00	Using index condition; Using where

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.06 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
executing	0.00 ms
Sending data	0.03 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
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:49

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 6.28 ms Po ostatnom dotaze: 1.82 ms Pamäť pre dotazy: 0.046 MB pamäť pred dotazom: 3.653 MB Vrátené riadky: 6

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 pdx79_content AS a

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

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

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

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

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

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid = 19 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-08-25 21:23:06') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-08-25 21:23:06')

  ORDER BY  c.lft,   
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC ,  a.created   
  LIMIT 16

Vysvetlenie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Using temporary; Pomocou filesort
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	6	100.00	Using where
1	SIMPLE	ua	ALL	PRIMARY	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	2	100.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	uam	ALL	PRIMARY	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	2	100.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where
1	SIMPLE	v	ALL	PRIMARY	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)

Profil

Status	Duration
starting	0.11 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.02 ms
init	0.07 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.05 ms
Creating tmp table	0.09 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	3.85 ms
Creating sort index	0.07 ms
end	0.02 ms
removing tmp table	1.58 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.03 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
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:49

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 0.33 ms Po ostatnom dotaze: 0.51 ms Pamäť pre dotazy: 0.036 MB pamäť pred dotazom: 3.761 MB Vrátené riadky: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `pdx79_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 42 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Vysvetlenie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_tag_type	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	db51003xnewjom.m.tag_id	1	100.00	Using where

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 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

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
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:49

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 0.31 ms Po ostatnom dotaze: 0.17 ms Pamäť pre dotazy: 0.036 MB pamäť pred dotazom: 3.783 MB Vrátené riadky: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `pdx79_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 77 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Vysvetlenie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_tag_type	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	db51003xnewjom.m.tag_id	1	100.00	Using where

Profil

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

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
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:49

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 0.30 ms Po ostatnom dotaze: 0.17 ms Pamäť pre dotazy: 0.036 MB pamäť pred dotazom: 3.805 MB Vrátené riadky: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `pdx79_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 93 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Vysvetlenie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_tag_type	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	db51003xnewjom.m.tag_id	1	100.00	Using where

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	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

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
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:49

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 0.31 ms Po ostatnom dotaze: 0.17 ms Pamäť pre dotazy: 0.036 MB pamäť pred dotazom: 3.827 MB Vrátené riadky: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `pdx79_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 101 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Vysvetlenie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_tag_type	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	db51003xnewjom.m.tag_id	1	100.00	Using where

Profil

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

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
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:49

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 0.30 ms Po ostatnom dotaze: 0.16 ms Pamäť pre dotazy: 0.036 MB pamäť pred dotazom: 3.849 MB Vrátené riadky: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `pdx79_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 103 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Vysvetlenie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_tag_type	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	db51003xnewjom.m.tag_id	1	100.00	Using where

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	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

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
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:49

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 0.30 ms Po ostatnom dotaze: 0.17 ms Pamäť pre dotazy: 0.036 MB pamäť pred dotazom: 3.871 MB Vrátené riadky: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `pdx79_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 104 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Vysvetlenie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_tag_type	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	db51003xnewjom.m.tag_id	1	100.00	Using where

Profil

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

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
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:49

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 0.43 ms Po ostatnom dotaze: 1.20 ms Pamäť pre dotazy: 0.026 MB pamäť pred dotazom: 3.983 MB Vrátené riadky: 1

SELECT COUNT(*)

  FROM pdx79_content AS a

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

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

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

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

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

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid = 19 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-08-25 21:23:06') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-08-25 21:23:06')

Vysvetlenie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	6	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	db51003xnewjom.a.created_by	1	100.00	Using where; Using index
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	db51003xnewjom.a.modified_by	1	100.00	Using where; Using index
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where; Using index
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	db51003xnewjom.a.id	1	100.00	Using where; Using index

Profil

Status	Duration
starting	0.04 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.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.07 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
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:49

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 0.32 ms Po ostatnom dotaze: 0.19 ms Pamäť pre dotazy: 0.036 MB pamäť pred dotazom: 3.996 MB Vrátené riadky: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `pdx79_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.category' 
  AND `m`.`content_item_id` = 19 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Vysvetlenie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_tag_type	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	db51003xnewjom.m.tag_id	1	100.00	Using where

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
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:49

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 0.44 ms Po ostatnom dotaze: 1.60 ms Pamäť pre dotazy: 0.039 MB pamäť pred dotazom: 4.110 MB Vrátené riadky: 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 `pdx79_categories` AS `s`

  INNER JOIN `pdx79_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) 
  AND c.published = 1 
  AND s.id = 19

  ORDER BY c.lft

Vysvetlenie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Pomocou filesort
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	23	60.87	Using where

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.06 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

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
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:135
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:478
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:49

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 0.48 ms Po ostatnom dotaze: 0.16 ms Pamäť pre dotazy: 0.037 MB pamäť pred dotazom: 4.131 MB Vrátené riadky: 0

SELECT 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 pdx79_fields AS a

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

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

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

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

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

  LEFT JOIN `pdx79_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 (19,0,17)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Vysvetlenie

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

Profil

Status	Duration
starting	0.06 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.03 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.03 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

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
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:135
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:478
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:49

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 0.57 ms Po ostatnom dotaze: 17.34 ms Pamäť pre dotazy: 0.030 MB pamäť pred dotazom: 6.082 MB Vrátené riadky: 4

Duplicitné dotazy: #18 #37

SELECT id, home, template, s.params

  FROM pdx79_template_styles as s

  LEFT JOIN pdx79_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

Vysvetlenie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	ALL	idx_template	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	6	100.00	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	db51003xnewjom.s.template,const	1	100.00	Using index condition; Using where

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.06 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

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry/core/gantrytemplate.class.php:638
22	GantryTemplate::getAllTemplates()	JROOT/libraries/gantry/core/gantrytemplate.class.php:590
21	GantryTemplate::getTemplateParams()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:69
20	GantryMenuItemParamOverride::_populateSingleItem()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:36
19	GantryMenuItemParamOverride::populate()	JROOT/libraries/gantry/core/gantry.class.php:1843
18	Gantry->populateParams()	JROOT/libraries/gantry/core/gantry.class.php:392
17	Gantry->init()	JROOT/libraries/gantry/gantry.php:275
16	gantry_setup()	JROOT/libraries/gantry/gantry.php:432
15	include JROOT/libraries/gantry/gantry.php	JROOT/templates/rt_sirocco/html/com_content/category/blog.php:14
14	include JROOT/templates/rt_sirocco/html/com_content/category/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
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:49

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 0.60 ms Po ostatnom dotaze: 0.60 ms Pamäť pre dotazy: 0.030 MB pamäť pred dotazom: 6.099 MB Vrátené riadky: 4

Duplicitné dotazy: #18 #36

SELECT id, home, template, s.params

  FROM pdx79_template_styles as s

  LEFT JOIN pdx79_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

Vysvetlenie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	ALL	idx_template	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	6	100.00	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	db51003xnewjom.s.template,const	1	100.00	Using index condition; Using where

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.12 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

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry/core/gantrytemplate.class.php:638
22	GantryTemplate::getAllTemplates()	JROOT/libraries/gantry/core/gantrytemplate.class.php:590
21	GantryTemplate::getTemplateParams()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:69
20	GantryMenuItemParamOverride::_populateSingleItem()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:36
19	GantryMenuItemParamOverride::populate()	JROOT/libraries/gantry/core/gantry.class.php:1843
18	Gantry->populateParams()	JROOT/libraries/gantry/core/gantry.class.php:392
17	Gantry->init()	JROOT/libraries/gantry/gantry.php:275
16	gantry_setup()	JROOT/libraries/gantry/gantry.php:432
15	include JROOT/libraries/gantry/gantry.php	JROOT/templates/rt_sirocco/html/com_content/category/blog.php:14
14	include JROOT/templates/rt_sirocco/html/com_content/category/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
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:49

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 2.41 ms Po ostatnom dotaze: 49.44 ms Pamäť pre dotazy: 0.028 MB pamäť pred dotazom: 7.688 MB Vrátené riadky: 5

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM pdx79_modules AS m

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

  LEFT JOIN pdx79_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 <= '2019-08-25 21:23:06') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-08-25 21:23:06') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 142 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Vysvetlenie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	41	100.00	Using index condition; Using where; Pomocou filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	db51003xnewjom.m.id	1	100.00	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	db51003xnewjom.m.module,const	1	100.00	Using index condition; Using where

Profil

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.06 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	1.65 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.06 ms
freeing items	0.05 ms
cleaning up	0.04 ms

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	Rovnaké, ako volanie o riadok nižšie.
15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
13	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
12	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
11	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
10	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/libraries/gantry/core/gantry.class.php:804
9	Gantry->getJoomlaModuleCount()	JROOT/libraries/gantry/core/gantry.class.php:757
8	Gantry->countModules()	JROOT/templates/rt_sirocco/index.php:58
7	require JROOT/templates/rt_sirocco/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
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:49

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 0.43 ms Po ostatnom dotaze: 8.66 ms Pamäť pre dotazy: 0.026 MB pamäť pred dotazom: 8.293 MB Vrátené riadky: 0

SELECT ts.template

  FROM pdx79_template_styles AS ts

  INNER JOIN pdx79_menu AS m 
  ON ts.id=m.template_style_id

  WHERE m.id = 142 
  AND m.template_style_id != 0

Vysvetlenie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

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

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
17	JDatabaseDriver->loadColumn()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:101
16	RokNavMenu::getTemplates()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:74
15	RokNavMenu::loadCatalogs()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:25
14	RokNavMenu->__construct()	JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:21
13	include JROOT/modules/mod_roknavmenu/mod_roknavmenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
11	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/rt_sirocco/features/dropdownmenu.php:56
10	GantryFeatureDropdownMenu->render()	JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:70
9	GantryModulesRenderer::display()	JROOT/libraries/gantry/core/gantry.class.php:867
8	Gantry->displayModules()	JROOT/templates/rt_sirocco/index.php:84
7	require JROOT/templates/rt_sirocco/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
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:49

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 0.38 ms Po ostatnom dotaze: 0.05 ms Pamäť pre dotazy: 0.026 MB pamäť pred dotazom: 8.301 MB Vrátené riadky: 1

SELECT template

  FROM pdx79_template_styles

  WHERE home = 1 
  AND client_id = 0

Vysvetlenie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pdx79_template_styles	ALL	idx_home	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	6	100.00	Using where

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.04 ms
cleaning up	0.00 ms

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
17	JDatabaseDriver->loadColumn()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:116
16	RokNavMenu::getTemplates()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:74
15	RokNavMenu::loadCatalogs()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:25
14	RokNavMenu->__construct()	JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:21
13	include JROOT/modules/mod_roknavmenu/mod_roknavmenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
11	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/rt_sirocco/features/dropdownmenu.php:56
10	GantryFeatureDropdownMenu->render()	JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:70
9	GantryModulesRenderer::display()	JROOT/libraries/gantry/core/gantry.class.php:867
8	Gantry->displayModules()	JROOT/templates/rt_sirocco/index.php:84
7	require JROOT/templates/rt_sirocco/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
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:49

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 0.92 ms Po ostatnom dotaze: 4.92 ms Pamäť pre dotazy: 0.030 MB pamäť pred dotazom: 8.506 MB Vrátené riadky: 5

SELECT id, title, module, position, content, showtitle, params, mm.menuid

  FROM pdx79_modules AS m

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

  WHERE m.published = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2019-08-25 21:23:06') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-08-25 21:23:06') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 142 OR mm.menuid <= 0)

  ORDER BY position, ordering

Vysvetlenie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	PRIMARY,published	published	1	const	41	100.00	Using index condition; Using where; Pomocou filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	db51003xnewjom.m.id	1	100.00	Using where; Using index

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.05 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.46 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
21	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:171
20	RokNavMenu::loadModules()	JROOT/templates/rt_sirocco/html/mod_roknavmenu/themes/gantry-dropdown/layout.php:262
19	GantryDropdownLayout->getModule()	JROOT/templates/rt_sirocco/html/mod_roknavmenu/themes/gantry-dropdown/layout.php:129
18	GantryDropdownLayout->renderItem()	JROOT/templates/rt_sirocco/html/mod_roknavmenu/themes/gantry-dropdown/layout.php:366
17	GantryDropdownLayout->renderMenu()	JROOT/modules/mod_roknavmenu/lib/librokmenu/RokMenuDefaultRenderer.php:97
16	RokMenuDefaultRenderer->renderMenu()	JROOT/modules/mod_roknavmenu/lib/librokmenu/RokMenu.php:93
15	RokMenu->renderMenu()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:59
14	RokNavMenu->render()	JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:23
13	include JROOT/modules/mod_roknavmenu/mod_roknavmenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
11	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/rt_sirocco/features/dropdownmenu.php:56
10	GantryFeatureDropdownMenu->render()	JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:70
9	GantryModulesRenderer::display()	JROOT/libraries/gantry/core/gantry.class.php:867
8	Gantry->displayModules()	JROOT/templates/rt_sirocco/index.php:84
7	require JROOT/templates/rt_sirocco/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
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:49

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 0.78 ms Po ostatnom dotaze: 8.23 ms Pamäť pre dotazy: 0.039 MB pamäť pred dotazom: 8.640 MB Vrátené riadky: 237

SELECT guest, client_id

  FROM pdx79_session

  WHERE client_id = 0

Vysvetlenie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pdx79_session	ALL	NULL	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	129	100.00	Using where

Profil

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.48 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

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_whosonline/helper.php:45
11	ModWhosonlineHelper::getOnlineCount()	JROOT/modules/mod_whosonline/mod_whosonline.php:19
10	include JROOT/modules/mod_whosonline/mod_whosonline.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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:49

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 18.50 ms Po ostatnom dotaze: 2.28 ms Pamäť pre dotazy: 0.030 MB pamäť pred dotazom: 8.752 MB Vrátené riadky: 6

SHOW FULL COLUMNS 
  FROM `pdx79_template_styles`

Vysvetlenie

Nie je možné VYSVETLENIE na dotaz: SHOW FULL COLUMNS FROM `pdx79_template_styles`

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	14.34 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.01 ms
Opening tables	0.02 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	3.61 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
17	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_templates/tables/style.php:30
16	TemplatesTableStyle->__construct()	JROOT/libraries/src/Table/Table.php:312
15	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/gantry/gantry.php:194
14	plgSystemGantry->getTable()	JROOT/plugins/system/gantry/gantry.php:165
13	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
12	plgSystemGantry->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:49

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

Čas dotazu: 0.26 ms Po ostatnom dotaze: 0.17 ms Pamäť pre dotazy: 0.026 MB pamäť pred dotazom: 8.774 MB Vrátené riadky: 1

SELECT *

  FROM pdx79_template_styles

  WHERE `id` = '26'

Vysvetlenie

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

Profil

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 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

Zásobník volaní

#	Volacia funkcia	Súbor a číslo riadku
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
15	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
14	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/gantry/gantry.php:168
13	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
12	plgSystemGantry->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:49

[Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

31 zaznamenaných typov dotazov, zoradené podľa výskytu udalosti.

VYBERTE tabuľky:

7 × SELECT `m`.`tag_id`,`t`.* 
  FROM `pdx79_contentitem_tag_map` AS m  
  INNER JOIN `pdx79_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

3 × SELECT id, home, template, s.params 
  FROM pdx79_template_styles as s 
  LEFT JOIN pdx79_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `pdx79_extensions`

2 × SELECT template 
  FROM pdx79_template_styles as s

2 × SELECT `extension_id` 
  FROM `pdx79_extensions`

```
2 × SELECT * 
  FROM pdx79_extensions
```

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `pdx79_assets`

1 × SELECT `data` 
  FROM `pdx79_session`

1 × SELECT guest, client_id 
  FROM pdx79_session

1 × SELECT id, title, module, position, content, showtitle, params, mm.menuid 
  FROM pdx79_modules AS m 
  LEFT JOIN pdx79_modules_menu AS mm 
  ON mm.moduleid = m.id

1 × SELECT template 
  FROM pdx79_template_styles

1 × SELECT ts.template 
  FROM pdx79_template_styles AS ts 
  INNER JOIN pdx79_menu AS m 
  ON ts.id=m.template_style_id

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM pdx79_modules AS m 
  LEFT JOIN pdx79_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN pdx79_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT 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 pdx79_fields AS a 
  LEFT JOIN `pdx79_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN pdx79_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN pdx79_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN pdx79_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN pdx79_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `pdx79_fields_categories` AS fc 
  ON fc.field_id = a.id

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM `pdx79_categories` AS `s` 
  INNER JOIN `pdx79_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

1 × SELECT COUNT(*) 
  FROM pdx79_content AS a 
  LEFT JOIN pdx79_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN pdx79_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN pdx79_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN pdx79_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN pdx79_content_rating AS v 
  ON a.id = v.content_id

```
1 × SELECT * 
  FROM pdx79_languages
```

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

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`) 
  FROM `pdx79_content` AS `i`

1 × SELECT `session_id` 
  FROM `pdx79_session`

```
1 × SELECT * 
  FROM pdx79_rokcandy
```

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM pdx79_menu AS m 
  LEFT JOIN pdx79_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT extension, file, type 
  FROM pdx79_rokcommon_configs

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM pdx79_extensions

1 × SELECT b.id 
  FROM pdx79_usergroups AS a 
  LEFT JOIN pdx79_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT id, rules 
  FROM `pdx79_viewlevels

1 × SELECT * 
  FROM pdx79_template_styles

ĎALŠIE tabuľky:

1 × INSERT INTO `pdx79_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('750797a2895a887c30ad1c3ac6d7dc5f', 1, 1566768186, 0, '', 0

1 × SHOW FULL COLUMNS 
  FROM `pdx79_extensions

1 × UPDATE `pdx79_extensions` 
  SET `params` = '{\"mediaversion\":\"4e5d60f8dfeda3305f1c19eab64099cf\"}'

1 × SHOW FULL COLUMNS 
  FROM `pdx79_template_styles

Interviews

Vedie Homosexualita do tmy?

Spoveď pornoherečky

Samir - o kresťanstve v Azerbajdžane

Daniel Pastirčák - čo sa vlastne stalo pred 2000 rokmi?

Juraj Jordán Dovala - o otvorenom srdci

Jaro Tomašovský - o misionárskej práci

Facebook

Who's Online

Ladiaca konzola systému Joomla!

Sedenie

Informácie o profile

Čas

Pamäť

Využitie pamäte

Databázové dotazy

Zaznamenané dotazy: 44 61.61 ms

Bolo nájdených 7 duplicít!

31 zaznamenaných typov dotazov, zoradené podľa výskytu udalosti.

VYBERTE tabuľky:

ĎALŠIE tabuľky: