Základní škola Rozvadov

Exif Informace:

Název souboru	20230220_210710.jpg
Datum a čas souboru	20/02/2023, 20:02
Velikost souboru	1.56 MB
MIME typ	image/jpeg
Udělej	samsung
Model	SM-J510FN
Orientace	0
Rozlišení X	72/1
Rozlišení Y	72/1
Jednotka rozlišení	Palce
Software	J510FNXXU2BRH2
Datum a čas	2023:02:20 21:07:10
Exif IFD Pointer	239
GPS IFD Pointer	870
ExposureTime	1/17 sec
FNumber	190/100
ExposureProgram	Normální program
ISOSpeedRatings	160
ExifVersion	2.2
DateTimeOriginal	2023:02:20 12:33:19
DateTimeDigitized	2023:02:20 12:33:19
ShutterSpeedValue	405/100
ApertureValue	185/100
ExposureBiasValue	0/10
MaxApertureValue	185/100
MeteringMode	Průměrná šířka
LightSource	Neznámý
Flash	0
FocalLength	3.7 mm
ColorSpace	sRGB
ExifImageWidth	1600 px
ExifImageLength	1232 px
SensingMethod	Jednočipový senzor
ExposureMode	Auto. expozice
WhiteBalance	Auto. vyvážení bílé
FocalLengthIn35mmFilm	28
SceneCaptureType	Standardní
GPS čas	11 h 33 m 19 s
GPS datum	2023:02:20

Čeká nás

Archív

		Duben 2025

Po	Út	St	Čt	Pá	So	Ne
31	1 Rozsah učiva do 6. 4. 2025 Rozsah učiva do 6. 4. 2025 Rozsah učiva do 6. 3. 2025 BESIP - dopravní výchova	2	3	4	5 My free time - lekce 9 Animal safari - lekce 10	6
7	8 Rozsah učiva do 13. 4. 2025 Rozsah učiva do 13. 4. 2025 Ředitelské volno	9 Rozsah učiva do 13. 4. 2025 Rozsah učiva do 13. 4.	10	11	12	13
14	15 Rozsah učiva do 20. 4. 2025	16 Rozsah učiva do 21. 4. 2025 Rozsah učiva do 21. 4. 2025 Projekt "Velikonoce"	17	18	19	20
21	22	23	24 Rozsah učiva do 27. 4. 2025 Rozsah učiva do 27. 4. 2025	25 slovní druhy - kódy	26	27
28 Rozsah učiva do 4. 5. 2025 Rozsah učiva do 4. 5. 2025	29 Review C My favourite things - lekce 11 Rozsah učiva do 30. 4. 2025	30	1	2	3	4

Přihlášení

Konzole ladění chyb Joomla!

Sezení

{
    "__default": {
        "session": {
            "counter": 2,
            "timer": {
                "start": 1746001316,
                "last": 1746001316,
                "now": 1746001316
            },
            "token": "Jrc8ReyMenjrecEFKQhtvAgnbnrykfU4"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Informace o profilu

Využití paměti

Dotazy do databáze

13 zaznamenaných dotazů 27.29 ms

Nalezeno 2 duplikátů!

2 duplikátů: #5 #9

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

SELECT `data`

  FROM `j3_session`

  WHERE `session_id` = X'3430356161393135323637396564656339333630353133313963346162653331'

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.07 ms
checking permissions	0.05 ms
Opening tables	0.17 ms
After opening tables	0.05 ms
System lock	0.03 ms
Table lock	0.06 ms
After opening tables	0.03 ms
init	0.04 ms
optimizing	0.06 ms
statistics	0.13 ms
preparing	0.06 ms
executing	0.03 ms
Sending data	0.04 ms
end	0.04 ms
query end	0.06 ms
closing tables	0.03 ms
freeing items	0.03 ms
updating status	0.09 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: 2.90 ms Po posledním dotazu: 4.60 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.07 ms
checking permissions	0.03 ms
Opening tables	0.07 ms
After opening tables	0.04 ms
System lock	0.04 ms
Table lock	0.04 ms
After opening tables	0.03 ms
init	0.06 ms
optimizing	0.03 ms
statistics	0.03 ms
preparing	0.05 ms
executing	0.05 ms
Sending data	0.07 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.06 ms
updating status	0.05 ms
cleaning up	0.05 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: 1.86 ms Po posledním dotazu: 0.06 ms Dotaz paměti: 0.021 MB Paměť před dotazem: 1.162 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.12 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
Opening tables	0.05 ms
After opening tables	0.04 ms
System lock	0.03 ms
Table lock	0.06 ms
After opening tables	0.09 ms
init	0.06 ms
optimizing	0.04 ms
statistics	0.15 ms
preparing	0.10 ms
executing	0.03 ms
Sending data	0.07 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.04 ms
freeing items	0.12 ms
updating status	0.06 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.61 ms Po posledním dotazu: 25.37 ms Dotaz paměti: 0.006 MB Paměť před dotazem: 1.961 MB

UPDATE `j3_extensions`

  SET `params` = '{\"mediaversion\":\"88c638218c67cb87fb3a996e4c8771d5\"}'

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

Vysvětlení

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

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.03 ms
init	0.26 ms
updating	0.22 ms
end	0.03 ms
query end	1.21 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
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.00 ms Po posledním dotazu: 14.91 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 2.566 MB Vráceno řádků: 3

Duplicitní dotazy: #9

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.08 ms
checking permissions	0.03 ms
Opening tables	0.03 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.04 ms
optimizing	0.03 ms
statistics	0.04 ms
preparing	0.04 ms
executing	0.02 ms
Sorting result	0.09 ms
Sending data	0.06 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.04 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/info/view.html.php:76
10	PhocaGalleryViewInfo->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.85 ms Po posledním dotazu: 5.26 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 2.583 MB Vráceno řádků: 1

SELECT a.title, a.filename, a.description, a.exto, a.extid, a.metakey, a.metadesc, 
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, 
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug 
  FROM j3_phocagallery AS a 
  LEFT JOIN j3_phocagallery_categories AS c 
  ON c.id = a.catid 
  WHERE a.id = 15251 
  LIMIT 0, 1

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	c	const	PRIMARY	PRIMARY	4	const	1

Profil

Status	Duration
starting	0.15 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
After opening tables	0.04 ms
init	0.46 ms
optimizing	0.04 ms
statistics	0.10 ms
preparing	0.06 ms
executing	0.05 ms
Sending data	0.06 ms
end	0.04 ms
query end	0.03 ms
closing tables	0.04 ms
freeing items	0.03 ms
updating status	0.05 ms
cleaning up	0.04 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/info.php:54
12	PhocaGalleryModelInfo->_loadData()	JROOT/components/com_phocagallery/models/info.php:35
11	PhocaGalleryModelInfo->getData()	JROOT/components/com_phocagallery/views/info/view.html.php:130
10	PhocaGalleryViewInfo->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.82 ms Po posledním dotazu: 38.54 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 2.921 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.08 ms
checking permissions	0.05 ms
Opening tables	0.04 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.04 ms
optimizing	0.05 ms
statistics	0.10 ms
preparing	0.06 ms
executing	0.02 ms
Sending data	0.20 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.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: 2.95 ms Po posledním dotazu: 4.29 ms Dotaz paměti: 0.027 MB Paměť před dotazem: 2.953 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.08 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.02 ms
After opening tables	0.03 ms
init	0.04 ms
optimizing	0.04 ms
statistics	0.14 ms
preparing	0.06 ms
executing	0.03 ms
Sending data	0.07 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
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: 3.12 ms Po posledním dotazu: 11.00 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 3.033 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.14 ms
checking permissions	0.04 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.05 ms
optimizing	0.04 ms
statistics	0.05 ms
preparing	0.08 ms
executing	0.03 ms
Sorting result	0.11 ms
Sending data	0.09 ms
end	0.08 ms
query end	0.03 ms
closing tables	0.45 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: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: 14.07 ms Dotaz paměti: 0.025 MB Paměť před dotazem: 3.060 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.10 ms
checking permissions	0.03 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.04 ms
init	0.07 ms
optimizing	0.05 ms
statistics	0.34 ms
preparing	0.07 ms
executing	0.04 ms
Sorting result	0.12 ms
Sending data	0.05 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 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
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: 1.93 ms Po posledním dotazu: 20.05 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 3.127 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.09 ms
checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.02 ms
After opening tables	0.02 ms
init	1.07 ms
optimizing	0.04 ms
statistics	0.08 ms
preparing	0.05 ms
executing	0.02 ms
Sending data	0.04 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.02 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: 3.13 ms Po posledním dotazu: 1.30 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 3.142 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.30 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
Opening tables	0.06 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.14 ms
optimizing	0.06 ms
statistics	0.37 ms
preparing	0.12 ms
executing	0.03 ms
Sorting result	0.04 ms
Sending data	0.23 ms
end	0.04 ms
query end	0.03 ms
closing tables	0.04 ms
freeing items	0.05 ms
updating status	0.07 ms
cleaning up	0.06 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: 1.36 ms Po posledním dotazu: 0.66 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 3.161 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.05 ms
checking permissions	0.03 ms
Opening tables	0.03 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.05 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.02 ms
updating status	0.05 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.]

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

VYBRANÉ tabulky:

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 id, rules 
  FROM `j3_viewlevels

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 a.title, a.filename, a.description, a.exto, a.extid, a.metakey, a.metadesc, 
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, 
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug 
  FROM j3_phocagallery AS a 
  LEFT JOIN j3_phocagallery_categories AS c 
  ON c.id = a.catid

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

1 × SELECT `title` 
  FROM `j3_finder_taxonomy`

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 `alias` 
  FROM `j3_content`

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
```

OSTATNÍ tabulky:

1 × UPDATE `j3_extensions` 
  SET `params` = '{\"mediaversion\":\"88c638218c67cb87fb3a996e4c8771d5\"}'