Szabályzatok

Joomla! hibakereső konzol

Munkamenet

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1675867464,
                "last": 1675867464,
                "now": 1675867464
            },
            "client": {
                "forwarded": "3.236.80.119"
            },
            "token": "Txuj6sVixruazh4aEn2nmmUCaHLd0rtn"
        },
        "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
        }
    }
}

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

#	Hívó	Fájl és sorok száma
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

Az EXPLAIN nem lehetséges a következő lekérdezésen: INSERT INTO `ast_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'7368707162766238326f686b366662696f643536326d6c623937', 1, 1675867464, 0, '', 0)

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.25 ms Utolsó lekérdezés után: 7.35 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 1.138 MB Visszaadott sorok: 5

SELECT id, rules

  FROM `ast_viewlevels`

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ast_viewlevels	NULL	ALL	NULL	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	5	100.00	NULL

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.34 ms Utolsó lekérdezés után: 0.07 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 1.150 MB Visszaadott sorok: 2

SELECT b.id

  FROM ast_usergroups AS a

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

  WHERE a.id = 9

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 7.11 ms Utolsó lekérdezés után: 34.62 ms Memória lekérdezése: 0.006 MB memória a lekérdezés előtt: 1.724 MB

UPDATE `ast_extensions`

  SET `params` = '{\"mediaversion\":\"b695e666c05f9247a9f2441e65f2da82\"}'

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

Magyarázat

Az EXPLAIN nem lehetséges a következő lekérdezésen: UPDATE `ast_extensions` SET `params` = '{\"mediaversion\":\"b695e666c05f9247a9f2441e65f2da82\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
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/bt_socialconnect_system/bt_socialconnect_system.php:228
8	plgSystemBt_socialconnect_system->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 10.02 ms Utolsó lekérdezés után: 115.94 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 4.856 MB Visszaadott sorok: 1

SELECT cc.id, cc.title, cc.alias, cc.access as cataccess, cc.accessuserid as cataccessuserid, cc.description, cc.metakey, cc.metadesc, pc.title as parenttitle, cc.parent_id as parentid, pc.alias as parentalias 
  FROM ast_phocadownload_categories AS cc 
  LEFT JOIN ast_phocadownload_categories AS pc 
  ON pc.id = cc.parent_id 
  WHERE  cc.id= 1 
  AND  cc.access IN (1,1,5) 
  AND  cc.published = 1 
  ORDER BY cc.ordering 
  LIMIT 0, 1

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cc	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	pc	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_phocadownload/models/category.php:86
11	PhocaDownloadModelCategory->getCategory()	JROOT/components/com_phocadownload/views/category/view.html.php:34
10	PhocaDownloadViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocadownload/controller.php:34
8	PhocaDownloadController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocadownload/phocadownload.php:53
6	require_once JROOT/components/com_phocadownload/phocadownload.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 16.44 ms Utolsó lekérdezés után: 0.91 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 4.878 MB Visszaadott sorok: 0

SELECT  cc.id, cc.title, cc.alias, cc.access as cataccess, cc.accessuserid as cataccessuserid, COUNT(c.id) AS numdoc 
  FROM ast_phocadownload_categories AS cc 
  LEFT JOIN ast_phocadownload AS c 
  ON c.catid = cc.id 
  AND c.published = 1 
  AND c.textonly = 0 
  WHERE  cc.parent_id = 1 
  AND  cc.access IN (1,1,5) 
  AND  cc.published = 1 
  GROUP BY cc.id 
  ORDER BY cc.ordering ASC

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cc	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout	PRIMARY	4	NULL	1	100.00	Using where; Using temporary; Fájlrendezés használata
1	SIMPLE	c	NULL	ref	catid	catid	5	portal_krehu_site.cc.id,const	26	100.00	Using where

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_phocadownload/models/category.php:94
11	PhocaDownloadModelCategory->getSubcategories()	JROOT/components/com_phocadownload/views/category/view.html.php:35
10	PhocaDownloadViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocadownload/controller.php:34
8	PhocaDownloadController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocadownload/phocadownload.php:53
6	require_once JROOT/components/com_phocadownload/phocadownload.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 6.37 ms Utolsó lekérdezés után: 0.09 ms Memória lekérdezése: 0.101 MB memória a lekérdezés előtt: 4.887 MB Visszaadott sorok: 48

SELECT c.*, cc.id AS categoryid, cc.title AS categorytitle, cc.alias AS categoryalias, cc.access as cataccess, cc.accessuserid as cataccessuserid  
  FROM ast_phocadownload AS c 
  LEFT JOIN ast_phocadownload_categories AS cc 
  ON cc.id = c.catid 
  LEFT JOIN ast_phocadownload_file_votes_statistics AS r 
  ON r.fileid = c.id 
  WHERE  c.catid= 1 
  AND ( (unaccessible_file = 1 ) OR (unaccessible_file = 0 
  AND c.access IN (1,1,5) ) ) 
  AND ( (unaccessible_file = 1 ) OR (unaccessible_file = 0 
  AND cc.access IN (1,1,5) ) ) 
  AND  c.published = 1 
  AND  c.approved = 1 
  AND  cc.published = 1 
  AND  ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2023-02-08 14:44:24' ) 
  AND  ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2023-02-08 14:44:24' ) 
  ORDER BY c.ordering ASC 
  LIMIT 0, 150

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cc	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Using temporary; Fájlrendezés használata
1	SIMPLE	c	NULL	ALL	catid	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	53	1.89	Using where
1	SIMPLE	r	NULL	ALL	NULL	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	1	100.00	Using where; Using join buffer (hash join)

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_phocadownload/models/category.php:78
11	PhocaDownloadModelCategory->getFileList()	JROOT/components/com_phocadownload/views/category/view.html.php:36
10	PhocaDownloadViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocadownload/controller.php:34
8	PhocaDownloadController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocadownload/phocadownload.php:53
6	require_once JROOT/components/com_phocadownload/phocadownload.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.37 ms Utolsó lekérdezés után: 2.19 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 5.133 MB Visszaadott sorok: 48

SELECT c.id 
  FROM ast_phocadownload AS c 
  LEFT JOIN ast_phocadownload_categories AS cc 
  ON cc.id = c.catid 
  WHERE  c.catid= 1 
  AND ( (unaccessible_file = 1 ) OR (unaccessible_file = 0 
  AND c.access IN (1,1,5) ) ) 
  AND ( (unaccessible_file = 1 ) OR (unaccessible_file = 0 
  AND cc.access IN (1,1,5) ) ) 
  AND  c.published = 1 
  AND  c.approved = 1 
  AND  cc.published = 1 
  AND  ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2023-02-08 14:44:24' ) 
  AND  ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2023-02-08 14:44:24' ) 
  ORDER BY c.id

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cc	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	index	catid	PRIMARY	4	NULL	53	1.89	Using where

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:353
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/components/com_phocadownload/models/category.php:70
12	PhocaDownloadModelCategory->getTotal()	JROOT/components/com_phocadownload/models/category.php:62
11	PhocaDownloadModelCategory->getPagination()	JROOT/components/com_phocadownload/views/category/view.html.php:37
10	PhocaDownloadViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocadownload/controller.php:34
8	PhocaDownloadController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocadownload/phocadownload.php:53
6	require_once JROOT/components/com_phocadownload/phocadownload.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 6.87 ms Utolsó lekérdezés után: 1.05 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 5.162 MB Visszaadott sorok: 3

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

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	NULL	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	6	16.67	Using where; Fájlrendezés használata

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_phocadownload/libraries/phocadownload/render/renderfront.php:22
11	PhocaDownloadRenderFront::renderAllCSS()	JROOT/components/com_phocadownload/views/category/view.html.php:39
10	PhocaDownloadViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocadownload/controller.php:34
8	PhocaDownloadController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocadownload/phocadownload.php:53
6	require_once JROOT/components/com_phocadownload/phocadownload.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 1.05 ms Utolsó lekérdezés után: 95.19 ms Memória lekérdezése: 0.049 MB memória a lekérdezés előtt: 5.715 MB Visszaadott sorok: 29

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

  FROM ast_modules AS m

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

  LEFT JOIN ast_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-02-08 14:44:24') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-02-08 14:44:24') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 241 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds	published	5	NULL	29	1.60	Using index condition; Using where; Fájlrendezés használata
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	portal_krehu_site.m.id	1	40.00	Using where; Using index
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	portal_krehu_site.m.module,const	1	10.00	Using index condition; Using where

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:423
15	JModuleHelper::_load()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:102
14	JModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:604
13	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/t3/includes/core/template.php:608
12	T3Template->countModules()	JROOT/templates/bt_education/tpls/blocks/header.php:65
11	include JROOT/templates/bt_education/tpls/blocks/header.php	JROOT/plugins/system/t3/includes/core/template.php:176
10	T3Template->loadBlock()	JROOT/templates/bt_education/tpls/default.php:29
9	include JROOT/templates/bt_education/tpls/default.php	JROOT/plugins/system/t3/includes/core/template.php:200
8	T3Template->loadLayout()	JROOT/templates/bt_education/index.php:34
7	require JROOT/templates/bt_education/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.31 ms Utolsó lekérdezés után: 346.67 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 7.996 MB Visszaadott sorok: 0

SELECT social_id 
  FROM ast_bt_connections 
  WHERE social_type ="facebook" 
  AND  user_id ="0"

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ast_bt_connections	NULL	ALL	NULL	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	1	100.00	Using where

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/bt_socialconnect_system/bt_socialconnect_system.php:488
8	plgSystemBt_socialconnect_system::getSocialID()	JROOT/plugins/system/bt_socialconnect_system/bt_socialconnect_system.php:148
7	plgSystemBt_socialconnect_system->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:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

12 naplózott lekérdezéstípus, rendezés előfordulás szerint

SELECT táblák:

1 × SELECT `session_id` 
  FROM `ast_session`

1 × SELECT id, rules 
  FROM `ast_viewlevels

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

1 × SELECT cc.id, cc.title, cc.alias, cc.access as cataccess, cc.accessuserid as cataccessuserid, cc.description, cc.metakey, cc.metadesc, pc.title as parenttitle, cc.parent_id as parentid, pc.alias as parentalias 
  FROM ast_phocadownload_categories AS cc 
  LEFT JOIN ast_phocadownload_categories AS pc 
  ON pc.id = cc.parent_id

1 × SELECT  cc.id, cc.title, cc.alias, cc.access as cataccess, cc.accessuserid as cataccessuserid, COUNT(c.id) AS numdoc 
  FROM ast_phocadownload_categories AS cc 
  LEFT JOIN ast_phocadownload AS c 
  ON c.catid = cc.id 
  AND c.published = 1 
  AND c.textonly = 0

1 × SELECT c.*, cc.id AS categoryid, cc.title AS categorytitle, cc.alias AS categoryalias, cc.access as cataccess, cc.accessuserid as cataccessuserid  
  FROM ast_phocadownload AS c 
  LEFT JOIN ast_phocadownload_categories AS cc 
  ON cc.id = c.catid 
  LEFT JOIN ast_phocadownload_file_votes_statistics AS r 
  ON r.fileid = c.id

1 × SELECT c.id 
  FROM ast_phocadownload AS c 
  LEFT JOIN ast_phocadownload_categories AS cc 
  ON cc.id = c.catid

1 × SELECT a.filename as filename, a.type as type, a.menulink as menulink 
  FROM ast_phocadownload_styles AS a

1 × SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM ast_modules AS m 
  LEFT JOIN ast_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN ast_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT social_id 
  FROM ast_bt_connections

EGYÉB táblák:

1 × INSERT INTO `ast_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'7368707162766238326f686b366662696f643536326d6c623937', 1, 1675867464, 0, '', 0

1 × UPDATE `ast_extensions` 
  SET `params` = '{\"mediaversion\":\"b695e666c05f9247a9f2441e65f2da82\"}'

Szabályzatok

Szabályzatok

Következő események

Galéria

Tudomány, kutatás

Névjegy

Napi biztatás

Blog

Sport a Károlin

Szakirányú továbbképzések

Youtube

Archívum

Károli magazin

Joomla! hibakereső konzol

Munkamenet

Profilinformációk

Idő

Memória

Memóriahasználat

Adatbázis lekérdezések

12 naplózott lekérdezés 63.24 ms

12 naplózott lekérdezéstípus, rendezés előfordulás szerint

SELECT táblák:

EGYÉB táblák: