Základní škola Rozvadov

Základní škola Rozvadov

2024/2025 - 2024-12-19 Vánoční zvyky

Konzole ladění chyb Joomla!

Konzole ladění chyb Joomla!

Čeká nás

Archív

Přihlášení

Sezení

Informace o profilu

Využití paměti

Dotazy do databáze

Sezení

Informace o profilu

Využití paměti

Dotazy do databáze

21 zaznamenaných dotazů 37.50 ms

Nalezeno 2 duplikátů!

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

Čas

Paměť

21 zaznamenaných dotazů 37.50 ms

Nalezeno 2 duplikátů!

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

VYBRANÉ tabulky:

OSTATNÍ tabulky:

VYBRANÉ tabulky:

OSTATNÍ tabulky:

1000051721

1000051722

1000051730

1000051734

1000051742

1000051755

1000051762

1000051767

1000051773

1000051778

1000051782

1000051787

1000051792

1000051797

1000051802

1000051804

1000051806

1000051808

1000051810

1000051812

		Květen 2025

{
    "__default": {
        "session": {
            "counter": 2,
            "timer": {
                "start": 1746866722,
                "last": 1746866722,
                "now": 1746866723
            },
            "token": "9kr7bJi17DSNZ4Iwx9nxrrYs6gFriqMi"
        },
        "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
        }
    }
}

2 duplikátů: #5 #17

Čas pro dotazy: 0.84 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 1.054 MB Vráceno řádků: 1

SELECT `data`

  FROM `j3_session`

  WHERE `session_id` = X'3437653365333762613335376164616265376135646365323365303932333038'

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j3_session	const	PRIMARY	PRIMARY	194	const	1

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.03 ms
Opening tables	0.08 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.02 ms
After opening tables	0.03 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.03 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.04 ms
updating status	0.05 ms
cleaning up	0.03 ms

Stack volání

#	Volající	Soubor a číslo řádku
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Stejné jako volání na řádku níže.
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:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
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:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.82 ms Po posledním dotazu: 5.08 ms Dotaz paměti: 0.021 MB Paměť před dotazem: 1.151 MB Vráceno řádků: 5

SELECT id, rules

  FROM `j3_viewlevels`

Vysvětlení

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

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
After opening tables	0.03 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.03 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.07 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.03 ms
updating status	0.05 ms
cleaning up	0.03 ms

Stack volání

#	Volající	Soubor a číslo řádku
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 3.05 ms Po posledním dotazu: 0.06 ms Dotaz paměti: 0.021 MB Paměť před dotazem: 1.163 MB Vráceno řádků: 2

SELECT b.id

  FROM j3_usergroups AS a

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

  WHERE a.id = 9

Vysvětlení

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

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
Opening tables	0.06 ms
After opening tables	0.03 ms
System lock	0.05 ms
Table lock	0.04 ms
After opening tables	0.04 ms
init	0.06 ms
optimizing	0.04 ms
statistics	0.11 ms
preparing	0.05 ms
executing	0.03 ms
Sending data	0.05 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.05 ms
freeing items	0.04 ms
updating status	0.05 ms
cleaning up	0.03 ms

Stack volání

#	Volající	Soubor a číslo řádku
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 2.60 ms Po posledním dotazu: 30.55 ms Dotaz paměti: 0.006 MB Paměť před dotazem: 1.961 MB

UPDATE `j3_extensions`

  SET `params` = '{\"mediaversion\":\"124f35eb148e94af8987ace4c8c1edb6\"}'

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

Vysvětlení

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

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
After opening tables	0.02 ms
init	0.50 ms
updating	0.14 ms
end	0.03 ms
query end	1.12 ms
closing tables	0.05 ms
freeing items	0.02 ms
updating status	0.05 ms
cleaning up	0.02 ms

Stack volání

#	Volající	Soubor a číslo řádku
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jcomments/jcomments.php:111
8	plgSystemJComments->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:1190
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.54 ms Po posledním dotazu: 21.19 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 2.968 MB Vráceno řádků: 3

Duplicitní dotazy: #17

SELECT a.filename as filename, a.type as type, a.menulink as menulink 
  FROM j3_phocagallery_styles AS a 
  WHERE a.published = 1 
  ORDER BY a.type, a.ordering ASC

Vysvětlení

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

Profil

Status	Duration
starting	0.13 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
After opening tables	0.03 ms
init	0.04 ms
optimizing	0.04 ms
statistics	0.06 ms
preparing	0.06 ms
executing	0.03 ms
Sorting result	0.57 ms
Sending data	0.10 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.03 ms
updating status	0.05 ms
cleaning up	0.03 ms

Stack volání

#	Volající	Soubor a číslo řádku
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_phocagallery/libraries/phocagallery/render/renderfront.php:735
11	PhocaGalleryRenderFront::renderAllCSS()	JROOT/components/com_phocagallery/views/category/view.html.php:65
10	PhocaGalleryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocagallery/controller.php:30
8	PhocaGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocagallery/phocagallery.php:58
6	require_once JROOT/components/com_phocagallery/phocagallery.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.86 ms Po posledním dotazu: 5.19 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 3.073 MB Vráceno řádků: 0

SELECT a.* 
  FROM j3_phocagallery_fb_users AS a 
  WHERE a.id =0

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.03 ms
Opening tables	0.06 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.02 ms
After opening tables	0.02 ms
init	0.06 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.03 ms
executing	0.05 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.02 ms
updating status	0.05 ms
cleaning up	0.03 ms

Stack volání

#	Volající	Soubor a číslo řádku
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_phocagallery/libraries/phocagallery/facebook/fbsystem.php:46
12	PhocaGalleryFbSystem::getFbUserInfo()	JROOT/administrator/components/com_phocagallery/libraries/phocagallery/facebook/fbsystem.php:53
11	PhocaGalleryFbSystem::getCommentsParams()	JROOT/components/com_phocagallery/views/category/view.html.php:211
10	PhocaGalleryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocagallery/controller.php:30
8	PhocaGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocagallery/phocagallery.php:58
6	require_once JROOT/components/com_phocagallery/phocagallery.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.66 ms Po posledním dotazu: 18.48 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 3.335 MB Vráceno řádků: 1

SELECT c.id, c.title, c.alias, c.description, c.published, c.approved, c.parent_id, c.deleteuserid, c.accessuserid, c.uploaduserid, c.owner_id, c.access, c.metakey, c.metadesc, c.latitude, c.longitude, c.zoom, c.geotitle, c.userfolder, c.image_id, 
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug  
  FROM j3_phocagallery_categories AS c 
  WHERE c.id = 556 
  LIMIT 0, 1

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1

Profil

Status	Duration
starting	0.20 ms
checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.04 ms
System lock	0.02 ms
Table lock	0.02 ms
After opening tables	0.03 ms
init	0.13 ms
optimizing	0.38 ms
statistics	0.11 ms
preparing	0.08 ms
executing	0.03 ms
Sending data	0.09 ms
end	0.04 ms
query end	0.03 ms
closing tables	0.04 ms
freeing items	0.03 ms
updating status	0.06 ms
cleaning up	0.03 ms

Stack volání

#	Volající	Soubor a číslo řádku
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_phocagallery/models/category.php:229
13	PhocagalleryModelCategory->_loadCategory()	JROOT/components/com_phocagallery/models/category.php:184
12	PhocagalleryModelCategory->getCategory()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_phocagallery/views/category/view.html.php:382
10	PhocaGalleryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocagallery/controller.php:30
8	PhocaGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocagallery/phocagallery.php:58
6	require_once JROOT/components/com_phocagallery/phocagallery.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

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

SELECT * 
  FROM j3_phocagallery_categories AS c 
  WHERE c.id = 536 
  AND c.published = 1

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.04 ms
After opening tables	0.03 ms
init	0.07 ms
optimizing	0.04 ms
statistics	0.09 ms
preparing	0.07 ms
executing	0.04 ms
Sending data	0.08 ms
end	0.06 ms
query end	0.08 ms
closing tables	0.06 ms
freeing items	0.06 ms
updating status	0.06 ms
cleaning up	0.03 ms

Stack volání

#	Volající	Soubor a číslo řádku
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_phocagallery/views/category/view.html.php:2266
11	PhocaGalleryViewCategory->_addBreadCrumbs()	JROOT/components/com_phocagallery/views/category/view.html.php:432
10	PhocaGalleryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocagallery/controller.php:30
8	PhocaGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocagallery/phocagallery.php:58
6	require_once JROOT/components/com_phocagallery/phocagallery.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.13 ms Po posledním dotazu: 3.24 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 3.419 MB Vráceno řádků: 1

SELECT cc.id, cc.title, cc.alias, cc.published, cc.approved, cc.parent_id, cc.deleteuserid, cc.accessuserid, cc.uploaduserid, cc.access 
  FROM j3_phocagallery_categories AS cc 
  WHERE cc.id = 536 
  AND cc.published = 1 
  AND cc.approved = 1 
  AND cc.id <> 556 
  ORDER BY cc.title DESC 
  LIMIT 0, 1

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cc	const	PRIMARY	PRIMARY	4	const	1

Profil

Status	Duration
starting	0.10 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.04 ms
System lock	0.03 ms
Table lock	0.02 ms
After opening tables	0.06 ms
init	0.06 ms
optimizing	0.04 ms
statistics	0.06 ms
preparing	0.04 ms
executing	0.04 ms
Sending data	0.05 ms
end	0.03 ms
query end	0.05 ms
closing tables	0.04 ms
freeing items	0.04 ms
updating status	0.05 ms
cleaning up	0.02 ms

Stack volání

#	Volající	Soubor a číslo řádku
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_phocagallery/models/category.php:257
12	PhocagalleryModelCategory->getParentCategory()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_phocagallery/views/category/view.html.php:577
10	PhocaGalleryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocagallery/controller.php:30
8	PhocaGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocagallery/phocagallery.php:58
6	require_once JROOT/components/com_phocagallery/phocagallery.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 3.01 ms Po posledním dotazu: 1.25 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 3.587 MB Vráceno řádků: 0

SELECT cc.id, cc.title, cc.alias, cc.published, cc.approved, cc.parent_id, cc.deleteuserid, cc.accessuserid, cc.uploaduserid, cc.access, cc.image_id, a.filename, a.extm, a.exts, a.extw, a.exth, a.extid 
  FROM j3_phocagallery_categories AS cc 
  LEFT JOIN j3_phocagallery AS a 
  ON cc.id = a.catid 
  WHERE cc.parent_id = 556 
  AND cc.published = 1 
  AND cc.approved = 1 
  AND cc.id <> 556 
  GROUP BY cc.id 
  ORDER BY cc.title DESC

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cc	index	PRIMARY	PRIMARY	4	NULL	407	Using where; Using temporary; Použití filesort
1	SIMPLE	a	ref	catid	catid	4	d65961_5f7b39b.cc.id	16

Profil

Status	Duration
starting	0.11 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
Opening tables	0.06 ms
After opening tables	0.02 ms
System lock	0.03 ms
Table lock	0.04 ms
After opening tables	0.03 ms
init	0.06 ms
optimizing	0.06 ms
statistics	0.14 ms
preparing	0.13 ms
executing	0.03 ms
Copying to tmp table	0.49 ms
Sorting for group	0.06 ms
Copying to tmp table	0.93 ms
Sorting result	0.08 ms
Sending data	0.04 ms
end	0.02 ms
removing tmp table	0.12 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.04 ms
freeing items	0.03 ms
updating status	0.08 ms
cleaning up	0.02 ms

Stack volání

#	Volající	Soubor a číslo řádku
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_phocagallery/models/category.php:299
12	PhocagalleryModelCategory->getSubCategory()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_phocagallery/views/category/view.html.php:739
10	PhocaGalleryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocagallery/controller.php:30
8	PhocaGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocagallery/phocagallery.php:58
6	require_once JROOT/components/com_phocagallery/phocagallery.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 3.61 ms Po posledním dotazu: 0.06 ms Dotaz paměti: 0.039 MB Paměť před dotazem: 3.593 MB Vráceno řádků: 20

SELECT a.*, cc.alias AS catalias, cc.accessuserid AS cataccessuserid, cc.access AS cataccess, 
  CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug 
  FROM j3_phocagallery AS a 
  LEFT JOIN j3_phocagallery_img_votes_statistics AS r 
  ON r.imgid = a.id 
  LEFT JOIN j3_phocagallery_categories AS cc 
  ON cc.id = a.catid 
  WHERE  a.catid= 556 
  AND a.published = 1 
  AND a.approved = 1 
  ORDER BY a.date ASC 
  LIMIT 0, 20

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	catid	catid	5	const,const	71	Using where; Using temporary; Použití filesort
1	SIMPLE	r	ALL	NULL	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)
1	SIMPLE	cc	const	PRIMARY	PRIMARY	4	const	1

Profil

Status	Duration
starting	0.10 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.06 ms
Opening tables	0.06 ms
After opening tables	0.03 ms
System lock	0.04 ms
Table lock	0.03 ms
After opening tables	0.03 ms
init	0.09 ms
optimizing	0.05 ms
statistics	0.13 ms
preparing	0.08 ms
executing	0.06 ms
Copying to tmp table	0.55 ms
Copying to tmp table	1.34 ms
Sorting result	0.14 ms
Sending data	0.20 ms
end	0.03 ms
removing tmp table	0.15 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.03 ms
updating status	0.05 ms
cleaning up	0.02 ms

Stack volání

#	Volající	Soubor a číslo řádku
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_phocagallery/models/category.php:67
11	PhocagalleryModelCategory->getData()	JROOT/components/com_phocagallery/views/category/view.html.php:958
10	PhocaGalleryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocagallery/controller.php:30
8	PhocaGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocagallery/phocagallery.php:58
6	require_once JROOT/components/com_phocagallery/phocagallery.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 2.81 ms Po posledním dotazu: 1.57 ms Dotaz paměti: 0.025 MB Paměť před dotazem: 3.745 MB Vráceno řádků: 71

SELECT a.id 
  FROM j3_phocagallery AS a 
  LEFT JOIN j3_phocagallery_categories AS cc 
  ON cc.id = a.catid 
  WHERE  a.catid= 556 
  AND a.published = 1 
  AND a.approved = 1 
  ORDER BY a.id

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	catid	catid	5	const,const	71	Using where

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.03 ms
Table lock	0.02 ms
After opening tables	0.09 ms
init	0.05 ms
optimizing	0.04 ms
statistics	0.14 ms
preparing	0.10 ms
executing	0.02 ms
Sorting result	0.02 ms
Sending data	0.29 ms
end	0.03 ms
query end	0.04 ms
closing tables	0.04 ms
freeing items	0.08 ms
updating status	0.05 ms
cleaning up	0.02 ms

Stack volání

#	Volající	Soubor a číslo řádku
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:367
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/components/com_phocagallery/models/category.php:75
12	PhocagalleryModelCategory->getTotal()	JROOT/components/com_phocagallery/models/category.php:83
11	PhocagalleryModelCategory->getPagination()	JROOT/components/com_phocagallery/views/category/view.html.php:960
10	PhocaGalleryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocagallery/controller.php:30
8	PhocaGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocagallery/phocagallery.php:58
6	require_once JROOT/components/com_phocagallery/phocagallery.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 4.01 ms Po posledním dotazu: 19.18 ms Dotaz paměti: 0.033 MB Paměť před dotazem: 4.178 MB Vráceno řádků: 40

SHOW FULL COLUMNS 
  FROM `j3_phocagallery_categories`

Vysvětlení

VYSVĚTLENÍ není možné pro dotaz: SHOW FULL COLUMNS FROM `j3_phocagallery_categories`

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.02 ms
closing tables	0.02 ms
Opening tables	0.45 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
After opening tables	0.09 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.08 ms
executing	0.06 ms
Filling schema table	0.03 ms
Opening tables	0.03 ms
After opening tables	0.05 ms
checking permissions	0.09 ms
checking permissions	0.08 ms
checking permissions	0.10 ms
checking permissions	0.06 ms
checking permissions	0.03 ms
checking permissions	0.06 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.08 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.05 ms
checking permissions	0.07 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.04 ms
checking permissions	0.09 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.08 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.06 ms
checking permissions	0.04 ms
checking permissions	0.06 ms
checking permissions	0.05 ms
checking permissions	0.03 ms
checking permissions	0.08 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.04 ms
checking permissions	0.06 ms
checking permissions	0.07 ms
checking permissions	0.05 ms
checking permissions	0.03 ms
checking permissions	0.08 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
closing tables	0.03 ms
executing	0.04 ms
Sending data	0.22 ms
end	0.02 ms
query end	0.03 ms
closing tables	0.02 ms
removing tmp table	0.14 ms
closing tables	0.07 ms
freeing items	0.03 ms
updating status	0.05 ms
cleaning up	0.03 ms

Stack volání

#	Volající	Soubor a číslo řádku
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
15	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
14	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_phocagallery/tables/phocagalleryc.php:17
13	TablePhocaGalleryc->__construct()	JROOT/libraries/src/Table/Table.php:328
12	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_phocagallery/models/category.php:560
11	PhocagalleryModelCategory->hit()	JROOT/components/com_phocagallery/views/category/view.html.php:2009
10	PhocaGalleryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocagallery/controller.php:30
8	PhocaGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocagallery/phocagallery.php:58
6	require_once JROOT/components/com_phocagallery/phocagallery.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.87 ms Po posledním dotazu: 1.49 ms Dotaz paměti: 0.006 MB Paměť před dotazem: 4.243 MB

UPDATE j3_phocagallery_categories

  SET `hits` = (`hits` + 1)

  WHERE `id` = '556'

Vysvětlení

VYSVĚTLENÍ není možné pro dotaz: UPDATE j3_phocagallery_categories SET `hits` = (`hits` + 1) WHERE `id` = '556'

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.03 ms
After opening tables	0.02 ms
init	0.08 ms
updating	0.16 ms
end	0.02 ms
Waiting for query cache lock	0.05 ms
end	0.03 ms
query end	1.07 ms
closing tables	0.04 ms
freeing items	0.03 ms
updating status	0.05 ms
cleaning up	0.03 ms

Stack volání

#	Volající	Soubor a číslo řádku
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
12	Joomla\CMS\Table\Table->hit()	JROOT/components/com_phocagallery/models/category.php:561
11	PhocagalleryModelCategory->hit()	JROOT/components/com_phocagallery/views/category/view.html.php:2009
10	PhocaGalleryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocagallery/controller.php:30
8	PhocaGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocagallery/phocagallery.php:58
6	require_once JROOT/components/com_phocagallery/phocagallery.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.52 ms Po posledním dotazu: 53.40 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 5.163 MB Vráceno řádků: 5

SELECT `name`,`element`

  FROM `j3_extensions`

  WHERE `type` = 'plugin' 
  AND `folder` = 'finder' 
  AND `enabled` = 1

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j3_extensions	ref	extension	extension	82	const	116	Using index condition; Using where

Profil

Status	Duration
starting	0.18 ms
checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.04 ms
Table lock	0.03 ms
After opening tables	0.03 ms
init	0.06 ms
optimizing	0.08 ms
statistics	0.17 ms
preparing	0.08 ms
executing	0.03 ms
Sending data	0.34 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.02 ms
updating status	0.05 ms
cleaning up	0.02 ms

Stack volání

#	Volající	Soubor a číslo řádku
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_finder/helpers/language.php:126
17	FinderHelperLanguage::loadPluginLanguage()	JROOT/modules/mod_finder/mod_finder.php:51
16	include JROOT/modules/mod_finder/mod_finder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/simple_v1/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/simple_v1/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/simple_v1/warp/systems/joomla/layouts/widgets.php	JROOT/templates/simple_v1/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/simple_v1/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/simple_v1/layouts/theme.php:72
9	include JROOT/templates/simple_v1/layouts/theme.php	JROOT/templates/simple_v1/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/simple_v1/index.php:16
7	require JROOT/templates/simple_v1/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
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:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.00 ms Po posledním dotazu: 8.34 ms Dotaz paměti: 0.027 MB Paměť před dotazem: 5.443 MB Vráceno řádků: 4

SELECT `title`

  FROM `j3_finder_taxonomy`

  WHERE `parent_id` = 1 
  AND `state` = 1 
  AND `access` IN (1,1,5)

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j3_finder_taxonomy	ref	parent_id,state,access,idx_parent_published	parent_id	4	const	4	Using where

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.04 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
After opening tables	0.02 ms
init	0.04 ms
optimizing	0.04 ms
statistics	0.18 ms
preparing	0.07 ms
executing	0.03 ms
Sending data	0.08 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.04 ms
freeing items	0.03 ms
updating status	0.06 ms
cleaning up	0.03 ms

Stack volání

#	Volající	Soubor a číslo řádku
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
21	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_finder/helpers/indexer/taxonomy.php:258
20	FinderIndexerTaxonomy::getBranchTitles()	JROOT/administrator/components/com_finder/helpers/indexer/query.php:750
19	FinderIndexerQuery->processString()	JROOT/administrator/components/com_finder/helpers/indexer/query.php:236
18	FinderIndexerQuery->__construct()	JROOT/modules/mod_finder/helper.php:84
17	ModFinderHelper::getQuery()	JROOT/modules/mod_finder/mod_finder.php:54
16	include JROOT/modules/mod_finder/mod_finder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/simple_v1/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/simple_v1/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/simple_v1/warp/systems/joomla/layouts/widgets.php	JROOT/templates/simple_v1/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/simple_v1/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/simple_v1/layouts/theme.php:72
9	include JROOT/templates/simple_v1/layouts/theme.php	JROOT/templates/simple_v1/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/simple_v1/index.php:16
7	require JROOT/templates/simple_v1/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
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:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.05 ms Po posledním dotazu: 11.97 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 5.656 MB Vráceno řádků: 3

Duplicitní dotazy: #5

SELECT a.filename as filename, a.type as type, a.menulink as menulink 
  FROM j3_phocagallery_styles AS a 
  WHERE a.published = 1 
  ORDER BY a.type, a.ordering ASC

Vysvětlení

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

Profil

Status	Duration
starting	0.13 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.03 ms
After opening tables	0.02 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.05 ms
preparing	0.05 ms
executing	0.03 ms
Sorting result	0.09 ms
Sending data	0.08 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.04 ms
freeing items	0.03 ms
updating status	0.05 ms
cleaning up	0.02 ms

Stack volání

#	Volající	Soubor a číslo řádku
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_phocagallery/libraries/phocagallery/render/renderfront.php:735
17	PhocaGalleryRenderFront::renderAllCSS()	JROOT/modules/mod_phocagallery_image/mod_phocagallery_image.php:46
16	include JROOT/modules/mod_phocagallery_image/mod_phocagallery_image.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/simple_v1/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/simple_v1/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/simple_v1/warp/systems/joomla/layouts/widgets.php	JROOT/templates/simple_v1/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/simple_v1/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/simple_v1/layouts/theme.php:125
9	include JROOT/templates/simple_v1/layouts/theme.php	JROOT/templates/simple_v1/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/simple_v1/index.php:16
7	require JROOT/templates/simple_v1/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
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:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.50 ms Po posledním dotazu: 2.41 ms Dotaz paměti: 0.025 MB Paměť před dotazem: 5.673 MB Vráceno řádků: 0

SELECT cc.title AS text, cc.id AS id, cc.parent_id as parentid, cc.alias as alias, cc.access as access, cc.accessuserid as accessuserid 
  FROM j3_phocagallery_categories AS cc 
  WHERE cc.published = 1 
  AND cc.access IN (1,1,5) 
  AND cc.id IN (202,203,204,205,206,207) 
  ORDER BY cc.ordering

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cc	range	PRIMARY,idx_access	PRIMARY	4	NULL	6	Using where; Použití filesort

Profil

Status	Duration
starting	0.14 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.02 ms
After opening tables	0.02 ms
init	0.07 ms
optimizing	0.04 ms
statistics	0.34 ms
preparing	0.05 ms
executing	0.02 ms
Sorting result	0.23 ms
Sending data	0.06 ms
end	0.02 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.03 ms
updating status	0.05 ms
cleaning up	0.02 ms

Stack volání

#	Volající	Soubor a číslo řádku
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_phocagallery_image/mod_phocagallery_image.php:622
16	include JROOT/modules/mod_phocagallery_image/mod_phocagallery_image.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/simple_v1/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/simple_v1/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/simple_v1/warp/systems/joomla/layouts/widgets.php	JROOT/templates/simple_v1/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/simple_v1/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/simple_v1/layouts/theme.php:125
9	include JROOT/templates/simple_v1/layouts/theme.php	JROOT/templates/simple_v1/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/simple_v1/index.php:16
7	require JROOT/templates/simple_v1/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
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:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

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

SELECT `alias`

  FROM `j3_content`

  WHERE id = '875'

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j3_content	const	PRIMARY	PRIMARY	4	const	1

Profil

Status	Duration
starting	0.10 ms
checking permissions	0.04 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.02 ms
After opening tables	0.03 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.05 ms
executing	0.02 ms
Sending data	0.03 ms
end	0.02 ms
query end	0.03 ms
closing tables	0.04 ms
freeing items	0.03 ms
updating status	0.06 ms
cleaning up	0.03 ms

Stack volání

#	Volající	Soubor a číslo řádku
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
17	ContentRouter->getArticleSegment()	Stejné jako volání na řádku níže.
16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.66 ms Po posledním dotazu: 1.58 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 5.648 MB Vráceno řádků: 2

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

  FROM `j3_categories` AS `s`

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

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

  ORDER BY c.lft

Vysvětlení

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

Profil

Status	Duration
starting	0.23 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.03 ms
After opening tables	0.03 ms
init	0.11 ms
optimizing	0.06 ms
statistics	0.26 ms
preparing	0.08 ms
executing	0.02 ms
Sorting result	0.03 ms
Sending data	0.20 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.04 ms
freeing items	0.03 ms
updating status	0.05 ms
cleaning up	0.02 ms

Stack volání

#	Volající	Soubor a číslo řádku
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
18	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
17	ContentRouter->getCategorySegment()	Stejné jako volání na řádku níže.
16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

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

SELECT alias

  FROM j3_content

  WHERE id=875

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j3_content	const	PRIMARY	PRIMARY	4	const	1

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
15	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
14	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:532
13	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
12	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

2 × SELECT a.filename as filename, a.type as type, a.menulink as menulink 
  FROM j3_phocagallery_styles AS a

1 × SELECT `data` 
  FROM `j3_session`

1 × SELECT a.id 
  FROM j3_phocagallery AS a 
  LEFT JOIN j3_phocagallery_categories AS cc 
  ON cc.id = a.catid

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 `j3_categories` AS `s` 
  INNER JOIN `j3_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 `alias` 
  FROM `j3_content`

1 × SELECT cc.title AS text, cc.id AS id, cc.parent_id as parentid, cc.alias as alias, cc.access as access, cc.accessuserid as accessuserid 
  FROM j3_phocagallery_categories AS cc

1 × SELECT `title` 
  FROM `j3_finder_taxonomy`

1 × SELECT `name`,`element` 
  FROM `j3_extensions`

1 × SELECT cc.id, cc.title, cc.alias, cc.published, cc.approved, cc.parent_id, cc.deleteuserid, cc.accessuserid, cc.uploaduserid, cc.access, cc.image_id, a.filename, a.extm, a.exts, a.extw, a.exth, a.extid 
  FROM j3_phocagallery_categories AS cc 
  LEFT JOIN j3_phocagallery AS a 
  ON cc.id = a.catid

1 × SELECT a.*, cc.alias AS catalias, cc.accessuserid AS cataccessuserid, cc.access AS cataccess, 
  CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug 
  FROM j3_phocagallery AS a 
  LEFT JOIN j3_phocagallery_img_votes_statistics AS r 
  ON r.imgid = a.id 
  LEFT JOIN j3_phocagallery_categories AS cc 
  ON cc.id = a.catid

1 × SELECT id, rules 
  FROM `j3_viewlevels

1 × SELECT cc.id, cc.title, cc.alias, cc.published, cc.approved, cc.parent_id, cc.deleteuserid, cc.accessuserid, cc.uploaduserid, cc.access 
  FROM j3_phocagallery_categories AS cc

1 × SELECT * 
  FROM j3_phocagallery_categories AS c

1 × SELECT c.id, c.title, c.alias, c.description, c.published, c.approved, c.parent_id, c.deleteuserid, c.accessuserid, c.uploaduserid, c.owner_id, c.access, c.metakey, c.metadesc, c.latitude, c.longitude, c.zoom, c.geotitle, c.userfolder, c.image_id, 
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug  
  FROM j3_phocagallery_categories AS c

1 × SELECT a.* 
  FROM j3_phocagallery_fb_users AS a

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

```
1 × SELECT alias 
  FROM j3_content
```

1 × UPDATE `j3_extensions` 
  SET `params` = '{\"mediaversion\":\"124f35eb148e94af8987ace4c8c1edb6\"}'

1 × SHOW FULL COLUMNS 
  FROM `j3_phocagallery_categories

1 × UPDATE j3_phocagallery_categories 
  SET `hits` = (`hits` + 1)

2

PRV 28.4. - 2.5.

5

Rozsah učiva do 11. 5.

7

PRV, AJ 5. -7.5.