Copyright © 2022: Kell Alapítvány
Joomla! hibakereső konzol
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1670071274,
"last": 1670071274,
"now": 1670071274
},
"token": "HD9DWHlkWmShcC9d2kUDiMFSf5Crs0S8"
},
"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ő: 62.81 ms / 62.81 ms Memória: 0.804 MB / 1.16 MB Application: afterLoad
Idő: 116.84 ms / 179.65 ms Memória: 1.289 MB / 2.45 MB Application: afterInitialise
Idő: 25.18 ms / 204.83 ms Memória: 0.273 MB / 2.72 MB Application: afterRoute
Idő: 10.33 ms / 215.16 ms Memória: 0.181 MB / 2.90 MB Application: beforeRenderComponent com_phocagallery
Idő: 274.49 ms / 489.64 ms Memória: 2.561 MB / 5.46 MB Application: afterRenderComponent com_phocagallery
Idő: 1.31 ms / 490.95 ms Memória: 0.005 MB / 5.47 MB Application: afterDispatch
Idő: 8.83 ms / 499.78 ms Memória: 0.085 MB / 5.55 MB Application: beforeRenderModule mod_as_menu (Top Menu)
Idő: 6.32 ms / 506.10 ms Memória: 0.071 MB / 5.62 MB Application: afterRenderModule mod_as_menu (Top Menu)
Idő: 15.58 ms / 521.68 ms Memória: 0.636 MB / 6.26 MB Application: afterRender
Adatbázislekérdezés összesen: 139.68 ms
8,38 MB (8.792.200 Bájtok)
194 naplózott lekérdezés 139.68 ms
12 duplikátum található!
- Lekérdezés ideje: 1.71 ms Memória lekérdezése: 0.010 MB memória a lekérdezés előtt: 1.547 MB Visszaadott sorok: 0
SELECT `data`
FROM `m4qou_session`
WHERE `session_id` = X'6161313965313463333235616532353534353030636466343031356337336233'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.43 ms Utolsó lekérdezés után: 2.97 ms Memória lekérdezése: 0.006 MB memória a lekérdezés előtt: 1.628 MB Visszaadott sorok: 0
SELECT `session_id`
FROM `m4qou_session`
WHERE `session_id` = X'6161313965313463333235616532353534353030636466343031356337336233'
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.17 ms Utolsó lekérdezés után: 0.14 ms Memória lekérdezése: 0.005 MB memória a lekérdezés előtt: 1.635 MB
INSERT INTO `m4qou_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6161313965313463333235616532353534353030636466343031356337336233', 1, 1670071274, 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'6161313965313463333235616532353534353030636466343031356337336233', 1, 1670071274, 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: 2.53 ms Utolsó lekérdezés után: 5.71 ms Memória lekérdezése: 0.008 MB memória a lekérdezés előtt: 1.672 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: 1.30 ms Utolsó lekérdezés után: 5.89 ms Memória lekérdezése: 0.007 MB memória a lekérdezés előtt: 1.777 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: 1.08 ms Utolsó lekérdezés után: 0.14 ms Memória lekérdezése: 0.007 MB memória a lekérdezés előtt: 1.791 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 index idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 8 NULL 9 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: 1.99 ms Utolsó lekérdezés után: 1.48 ms Memória lekérdezése: 0.007 MB memória a lekérdezés előtt: 1.815 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 ref extension extension 82 const 124 Using index condition; 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: 2.13 ms Utolsó lekérdezés után: 41.14 ms Memória lekérdezése: 0.012 MB memória a lekérdezés előtt: 2.479 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 23364_kellalap.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.96 ms Utolsó lekérdezés után: 19.53 ms Memória lekérdezése: 0.010 MB memória a lekérdezés előtt: 2.742 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.80 ms Utolsó lekérdezés után: 0.13 ms Memória lekérdezése: 0.007 MB memória a lekérdezés előtt: 2.736 MB
UPDATE `m4qou_extensions`
SET `params` = '{\"mediaversion\":\"4d197686db710dac4a9ffc452c8a7c19\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'Az EXPLAIN nem lehetséges a következő lekérdezésen: UPDATE `m4qou_extensions` SET `params` = '{\"mediaversion\":\"4d197686db710dac4a9ffc452c8a7c19\"}' 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: 1.28 ms Utolsó lekérdezés után: 2.66 ms Memória lekérdezése: 0.005 MB memória a lekérdezés előtt: 2.870 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: 1.52 ms Utolsó lekérdezés után: 0.18 ms Memória lekérdezése: 0.004 MB memória a lekérdezés előtt: 2.882 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 ALL idx_template,idx_client_id,idx_client_id_home NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 5 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 23364_kellalap.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: 2.37 ms Utolsó lekérdezés után: 62.79 ms Memória lekérdezése: 0.009 MB memória a lekérdezés előtt: 3.378 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: 2.09 ms Utolsó lekérdezés után: 14.85 ms Memória lekérdezése: 0.009 MB memória a lekérdezés előtt: 3.407 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.42 ms Utolsó lekérdezés után: 0.05 ms Memória lekérdezése: 0.009 MB memória a lekérdezés előtt: 3.416 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: 2.25 ms Utolsó lekérdezés után: 19.58 ms Memória lekérdezése: 0.010 MB memória a lekérdezés előtt: 3.513 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: 2.00 ms Utolsó lekérdezés után: 6.35 ms Memória lekérdezése: 0.010 MB memória a lekérdezés előtt: 3.538 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: 3.78 ms Utolsó lekérdezés után: 0.08 ms Memória lekérdezése: 0.009 MB memória a lekérdezés előtt: 3.548 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 range PRIMARY PRIMARY 4 NULL 138 Using where; Using temporary; Fájlrendezés használata 1 SIMPLE a ref catid catid 4 23364_kellalap.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: 1.37 ms Utolsó lekérdezés után: 0.10 ms Memória lekérdezése: 0.009 MB memória a lekérdezés előtt: 3.566 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: 1.51 ms Utolsó lekérdezés után: 0.05 ms Memória lekérdezése: 0.009 MB memória a lekérdezés előtt: 3.574 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: 2.15 ms Utolsó lekérdezés után: 4.26 ms Memória lekérdezése: 0.009 MB memória a lekérdezés előtt: 3.648 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.27 ms Utolsó lekérdezés után: 0.10 ms Memória lekérdezése: 0.009 MB memória a lekérdezés előtt: 3.657 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: 1.07 ms Utolsó lekérdezés után: 0.11 ms Memória lekérdezése: 0.009 MB memória a lekérdezés előtt: 3.667 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.55 ms Utolsó lekérdezés után: 0.07 ms Memória lekérdezése: 0.010 MB memória a lekérdezés előtt: 3.677 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: 0.89 ms Utolsó lekérdezés után: 0.07 ms Memória lekérdezése: 0.010 MB memória a lekérdezés előtt: 3.693 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: 0.49 ms Utolsó lekérdezés után: 0.07 ms Memória lekérdezése: 0.010 MB memória a lekérdezés előtt: 3.703 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.67 ms Utolsó lekérdezés után: 0.06 ms Memória lekérdezése: 0.010 MB memória a lekérdezés előtt: 3.713 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.51 ms Utolsó lekérdezés után: 0.06 ms Memória lekérdezése: 0.010 MB memória a lekérdezés előtt: 3.723 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.63 ms Utolsó lekérdezés után: 0.06 ms Memória lekérdezése: 0.010 MB memória a lekérdezés előtt: 3.733 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 = 186
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 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.58 ms Utolsó lekérdezés után: 0.06 ms Memória lekérdezése: 0.010 MB memória a lekérdezés előtt: 3.743 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 = 183
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.51 ms Utolsó lekérdezés után: 0.07 ms Memória lekérdezése: 0.010 MB memória a lekérdezés előtt: 3.753 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 = 185
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 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.47 ms Utolsó lekérdezés után: 0.04 ms Memória lekérdezése: 0.010 MB memória a lekérdezés előtt: 3.763 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 = 190
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.54 ms Utolsó lekérdezés után: 0.04 ms Memória lekérdezése: 0.011 MB memória a lekérdezés előtt: 3.779 MB Visszaadott sorok: 1