J2013.09....
J2013.10....
J2013.10....
J2013.10....
J2013.11....
J2013.12....
J2014.01....
J2014.02....
J2014.03....
J2014.04....
J2014.04....
J2014.04....
J2014.05....
J2014.06....
J2014.07....
J2014.08....
J2014.10....
J2014.12....
J2015.03....
J2015.04....
J2015.04....
Powered by Phoca Gallery
Copyright © 2024: Kell Alapítvány
Joomla! hibakereső konzol
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1713627221,
"last": 1713627221,
"now": 1713627221
},
"token": "aD39VRmDgUzeTel0NUyo6C2os4dxIbi2"
},
"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ő: 12.76 ms / 12.76 ms Memória: 0.585 MB / 0.92 MB Application: afterLoad
Idő: 36.14 ms / 48.90 ms Memória: 1.097 MB / 2.01 MB Application: afterInitialise
Idő: 9.75 ms / 58.65 ms Memória: 0.207 MB / 2.22 MB Application: afterRoute
Idő: 6.13 ms / 64.78 ms Memória: 0.118 MB / 2.34 MB Application: beforeRenderComponent com_phocagallery
Idő: 112.68 ms / 177.46 ms Memória: 1.516 MB / 3.85 MB Application: afterRenderComponent com_phocagallery
Idő: 2.91 ms / 180.37 ms Memória: 0.005 MB / 3.86 MB Application: afterDispatch
Idő: 5.20 ms / 185.57 ms Memória: 0.145 MB / 4.00 MB Application: beforeRenderModule mod_as_menu (Top Menu)
Idő: 4.50 ms / 190.07 ms Memória: 0.061 MB / 4.07 MB Application: afterRenderModule mod_as_menu (Top Menu)
Idő: 8.74 ms / 198.81 ms Memória: 0.512 MB / 4.58 MB Application: afterRender
Adatbázislekérdezés összesen: 56.60 ms
6,01 MB (6.297.832 Bájtok)
93 naplózott lekérdezés 56.60 ms
44 duplikátum található!
- Lekérdezés ideje: 0.71 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'356c7673343961316e6b33753936693364736b6b6d6575713635'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.12 ms checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.06 ms Optimizing 0.02 ms Statistics 0.07 ms Preparing 0.04 ms Executing 0.03 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.03 ms closing tables 0.02 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 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.09 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 1.264 MB Visszaadott sorok: 0
SELECT `session_id`
FROM `m4qou_session`
WHERE `session_id` = X'356c7673343961316e6b33753936693364736b6b6d6575713635'
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.06 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.01 ms Executing 0.03 ms End of update loop 0.01 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.03 ms Starting cleanup 0.02 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 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.01 ms Utolsó lekérdezés után: 0.12 ms Memória lekérdezése: 0.005 MB memória a lekérdezés előtt: 1.271 MB
INSERT INTO `m4qou_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'356c7673343961316e6b33753936693364736b6b6d6575713635', 1, 1713627221, 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'356c7673343961316e6b33753936693364736b6b6d6575713635', 1, 1713627221, 0, '', 0)Status Duration Starting 0.06 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 for update 0.03 ms Update 0.13 ms Waiting for query cache lock 0.01 ms Update 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.49 ms closing tables 0.06 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 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.86 ms Utolsó lekérdezés után: 1.18 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.07 ms checking permissions 0.03 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.02 ms table lock 0.03 ms init 0.04 ms Optimizing 0.04 ms Statistics 0.09 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.20 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.02 ms Updating status 0.03 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.45 ms Utolsó lekérdezés után: 1.39 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 1.422 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.04 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.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.04 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.03 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.02 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.49 ms Utolsó lekérdezés után: 0.09 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 1.436 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.06 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.09 ms Preparing 0.02 ms Unlocking tables 0.01 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.04 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.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 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.05 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.08 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.07 ms Statistics 0.05 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.03 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.04 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: 0.97 ms Utolsó lekérdezés után: 17.69 ms Memória lekérdezése: 0.037 MB memória a lekérdezés előtt: 2.043 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.12 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.09 ms Preparing 0.09 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.21 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.03 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.66 ms Utolsó lekérdezés után: 7.27 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 2.240 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.04 ms Optimizing 0.03 ms Statistics 0.09 ms Preparing 0.03 ms Executing 0.00 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.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 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.14 ms Utolsó lekérdezés után: 0.19 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\":\"80e668cd5988911dc61bed93ad6a051d\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'Az EXPLAIN nem lehetséges a következő lekérdezésen: UPDATE `m4qou_extensions` SET `params` = '{\"mediaversion\":\"80e668cd5988911dc61bed93ad6a051d\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.02 ms table lock 0.01 ms init for update 0.06 ms Updating 0.07 ms End of update loop 0.01 ms Waiting for query cache lock 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.69 ms closing tables 0.03 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.02 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.54 ms Utolsó lekérdezés után: 1.29 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 2.305 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.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.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.07 ms End of update loop 0.01 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.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 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.52 ms Utolsó lekérdezés után: 0.31 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 2.318 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.02 ms Opening tables 0.02 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.07 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.06 ms End of update loop 0.01 ms Query end 0.02 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: 0.77 ms Utolsó lekérdezés után: 11.56 ms Memória lekérdezése: 0.027 MB memória a lekérdezés előtt: 2.811 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.11 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.03 ms Optimizing 0.03 ms Statistics 0.02 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.02 ms Sending data 0.01 ms Creating sort index 0.14 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 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/category/view.html.php:60 10 PhocaGalleryViewCategory->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.47 ms Utolsó lekérdezés után: 4.36 ms Memória lekérdezése: 0.032 MB memória a lekérdezés előtt: 2.839 MB Visszaadott sorok: 0Duplikált lekérdezések: #15
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.09 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.04 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.01 ms Executing 0.02 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 Updating status 0.02 ms Reset for next command 0.01 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/category/view.html.php:200 10 PhocaGalleryViewCategory->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.23 ms Utolsó lekérdezés után: 0.04 ms Memória lekérdezése: 0.032 MB memória a lekérdezés előtt: 2.848 MB Visszaadott sorok: 0Duplikált lekérdezések: #14
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.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 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.01 ms Freeing items 0.01 ms Updating status 0.01 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: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/category/view.html.php:200 10 PhocaGalleryViewCategory->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.71 ms Utolsó lekérdezés után: 13.74 ms Memória lekérdezése: 0.032 MB memória a lekérdezés előtt: 2.883 MB Visszaadott sorok: 1
SELECT c.id, c.title, c.alias, c.description, c.published, c.approved, c.parent_id, c.deleteuserid, c.accessuserid, c.uploaduserid, c.access, c.metakey, c.metadesc, c.latitude, c.longitude, c.zoom, c.geotitle, c.userfolder,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM m4qou_phocagallery_categories AS c
WHERE c.id = 52
LIMIT 0, 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.14 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.03 ms init 0.06 ms Optimizing 0.06 ms Statistics 0.06 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.05 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.02 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/components/com_phocagallery/models/category.php:212 13 PhocagalleryModelCategory->_loadCategory() JROOT/components/com_phocagallery/models/category.php:169 12 PhocagalleryModelCategory->getCategory() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_phocagallery/views/category/view.html.php:371 10 PhocaGalleryViewCategory->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.31 ms Utolsó lekérdezés után: 0.15 ms Memória lekérdezése: 0.040 MB memória a lekérdezés előtt: 2.898 MB Visszaadott sorok: 1
SELECT *
FROM m4qou_phocagallery_categories AS c
WHERE c.id = 180
AND c.published = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.03 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Unlocking tables 0.02 ms Preparing 0.01 ms Executing 0.00 ms Sending data 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.01 ms Starting cleanup 0.00 ms Freeing items 0.01 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/components/com_phocagallery/views/category/view.html.php:2054 11 PhocaGalleryViewCategory->_addBreadCrumbs() JROOT/components/com_phocagallery/views/category/view.html.php:421 10 PhocaGalleryViewCategory->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.43 ms Utolsó lekérdezés után: 2.46 ms Memória lekérdezése: 0.029 MB memória a lekérdezés előtt: 2.983 MB Visszaadott sorok: 1
SELECT cc.id, cc.title, cc.alias, cc.published, cc.approved, cc.parent_id, cc.deleteuserid, cc.accessuserid, cc.uploaduserid, cc.access
FROM m4qou_phocagallery_categories AS cc
WHERE cc.id = 180
AND cc.published = 1
AND cc.approved = 1
AND cc.id <> 52
ORDER BY cc.ordering ASC
LIMIT 0, 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE cc const PRIMARY PRIMARY 4 const 1 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.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.01 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 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_phocagallery/models/category.php:240 12 PhocagalleryModelCategory->getParentCategory() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_phocagallery/views/category/view.html.php:565 10 PhocaGalleryViewCategory->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: 1.52 ms Utolsó lekérdezés után: 0.56 ms Memória lekérdezése: 0.039 MB memória a lekérdezés előtt: 2.998 MB Visszaadott sorok: 21
SELECT cc.id, cc.title, cc.alias, cc.published, cc.approved, cc.parent_id, cc.deleteuserid, cc.accessuserid, cc.uploaduserid, cc.access, a.filename, a.extm, a.exts, a.extw, a.exth, a.extid
FROM m4qou_phocagallery_categories AS cc
LEFT JOIN m4qou_phocagallery AS a
ON cc.id = a.catid
WHERE cc.parent_id = 52
AND cc.published = 1
AND cc.approved = 1
AND cc.id <> 52
GROUP BY cc.id
ORDER BY cc.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE cc index PRIMARY PRIMARY 4 NULL 139 Using where; Using temporary; Fájlrendezés használata 1 SIMPLE a ref catid catid 4 c7kellalapitvany.cc.id 7 Status Duration Starting 0.05 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.04 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.03 ms Creating tmp table 0.05 ms Sorting for group 0.01 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.88 ms Creating sort index 0.07 ms Removing tmp table 0.11 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.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 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/components/com_phocagallery/models/category.php:282 12 PhocagalleryModelCategory->getSubCategory() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_phocagallery/views/category/view.html.php:723 10 PhocaGalleryViewCategory->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.38 ms Utolsó lekérdezés után: 0.14 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.044 MB Visszaadott sorok: 1Duplikált lekérdezések: #21
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 77id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 20 Using where Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.04 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.05 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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 12 JDatabase->query() JROOT/components/com_phocagallery/models/category.php:300 11 PhocagalleryModelCategory->getCountItem() JROOT/components/com_phocagallery/views/category/view.html.php:753 10 PhocaGalleryViewCategory->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.31 ms Utolsó lekérdezés után: 0.04 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.053 MB Visszaadott sorok: 1Duplikált lekérdezések: #20
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 77id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 20 Using where Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.06 ms Starting cleanup 0.00 ms Freeing items 0.01 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:1773 12 JDatabaseDriver->loadRow() JROOT/components/com_phocagallery/models/category.php:304 11 PhocagalleryModelCategory->getCountItem() JROOT/components/com_phocagallery/views/category/view.html.php:753 10 PhocaGalleryViewCategory->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: 1.00 ms Utolsó lekérdezés után: 0.11 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 3.063 MB Visszaadott sorok: 1
SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM m4qou_phocagallery AS a
LEFT JOIN m4qou_phocagallery_categories AS c
ON a.catid = c.id
WHERE a.catid = 77
AND a.published = 1
AND a.approved = 1
ORDER BY RAND()
LIMIT 0,1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 20 Using where; Using temporary; Fájlrendezés használata 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 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.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.02 ms Creating tmp table 0.06 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.35 ms Creating sort index 0.04 ms End of update loop 0.01 ms Removing tmp table 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.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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:457 11 PhocaGalleryImageFront::getRandomImageRecursive() JROOT/components/com_phocagallery/views/category/view.html.php:793 10 PhocaGalleryViewCategory->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.38 ms Utolsó lekérdezés után: 1.32 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.075 MB Visszaadott sorok: 1Duplikált lekérdezések: #24
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 78id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 17 Using where Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.02 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.05 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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 12 JDatabase->query() JROOT/components/com_phocagallery/models/category.php:300 11 PhocagalleryModelCategory->getCountItem() JROOT/components/com_phocagallery/views/category/view.html.php:753 10 PhocaGalleryViewCategory->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.27 ms Utolsó lekérdezés után: 0.04 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.083 MB Visszaadott sorok: 1Duplikált lekérdezések: #23
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 78id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 17 Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.04 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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1773 12 JDatabaseDriver->loadRow() JROOT/components/com_phocagallery/models/category.php:304 11 PhocagalleryModelCategory->getCountItem() JROOT/components/com_phocagallery/views/category/view.html.php:753 10 PhocaGalleryViewCategory->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.85 ms Utolsó lekérdezés után: 0.06 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 3.092 MB Visszaadott sorok: 1
SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM m4qou_phocagallery AS a
LEFT JOIN m4qou_phocagallery_categories AS c
ON a.catid = c.id
WHERE a.catid = 78
AND a.published = 1
AND a.approved = 1
ORDER BY RAND()
LIMIT 0,1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 17 Using where; Using temporary; Fájlrendezés használata 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.05 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.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Creating tmp table 0.10 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.31 ms Creating sort index 0.03 ms End of update loop 0.01 ms Removing tmp table 0.09 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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:457 11 PhocaGalleryImageFront::getRandomImageRecursive() JROOT/components/com_phocagallery/views/category/view.html.php:793 10 PhocaGalleryViewCategory->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.29 ms Utolsó lekérdezés után: 0.71 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.103 MB Visszaadott sorok: 1Duplikált lekérdezések: #27
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 79id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 16 Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.04 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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 12 JDatabase->query() JROOT/components/com_phocagallery/models/category.php:300 11 PhocagalleryModelCategory->getCountItem() JROOT/components/com_phocagallery/views/category/view.html.php:753 10 PhocaGalleryViewCategory->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.03 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.112 MB Visszaadott sorok: 1Duplikált lekérdezések: #26
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 79id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 16 Using where Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.05 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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1773 12 JDatabaseDriver->loadRow() JROOT/components/com_phocagallery/models/category.php:304 11 PhocagalleryModelCategory->getCountItem() JROOT/components/com_phocagallery/views/category/view.html.php:753 10 PhocaGalleryViewCategory->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.98 ms Utolsó lekérdezés után: 0.10 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 3.121 MB Visszaadott sorok: 1
SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM m4qou_phocagallery AS a
LEFT JOIN m4qou_phocagallery_categories AS c
ON a.catid = c.id
WHERE a.catid = 79
AND a.published = 1
AND a.approved = 1
ORDER BY RAND()
LIMIT 0,1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 16 Using where; Using temporary; Fájlrendezés használata 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.06 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.03 ms Optimizing 0.02 ms Statistics 0.07 ms Preparing 0.02 ms Creating tmp table 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.41 ms Creating sort index 0.04 ms End of update loop 0.01 ms Removing tmp table 0.10 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.02 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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:457 11 PhocaGalleryImageFront::getRandomImageRecursive() JROOT/components/com_phocagallery/views/category/view.html.php:793 10 PhocaGalleryViewCategory->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: 0.70 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.132 MB Visszaadott sorok: 1Duplikált lekérdezések: #30
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 80id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 20 Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.05 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.03 ms Reset for next command 0.01 ms # Hívó Fájl és sorok száma 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 12 JDatabase->query() JROOT/components/com_phocagallery/models/category.php:300 11 PhocagalleryModelCategory->getCountItem() JROOT/components/com_phocagallery/views/category/view.html.php:753 10 PhocaGalleryViewCategory->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.30 ms Utolsó lekérdezés után: 0.06 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.140 MB Visszaadott sorok: 1Duplikált lekérdezések: #29
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 80id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 20 Using where Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.05 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.04 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.00 ms # Hívó Fájl és sorok száma 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1773 12 JDatabaseDriver->loadRow() JROOT/components/com_phocagallery/models/category.php:304 11 PhocagalleryModelCategory->getCountItem() JROOT/components/com_phocagallery/views/category/view.html.php:753 10 PhocaGalleryViewCategory->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: 1.20 ms Utolsó lekérdezés után: 0.09 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 3.149 MB Visszaadott sorok: 1
SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM m4qou_phocagallery AS a
LEFT JOIN m4qou_phocagallery_categories AS c
ON a.catid = c.id
WHERE a.catid = 80
AND a.published = 1
AND a.approved = 1
ORDER BY RAND()
LIMIT 0,1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 20 Using where; Using temporary; Fájlrendezés használata 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.08 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.02 ms Statistics 0.07 ms Preparing 0.03 ms Creating tmp table 0.05 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.49 ms Creating sort index 0.06 ms End of update loop 0.01 ms Removing tmp table 0.12 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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:457 11 PhocaGalleryImageFront::getRandomImageRecursive() JROOT/components/com_phocagallery/views/category/view.html.php:793 10 PhocaGalleryViewCategory->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.47 ms Utolsó lekérdezés után: 0.76 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.160 MB Visszaadott sorok: 1Duplikált lekérdezések: #33
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 81id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 20 Using where Status Duration Starting 0.06 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.03 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.03 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.01 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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 12 JDatabase->query() JROOT/components/com_phocagallery/models/category.php:300 11 PhocagalleryModelCategory->getCountItem() JROOT/components/com_phocagallery/views/category/view.html.php:753 10 PhocaGalleryViewCategory->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: 0.06 ms Memória lekérdezése: 0.027 MB memória a lekérdezés előtt: 3.175 MB Visszaadott sorok: 1Duplikált lekérdezések: #32
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 81id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 20 Using where Status Duration Starting 0.03 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 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 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.00 ms Unlocking tables 0.00 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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1773 12 JDatabaseDriver->loadRow() JROOT/components/com_phocagallery/models/category.php:304 11 PhocagalleryModelCategory->getCountItem() JROOT/components/com_phocagallery/views/category/view.html.php:753 10 PhocaGalleryViewCategory->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: 1.08 ms Utolsó lekérdezés után: 0.07 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 3.186 MB Visszaadott sorok: 1
SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM m4qou_phocagallery AS a
LEFT JOIN m4qou_phocagallery_categories AS c
ON a.catid = c.id
WHERE a.catid = 81
AND a.published = 1
AND a.approved = 1
ORDER BY RAND()
LIMIT 0,1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 20 Using where; Using temporary; Fájlrendezés használata 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 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.03 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.02 ms Creating tmp table 0.04 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.46 ms Creating sort index 0.05 ms End of update loop 0.01 ms Removing tmp table 0.11 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.01 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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:457 11 PhocaGalleryImageFront::getRandomImageRecursive() JROOT/components/com_phocagallery/views/category/view.html.php:793 10 PhocaGalleryViewCategory->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.43 ms Utolsó lekérdezés után: 0.85 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.196 MB Visszaadott sorok: 1Duplikált lekérdezések: #36
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 82id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 7 Using where Status Duration Starting 0.06 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.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.04 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.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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 12 JDatabase->query() JROOT/components/com_phocagallery/models/category.php:300 11 PhocagalleryModelCategory->getCountItem() JROOT/components/com_phocagallery/views/category/view.html.php:753 10 PhocaGalleryViewCategory->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.41 ms Utolsó lekérdezés után: 0.06 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.205 MB Visszaadott sorok: 1Duplikált lekérdezések: #35
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 82id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 7 Using where Status Duration Starting 0.05 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 0.02 ms Optimizing 0.09 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.04 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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1773 12 JDatabaseDriver->loadRow() JROOT/components/com_phocagallery/models/category.php:304 11 PhocagalleryModelCategory->getCountItem() JROOT/components/com_phocagallery/views/category/view.html.php:753 10 PhocaGalleryViewCategory->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: 1.15 ms Utolsó lekérdezés után: 0.08 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 3.214 MB Visszaadott sorok: 1
SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM m4qou_phocagallery AS a
LEFT JOIN m4qou_phocagallery_categories AS c
ON a.catid = c.id
WHERE a.catid = 82
AND a.published = 1
AND a.approved = 1
ORDER BY RAND()
LIMIT 0,1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 7 Using where; Using temporary; Fájlrendezés használata 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.06 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.03 ms Optimizing 0.02 ms Statistics 0.08 ms Preparing 0.02 ms Creating tmp table 0.04 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.48 ms Creating sort index 0.05 ms End of update loop 0.01 ms Removing tmp table 0.13 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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:457 11 PhocaGalleryImageFront::getRandomImageRecursive() JROOT/components/com_phocagallery/views/category/view.html.php:793 10 PhocaGalleryViewCategory->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.43 ms Utolsó lekérdezés után: 0.79 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.225 MB Visszaadott sorok: 1Duplikált lekérdezések: #39
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 83id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 19 Using where Status Duration Starting 0.06 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.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.07 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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 12 JDatabase->query() JROOT/components/com_phocagallery/models/category.php:300 11 PhocagalleryModelCategory->getCountItem() JROOT/components/com_phocagallery/views/category/view.html.php:753 10 PhocaGalleryViewCategory->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.31 ms Utolsó lekérdezés után: 0.03 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.234 MB Visszaadott sorok: 1Duplikált lekérdezések: #38
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 83id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 19 Using where Status Duration Starting 0.03 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 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.00 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.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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1773 12 JDatabaseDriver->loadRow() JROOT/components/com_phocagallery/models/category.php:304 11 PhocagalleryModelCategory->getCountItem() JROOT/components/com_phocagallery/views/category/view.html.php:753 10 PhocaGalleryViewCategory->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: 1.05 ms Utolsó lekérdezés után: 0.07 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 3.243 MB Visszaadott sorok: 1
SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM m4qou_phocagallery AS a
LEFT JOIN m4qou_phocagallery_categories AS c
ON a.catid = c.id
WHERE a.catid = 83
AND a.published = 1
AND a.approved = 1
ORDER BY RAND()
LIMIT 0,1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 19 Using where; Using temporary; Fájlrendezés használata 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.06 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.03 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.02 ms Creating tmp table 0.05 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.42 ms Creating sort index 0.05 ms End of update loop 0.01 ms Removing tmp table 0.15 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.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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:457 11 PhocaGalleryImageFront::getRandomImageRecursive() JROOT/components/com_phocagallery/views/category/view.html.php:793 10 PhocaGalleryViewCategory->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.43 ms Utolsó lekérdezés után: 0.79 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.254 MB Visszaadott sorok: 1Duplikált lekérdezések: #42
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 84id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 17 Using where Status Duration Starting 0.06 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.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.02 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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 12 JDatabase->query() JROOT/components/com_phocagallery/models/category.php:300 11 PhocagalleryModelCategory->getCountItem() JROOT/components/com_phocagallery/views/category/view.html.php:753 10 PhocaGalleryViewCategory->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.29 ms Utolsó lekérdezés után: 0.04 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.263 MB Visszaadott sorok: 1Duplikált lekérdezések: #41
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 84id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 17 Using where Status Duration Starting 0.03 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 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.00 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.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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1773 12 JDatabaseDriver->loadRow() JROOT/components/com_phocagallery/models/category.php:304 11 PhocagalleryModelCategory->getCountItem() JROOT/components/com_phocagallery/views/category/view.html.php:753 10 PhocaGalleryViewCategory->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: 1.09 ms Utolsó lekérdezés után: 0.08 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 3.272 MB Visszaadott sorok: 1
SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM m4qou_phocagallery AS a
LEFT JOIN m4qou_phocagallery_categories AS c
ON a.catid = c.id
WHERE a.catid = 84
AND a.published = 1
AND a.approved = 1
ORDER BY RAND()
LIMIT 0,1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 17 Using where; Using temporary; Fájlrendezés használata 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.06 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.03 ms Optimizing 0.02 ms Statistics 0.12 ms Preparing 0.02 ms Creating tmp table 0.05 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.41 ms Creating sort index 0.06 ms End of update loop 0.01 ms Removing tmp table 0.12 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.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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:457 11 PhocaGalleryImageFront::getRandomImageRecursive() JROOT/components/com_phocagallery/views/category/view.html.php:793 10 PhocaGalleryViewCategory->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.46 ms Utolsó lekérdezés után: 0.79 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.283 MB Visszaadott sorok: 1Duplikált lekérdezések: #45
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 85id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 11 Using where Status Duration Starting 0.06 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.03 ms Optimizing 0.02 ms Statistics 0.07 ms Preparing 0.02 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.02 ms Reset for next command 0.01 ms # Hívó Fájl és sorok száma 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 12 JDatabase->query() JROOT/components/com_phocagallery/models/category.php:300 11 PhocagalleryModelCategory->getCountItem() JROOT/components/com_phocagallery/views/category/view.html.php:753 10 PhocaGalleryViewCategory->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.29 ms Utolsó lekérdezés után: 0.04 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.291 MB Visszaadott sorok: 1Duplikált lekérdezések: #44
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 85id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 11 Using where Status Duration Starting 0.03 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 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.01 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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1773 12 JDatabaseDriver->loadRow() JROOT/components/com_phocagallery/models/category.php:304 11 PhocagalleryModelCategory->getCountItem() JROOT/components/com_phocagallery/views/category/view.html.php:753 10 PhocaGalleryViewCategory->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.98 ms Utolsó lekérdezés után: 0.06 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 3.300 MB Visszaadott sorok: 1
SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM m4qou_phocagallery AS a
LEFT JOIN m4qou_phocagallery_categories AS c
ON a.catid = c.id
WHERE a.catid = 85
AND a.published = 1
AND a.approved = 1
ORDER BY RAND()
LIMIT 0,1id 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 c const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.06 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.02 ms Statistics 0.04 ms Preparing 0.02 ms Creating tmp table 0.05 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.41 ms Creating sort index 0.06 ms End of update loop 0.01 ms Removing tmp table 0.12 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.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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:457 11 PhocaGalleryImageFront::getRandomImageRecursive() JROOT/components/com_phocagallery/views/category/view.html.php:793 10 PhocaGalleryViewCategory->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.37 ms Utolsó lekérdezés után: 0.76 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.311 MB Visszaadott sorok: 1Duplikált lekérdezések: #48
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 86id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 12 Using where Status Duration Starting 0.05 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.02 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.05 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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 12 JDatabase->query() JROOT/components/com_phocagallery/models/category.php:300 11 PhocagalleryModelCategory->getCountItem() JROOT/components/com_phocagallery/views/category/view.html.php:753 10 PhocaGalleryViewCategory->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.29 ms Utolsó lekérdezés után: 0.03 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.320 MB Visszaadott sorok: 1Duplikált lekérdezések: #47
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 86id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 12 Using where Status Duration Starting 0.03 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 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.04 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 Updating status 0.02 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:1773 12 JDatabaseDriver->loadRow() JROOT/components/com_phocagallery/models/category.php:304 11 PhocagalleryModelCategory->getCountItem() JROOT/components/com_phocagallery/views/category/view.html.php:753 10 PhocaGalleryViewCategory->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: 1.12 ms Utolsó lekérdezés után: 0.07 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 3.329 MB Visszaadott sorok: 1
SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM m4qou_phocagallery AS a
LEFT JOIN m4qou_phocagallery_categories AS c
ON a.catid = c.id
WHERE a.catid = 86
AND a.published = 1
AND a.approved = 1
ORDER BY RAND()
LIMIT 0,1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 12 Using where; Using temporary; Fájlrendezés használata 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.06 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.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Creating tmp table 0.04 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.41 ms Creating sort index 0.06 ms End of update loop 0.01 ms Removing tmp table 0.16 ms End of update loop 0.01 ms Query end 0.07 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.02 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_phocagallery/libraries/phocagallery/image/imagefront.php:457 11 PhocaGalleryImageFront::getRandomImageRecursive() JROOT/components/com_phocagallery/views/category/view.html.php:793 10 PhocaGalleryViewCategory->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.42 ms Utolsó lekérdezés után: 0.73 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.340 MB Visszaadott sorok: 1Duplikált lekérdezések: #51
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 87id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 4 Using where Status Duration Starting 0.10 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.03 ms Optimizing 0.02 ms Statistics 0.04 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.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.02 ms Reset for next command 0.01 ms # Hívó Fájl és sorok száma 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 12 JDatabase->query() JROOT/components/com_phocagallery/models/category.php:300 11 PhocagalleryModelCategory->getCountItem() JROOT/components/com_phocagallery/views/category/view.html.php:753 10 PhocaGalleryViewCategory->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.28 ms Utolsó lekérdezés után: 0.03 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.348 MB Visszaadott sorok: 1Duplikált lekérdezések: #50
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 87id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 4 Using where Status Duration Starting 0.03 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 0.02 ms Optimizing 0.01 ms Statistics 0.03 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.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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1773 12 JDatabaseDriver->loadRow() JROOT/components/com_phocagallery/models/category.php:304 11 PhocagalleryModelCategory->getCountItem() JROOT/components/com_phocagallery/views/category/view.html.php:753 10 PhocaGalleryViewCategory->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: 1.01 ms Utolsó lekérdezés után: 0.06 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 3.357 MB Visszaadott sorok: 1
SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM m4qou_phocagallery AS a
LEFT JOIN m4qou_phocagallery_categories AS c
ON a.catid = c.id
WHERE a.catid = 87
AND a.published = 1
AND a.approved = 1
ORDER BY RAND()
LIMIT 0,1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 4 Using where; Using temporary; Fájlrendezés használata 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.06 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.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.02 ms Creating tmp table 0.04 ms Sorting result 0.01 ms Executing 0.06 ms Sending data 0.39 ms Creating sort index 0.04 ms End of update loop 0.01 ms Removing tmp table 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.01 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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:457 11 PhocaGalleryImageFront::getRandomImageRecursive() JROOT/components/com_phocagallery/views/category/view.html.php:793 10 PhocaGalleryViewCategory->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.38 ms Utolsó lekérdezés után: 0.69 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.368 MB Visszaadott sorok: 1Duplikált lekérdezések: #54
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 88id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 12 Using where Status Duration Starting 0.05 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.02 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.05 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.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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 12 JDatabase->query() JROOT/components/com_phocagallery/models/category.php:300 11 PhocagalleryModelCategory->getCountItem() JROOT/components/com_phocagallery/views/category/view.html.php:753 10 PhocaGalleryViewCategory->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.34 ms Utolsó lekérdezés után: 0.04 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.377 MB Visszaadott sorok: 1Duplikált lekérdezések: #53
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 88id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 12 Using where Status Duration Starting 0.03 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 0.04 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.05 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.02 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:1773 12 JDatabaseDriver->loadRow() JROOT/components/com_phocagallery/models/category.php:304 11 PhocagalleryModelCategory->getCountItem() JROOT/components/com_phocagallery/views/category/view.html.php:753 10 PhocaGalleryViewCategory->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: 1.05 ms Utolsó lekérdezés után: 0.07 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 3.386 MB Visszaadott sorok: 1
SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM m4qou_phocagallery AS a
LEFT JOIN m4qou_phocagallery_categories AS c
ON a.catid = c.id
WHERE a.catid = 88
AND a.published = 1
AND a.approved = 1
ORDER BY RAND()
LIMIT 0,1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 12 Using where; Using temporary; Fájlrendezés használata 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.06 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.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.02 ms Creating tmp table 0.05 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.44 ms Creating sort index 0.07 ms End of update loop 0.01 ms Removing tmp table 0.12 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.02 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_phocagallery/libraries/phocagallery/image/imagefront.php:457 11 PhocaGalleryImageFront::getRandomImageRecursive() JROOT/components/com_phocagallery/views/category/view.html.php:793 10 PhocaGalleryViewCategory->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.34 ms Utolsó lekérdezés után: 0.67 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.397 MB Visszaadott sorok: 1Duplikált lekérdezések: #57
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 89id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 9 Using where Status Duration Starting 0.04 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 0.02 ms Optimizing 0.02 ms Statistics 0.03 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.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.02 ms Reset for next command 0.01 ms # Hívó Fájl és sorok száma 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 12 JDatabase->query() JROOT/components/com_phocagallery/models/category.php:300 11 PhocagalleryModelCategory->getCountItem() JROOT/components/com_phocagallery/views/category/view.html.php:753 10 PhocaGalleryViewCategory->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.29 ms Utolsó lekérdezés után: 0.03 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.405 MB Visszaadott sorok: 1Duplikált lekérdezések: #56
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 89id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 9 Using where Status Duration Starting 0.03 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 0.02 ms Optimizing 0.01 ms Statistics 0.03 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.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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1773 12 JDatabaseDriver->loadRow() JROOT/components/com_phocagallery/models/category.php:304 11 PhocagalleryModelCategory->getCountItem() JROOT/components/com_phocagallery/views/category/view.html.php:753 10 PhocaGalleryViewCategory->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.94 ms Utolsó lekérdezés után: 0.05 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 3.414 MB Visszaadott sorok: 1
SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM m4qou_phocagallery AS a
LEFT JOIN m4qou_phocagallery_categories AS c
ON a.catid = c.id
WHERE a.catid = 89
AND a.published = 1
AND a.approved = 1
ORDER BY RAND()
LIMIT 0,1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 9 Using where; Using temporary; Fájlrendezés használata 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.06 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.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Creating tmp table 0.04 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.39 ms Creating sort index 0.05 ms End of update loop 0.01 ms Removing tmp table 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.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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:457 11 PhocaGalleryImageFront::getRandomImageRecursive() JROOT/components/com_phocagallery/views/category/view.html.php:793 10 PhocaGalleryViewCategory->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.37 ms Utolsó lekérdezés után: 0.71 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.425 MB Visszaadott sorok: 1Duplikált lekérdezések: #60
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 90id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 9 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.02 ms Optimizing 0.02 ms Statistics 0.04 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.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.02 ms Reset for next command 0.01 ms # Hívó Fájl és sorok száma 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 12 JDatabase->query() JROOT/components/com_phocagallery/models/category.php:300 11 PhocagalleryModelCategory->getCountItem() JROOT/components/com_phocagallery/views/category/view.html.php:753 10 PhocaGalleryViewCategory->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.04 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.434 MB Visszaadott sorok: 1Duplikált lekérdezések: #59
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 90id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 9 Using where Status Duration Starting 0.03 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 0.02 ms Optimizing 0.02 ms Statistics 0.03 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.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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1773 12 JDatabaseDriver->loadRow() JROOT/components/com_phocagallery/models/category.php:304 11 PhocagalleryModelCategory->getCountItem() JROOT/components/com_phocagallery/views/category/view.html.php:753 10 PhocaGalleryViewCategory->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.06 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 3.443 MB Visszaadott sorok: 1
SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM m4qou_phocagallery AS a
LEFT JOIN m4qou_phocagallery_categories AS c
ON a.catid = c.id
WHERE a.catid = 90
AND a.published = 1
AND a.approved = 1
ORDER BY RAND()
LIMIT 0,1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 9 Using where; Using temporary; Fájlrendezés használata 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.06 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.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Creating tmp table 0.04 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.37 ms Creating sort index 0.05 ms End of update loop 0.01 ms Removing tmp table 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.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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:457 11 PhocaGalleryImageFront::getRandomImageRecursive() JROOT/components/com_phocagallery/views/category/view.html.php:793 10 PhocaGalleryViewCategory->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.38 ms Utolsó lekérdezés után: 0.71 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.454 MB Visszaadott sorok: 1Duplikált lekérdezések: #63
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 91id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 14 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.02 ms Optimizing 0.02 ms Statistics 0.04 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.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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 12 JDatabase->query() JROOT/components/com_phocagallery/models/category.php:300 11 PhocagalleryModelCategory->getCountItem() JROOT/components/com_phocagallery/views/category/view.html.php:753 10 PhocaGalleryViewCategory->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.31 ms Utolsó lekérdezés után: 0.03 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.462 MB Visszaadott sorok: 1Duplikált lekérdezések: #62
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 91id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 14 Using where Status Duration Starting 0.03 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 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.05 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.02 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:1773 12 JDatabaseDriver->loadRow() JROOT/components/com_phocagallery/models/category.php:304 11 PhocagalleryModelCategory->getCountItem() JROOT/components/com_phocagallery/views/category/view.html.php:753 10 PhocaGalleryViewCategory->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: 1.04 ms Utolsó lekérdezés után: 0.05 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 3.471 MB Visszaadott sorok: 1
SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM m4qou_phocagallery AS a
LEFT JOIN m4qou_phocagallery_categories AS c
ON a.catid = c.id
WHERE a.catid = 91
AND a.published = 1
AND a.approved = 1
ORDER BY RAND()
LIMIT 0,1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 14 Using where; Using temporary; Fájlrendezés használata 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.06 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.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Creating tmp table 0.04 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.47 ms Creating sort index 0.06 ms End of update loop 0.01 ms Removing tmp table 0.12 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.02 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_phocagallery/libraries/phocagallery/image/imagefront.php:457 11 PhocaGalleryImageFront::getRandomImageRecursive() JROOT/components/com_phocagallery/views/category/view.html.php:793 10 PhocaGalleryViewCategory->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.35 ms Utolsó lekérdezés után: 0.66 ms Memória lekérdezése: 0.031 MB memória a lekérdezés előtt: 3.493 MB Visszaadott sorok: 1Duplikált lekérdezések: #66
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 92id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 11 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.02 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.05 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.02 ms Reset for next command 0.01 ms # Hívó Fájl és sorok száma 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 12 JDatabase->query() JROOT/components/com_phocagallery/models/category.php:300 11 PhocagalleryModelCategory->getCountItem() JROOT/components/com_phocagallery/views/category/view.html.php:753 10 PhocaGalleryViewCategory->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.31 ms Utolsó lekérdezés után: 0.03 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.507 MB Visszaadott sorok: 1Duplikált lekérdezések: #65
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 92id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 11 Using where Status Duration Starting 0.03 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 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.05 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.02 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:1773 12 JDatabaseDriver->loadRow() JROOT/components/com_phocagallery/models/category.php:304 11 PhocagalleryModelCategory->getCountItem() JROOT/components/com_phocagallery/views/category/view.html.php:753 10 PhocaGalleryViewCategory->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.93 ms Utolsó lekérdezés után: 0.05 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 3.516 MB Visszaadott sorok: 1
SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM m4qou_phocagallery AS a
LEFT JOIN m4qou_phocagallery_categories AS c
ON a.catid = c.id
WHERE a.catid = 92
AND a.published = 1
AND a.approved = 1
ORDER BY RAND()
LIMIT 0,1id 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 c const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.06 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.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Creating tmp table 0.04 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.35 ms Creating sort index 0.05 ms End of update loop 0.01 ms Removing tmp table 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.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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:457 11 PhocaGalleryImageFront::getRandomImageRecursive() JROOT/components/com_phocagallery/views/category/view.html.php:793 10 PhocaGalleryViewCategory->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.43 ms Utolsó lekérdezés után: 0.75 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.526 MB Visszaadott sorok: 1Duplikált lekérdezések: #69
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 93id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 1 Using where Status Duration Starting 0.05 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.02 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.01 ms Sending data 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.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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 12 JDatabase->query() JROOT/components/com_phocagallery/models/category.php:300 11 PhocagalleryModelCategory->getCountItem() JROOT/components/com_phocagallery/views/category/view.html.php:753 10 PhocaGalleryViewCategory->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.34 ms Utolsó lekérdezés után: 0.06 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.535 MB Visszaadott sorok: 1Duplikált lekérdezések: #68
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 93id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 1 Using where Status Duration Starting 0.04 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 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.01 ms Sending data 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.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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1773 12 JDatabaseDriver->loadRow() JROOT/components/com_phocagallery/models/category.php:304 11 PhocagalleryModelCategory->getCountItem() JROOT/components/com_phocagallery/views/category/view.html.php:753 10 PhocaGalleryViewCategory->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.94 ms Utolsó lekérdezés után: 0.11 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 3.544 MB Visszaadott sorok: 0
SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM m4qou_phocagallery AS a
LEFT JOIN m4qou_phocagallery_categories AS c
ON a.catid = c.id
WHERE a.catid = 93
AND a.published = 1
AND a.approved = 1
ORDER BY RAND()
LIMIT 0,1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 1 Using where; Using temporary; Fájlrendezés használata 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.06 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.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.02 ms Creating tmp table 0.04 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.35 ms Creating sort index 0.06 ms End of update loop 0.01 ms Removing tmp table 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.02 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_phocagallery/libraries/phocagallery/image/imagefront.php:457 11 PhocaGalleryImageFront::getRandomImageRecursive() JROOT/components/com_phocagallery/views/category/view.html.php:793 10 PhocaGalleryViewCategory->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.65 ms Utolsó lekérdezés után: 0.10 ms Memória lekérdezése: 0.027 MB memória a lekérdezés előtt: 3.553 MB Visszaadott sorok: 0
SELECT a.id, a.extid
FROM m4qou_phocagallery_categories AS a
WHERE a.parent_id = 93
AND a.published = 1
AND a.access IN(1,1,5)
ORDER BY RAND()id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL idx_access NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 139 Using where; Using temporary; Fájlrendezés használata Status Duration Starting 0.05 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.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.02 ms Creating tmp table 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.24 ms Creating sort index 0.03 ms End of update loop 0.01 ms Removing tmp table 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.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 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:537 12 PhocaGalleryImageFront::getRandomCategory() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:482 11 PhocaGalleryImageFront::getRandomImageRecursive() JROOT/components/com_phocagallery/views/category/view.html.php:793 10 PhocaGalleryViewCategory->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.37 ms Utolsó lekérdezés után: 0.73 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.564 MB Visszaadott sorok: 1Duplikált lekérdezések: #73
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 94id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 1 Using where Status Duration Starting 0.05 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.02 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.03 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.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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 12 JDatabase->query() JROOT/components/com_phocagallery/models/category.php:300 11 PhocagalleryModelCategory->getCountItem() JROOT/components/com_phocagallery/views/category/view.html.php:753 10 PhocaGalleryViewCategory->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.28 ms Utolsó lekérdezés után: 0.04 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.573 MB Visszaadott sorok: 1Duplikált lekérdezések: #72
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 94id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 1 Using where Status Duration Starting 0.03 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 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.01 ms Sending data 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.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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1773 12 JDatabaseDriver->loadRow() JROOT/components/com_phocagallery/models/category.php:304 11 PhocagalleryModelCategory->getCountItem() JROOT/components/com_phocagallery/views/category/view.html.php:753 10 PhocaGalleryViewCategory->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.90 ms Utolsó lekérdezés után: 0.06 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 3.582 MB Visszaadott sorok: 0
SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM m4qou_phocagallery AS a
LEFT JOIN m4qou_phocagallery_categories AS c
ON a.catid = c.id
WHERE a.catid = 94
AND a.published = 1
AND a.approved = 1
ORDER BY RAND()
LIMIT 0,1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 1 Using where; Using temporary; Fájlrendezés használata 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.05 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.03 ms Optimizing 0.04 ms Statistics 0.05 ms Preparing 0.02 ms Creating tmp table 0.04 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.29 ms Creating sort index 0.05 ms End of update loop 0.01 ms Removing tmp table 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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:457 11 PhocaGalleryImageFront::getRandomImageRecursive() JROOT/components/com_phocagallery/views/category/view.html.php:793 10 PhocaGalleryViewCategory->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.52 ms Utolsó lekérdezés után: 0.11 ms Memória lekérdezése: 0.027 MB memória a lekérdezés előtt: 3.591 MB Visszaadott sorok: 0
SELECT a.id, a.extid
FROM m4qou_phocagallery_categories AS a
WHERE a.parent_id = 94
AND a.published = 1
AND a.access IN(1,1,5)
ORDER BY RAND()id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL idx_access NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 139 Using where; Using temporary; Fájlrendezés használata Status Duration Starting 0.05 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 0.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.03 ms Creating tmp table 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.11 ms Creating sort index 0.02 ms End of update loop 0.01 ms Removing tmp table 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.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 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:537 12 PhocaGalleryImageFront::getRandomCategory() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:482 11 PhocaGalleryImageFront::getRandomImageRecursive() JROOT/components/com_phocagallery/views/category/view.html.php:793 10 PhocaGalleryViewCategory->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.35 ms Utolsó lekérdezés után: 1.03 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.602 MB Visszaadott sorok: 1Duplikált lekérdezések: #77
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 95id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 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.02 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.03 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.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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 12 JDatabase->query() JROOT/components/com_phocagallery/models/category.php:300 11 PhocagalleryModelCategory->getCountItem() JROOT/components/com_phocagallery/views/category/view.html.php:753 10 PhocaGalleryViewCategory->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.40 ms Utolsó lekérdezés után: 0.05 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.610 MB Visszaadott sorok: 1Duplikált lekérdezések: #76
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 95id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 1 Using where Status Duration Starting 0.03 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 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.01 ms Sending data 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.01 ms Starting cleanup 0.02 ms Freeing items 0.07 ms Updating status 0.02 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:1773 12 JDatabaseDriver->loadRow() JROOT/components/com_phocagallery/models/category.php:304 11 PhocagalleryModelCategory->getCountItem() JROOT/components/com_phocagallery/views/category/view.html.php:753 10 PhocaGalleryViewCategory->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.98 ms Utolsó lekérdezés után: 0.10 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 3.619 MB Visszaadott sorok: 0
SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM m4qou_phocagallery AS a
LEFT JOIN m4qou_phocagallery_categories AS c
ON a.catid = c.id
WHERE a.catid = 95
AND a.published = 1
AND a.approved = 1
ORDER BY RAND()
LIMIT 0,1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 1 Using where; Using temporary; Fájlrendezés használata 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.06 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.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.02 ms Creating tmp table 0.04 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.32 ms Creating sort index 0.05 ms End of update loop 0.01 ms Removing tmp table 0.20 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.02 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_phocagallery/libraries/phocagallery/image/imagefront.php:457 11 PhocaGalleryImageFront::getRandomImageRecursive() JROOT/components/com_phocagallery/views/category/view.html.php:793 10 PhocaGalleryViewCategory->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.52 ms Utolsó lekérdezés után: 0.07 ms Memória lekérdezése: 0.027 MB memória a lekérdezés előtt: 3.629 MB Visszaadott sorok: 0
SELECT a.id, a.extid
FROM m4qou_phocagallery_categories AS a
WHERE a.parent_id = 95
AND a.published = 1
AND a.access IN(1,1,5)
ORDER BY RAND()id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL idx_access NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 139 Using where; Using temporary; Fájlrendezés használata 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.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.11 ms Creating sort index 0.01 ms End of update loop 0.01 ms Removing tmp table 0.01 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.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 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:537 12 PhocaGalleryImageFront::getRandomCategory() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:482 11 PhocaGalleryImageFront::getRandomImageRecursive() JROOT/components/com_phocagallery/views/category/view.html.php:793 10 PhocaGalleryViewCategory->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.44 ms Utolsó lekérdezés után: 0.98 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.639 MB Visszaadott sorok: 1Duplikált lekérdezések: #81
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 96id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 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.02 ms Optimizing 0.02 ms Statistics 0.05 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.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.08 ms Reset for next command 0.01 ms # Hívó Fájl és sorok száma 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 12 JDatabase->query() JROOT/components/com_phocagallery/models/category.php:300 11 PhocagalleryModelCategory->getCountItem() JROOT/components/com_phocagallery/views/category/view.html.php:753 10 PhocaGalleryViewCategory->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.29 ms Utolsó lekérdezés után: 0.05 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.648 MB Visszaadott sorok: 1Duplikált lekérdezések: #80
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 96id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 1 Using where Status Duration Starting 0.03 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 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.01 ms Sending data 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.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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1773 12 JDatabaseDriver->loadRow() JROOT/components/com_phocagallery/models/category.php:304 11 PhocagalleryModelCategory->getCountItem() JROOT/components/com_phocagallery/views/category/view.html.php:753 10 PhocaGalleryViewCategory->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.89 ms Utolsó lekérdezés után: 0.08 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 3.657 MB Visszaadott sorok: 0
SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM m4qou_phocagallery AS a
LEFT JOIN m4qou_phocagallery_categories AS c
ON a.catid = c.id
WHERE a.catid = 96
AND a.published = 1
AND a.approved = 1
ORDER BY RAND()
LIMIT 0,1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 1 Using where; Using temporary; Fájlrendezés használata 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.06 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.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Creating tmp table 0.04 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.33 ms Creating sort index 0.05 ms End of update loop 0.01 ms Removing tmp table 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.02 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_phocagallery/libraries/phocagallery/image/imagefront.php:457 11 PhocaGalleryImageFront::getRandomImageRecursive() JROOT/components/com_phocagallery/views/category/view.html.php:793 10 PhocaGalleryViewCategory->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.57 ms Utolsó lekérdezés után: 0.10 ms Memória lekérdezése: 0.027 MB memória a lekérdezés előtt: 3.666 MB Visszaadott sorok: 0
SELECT a.id, a.extid
FROM m4qou_phocagallery_categories AS a
WHERE a.parent_id = 96
AND a.published = 1
AND a.access IN(1,1,5)
ORDER BY RAND()id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL idx_access NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 139 Using where; Using temporary; Fájlrendezés használata Status Duration Starting 0.06 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Creating tmp table 0.02 ms Sorting result 0.04 ms Executing 0.01 ms Sending data 0.10 ms Creating sort index 0.02 ms End of update loop 0.01 ms Removing tmp table 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.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 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:537 12 PhocaGalleryImageFront::getRandomCategory() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:482 11 PhocaGalleryImageFront::getRandomImageRecursive() JROOT/components/com_phocagallery/views/category/view.html.php:793 10 PhocaGalleryViewCategory->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.37 ms Utolsó lekérdezés után: 0.97 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.677 MB Visszaadott sorok: 1Duplikált lekérdezések: #85
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 97id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 1 Using where Status Duration Starting 0.06 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.02 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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 12 JDatabase->query() JROOT/components/com_phocagallery/models/category.php:300 11 PhocagalleryModelCategory->getCountItem() JROOT/components/com_phocagallery/views/category/view.html.php:753 10 PhocaGalleryViewCategory->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.23 ms Utolsó lekérdezés után: 0.07 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.686 MB Visszaadott sorok: 1Duplikált lekérdezések: #84
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 97id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 1 Using where Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 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.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:1773 12 JDatabaseDriver->loadRow() JROOT/components/com_phocagallery/models/category.php:304 11 PhocagalleryModelCategory->getCountItem() JROOT/components/com_phocagallery/views/category/view.html.php:753 10 PhocaGalleryViewCategory->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.68 ms Utolsó lekérdezés után: 0.08 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 3.695 MB Visszaadott sorok: 0
SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM m4qou_phocagallery AS a
LEFT JOIN m4qou_phocagallery_categories AS c
ON a.catid = c.id
WHERE a.catid = 97
AND a.published = 1
AND a.approved = 1
ORDER BY RAND()
LIMIT 0,1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 1 Using where; Using temporary; Fájlrendezés használata 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.05 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.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Creating tmp table 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.23 ms Creating sort index 0.04 ms End of update loop 0.01 ms Removing tmp table 0.07 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.01 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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:457 11 PhocaGalleryImageFront::getRandomImageRecursive() JROOT/components/com_phocagallery/views/category/view.html.php:793 10 PhocaGalleryViewCategory->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.40 ms Utolsó lekérdezés után: 0.07 ms Memória lekérdezése: 0.027 MB memória a lekérdezés előtt: 3.704 MB Visszaadott sorok: 0
SELECT a.id, a.extid
FROM m4qou_phocagallery_categories AS a
WHERE a.parent_id = 97
AND a.published = 1
AND a.access IN(1,1,5)
ORDER BY RAND()id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL idx_access NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 139 Using where; Using temporary; Fájlrendezés használata Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.07 ms Creating sort index 0.01 ms End of update loop 0.01 ms Removing tmp table 0.01 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.00 ms # Hívó Fájl és sorok száma 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:537 12 PhocaGalleryImageFront::getRandomCategory() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:482 11 PhocaGalleryImageFront::getRandomImageRecursive() JROOT/components/com_phocagallery/views/category/view.html.php:793 10 PhocaGalleryViewCategory->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.94 ms Utolsó lekérdezés után: 0.98 ms Memória lekérdezése: 0.039 MB memória a lekérdezés előtt: 3.715 MB Visszaadott sorok: 0
SELECT a.*, cc.alias AS catalias, cc.accessuserid AS cataccessuserid, cc.access AS cataccess,
CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM m4qou_phocagallery AS a
LEFT JOIN m4qou_phocagallery_img_votes_statistics AS r
ON r.imgid = a.id
LEFT JOIN m4qou_phocagallery_categories AS cc
ON cc.id = a.catid
WHERE a.catid= 52
AND a.published = 1
AND a.approved = 1
ORDER BY a.ordering ASC
LIMIT 0, 20id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 1 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) 1 SIMPLE cc const PRIMARY PRIMARY 4 const 1 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.03 ms Statistics 0.04 ms Preparing 0.02 ms Creating tmp table 0.06 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.34 ms Creating sort index 0.04 ms Removing tmp table 0.06 ms Creating sort index 0.01 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 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 12 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/components/com_phocagallery/models/category.php:67 11 PhocagalleryModelCategory->getData() JROOT/components/com_phocagallery/views/category/view.html.php:940 10 PhocaGalleryViewCategory->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.90 ms Utolsó lekérdezés után: 1.16 ms Memória lekérdezése: 0.039 MB memória a lekérdezés előtt: 3.729 MB Visszaadott sorok: 0
SELECT a.*, cc.alias AS catalias, cc.accessuserid AS cataccessuserid, cc.access AS cataccess,
CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM m4qou_phocagallery AS a
LEFT JOIN m4qou_phocagallery_img_votes_statistics AS r
ON r.imgid = a.id
LEFT JOIN m4qou_phocagallery_categories AS cc
ON cc.id = a.catid
WHERE a.catid= 52
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 1 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) 1 SIMPLE cc const PRIMARY PRIMARY 4 const 1 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.04 ms Preparing 0.02 ms Creating tmp table 0.05 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.32 ms Creating sort index 0.03 ms Removing tmp table 0.06 ms Creating sort index 0.01 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 14 JDatabaseDriverMysqli->execute() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:367 13 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() JROOT/components/com_phocagallery/models/category.php:75 12 PhocagalleryModelCategory->getTotal() JROOT/components/com_phocagallery/models/category.php:83 11 PhocagalleryModelCategory->getPagination() JROOT/components/com_phocagallery/views/category/view.html.php:941 10 PhocaGalleryViewCategory->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.80 ms Utolsó lekérdezés után: 2.39 ms Memória lekérdezése: 0.041 MB memória a lekérdezés előtt: 3.751 MB Visszaadott sorok: 39
SHOW FULL COLUMNS
FROM `m4qou_phocagallery_categories`Az EXPLAIN nem lehetséges a következő lekérdezésen: SHOW FULL COLUMNS FROM `m4qou_phocagallery_categories`Status Duration Starting 0.03 ms checking permissions 0.01 ms closing tables 0.01 ms Opening tables 0.23 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms checking permissions 0.11 ms closing tables 0.01 ms Executing 0.01 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.02 ms closing tables 0.00 ms Removing tmp table 0.10 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.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/phocagalleryc.php:16 13 TablePhocaGalleryc->__construct() JROOT/libraries/src/Table/Table.php:328 12 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_phocagallery/models/category.php:542 11 PhocagalleryModelCategory->hit() JROOT/components/com_phocagallery/views/category/view.html.php:1871 10 PhocaGalleryViewCategory->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.77 ms Utolsó lekérdezés után: 1.83 ms Memória lekérdezése: 0.009 MB memória a lekérdezés előtt: 3.835 MB
UPDATE m4qou_phocagallery_categories
SET `hits` = (`hits` + 1)
WHERE `id` = '52'Az EXPLAIN nem lehetséges a következő lekérdezésen: UPDATE m4qou_phocagallery_categories SET `hits` = (`hits` + 1) WHERE `id` = '52'Status Duration Starting 0.05 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 for update 0.06 ms Updating 0.08 ms End of update loop 0.01 ms Waiting for query cache lock 0.00 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.37 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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1264 12 Joomla\CMS\Table\Table->hit() JROOT/components/com_phocagallery/models/category.php:543 11 PhocagalleryModelCategory->hit() JROOT/components/com_phocagallery/views/category/view.html.php:1871 10 PhocaGalleryViewCategory->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: 1.09 ms Utolsó lekérdezés után: 13.69 ms Memória lekérdezése: 0.030 MB memória a lekérdezés előtt: 3.917 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-20 15:33:41')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-20 15:33:41')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 104 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.16 ms checking permissions 0.02 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.02 ms table lock 0.01 ms init 0.07 ms Optimizing 0.06 ms Statistics 0.12 ms Preparing 0.06 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.18 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.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.59 ms Utolsó lekérdezés után: 14.20 ms Memória lekérdezése: 0.034 MB memória a lekérdezés előtt: 4.487 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.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.06 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.05 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 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
25 naplózott lekérdezéstípus, rendezés előfordulás szerint
SELECT táblák:
42 × SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a21 × SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM m4qou_phocagallery AS a
LEFT JOIN m4qou_phocagallery_categories AS c
ON a.catid = c.id5 × SELECT a.id, a.extid
FROM m4qou_phocagallery_categories AS a2 × SELECT a.*
FROM m4qou_phocagallery_fb_users AS a2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `m4qou_extensions`2 × SELECT a.*, cc.alias AS catalias, cc.accessuserid AS cataccessuserid, cc.access AS cataccess,
CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM m4qou_phocagallery AS a
LEFT JOIN m4qou_phocagallery_img_votes_statistics AS r
ON r.imgid = a.id
LEFT JOIN m4qou_phocagallery_categories AS cc
ON cc.id = a.catid1 × SELECT *
FROM m4qou_phocagallery_categories AS c1 × 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 cc.id, cc.title, cc.alias, cc.published, cc.approved, cc.parent_id, cc.deleteuserid, cc.accessuserid, cc.uploaduserid, cc.access, a.filename, a.extm, a.exts, a.extw, a.exth, a.extid
FROM m4qou_phocagallery_categories AS cc
LEFT JOIN m4qou_phocagallery AS a
ON cc.id = a.catid1 × SELECT cc.id, cc.title, cc.alias, cc.published, cc.approved, cc.parent_id, cc.deleteuserid, cc.accessuserid, cc.uploaduserid, cc.access
FROM m4qou_phocagallery_categories AS cc1 × SELECT `data`
FROM `m4qou_session`1 × SELECT c.id, c.title, c.alias, c.description, c.published, c.approved, c.parent_id, c.deleteuserid, c.accessuserid, c.uploaduserid, c.access, c.metakey, c.metadesc, c.latitude, c.longitude, c.zoom, c.geotitle, c.userfolder,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM m4qou_phocagallery_categories AS c1 × SELECT `session_id`
FROM `m4qou_session`1 × SELECT a.filename as filename, a.type as type, a.menulink as menulink
FROM m4qou_phocagallery_styles AS a1 × 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'356c7673343961316e6b33753936693364736b6b6d6575713635', 1, 1713627221, 0, '', 01 × UPDATE `m4qou_extensions`
SET `params` = '{\"mediaversion\":\"80e668cd5988911dc61bed93ad6a051d\"}'1 × SHOW FULL COLUMNS
FROM `m4qou_phocagallery_categories1 × UPDATE m4qou_phocagallery_categories
SET `hits` = (`hits` + 1)