Lekérdezés ideje: 0.36 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 1.028 MB Visszaadott sorok: 0
SELECT `session_id`
FROM `ast_session`
WHERE `session_id` = X'7368707162766238326f686b366662696f643536326d6c623937'
LIMIT 1
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 |
Status | Duration |
---|
starting | 0.06 ms |
Executing hook on transaction | 0.00 ms |
starting | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.04 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.11 ms |
executing | 0.02 ms |
end | 0.01 ms |
query end | 0.00 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | 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 |
Lekérdezés ideje: 13.75 ms Utolsó lekérdezés után: 0.06 ms Memória lekérdezése: 0.004 MB memória a lekérdezés előtt: 1.034 MB
INSERT INTO `ast_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'7368707162766238326f686b366662696f643536326d6c623937', 1, 1675867464, 0, '', 0)
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)
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ó | 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 |
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`
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 |
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ó | 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 |
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
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 |
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ó | 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 |
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'
Az EXPLAIN nem lehetséges a következő lekérdezésen: UPDATE `ast_extensions`
SET `params` = '{\"mediaversion\":\"b695e666c05f9247a9f2441e65f2da82\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
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ó | 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 |
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
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 |
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ó | 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 |
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
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 |
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ó | 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 |
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
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) |
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ó | 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 |
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
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 |
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ó | 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 |
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
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 |
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ó | 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 |
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
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 |
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ó | 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 |
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"
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 |
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ó | 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 |
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