 | |||||
 |  |  |  |  |  |
Copyright © 2025: Kell Alapítvány
Joomla! hibakereső konzol
{
"__default": {
"session": {
"counter": 3,
"timer": {
"start": 1749389028,
"last": 1749389028,
"now": 1749389028
},
"client": {
"forwarded": "10.1.159.50"
}
},
"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ő: 6.00 ms / 6.00 ms Memória: 0.587 MB / 0.92 MB Application: afterLoad
Idő: 16.26 ms / 22.26 ms Memória: 1.088 MB / 2.01 MB Application: afterInitialise
Idő: 4.68 ms / 26.94 ms Memória: 0.205 MB / 2.21 MB Application: afterRoute
Idő: 2.57 ms / 29.51 ms Memória: 0.116 MB / 2.33 MB Application: beforeRenderComponent com_phocagallery
Idő: 17.16 ms / 46.67 ms Memória: 0.682 MB / 3.01 MB Application: afterRenderComponent com_phocagallery
Idő: 3.88 ms / 50.55 ms Memória: 0.014 MB / 3.03 MB Application: afterDispatch
Idő: 1.99 ms / 52.54 ms Memória: 0.083 MB / 3.11 MB Application: beforeRenderModule mod_as_menu (Top Menu)
Idő: 1.46 ms / 54.00 ms Memória: 0.118 MB / 3.23 MB Application: afterRenderModule mod_as_menu (Top Menu)
Idő: 3.77 ms / 57.77 ms Memória: 0.493 MB / 3.72 MB Application: afterRender
Adatbázislekérdezés összesen: 8.52 ms
4,10 MB (4.301.344 Bájtok)
23 naplózott lekérdezés 8.52 ms
- Lekérdezés ideje: 0.24 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 1.249 MB Visszaadott sorok: 1
SELECT `data`
FROM `m4qou_session`
WHERE `session_id` = X'376f396e357638373531357337386265656237653633396f3434'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.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.00 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.01 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 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.32 ms Utolsó lekérdezés után: 0.79 ms Memória lekérdezése: 0.041 MB memória a lekérdezés előtt: 1.365 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.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.07 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 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.16 ms Utolsó lekérdezés után: 0.65 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 1.416 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.01 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.00 ms Statistics 0.01 ms Preparing 0.00 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 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.18 ms Utolsó lekérdezés után: 0.06 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 1.430 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.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 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: 0.43 ms Utolsó lekérdezés után: 0.10 ms Memória lekérdezése: 0.038 MB memória a lekérdezés előtt: 1.454 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.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.01 ms Sorting result 0.00 ms Executing 0.00 ms Sending data 0.00 ms Creating sort index 0.17 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 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: 0.79 ms Utolsó lekérdezés után: 8.55 ms Memória lekérdezése: 0.037 MB memória a lekérdezés előtt: 2.038 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 ALL idx_client_id_parent_id_alias_language NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 72 Using where; Fájlrendezés használata 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 kellalapitvany.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.00 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.09 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 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.32 ms Utolsó lekérdezés után: 3.27 ms Memória lekérdezése: 0.027 MB memória a lekérdezés előtt: 2.232 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.05 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.05 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 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: 0.23 ms Utolsó lekérdezés után: 0.13 ms Memória lekérdezése: 0.007 MB memória a lekérdezés előtt: 2.225 MB
UPDATE `m4qou_extensions`
SET `params` = '{\"mediaversion\":\"acec1546ee1ba027f1fd0109e75eb32e\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'Az EXPLAIN nem lehetséges a következő lekérdezésen: UPDATE `m4qou_extensions` SET `params` = '{\"mediaversion\":\"acec1546ee1ba027f1fd0109e75eb32e\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms checking permissions 0.00 ms After opening tables 0.00 ms init for update 0.00 ms init 0.01 ms Updating main table 0.00 ms init 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.00 ms init for update 0.03 ms Updating 0.02 ms End of update loop 0.00 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 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.20 ms Utolsó lekérdezés után: 0.56 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 2.298 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.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Sorting result 0.00 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 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.29 ms Utolsó lekérdezés után: 0.14 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 2.309 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 kellalapitvany.s.template,const 1 Using index condition; Using where Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 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: 0.33 ms Utolsó lekérdezés után: 4.88 ms Memória lekérdezése: 0.027 MB memória a lekérdezés előtt: 2.739 MB Visszaadott sorok: 3
SELECT a.filename as filename, a.type as type, a.menulink as menulink
FROM m4qou_phocagallery_styles AS a
WHERE a.published = 1
ORDER BY a.type, a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 4 Using where; Fájlrendezés használata Status Duration Starting 0.05 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Sorting result 0.00 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 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_phocagallery/libraries/phocagallery/render/renderfront.php:721 11 PhocaGalleryRenderFront::renderAllCSS() JROOT/components/com_phocagallery/views/detail/view.html.php:71 10 PhocaGalleryViewDetail->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_phocagallery/controller.php:30 8 PhocaGalleryController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_phocagallery/phocagallery.php:55 6 require_once JROOT/components/com_phocagallery/phocagallery.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Lekérdezés ideje: 0.20 ms Utolsó lekérdezés után: 2.02 ms Memória lekérdezése: 0.031 MB memória a lekérdezés előtt: 2.822 MB Visszaadott sorok: 0Duplikált lekérdezések: #13
SELECT a.*
FROM m4qou_phocagallery_fb_users AS a
WHERE a.id =0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.00 ms Executing 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Hívó Fájl és sorok száma 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 13 JDatabase->query() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/facebook/fbsystem.php:44 12 PhocaGalleryFbSystem::getFbUserInfo() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/facebook/fbsystem.php:56 11 PhocaGalleryFbSystem::getCommentsParams() JROOT/components/com_phocagallery/views/detail/view.html.php:112 10 PhocaGalleryViewDetail->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_phocagallery/controller.php:30 8 PhocaGalleryController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_phocagallery/phocagallery.php:55 6 require_once JROOT/components/com_phocagallery/phocagallery.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Lekérdezés ideje: 0.15 ms Utolsó lekérdezés után: 0.04 ms Memória lekérdezése: 0.031 MB memória a lekérdezés előtt: 2.832 MB Visszaadott sorok: 0Duplikált lekérdezések: #12
SELECT a.*
FROM m4qou_phocagallery_fb_users AS a
WHERE a.id =0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.00 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.00 ms Executing 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.01 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Hívó Fájl és sorok száma 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/facebook/fbsystem.php:49 12 PhocaGalleryFbSystem::getFbUserInfo() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/facebook/fbsystem.php:56 11 PhocaGalleryFbSystem::getCommentsParams() JROOT/components/com_phocagallery/views/detail/view.html.php:112 10 PhocaGalleryViewDetail->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_phocagallery/controller.php:30 8 PhocaGalleryController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_phocagallery/phocagallery.php:55 6 require_once JROOT/components/com_phocagallery/phocagallery.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Lekérdezés ideje: 0.36 ms Utolsó lekérdezés után: 0.24 ms Memória lekérdezése: 0.040 MB memória a lekérdezés előtt: 2.843 MB Visszaadott sorok: 1
SELECT a.*, c.accessuserid as cataccessuserid, c.access as cataccess, ua.id AS userid, ua.username AS username, ua.name AS usernameno,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug
FROM m4qou_phocagallery AS a
LEFT JOIN m4qou_phocagallery_categories AS c
ON c.id = a.catid
LEFT JOIN m4qou_users AS ua
ON ua.id = a.userid
WHERE a.id = 1205
AND a.published > 0
AND a.approved > 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 1 SIMPLE ua const PRIMARY PRIMARY 4 const 1 Unique row not found Status Duration Starting 0.08 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.04 ms Optimizing 0.01 ms Statistics 0.05 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 ms # Hívó Fájl és sorok száma 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_phocagallery/models/detail.php:73 12 PhocaGalleryModelDetail->_loadData() JROOT/components/com_phocagallery/models/detail.php:34 11 PhocaGalleryModelDetail->getData() JROOT/components/com_phocagallery/views/detail/view.html.php:175 10 PhocaGalleryViewDetail->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_phocagallery/controller.php:30 8 PhocaGalleryController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_phocagallery/phocagallery.php:55 6 require_once JROOT/components/com_phocagallery/phocagallery.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Lekérdezés ideje: 0.17 ms Utolsó lekérdezés után: 0.13 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 2.863 MB Visszaadott sorok: 0
SELECT a.*
FROM m4qou_phocagallery_user AS a
WHERE a.userid = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref userid userid 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Hívó Fájl és sorok száma 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 12 JDatabaseDriver->loadObject() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/user/user.php:53 11 PhocaGalleryUser::getUserAvatar() JROOT/components/com_phocagallery/views/detail/view.html.php:189 10 PhocaGalleryViewDetail->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_phocagallery/controller.php:30 8 PhocaGalleryController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_phocagallery/phocagallery.php:55 6 require_once JROOT/components/com_phocagallery/phocagallery.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Lekérdezés ideje: 0.33 ms Utolsó lekérdezés után: 1.22 ms Memória lekérdezése: 0.027 MB memória a lekérdezés előtt: 2.880 MB Visszaadott sorok: 0Duplikált lekérdezések: #17
SELECT a.id, a.filename as filename, b.id AS currentid,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug
FROM m4qou_phocagallery AS a, m4qou_phocagallery AS b
LEFT JOIN m4qou_phocagallery_categories AS c
ON c.id = b.catid
WHERE a.catid = 107
AND b.id = 1205
AND (a.ordering > b.ordering OR (a.ordering = b.ordering
and a.id > b.id))
AND a.published = 1
ORDER BY a.ordering ASC, a.id ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b const PRIMARY PRIMARY 4 const 1 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 1 SIMPLE a ref PRIMARY,catid catid 5 const,const 11 Using where; Fájlrendezés használata Status Duration Starting 0.05 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Sorting result 0.00 ms Executing 0.00 ms Sending data 0.00 ms Creating sort index 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 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_phocagallery/libraries/phocagallery/render/renderdetailbutton.php:97 11 PhocaGalleryRenderDetailButton->getNext() JROOT/components/com_phocagallery/views/detail/view.html.php:236 10 PhocaGalleryViewDetail->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_phocagallery/controller.php:30 8 PhocaGalleryController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_phocagallery/phocagallery.php:55 6 require_once JROOT/components/com_phocagallery/phocagallery.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Lekérdezés ideje: 0.32 ms Utolsó lekérdezés után: 0.19 ms Memória lekérdezése: 0.027 MB memória a lekérdezés előtt: 2.891 MB Visszaadott sorok: 0Duplikált lekérdezések: #16
SELECT a.id, a.filename as filename, b.id AS currentid,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug
FROM m4qou_phocagallery AS a, m4qou_phocagallery AS b
LEFT JOIN m4qou_phocagallery_categories AS c
ON c.id = b.catid
WHERE a.catid = 107
AND b.id = 1205
AND (a.ordering > b.ordering OR (a.ordering = b.ordering
and a.id > b.id))
AND a.published = 1
ORDER BY a.ordering ASC, a.id ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b const PRIMARY PRIMARY 4 const 1 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 1 SIMPLE a ref PRIMARY,catid catid 5 const,const 11 Using where; Fájlrendezés használata Status Duration Starting 0.05 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Sorting result 0.00 ms Executing 0.00 ms Sending data 0.00 ms Creating sort index 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 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_phocagallery/libraries/phocagallery/render/renderdetailbutton.php:97 11 PhocaGalleryRenderDetailButton->getNext() JROOT/components/com_phocagallery/views/detail/view.html.php:237 10 PhocaGalleryViewDetail->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_phocagallery/controller.php:30 8 PhocaGalleryController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_phocagallery/phocagallery.php:55 6 require_once JROOT/components/com_phocagallery/phocagallery.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Lekérdezés ideje: 0.53 ms Utolsó lekérdezés után: 0.15 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 2.901 MB Visszaadott sorok: 10
SELECT a.id, a.filename as filename, b.id AS currentid,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug
FROM m4qou_phocagallery AS a, m4qou_phocagallery AS b
LEFT JOIN m4qou_phocagallery_categories AS c
ON c.id = b.catid
WHERE a.catid = 107
AND b.id = 1205
AND (a.ordering < b.ordering OR (a.ordering = b.ordering
and a.id < b.id))
AND a.published = 1
ORDER BY a.ordering DESC, a.id DESCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b const PRIMARY PRIMARY 4 const 1 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 1 SIMPLE a ref PRIMARY,catid catid 5 const,const 11 Using where; Fájlrendezés használata Status Duration Starting 0.06 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.00 ms Creating sort index 0.06 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 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_phocagallery/libraries/phocagallery/render/renderdetailbutton.php:197 11 PhocaGalleryRenderDetailButton->getPrevious() JROOT/components/com_phocagallery/views/detail/view.html.php:238 10 PhocaGalleryViewDetail->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_phocagallery/controller.php:30 8 PhocaGalleryController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_phocagallery/phocagallery.php:55 6 require_once JROOT/components/com_phocagallery/phocagallery.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Lekérdezés ideje: 0.60 ms Utolsó lekérdezés után: 0.48 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 2.911 MB Visszaadott sorok: 11
SELECT a.id, a.filename, a.extl, a.description
FROM m4qou_phocagallery AS a
LEFT JOIN m4qou_phocagallery_img_votes_statistics AS r
ON r.imgid = a.id
WHERE a.catid=107
AND a.published = 1
AND a.approved = 1
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 11 Using where; Using temporary; Fájlrendezés használata 1 SIMPLE r ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 1 Using where; Using join buffer (flat, BNL join) Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Creating tmp table 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.24 ms Creating sort index 0.02 ms Removing tmp table 0.07 ms Creating sort index 0.00 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 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_phocagallery/libraries/phocagallery/render/renderdetailbutton.php:320 11 PhocaGalleryRenderDetailButton->getJsSlideshow() JROOT/components/com_phocagallery/views/detail/view.html.php:239 10 PhocaGalleryViewDetail->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_phocagallery/controller.php:30 8 PhocaGalleryController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_phocagallery/phocagallery.php:55 6 require_once JROOT/components/com_phocagallery/phocagallery.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Lekérdezés ideje: 0.50 ms Utolsó lekérdezés után: 2.33 ms Memória lekérdezése: 0.041 MB memória a lekérdezés előtt: 2.930 MB Visszaadott sorok: 38
SHOW FULL COLUMNS
FROM `m4qou_phocagallery`Az EXPLAIN nem lehetséges a következő lekérdezésen: SHOW FULL COLUMNS FROM `m4qou_phocagallery`Status Duration Starting 0.02 ms checking permissions 0.00 ms closing tables 0.00 ms checking permissions 0.00 ms Opening tables 0.18 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.00 ms Optimizing 0.00 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Filling schema table 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms checking permissions 0.06 ms closing tables 0.00 ms checking permissions 0.00 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Removing tmp table 0.05 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 ms # Hívó Fájl és sorok száma 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 16 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 15 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 14 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_phocagallery/tables/phocagallery.php:22 13 TablePhocaGallery->__construct() JROOT/libraries/src/Table/Table.php:328 12 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_phocagallery/models/detail.php:89 11 PhocaGalleryModelDetail->hit() JROOT/components/com_phocagallery/views/detail/view.html.php:289 10 PhocaGalleryViewDetail->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_phocagallery/controller.php:30 8 PhocaGalleryController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_phocagallery/phocagallery.php:55 6 require_once JROOT/components/com_phocagallery/phocagallery.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Lekérdezés ideje: 0.97 ms Utolsó lekérdezés után: 0.46 ms Memória lekérdezése: 0.009 MB memória a lekérdezés előtt: 3.013 MB
UPDATE m4qou_phocagallery
SET `hits` = (`hits` + 1)
WHERE `id` = '1205'Az EXPLAIN nem lehetséges a következő lekérdezésen: UPDATE m4qou_phocagallery SET `hits` = (`hits` + 1) WHERE `id` = '1205'Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms checking permissions 0.00 ms After opening tables 0.00 ms init for update 0.00 ms init 0.01 ms Updating main table 0.01 ms init 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.00 ms init for update 0.02 ms Updating 0.05 ms End of update loop 0.00 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.72 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 ms # Hívó Fájl és sorok száma 13 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1264 12 Joomla\CMS\Table\Table->hit() JROOT/components/com_phocagallery/models/detail.php:90 11 PhocaGalleryModelDetail->hit() JROOT/components/com_phocagallery/views/detail/view.html.php:289 10 PhocaGalleryViewDetail->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_phocagallery/controller.php:30 8 PhocaGalleryController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_phocagallery/phocagallery.php:55 6 require_once JROOT/components/com_phocagallery/phocagallery.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Lekérdezés ideje: 0.62 ms Utolsó lekérdezés után: 5.44 ms Memória lekérdezése: 0.030 MB memória a lekérdezés előtt: 3.084 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 <= '2025-06-08 13:23:48')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-06-08 13:23:48')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 0 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 range PRIMARY,published,newsfeeds published 5 NULL 6 Using index condition; Using where; Fájlrendezés használata 1 SIMPLE mm ref PRIMARY PRIMARY 4 kellalapitvany.m.id 1 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 kellalapitvany.m.module,const 1 Using index condition; Using where Status Duration Starting 0.11 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.05 ms Optimizing 0.04 ms Statistics 0.07 ms Preparing 0.04 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.09 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 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.28 ms Utolsó lekérdezés után: 5.16 ms Memória lekérdezése: 0.034 MB memória a lekérdezés előtt: 3.636 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.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.00 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 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
19 naplózott lekérdezéstípus, rendezés előfordulás szerint
SELECT táblák:
3 × SELECT a.id, a.filename as filename, b.id AS currentid,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug
FROM m4qou_phocagallery AS a, m4qou_phocagallery AS b
LEFT JOIN m4qou_phocagallery_categories AS c
ON c.id = b.catid2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `m4qou_extensions`2 × SELECT a.*
FROM m4qou_phocagallery_fb_users AS a1 × SELECT `data`
FROM `m4qou_session`1 × SELECT id, rules
FROM `m4qou_viewlevels1 × 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 `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM m4qou_extensions1 × 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 *
FROM m4qou_languages1 × 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 a.filename as filename, a.type as type, a.menulink as menulink
FROM m4qou_phocagallery_styles AS a1 × SELECT a.*, c.accessuserid as cataccessuserid, c.access as cataccess, ua.id AS userid, ua.username AS username, ua.name AS usernameno,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug
FROM m4qou_phocagallery AS a
LEFT JOIN m4qou_phocagallery_categories AS c
ON c.id = a.catid
LEFT JOIN m4qou_users AS ua
ON ua.id = a.userid1 × SELECT a.*
FROM m4qou_phocagallery_user AS a1 × SELECT a.id, a.filename, a.extl, a.description
FROM m4qou_phocagallery AS a
LEFT JOIN m4qou_phocagallery_img_votes_statistics AS r
ON r.imgid = a.id1 × 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 *
FROM m4qou_acymailing_confi
EGYÉB táblák:
1 × UPDATE `m4qou_extensions`
SET `params` = '{\"mediaversion\":\"acec1546ee1ba027f1fd0109e75eb32e\"}'1 × SHOW FULL COLUMNS
FROM `m4qou_phocagallery1 × UPDATE m4qou_phocagallery
SET `hits` = (`hits` + 1)