Copyright © 2023: Kell Alapítvány
Joomla! hibakereső konzol
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1701259727,
"last": 1701259727,
"now": 1701259727
},
"token": "FVr55HURarhlzhpYKGn9sn280ThRhpWL"
},
"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ő: 14.02 ms / 14.02 ms Memória: 0.586 MB / 0.92 MB Application: afterLoad
Idő: 35.39 ms / 49.41 ms Memória: 1.097 MB / 2.01 MB Application: afterInitialise
Idő: 9.43 ms / 58.84 ms Memória: 0.207 MB / 2.22 MB Application: afterRoute
Idő: 5.43 ms / 64.27 ms Memória: 0.118 MB / 2.34 MB Application: beforeRenderComponent com_phocagallery
Idő: 199.37 ms / 263.64 ms Memória: 2.440 MB / 4.78 MB Application: afterRenderComponent com_phocagallery
Idő: 2.79 ms / 266.43 ms Memória: 0.005 MB / 4.78 MB Application: afterDispatch
Idő: 4.48 ms / 270.91 ms Memória: 0.145 MB / 4.93 MB Application: beforeRenderModule mod_as_menu (Top Menu)
Idő: 3.37 ms / 274.28 ms Memória: 0.061 MB / 4.99 MB Application: afterRenderModule mod_as_menu (Top Menu)
Idő: 9.70 ms / 283.98 ms Memória: 0.504 MB / 5.49 MB Application: afterRender
Adatbázislekérdezés összesen: 134.64 ms
7,57 MB (7.934.512 Bájtok)
194 naplózott lekérdezés 134.64 ms
12 duplikátum található!
- Lekérdezés ideje: 0.58 ms Memória lekérdezése: 0.027 MB memória a lekérdezés előtt: 1.247 MB Visszaadott sorok: 0
SELECT `data`
FROM `m4qou_session`
WHERE `session_id` = X'7675386773636663746c643965727161743768706b6662326e32'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m4qou_session const PRIMARY PRIMARY 194 const 1 Nincs SHOW PROFILE (lehet azért, mert több mint 100 lekérdezés van)# 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.42 ms Utolsó lekérdezés után: 1.13 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 1.265 MB Visszaadott sorok: 0
SELECT `session_id`
FROM `m4qou_session`
WHERE `session_id` = X'7675386773636663746c643965727161743768706b6662326e32'
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 Nincs SHOW PROFILE (lehet azért, mert több mint 100 lekérdezés van)# 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.07 ms Utolsó lekérdezés után: 0.10 ms Memória lekérdezése: 0.005 MB memória a lekérdezés előtt: 1.272 MB
INSERT INTO `m4qou_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'7675386773636663746c643965727161743768706b6662326e32', 1, 1701259727, 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'7675386773636663746c643965727161743768706b6662326e32', 1, 1701259727, 0, '', 0)Nincs SHOW PROFILE (lehet azért, mert több mint 100 lekérdezés van)# 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.82 ms Utolsó lekérdezés után: 1.38 ms Memória lekérdezése: 0.042 MB memória a lekérdezés előtt: 1.371 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 Nincs SHOW PROFILE (lehet azért, mert több mint 100 lekérdezés van)# 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.46 ms Utolsó lekérdezés után: 1.57 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 1.423 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 Nincs SHOW PROFILE (lehet azért, mert több mint 100 lekérdezés van)# 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.46 ms Utolsó lekérdezés után: 0.12 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 1.437 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 Nincs SHOW PROFILE (lehet azért, mert több mint 100 lekérdezés van)# Hívó Fájl és sorok száma 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Lekérdezés ideje: 0.84 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.461 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 Nincs SHOW PROFILE (lehet azért, mert több mint 100 lekérdezés van)# Hívó Fájl és sorok száma 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:351 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Ugyanaz a hívás, mint egy sorral lejjebb. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:356 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Lekérdezés ideje: 1.14 ms Utolsó lekérdezés után: 17.14 ms Memória lekérdezése: 0.037 MB memória a lekérdezés előtt: 2.044 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 Nincs SHOW PROFILE (lehet azért, mert több mint 100 lekérdezés van)# 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.61 ms Utolsó lekérdezés után: 6.87 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 2.241 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 Nincs SHOW PROFILE (lehet azért, mert több mint 100 lekérdezés van)# Hívó Fájl és sorok száma 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 13 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Ugyanaz a hívás, mint egy sorral lejjebb. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 10 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 9 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 8 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1137 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Lekérdezés ideje: 0.69 ms Utolsó lekérdezés után: 0.20 ms Memória lekérdezése: 0.007 MB memória a lekérdezés előtt: 2.234 MB
UPDATE `m4qou_extensions`
SET `params` = '{\"mediaversion\":\"0ebfe7dd09a50410d089c4085d3c8595\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'Az EXPLAIN nem lehetséges a következő lekérdezésen: UPDATE `m4qou_extensions` SET `params` = '{\"mediaversion\":\"0ebfe7dd09a50410d089c4085d3c8595\"}' WHERE `type` = 'library' AND `element` = 'joomla'Nincs SHOW PROFILE (lehet azért, mert több mint 100 lekérdezés van)# 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.17 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 2.306 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 Nincs SHOW PROFILE (lehet azért, mert több mint 100 lekérdezés van)# 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.48 ms Utolsó lekérdezés után: 0.32 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 2.319 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 Nincs SHOW PROFILE (lehet azért, mert több mint 100 lekérdezés van)# 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.63 ms Utolsó lekérdezés után: 11.52 ms Memória lekérdezése: 0.027 MB memória a lekérdezés előtt: 2.812 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 Nincs SHOW PROFILE (lehet azért, mert több mint 100 lekérdezés van)# 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.58 ms Utolsó lekérdezés után: 12.44 ms Memória lekérdezése: 0.032 MB memória a lekérdezés előtt: 2.840 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 Nincs SHOW PROFILE (lehet azért, mert több mint 100 lekérdezés van)# 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.22 ms Utolsó lekérdezés után: 0.07 ms Memória lekérdezése: 0.032 MB memória a lekérdezés előtt: 2.849 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 Nincs SHOW PROFILE (lehet azért, mert több mint 100 lekérdezés van)# 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.81 ms Utolsó lekérdezés után: 17.31 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 = 180
LIMIT 0, 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 Nincs SHOW PROFILE (lehet azért, mert több mint 100 lekérdezés van)# 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.47 ms Utolsó lekérdezés után: 1.70 ms Memória lekérdezése: 0.030 MB memória a lekérdezés előtt: 2.908 MB Visszaadott sorok: 0
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 = 0
AND cc.published = 1
AND cc.approved = 1
AND cc.id <> 180
ORDER BY cc.ordering ASC
LIMIT 0, 1id 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 Nincs SHOW PROFILE (lehet azért, mert több mint 100 lekérdezés van)# 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.40 ms Utolsó lekérdezés után: 0.08 ms Memória lekérdezése: 0.032 MB memória a lekérdezés előtt: 2.918 MB Visszaadott sorok: 5
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 = 180
AND cc.published = 1
AND cc.approved = 1
AND cc.id <> 180
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 Nincs SHOW PROFILE (lehet azért, mert több mint 100 lekérdezés van)# 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.33 ms Utolsó lekérdezés után: 0.15 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 2.937 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 = 50id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 1 Using where Nincs SHOW PROFILE (lehet azért, mert több mint 100 lekérdezés van)# 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: 2.945 MB Visszaadott sorok: 1Duplikált lekérdezések: #19
SELECT COUNT(a.id)
FROM m4qou_phocagallery AS a
WHERE a.published = 1
AND a.approved = 1
AND a.catid = 50id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref catid catid 5 const,const 1 Using where Nincs SHOW PROFILE (lehet azért, mert több mint 100 lekérdezés van)# 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.79 ms Utolsó lekérdezés után: 0.21 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 3.018 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 = 50
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 Nincs SHOW PROFILE (lehet azért, mert több mint 100 lekérdezés van)# 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: 2.10 ms Utolsó lekérdezés után: 0.09 ms Memória lekérdezése: 0.027 MB memória a lekérdezés előtt: 3.028 MB Visszaadott sorok: 1
SELECT a.id, a.extid
FROM m4qou_phocagallery_categories AS a
WHERE a.parent_id = 50
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 Nincs SHOW PROFILE (lehet azért, mert több mint 100 lekérdezés van)# 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.93 ms Utolsó lekérdezés után: 0.14 ms Memória lekérdezése: 0.029 MB memória a lekérdezés előtt: 3.038 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 = 181
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 Nincs SHOW PROFILE (lehet azért, mert több mint 100 lekérdezés van)# 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:457 12 PhocaGalleryImageFront::getRandomImageRecursive() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:486 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.48 ms Utolsó lekérdezés után: 0.13 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 3.048 MB Visszaadott sorok: 10
SELECT a.id, a.extid
FROM m4qou_phocagallery_categories AS a
WHERE a.parent_id = 181
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 Nincs SHOW PROFILE (lehet azért, mert több mint 100 lekérdezés van)# Hívó Fájl és sorok száma 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:537 13 PhocaGalleryImageFront::getRandomCategory() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:482 12 PhocaGalleryImageFront::getRandomImageRecursive() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:486 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: 1.28 ms Utolsó lekérdezés után: 0.08 ms Memória lekérdezése: 0.029 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 = 182
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 15 Using where; Using temporary; Fájlrendezés használata 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 Nincs SHOW PROFILE (lehet azért, mert több mint 100 lekérdezés van)# Hívó Fájl és sorok száma 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:457 13 PhocaGalleryImageFront::getRandomImageRecursive() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:486 12 PhocaGalleryImageFront::getRandomImageRecursive() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:486 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.90 ms Utolsó lekérdezés után: 0.10 ms Memória lekérdezése: 0.029 MB memória a lekérdezés előtt: 3.073 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 = 188
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 Nincs SHOW PROFILE (lehet azért, mert több mint 100 lekérdezés van)# Hívó Fájl és sorok száma 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:457 13 PhocaGalleryImageFront::getRandomImageRecursive() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:486 12 PhocaGalleryImageFront::getRandomImageRecursive() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:486 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.78 ms Utolsó lekérdezés után: 0.08 ms Memória lekérdezése: 0.029 MB memória a lekérdezés előtt: 3.083 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 = 187
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 Nincs SHOW PROFILE (lehet azért, mert több mint 100 lekérdezés van)# Hívó Fájl és sorok száma 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:457 13 PhocaGalleryImageFront::getRandomImageRecursive() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:486 12 PhocaGalleryImageFront::getRandomImageRecursive() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:486 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: 1.22 ms Utolsó lekérdezés után: 0.08 ms Memória lekérdezése: 0.029 MB memória a lekérdezés előtt: 3.093 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 = 191
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 27 Using where; Using temporary; Fájlrendezés használata 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 Nincs SHOW PROFILE (lehet azért, mert több mint 100 lekérdezés van)# Hívó Fájl és sorok száma 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:457 13 PhocaGalleryImageFront::getRandomImageRecursive() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:486 12 PhocaGalleryImageFront::getRandomImageRecursive() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:486 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.86 ms Utolsó lekérdezés után: 0.06 ms Memória lekérdezése: 0.029 MB memória a lekérdezés előtt: 3.103 MB Visszaadott sorok: 1