Kapcsolat
Munkatársaink
Copyright © 2024: Kell Alapítvány
Joomla! hibakereső konzol
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1713419177,
"last": 1713419177,
"now": 1713419177
},
"token": "iRnuM9WHW9sDNBEDHuAv3s9Mvg6PPCAd"
},
"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ő
Memória
Idő: 10.76 ms / 10.76 ms Memória: 0.584 MB / 0.92 MB Application: afterLoad
Idő: 54.35 ms / 65.11 ms Memória: 1.097 MB / 2.01 MB Application: afterInitialise
Idő: 16.67 ms / 81.78 ms Memória: 0.207 MB / 2.22 MB Application: afterRoute
Idő: 9.27 ms / 91.05 ms Memória: 0.093 MB / 2.31 MB Application: beforeRenderComponent com_contact
Idő: 11.58 ms / 102.63 ms Memória: 0.159 MB / 2.47 MB Application: Before Access::preloadComponents (all components)
Idő: 3.04 ms / 105.67 ms Memória: 0.061 MB / 2.53 MB Application: After Access::preloadComponents (all components)
Idő: 0.07 ms / 105.75 ms Memória: -0.002 MB / 2.53 MB Application: Before Access::getAssetRules (id:7 name:com_contact)
Idő: 0.76 ms / 106.50 ms Memória: 0.009 MB / 2.54 MB Application: After Access::getAssetRules (id:7 name:com_contact)
Idő: 68.90 ms / 175.40 ms Memória: 0.486 MB / 3.02 MB Application: afterRenderComponent com_contact
Idő: 3.11 ms / 178.51 ms Memória: 0.069 MB / 3.09 MB Application: afterDispatch
Idő: 7.00 ms / 185.51 ms Memória: 0.100 MB / 3.19 MB Application: beforeRenderModule mod_as_menu (Top Menu)
Idő: 6.47 ms / 191.98 ms Memória: 0.047 MB / 3.24 MB Application: afterRenderModule mod_as_menu (Top Menu)
Idő: 8.70 ms / 200.69 ms Memória: 0.409 MB / 3.65 MB Application: afterRender
Adatbázislekérdezés összesen: 32.99 ms
4,11 MB (4.312.936 Bájtok)
27 naplózott lekérdezés 32.99 ms
- Lekérdezés ideje: 0.77 ms Memória lekérdezése: 0.027 MB memória a lekérdezés előtt: 1.245 MB Visszaadott sorok: 0
SELECT `data`
FROM `m4qou_session`
WHERE `session_id` = X'6d6833746c39337263386e317135746970343766753934746d35'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m4qou_session const PRIMARY PRIMARY 194 const 1 Status Duration Starting 0.11 ms checking permissions 0.02 ms Opening tables 0.09 ms After opening tables 0.01 ms System lock 0.02 ms table lock 0.01 ms init 0.05 ms Optimizing 0.02 ms Statistics 0.11 ms Preparing 0.02 ms Executing 0.03 ms End of update loop 0.01 ms Query end 0.02 ms Commit 0.01 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Hívó Fájl és sorok száma 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Ugyanaz a hívás, mint egy sorral lejjebb. 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 - Lekérdezés ideje: 0.54 ms Utolsó lekérdezés után: 1.82 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 1.263 MB Visszaadott sorok: 0
SELECT `session_id`
FROM `m4qou_session`
WHERE `session_id` = X'6d6833746c39337263386e317135746970343766753934746d35'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m4qou_session const PRIMARY PRIMARY 194 const 1 Using index Status Duration Starting 0.08 ms checking permissions 0.01 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.02 ms table lock 0.01 ms init 0.04 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.01 ms Executing 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.03 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 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:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 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 - Lekérdezés ideje: 1.09 ms Utolsó lekérdezés után: 0.13 ms Memória lekérdezése: 0.005 MB memória a lekérdezés előtt: 1.270 MB
INSERT INTO `m4qou_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6d6833746c39337263386e317135746970343766753934746d35', 1, 1713419177, 0, '', 0)Az EXPLAIN nem lehetséges a következő lekérdezésen: INSERT INTO `m4qou_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6d6833746c39337263386e317135746970343766753934746d35', 1, 1713419177, 0, '', 0)Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.02 ms Update 0.12 ms Waiting for query cache lock 0.01 ms Update 0.14 ms End of update loop 0.01 ms Query end 0.02 ms Commit 0.56 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 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:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 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 - Lekérdezés ideje: 0.95 ms Utolsó lekérdezés után: 1.55 ms Memória lekérdezése: 0.042 MB memória a lekérdezés előtt: 1.369 MB Visszaadott sorok: 38
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `m4qou_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m4qou_extensions ref extension extension 82 const 38 Using index condition; Using where Status Duration Starting 0.11 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.09 ms Preparing 0.06 ms Executing 0.01 ms Sending data 0.26 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.02 ms Unlocking tables 0.00 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.05 ms Reset for next command 0.01 ms # Hívó Fájl és sorok száma 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Ugyanaz a hívás, mint egy sorral lejjebb. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Lekérdezés ideje: 0.44 ms Utolsó lekérdezés után: 1.33 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 1.421 MB Visszaadott sorok: 4
SELECT id, rules
FROM `m4qou_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m4qou_viewlevels ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 4 Status Duration Starting 0.06 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.02 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 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: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 - Lekérdezés ideje: 0.41 ms Utolsó lekérdezés után: 0.10 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 1.435 MB Visszaadott sorok: 2
SELECT b.id
FROM m4qou_usergroups AS a
LEFT JOIN m4qou_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 Using where; Using index Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.08 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 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: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 - Lekérdezés ideje: 1.00 ms Utolsó lekérdezés után: 0.19 ms Memória lekérdezése: 0.038 MB memória a lekérdezés előtt: 1.459 MB Visszaadott sorok: 96
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM m4qou_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m4qou_extensions ALL extension NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 231 Using where; Fájlrendezés használata Status Duration Starting 0.09 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.03 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.49 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.01 ms # Hívó Fájl és sorok száma 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:351 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Ugyanaz a hívás, mint egy sorral lejjebb. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:356 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 - Lekérdezés ideje: 1.04 ms Utolsó lekérdezés után: 36.30 ms Memória lekérdezése: 0.037 MB memória a lekérdezés előtt: 2.042 MB Visszaadott sorok: 9
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM m4qou_menu AS m
LEFT JOIN m4qou_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 21 Using index condition; Using where; Fájlrendezés használata 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 c7kellalapitvany.m.component_id 1 Using where Status Duration Starting 0.11 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.08 ms Preparing 0.04 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.24 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.01 ms # Hívó Fájl és sorok száma 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Ugyanaz a hívás, mint egy sorral lejjebb. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:78 13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:142 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:417 10 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 9 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 8 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 7 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:533 6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1141 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 - Lekérdezés ideje: 0.86 ms Utolsó lekérdezés után: 11.78 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 2.239 MB Visszaadott sorok: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `m4qou_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m4qou_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition Status Duration Starting 0.12 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.13 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.07 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Hívó Fájl és sorok száma 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 13 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Ugyanaz a hívás, mint egy sorral lejjebb. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 10 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 9 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 8 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1137 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Lekérdezés ideje: 1.24 ms Utolsó lekérdezés után: 0.57 ms Memória lekérdezése: 0.007 MB memória a lekérdezés előtt: 2.233 MB
UPDATE `m4qou_extensions`
SET `params` = '{\"mediaversion\":\"55f28a8e37dd0b703a463e43e06f0aa5\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'Az EXPLAIN nem lehetséges a következő lekérdezésen: UPDATE `m4qou_extensions` SET `params` = '{\"mediaversion\":\"55f28a8e37dd0b703a463e43e06f0aa5\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.09 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.13 ms Updating 0.11 ms End of update loop 0.01 ms Waiting for query cache lock 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.62 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Hívó Fájl és sorok száma 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1137 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Lekérdezés ideje: 0.64 ms Utolsó lekérdezés után: 2.26 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 2.272 MB Visszaadott sorok: 1
SELECT *
FROM m4qou_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m4qou_languages ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 1 Using where; Fájlrendezés használata Status Duration Starting 0.06 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.04 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.09 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Hívó Fájl és sorok száma 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 4 Joomla\CMS\Application\SiteApplication->getParams() JROOT/libraries/src/Application/SiteApplication.php:138 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Lekérdezés ideje: 0.64 ms Utolsó lekérdezés után: 0.75 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 2.292 MB Visszaadott sorok: 3
SELECT id, home, template, s.params
FROM m4qou_template_styles as s
LEFT JOIN m4qou_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ref idx_template,idx_client_id,idx_client_id_home idx_client_id 1 const 3 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 c7kellalapitvany.s.template,const 1 Using index condition; Using where Status Duration Starting 0.08 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.03 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.11 ms Preparing 0.05 ms Executing 0.01 ms Sending data 0.06 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Hívó Fájl és sorok száma 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 5 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 4 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/Application/SiteApplication.php:168 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 - Lekérdezés ideje: 2.61 ms Utolsó lekérdezés után: 13.66 ms Memória lekérdezése: 0.036 MB memória a lekérdezés előtt: 2.475 MB Visszaadott sorok: 38
SELECT `id`,`name`,`rules`,`parent_id`
FROM `m4qou_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocagallery','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m4qou_assets ALL idx_asset_name NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 168 Using where Status Duration Starting 0.14 ms checking permissions 0.01 ms Opening tables 0.07 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.05 ms Optimizing 0.02 ms Statistics 0.13 ms Preparing 0.03 ms Executing 0.01 ms Sending data 1.84 ms End of update loop 0.02 ms Query end 0.00 ms Commit 0.02 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Hívó Fájl és sorok száma 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 18 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 17 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 16 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 15 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 14 Joomla\CMS\User\User->authorise() JROOT/components/com_contact/models/category.php:296 13 ContactModelCategory->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 12 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/libraries/src/MVC/View/CategoryView.php:116 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_contact/views/category/view.html.php:54 10 ContactViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.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 - Lekérdezés ideje: 4.98 ms Utolsó lekérdezés után: 3.83 ms Memória lekérdezése: 0.041 MB memória a lekérdezés előtt: 2.534 MB Visszaadott sorok: 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,( SELECT COUNT(i.`id`)
FROM `m4qou_contact_details` AS `i`
WHERE i.`catid` = c.id
AND i.published = 1) AS numitems
FROM `m4qou_categories` AS `s`
INNER JOIN `m4qou_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_contact' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 41
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 PRIMARY c range cat_idx,idx_access,idx_left_right cat_idx 207 NULL 5 Using index condition; Using where; Fájlrendezés használata 2 DEPENDENT SUBQUERY i ALL idx_state,idx_catid NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 3 Using where Status Duration Starting 0.23 ms checking permissions 0.02 ms Opening tables 0.30 ms After opening tables 0.03 ms System lock 0.01 ms table lock 0.01 ms init 0.11 ms Optimizing 0.04 ms Statistics 1.73 ms Preparing 0.02 ms Unlocking tables 0.01 ms Preparing 0.05 ms Optimizing 0.03 ms Statistics 1.13 ms Preparing 0.05 ms Sorting result 0.02 ms Executing 0.00 ms Sending data 0.03 ms Creating sort index 0.23 ms Executing 0.01 ms Sending data 0.54 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Removing tmp table 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.02 ms # Hívó Fájl és sorok száma 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 15 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 14 Joomla\CMS\Categories\Categories->get() JROOT/components/com_contact/models/category.php:335 13 ContactModelCategory->getCategory() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:122 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_contact/views/category/view.html.php:54 10 ContactViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.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 - Lekérdezés ideje: 2.55 ms Utolsó lekérdezés után: 1.58 ms Memória lekérdezése: 0.044 MB memória a lekérdezés előtt: 2.614 MB Visszaadott sorok: 3
SELECT a.*,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email
FROM `m4qou_contact_details` AS a
LEFT JOIN m4qou_categories AS c
ON c.id = a.catid
LEFT JOIN m4qou_users AS ua
ON ua.id = a.created_by
LEFT JOIN m4qou_users AS uam
ON uam.id = a.modified_by
WHERE a.access IN (1,1,5)
AND a.catid = 41
AND c.access IN (1,1,5)
AND a.published = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-18 05:46:17')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-18 05:46:17')
ORDER BY ordering ASC
LIMIT 20id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY,idx_access PRIMARY 4 const 1 1 SIMPLE a ALL idx_access,idx_state,idx_catid NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 3 Using where; Fájlrendezés használata 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 c7kellalapitvany.a.created_by 1 Using where Status Duration Starting 0.15 ms checking permissions 0.01 ms Opening tables 0.08 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.08 ms Optimizing 0.05 ms Statistics 1.55 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.04 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.03 ms Creating sort index 0.11 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.04 ms Reset for next command 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/libraries/src/MVC/Model/BaseDatabaseModel.php:322 15 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 14 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_contact/models/category.php:91 13 ContactModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_contact/views/category/view.html.php:54 10 ContactViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.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 - Lekérdezés ideje: 1.18 ms Utolsó lekérdezés után: 1.59 ms Memória lekérdezése: 0.038 MB memória a lekérdezés előtt: 2.668 MB Visszaadott sorok: 0
SELECT `m`.`tag_id`,`t`.*
FROM `m4qou_contentitem_tag_map` AS m
INNER JOIN `m4qou_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_contact.contact'
AND `m`.`content_item_id` = 1
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 c7kellalapitvany.m.tag_id 1 Using where Status Duration Starting 0.11 ms checking permissions 0.01 ms Opening tables 0.07 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.06 ms Optimizing 0.03 ms Statistics 0.42 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.15 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Hívó Fájl és sorok száma 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 14 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_contact/models/category.php:107 13 ContactModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_contact/views/category/view.html.php:54 10 ContactViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.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 - Lekérdezés ideje: 0.48 ms Utolsó lekérdezés után: 0.46 ms Memória lekérdezése: 0.039 MB memória a lekérdezés előtt: 2.684 MB Visszaadott sorok: 0
SELECT `m`.`tag_id`,`t`.*
FROM `m4qou_contentitem_tag_map` AS m
INNER JOIN `m4qou_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_contact.contact'
AND `m`.`content_item_id` = 2
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 c7kellalapitvany.m.tag_id 1 Using where Status Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.02 ms Statistics 0.07 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Hívó Fájl és sorok száma 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 14 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_contact/models/category.php:107 13 ContactModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_contact/views/category/view.html.php:54 10 ContactViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.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 - Lekérdezés ideje: 0.38 ms Utolsó lekérdezés után: 0.31 ms Memória lekérdezése: 0.038 MB memória a lekérdezés előtt: 2.699 MB Visszaadott sorok: 0
SELECT `m`.`tag_id`,`t`.*
FROM `m4qou_contentitem_tag_map` AS m
INNER JOIN `m4qou_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_contact.contact'
AND `m`.`content_item_id` = 3
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 c7kellalapitvany.m.tag_id 1 Using where Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Hívó Fájl és sorok száma 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 14 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_contact/models/category.php:107 13 ContactModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_contact/views/category/view.html.php:54 10 ContactViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.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 - Lekérdezés ideje: 0.54 ms Utolsó lekérdezés után: 1.30 ms Memória lekérdezése: 0.029 MB memória a lekérdezés előtt: 2.719 MB Visszaadott sorok: 1
SELECT COUNT(*)
FROM `m4qou_contact_details` AS a
LEFT JOIN m4qou_categories AS c
ON c.id = a.catid
LEFT JOIN m4qou_users AS ua
ON ua.id = a.created_by
LEFT JOIN m4qou_users AS uam
ON uam.id = a.modified_by
WHERE a.access IN (1,1,5)
AND a.catid = 41
AND c.access IN (1,1,5)
AND a.published = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-18 05:46:17')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-18 05:46:17')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY,idx_access PRIMARY 4 const 1 1 SIMPLE a ALL idx_access,idx_state,idx_catid NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 3 Using where Status Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.08 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Hívó Fájl és sorok száma 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 16 JDatabaseDriver->loadResult() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354 15 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() JROOT/libraries/src/MVC/Model/ListModel.php:289 14 Joomla\CMS\MVC\Model\ListModel->getTotal() JROOT/libraries/src/MVC/Model/ListModel.php:239 13 Joomla\CMS\MVC\Model\ListModel->getPagination() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:145 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_contact/views/category/view.html.php:54 10 ContactViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.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 - Lekérdezés ideje: 0.93 ms Utolsó lekérdezés után: 4.62 ms Memória lekérdezése: 0.043 MB memória a lekérdezés előtt: 2.776 MB Visszaadott sorok: 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 `m4qou_categories` AS `s`
INNER JOIN `m4qou_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_contact' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 41
ORDER BY c.lftid 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 cat_idx 207 NULL 5 Using index condition; Using where; Fájlrendezés használata Status Duration Starting 0.16 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.06 ms Optimizing 0.03 ms Statistics 0.14 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.04 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.03 ms Creating sort index 0.11 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Hívó Fájl és sorok száma 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 20 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 19 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 18 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:140 17 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:194 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 14 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/libraries/src/MVC/View/CategoryView.php:179 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_contact/views/category/view.html.php:54 10 ContactViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.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 - Lekérdezés ideje: 2.41 ms Utolsó lekérdezés után: 0.44 ms Memória lekérdezése: 0.041 MB memória a lekérdezés előtt: 2.798 MB Visszaadott sorok: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM m4qou_fields AS a
LEFT JOIN `m4qou_languages` AS l
ON l.lang_code = a.language
LEFT JOIN m4qou_users AS uc
ON uc.id=a.checked_out
LEFT JOIN m4qou_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN m4qou_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN m4qou_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `m4qou_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_contact.contact'
AND (fc.category_id IS NULL OR fc.category_id IN (41,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Fájlrendezés használata 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 c7kellalapitvany.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 c7kellalapitvany.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 c7kellalapitvany.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 c7kellalapitvany.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 c7kellalapitvany.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 c7kellalapitvany.a.id 1 Using where; Using index; Distinct Status Duration Starting 0.10 ms checking permissions 0.01 ms Opening tables 0.17 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.82 ms Preparing 0.07 ms Creating tmp table 0.16 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.49 ms Creating sort index 0.06 ms Removing tmp table 0.13 ms Creating sort index 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.02 ms Starting cleanup 0.00 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.01 ms # Hívó Fájl és sorok száma 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 18 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 17 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 14 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/libraries/src/MVC/View/CategoryView.php:179 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_contact/views/category/view.html.php:54 10 ContactViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.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 - Lekérdezés ideje: 0.73 ms Utolsó lekérdezés után: 4.75 ms Memória lekérdezése: 0.037 MB memória a lekérdezés előtt: 2.834 MB Visszaadott sorok: 0
SELECT `m`.`tag_id`,`t`.*
FROM `m4qou_contentitem_tag_map` AS m
INNER JOIN `m4qou_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_contact.category'
AND `m`.`content_item_id` = 41
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 c7kellalapitvany.m.tag_id 1 Using where Status Duration Starting 0.12 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.06 ms Optimizing 0.04 ms Statistics 0.08 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.06 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 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/Helper/TagsHelper.php:454 12 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/libraries/src/MVC/View/CategoryView.php:229 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_contact/views/category/view.html.php:54 10 ContactViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.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 - Lekérdezés ideje: 1.65 ms Utolsó lekérdezés után: 7.58 ms Memória lekérdezése: 0.045 MB memória a lekérdezés előtt: 2.987 MB Visszaadott sorok: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM m4qou_fields AS a
LEFT JOIN `m4qou_languages` AS l
ON l.lang_code = a.language
LEFT JOIN m4qou_users AS uc
ON uc.id=a.checked_out
LEFT JOIN m4qou_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN m4qou_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN m4qou_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_contact.categories'
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Fájlrendezés használata 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 c7kellalapitvany.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 c7kellalapitvany.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 c7kellalapitvany.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 c7kellalapitvany.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 c7kellalapitvany.a.group_id 1 Using where Status Duration Starting 0.18 ms checking permissions 0.01 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.06 ms Optimizing 0.04 ms Statistics 0.13 ms Preparing 0.04 ms Creating tmp table 0.07 ms Sorting result 0.02 ms Executing 0.00 ms Sending data 0.50 ms Creating sort index 0.06 ms Removing tmp table 0.10 ms Creating sort index 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.00 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.01 ms # Hívó Fájl és sorok száma 26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 25 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 24 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 23 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 22 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 21 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 20 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 19 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 18 JEventDispatcher->trigger() JROOT/layouts/joomla/content/category_default.php:25 17 include JROOT/layouts/joomla/content/category_default.php JROOT/libraries/src/Layout/FileLayout.php:125 16 Joomla\CMS\Layout\FileLayout->render() JROOT/libraries/src/Layout/LayoutHelper.php:73 15 Joomla\CMS\Layout\LayoutHelper::render() JROOT/components/com_contact/views/category/tmpl/default.php:13 14 include JROOT/components/com_contact/views/category/tmpl/default.php JROOT/libraries/src/MVC/View/HtmlView.php:701 13 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 11 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_contact/views/category/view.html.php:83 10 ContactViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.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 - Lekérdezés ideje: 1.43 ms Utolsó lekérdezés után: 1.28 ms Memória lekérdezése: 0.046 MB memória a lekérdezés előtt: 3.006 MB Visszaadott sorok: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM m4qou_fields AS a
LEFT JOIN `m4qou_languages` AS l
ON l.lang_code = a.language
LEFT JOIN m4qou_users AS uc
ON uc.id=a.checked_out
LEFT JOIN m4qou_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN m4qou_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN m4qou_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `m4qou_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_contact.categories'
AND (fc.category_id IS NULL OR fc.category_id IN (41,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Fájlrendezés használata 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 c7kellalapitvany.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 c7kellalapitvany.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 c7kellalapitvany.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 c7kellalapitvany.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 c7kellalapitvany.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 c7kellalapitvany.a.id 1 Using where; Using index; Distinct Status Duration Starting 0.11 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.06 ms Optimizing 0.04 ms Statistics 0.11 ms Preparing 0.04 ms Creating tmp table 0.06 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.40 ms Creating sort index 0.05 ms Removing tmp table 0.09 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.01 ms # Hívó Fájl és sorok száma 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 26 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 25 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 24 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 23 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 22 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:404 21 PlgSystemFields->display() JROOT/plugins/system/fields/fields.php:324 20 PlgSystemFields->onContentAfterTitle() JROOT/libraries/joomla/event/event.php:70 19 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 18 JEventDispatcher->trigger() JROOT/layouts/joomla/content/category_default.php:28 17 include JROOT/layouts/joomla/content/category_default.php JROOT/libraries/src/Layout/FileLayout.php:125 16 Joomla\CMS\Layout\FileLayout->render() JROOT/libraries/src/Layout/LayoutHelper.php:73 15 Joomla\CMS\Layout\LayoutHelper::render() JROOT/components/com_contact/views/category/tmpl/default.php:13 14 include JROOT/components/com_contact/views/category/tmpl/default.php JROOT/libraries/src/MVC/View/HtmlView.php:701 13 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 11 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_contact/views/category/view.html.php:83 10 ContactViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.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 - Lekérdezés ideje: 1.64 ms Utolsó lekérdezés után: 3.29 ms Memória lekérdezése: 0.047 MB memória a lekérdezés előtt: 3.029 MB Visszaadott sorok: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM m4qou_fields AS a
LEFT JOIN `m4qou_languages` AS l
ON l.lang_code = a.language
LEFT JOIN m4qou_users AS uc
ON uc.id=a.checked_out
LEFT JOIN m4qou_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN m4qou_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN m4qou_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_contact.category.title'
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Fájlrendezés használata 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 c7kellalapitvany.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 c7kellalapitvany.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 c7kellalapitvany.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 c7kellalapitvany.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 c7kellalapitvany.a.group_id 1 Using where Status Duration Starting 0.18 ms checking permissions 0.01 ms Opening tables 0.08 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.09 ms Optimizing 0.05 ms Statistics 0.15 ms Preparing 0.05 ms Creating tmp table 0.06 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.46 ms Creating sort index 0.05 ms Removing tmp table 0.08 ms Creating sort index 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.00 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.01 ms # Hívó Fájl és sorok száma 30 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 29 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 28 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 27 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 26 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 25 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 24 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 23 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 22 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 21 JHtmlContent::prepare() Ugyanaz a hívás, mint egy sorral lejjebb. 20 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 19 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 18 Joomla\CMS\HTML\HTMLHelper::_() JROOT/layouts/joomla/content/category_default.php:57 17 include JROOT/layouts/joomla/content/category_default.php JROOT/libraries/src/Layout/FileLayout.php:125 16 Joomla\CMS\Layout\FileLayout->render() JROOT/libraries/src/Layout/LayoutHelper.php:73 15 Joomla\CMS\Layout\LayoutHelper::render() JROOT/components/com_contact/views/category/tmpl/default.php:13 14 include JROOT/components/com_contact/views/category/tmpl/default.php JROOT/libraries/src/MVC/View/HtmlView.php:701 13 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 11 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_contact/views/category/view.html.php:83 10 ContactViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.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 - Lekérdezés ideje: 1.14 ms Utolsó lekérdezés után: 24.68 ms Memória lekérdezése: 0.030 MB memória a lekérdezés előtt: 3.152 MB Visszaadott sorok: 2
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM m4qou_modules AS m
LEFT JOIN m4qou_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN m4qou_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 <= '2024-04-18 05:46:17')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-18 05:46:17')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 105 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds published 1 const 6 Using index condition; Using where; Fájlrendezés használata 1 SIMPLE mm ref PRIMARY PRIMARY 4 c7kellalapitvany.m.id 1 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 c7kellalapitvany.m.module,const 1 Using index condition; Using where Status Duration Starting 0.18 ms checking permissions 0.01 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.07 ms Optimizing 0.06 ms Statistics 0.11 ms Preparing 0.05 ms Sorting result 0.07 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.17 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.03 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.01 ms # Hívó Fájl és sorok száma 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() Ugyanaz a hívás, mint egy sorral lejjebb. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 12 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 11 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 10 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:601 9 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/as002056free/includes/includes.php:63 8 include JROOT/templates/as002056free/includes/includes.php JROOT/templates/as002056free/index.php:13 7 require JROOT/templates/as002056free/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 - Lekérdezés ideje: 0.70 ms Utolsó lekérdezés után: 17.51 ms Memória lekérdezése: 0.034 MB memória a lekérdezés előtt: 3.567 MB Visszaadott sorok: 90
SELECT *
FROM m4qou_acymailing_configid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m4qou_acymailing_config ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 90 Status Duration Starting 0.09 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.10 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.05 ms Reset for next command 0.01 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_acymailing/classes/cpanel.php:17 11 cpanelClass->load() JROOT/administrator/components/com_acymailing/helpers/helper.php:392 10 acymailing_config() JROOT/administrator/components/com_acymailing/helpers/helper.php:1369 9 include_once JROOT/administrator/components/com_acymailing/helpers/helper.php JROOT/plugins/system/regacymailing/regacymailing.php:21 8 plgSystemRegacymailing->initAcy() JROOT/plugins/system/regacymailing/regacymailing.php:145 7 plgSystemRegacymailing->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
21 naplózott lekérdezéstípus, rendezés előfordulás szerint
SELECT táblák:
4 × SELECT `m`.`tag_id`,`t`.*
FROM `m4qou_contentitem_tag_map` AS m
INNER JOIN `m4qou_tags` AS t
ON `m`.`tag_id` = `t`.`id`2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `m4qou_extensions`2 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM m4qou_fields AS a
LEFT JOIN `m4qou_languages` AS l
ON l.lang_code = a.language
LEFT JOIN m4qou_users AS uc
ON uc.id=a.checked_out
LEFT JOIN m4qou_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN m4qou_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN m4qou_fields_groups AS g
ON g.id = a.group_id2 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM m4qou_fields AS a
LEFT JOIN `m4qou_languages` AS l
ON l.lang_code = a.language
LEFT JOIN m4qou_users AS uc
ON uc.id=a.checked_out
LEFT JOIN m4qou_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN m4qou_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN m4qou_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `m4qou_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT `data`
FROM `m4qou_session`1 × SELECT a.*,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email
FROM `m4qou_contact_details` AS a
LEFT JOIN m4qou_categories AS c
ON c.id = a.catid
LEFT JOIN m4qou_users AS ua
ON ua.id = a.created_by
LEFT JOIN m4qou_users AS uam
ON uam.id = a.modified_by1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM m4qou_modules AS m
LEFT JOIN m4qou_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN m4qou_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × 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 `m4qou_categories` AS `s`
INNER JOIN `m4qou_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)1 × SELECT COUNT(*)
FROM `m4qou_contact_details` AS a
LEFT JOIN m4qou_categories AS c
ON c.id = a.catid
LEFT JOIN m4qou_users AS ua
ON ua.id = a.created_by
LEFT JOIN m4qou_users AS uam
ON uam.id = a.modified_by1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `m4qou_assets`1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`)
FROM `m4qou_contact_details` AS `i`1 × SELECT `session_id`
FROM `m4qou_session`1 × SELECT id, home, template, s.params
FROM m4qou_template_styles as s
LEFT JOIN m4qou_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT *
FROM m4qou_languages1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM m4qou_menu AS m
LEFT JOIN m4qou_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM m4qou_extensions1 × SELECT b.id
FROM m4qou_usergroups AS a
LEFT JOIN m4qou_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `m4qou_viewlevels1 × SELECT *
FROM m4qou_acymailing_confi
EGYÉB táblák:
1 × INSERT INTO `m4qou_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6d6833746c39337263386e317135746970343766753934746d35', 1, 1713419177, 0, '', 01 × UPDATE `m4qou_extensions`
SET `params` = '{\"mediaversion\":\"55f28a8e37dd0b703a463e43e06f0aa5\"}'