תרבות
תפריט נגישות
קונסול ניטור של ג'ומלה
{
"__default": {
"session": {
"counter": 2,
"timer": {
"start": 1749477185,
"last": 1749477185,
"now": 1749477186
},
"token": "xZGv0n95JrvB6ewYfCiIZ1JyrxFfrUW2"
},
"registry": {
"justmine_fv_ses": "0"
},
"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
},
"plg_system_languagefilter": {
"language": "he-IL"
}
}
}
Time
Memory
Time: 25.77 ms / 25.77 ms Memory: 2.876 MB / 3.28 MB Application: afterLoad
Time: 49.03 ms / 74.80 ms Memory: 5.764 MB / 9.05 MB Application: afterInitialise
Time: 7.93 ms / 82.73 ms Memory: 0.595 MB / 9.64 MB Application: afterRoute
Time: 5.71 ms / 88.45 ms Memory: 0.290 MB / 9.93 MB Application: beforeRenderComponent com_jevents
Time: 19.67 ms / 108.12 ms Memory: 2.009 MB / 11.94 MB Application: Before Access::preloadComponents (all components)
Time: 1.84 ms / 109.95 ms Memory: 0.069 MB / 12.01 MB Application: After Access::preloadComponents (all components)
Time: 0.04 ms / 109.99 ms Memory: 0.000 MB / 12.01 MB Application: Before Access::getAssetRules (id:914 name:com_jevents)
Time: 0.47 ms / 110.47 ms Memory: 0.028 MB / 12.04 MB Application: After Access::getAssetRules (id:914 name:com_jevents)
Time: 59.95 ms / 170.42 ms Memory: 4.216 MB / 16.25 MB Application: Before Access::preloadPermissions (com_jevents)
Time: 1.04 ms / 171.45 ms Memory: 0.032 MB / 16.28 MB Application: After Access::preloadPermissions (com_jevents)
Time: 0.03 ms / 171.48 ms Memory: 0.000 MB / 16.28 MB Application: Before Access::getAssetRules (id:923 name:com_jevents.category.58)
Time: 0.02 ms / 171.50 ms Memory: 0.002 MB / 16.29 MB Application: After Access::getAssetRules (id:923 name:com_jevents.category.58)
Time: 26.44 ms / 197.95 ms Memory: 1.358 MB / 17.64 MB Application: afterRenderComponent com_jevents
Time: 2.21 ms / 200.16 ms Memory: 0.052 MB / 17.70 MB Application: afterDispatch
Time: 1.72 ms / 201.88 ms Memory: 0.131 MB / 17.83 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Time: 0.06 ms / 201.94 ms Memory: 0.008 MB / 17.83 MB Application: After Access::getAssetRules (id:1 name:root.1)
Time: 0.50 ms / 202.44 ms Memory: 0.032 MB / 17.87 MB Application: beforeRenderModule mod_slogin (התחברות לספרייה)
Time: 3.37 ms / 205.81 ms Memory: 0.148 MB / 18.01 MB Application: afterRenderModule mod_slogin (התחברות לספרייה)
Time: 0.86 ms / 206.67 ms Memory: 0.000 MB / 17.98 MB Application: beforeRenderModule mod_agron_accessibility (תפריט נגישות)
Time: 0.38 ms / 207.04 ms Memory: 0.010 MB / 17.99 MB Application: afterRenderModule mod_agron_accessibility (תפריט נגישות)
Time: 0.07 ms / 207.11 ms Memory: 0.001 MB / 17.99 MB Application: beforeRenderModule mod_menu (Main Menu footer)
Time: 2.43 ms / 209.55 ms Memory: 0.169 MB / 18.16 MB Application: afterRenderModule mod_menu (Main Menu footer)
Time: 0.04 ms / 209.58 ms Memory: 0.000 MB / 18.16 MB Application: beforeRenderModule mod_menu (Main Menu (catalog-restricted) (footer))
Time: 0.94 ms / 210.52 ms Memory: 0.027 MB / 18.18 MB Application: afterRenderModule mod_menu (Main Menu (catalog-restricted) (footer))
Time: 0.07 ms / 210.59 ms Memory: 0.000 MB / 18.18 MB Application: beforeRenderModule mod_search (חיפוש)
Time: 0.69 ms / 211.28 ms Memory: 0.013 MB / 18.19 MB Application: afterRenderModule mod_search (חיפוש)
Time: 0.05 ms / 211.33 ms Memory: 0.000 MB / 18.19 MB Application: beforeRenderModule mod_menu (Main Menu (catalog-restricted))
Time: 1.33 ms / 212.67 ms Memory: 0.016 MB / 18.21 MB Application: afterRenderModule mod_menu (Main Menu (catalog-restricted))
Time: 0.05 ms / 212.72 ms Memory: 0.000 MB / 18.20 MB Application: beforeRenderModule mod_menu (Main Menu)
Time: 7.59 ms / 220.31 ms Memory: 0.078 MB / 18.28 MB Application: afterRenderModule mod_menu (Main Menu)
Time: 0.08 ms / 220.39 ms Memory: 0.000 MB / 18.28 MB Application: beforeRenderModule mod_languages (החלפת שפות)
Time: 4.00 ms / 224.39 ms Memory: 0.114 MB / 18.39 MB Application: afterRenderModule mod_languages (החלפת שפות)
Time: 0.07 ms / 224.46 ms Memory: 0.000 MB / 18.39 MB Application: beforeRenderModule mod_menu (frontend edit menu)
Time: 0.28 ms / 224.74 ms Memory: 0.007 MB / 18.39 MB Application: afterRenderModule mod_menu (frontend edit menu)
Time: 0.04 ms / 224.78 ms Memory: 0.000 MB / 18.39 MB Application: beforeRenderModule mod_menu (top_links)
Time: 0.22 ms / 225.00 ms Memory: 0.004 MB / 18.40 MB Application: afterRenderModule mod_menu (top_links)
Time: 3.28 ms / 228.28 ms Memory: 0.289 MB / 18.68 MB Application: afterRender
Database queries total: 41.69 ms
19.19 MB (20,120,040 Bytes)
35 שאילתות נרשמו 41.69 ms
- Query Time: 0.67 ms Query memory: 0.024 MB Memory before query: 4.826 MB Rows returned: 1
SELECT `data`
FROM `JdKlzg_session`
WHERE `session_id` = 'ef3f500f4ab2463ef2fcc959b2f80ce4'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE JdKlzg_session const PRIMARY PRIMARY 194 const 1 Status Duration Starting 0.10 ms Checking permissions 0.03 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.08 ms Preparing 0.02 ms Unlocking tables 0.03 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.02 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.04 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() /home/library/master/libraries/joomla/database/driver.php:1734 16 JDatabaseDriver->loadResult() /home/library/master/libraries/joomla/session/storage/database.php:45 15 JSessionStorageDatabase->read() Same as call in the line below. 14 session_start() /home/library/master/libraries/joomla/session/handler/native.php:260 13 JSessionHandlerNative->doSessionStart() /home/library/master/libraries/joomla/session/handler/native.php:50 12 JSessionHandlerNative->start() /home/library/master/libraries/joomla/session/handler/joomla.php:88 11 JSessionHandlerJoomla->start() /home/library/master/libraries/src/Session/Session.php:660 10 Joomla\CMS\Session\Session->_start() /home/library/master/libraries/src/Session/Session.php:620 9 Joomla\CMS\Session\Session->start() /home/library/master/libraries/src/Session/Session.php:498 8 Joomla\CMS\Session\Session->get() /home/library/master/libraries/src/Session/Session.php:455 7 Joomla\CMS\Session\Session->isNew() /home/library/master/libraries/src/Application/CMSApplication.php:758 6 Joomla\CMS\Application\CMSApplication->loadSession() /home/library/master/libraries/src/Application/CMSApplication.php:135 5 Joomla\CMS\Application\CMSApplication->__construct() /home/library/master/libraries/src/Application/SiteApplication.php:66 4 Joomla\CMS\Application\SiteApplication->__construct() /home/library/master/libraries/src/Application/CMSApplication.php:344 3 Joomla\CMS\Application\CMSApplication::getInstance() /home/library/master/libraries/src/Factory.php:140 2 Joomla\CMS\Factory::getApplication() JROOT/index.php(11) : eval()'d code:47 1 eval() JROOT/index.php:11 - Query Time: 0.83 ms After last query: 3.53 ms Query memory: 0.025 MB Memory before query: 5.133 MB Rows returned: 41
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `JdKlzg_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE JdKlzg_extensions ref extension extension 82 const 51 Using index condition; Using where Status Duration Starting 0.07 ms Checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.03 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.05 ms Executing 0.02 ms Sending data 0.21 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.03 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.03 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() /home/library/master/libraries/joomla/database/driver.php:1695 12 JDatabaseDriver->loadObjectList() /home/library/master/libraries/src/Component/ComponentHelper.php:445 11 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Same as call in the line below. 10 call_user_func_array() /home/library/master/libraries/src/Cache/Controller/CallbackController.php:173 9 Joomla\CMS\Cache\Controller\CallbackController->get() /home/library/master/libraries/src/Component/ComponentHelper.php:453 8 Joomla\CMS\Component\ComponentHelper::load() /home/library/master/libraries/src/Component/ComponentHelper.php:519 7 Joomla\CMS\Component\ComponentHelper::getComponents() /home/library/master/libraries/src/Component/ComponentHelper.php:44 6 Joomla\CMS\Component\ComponentHelper::getComponent() /home/library/master/libraries/src/Component/ComponentHelper.php:103 5 Joomla\CMS\Component\ComponentHelper::getParams() /home/library/master/libraries/src/Application/SiteApplication.php:594 4 Joomla\CMS\Application\SiteApplication->initialiseApp() /home/library/master/libraries/src/Application/SiteApplication.php:212 3 Joomla\CMS\Application\SiteApplication->doExecute() /home/library/master/libraries/src/Application/CMSApplication.php:196 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php(11) : eval()'d code:50 1 eval() JROOT/index.php:11 - Query Time: 0.51 ms After last query: 2.11 ms Query memory: 0.021 MB Memory before query: 5.402 MB Rows returned: 5
SELECT id, rules
FROM `JdKlzg_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE JdKlzg_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5 Status Duration Starting 0.04 ms Checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.02 ms Sending data 0.06 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.01 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() /home/library/master/libraries/joomla/database/driver.php:1500 10 JDatabaseDriver->loadAssocList() /home/library/master/libraries/src/Access/Access.php:1063 9 Joomla\CMS\Access\Access::getAuthorisedViewLevels() /home/library/master/libraries/src/User/User.php:466 8 Joomla\CMS\User\User->getAuthorisedViewLevels() /home/library/master/libraries/src/Plugin/PluginHelper.php:321 7 Joomla\CMS\Plugin\PluginHelper::load() /home/library/master/libraries/src/Plugin/PluginHelper.php:87 6 Joomla\CMS\Plugin\PluginHelper::getPlugin() /home/library/master/libraries/src/Plugin/PluginHelper.php:129 5 Joomla\CMS\Plugin\PluginHelper::isEnabled() /home/library/master/libraries/src/Application/SiteApplication.php:604 4 Joomla\CMS\Application\SiteApplication->initialiseApp() /home/library/master/libraries/src/Application/SiteApplication.php:212 3 Joomla\CMS\Application\SiteApplication->doExecute() /home/library/master/libraries/src/Application/CMSApplication.php:196 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php(11) : eval()'d code:50 1 eval() JROOT/index.php:11 - Query Time: 0.59 ms After last query: 0.09 ms Query memory: 0.021 MB Memory before query: 5.414 MB Rows returned: 1
SELECT b.id
FROM JdKlzg_usergroups AS a
LEFT JOIN JdKlzg_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1id 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 1 Using where; Using index Status Duration Starting 0.05 ms Checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.04 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.02 ms Unlocking tables 0.01 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.05 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() /home/library/master/libraries/joomla/database/driver.php:1544 11 JDatabaseDriver->loadColumn() /home/library/master/libraries/src/Access/Access.php:980 10 Joomla\CMS\Access\Access::getGroupsByUser() /home/library/master/libraries/src/Access/Access.php:1095 9 Joomla\CMS\Access\Access::getAuthorisedViewLevels() /home/library/master/libraries/src/User/User.php:466 8 Joomla\CMS\User\User->getAuthorisedViewLevels() /home/library/master/libraries/src/Plugin/PluginHelper.php:321 7 Joomla\CMS\Plugin\PluginHelper::load() /home/library/master/libraries/src/Plugin/PluginHelper.php:87 6 Joomla\CMS\Plugin\PluginHelper::getPlugin() /home/library/master/libraries/src/Plugin/PluginHelper.php:129 5 Joomla\CMS\Plugin\PluginHelper::isEnabled() /home/library/master/libraries/src/Application/SiteApplication.php:604 4 Joomla\CMS\Application\SiteApplication->initialiseApp() /home/library/master/libraries/src/Application/SiteApplication.php:212 3 Joomla\CMS\Application\SiteApplication->doExecute() /home/library/master/libraries/src/Application/CMSApplication.php:196 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php(11) : eval()'d code:50 1 eval() JROOT/index.php:11 - Query Time: 1.12 ms After last query: 0.60 ms Query memory: 0.026 MB Memory before query: 5.484 MB Rows returned: 57
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM JdKlzg_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE JdKlzg_extensions ref extension extension 82 const 136 Using index condition; Using where; Using filesort Status Duration Starting 0.06 ms Checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.03 ms Optimizing 0.03 ms Statistics 0.05 ms Preparing 0.03 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.52 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.03 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() /home/library/master/libraries/joomla/database/driver.php:1695 11 JDatabaseDriver->loadObjectList() /home/library/master/libraries/src/Plugin/PluginHelper.php:354 10 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Same as call in the line below. 9 call_user_func_array() /home/library/master/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() /home/library/master/libraries/src/Plugin/PluginHelper.php:359 7 Joomla\CMS\Plugin\PluginHelper::load() /home/library/master/libraries/src/Plugin/PluginHelper.php:87 6 Joomla\CMS\Plugin\PluginHelper::getPlugin() /home/library/master/libraries/src/Plugin/PluginHelper.php:129 5 Joomla\CMS\Plugin\PluginHelper::isEnabled() /home/library/master/libraries/src/Application/SiteApplication.php:604 4 Joomla\CMS\Application\SiteApplication->initialiseApp() /home/library/master/libraries/src/Application/SiteApplication.php:212 3 Joomla\CMS\Application\SiteApplication->doExecute() /home/library/master/libraries/src/Application/CMSApplication.php:196 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php(11) : eval()'d code:50 1 eval() JROOT/index.php:11 - Query Time: 0.70 ms After last query: 6.09 ms Query memory: 0.021 MB Memory before query: 6.046 MB Rows returned: 1
SELECT *
FROM JdKlzg_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE JdKlzg_languages ALL NULL NO INDEX KEY COULD BE USED NULL NULL 2 Using where; Using filesort Status Duration Starting 0.08 ms Checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.04 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.03 ms Sorting result 0.02 ms Executing 0.02 ms Sending data 0.02 ms Creating sort index 0.10 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.03 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() /home/library/master/libraries/joomla/database/driver.php:1695 10 JDatabaseDriver->loadObjectList() /home/library/master/libraries/src/Language/LanguageHelper.php:150 9 Joomla\CMS\Language\LanguageHelper::getLanguages() /home/library/master/plugins/system/languagefilter/languagefilter.php:96 8 PlgSystemLanguageFilter->__construct() /home/library/master/libraries/src/Plugin/PluginHelper.php:283 7 Joomla\CMS\Plugin\PluginHelper::import() /home/library/master/libraries/src/Plugin/PluginHelper.php:182 6 Joomla\CMS\Plugin\PluginHelper::importPlugin() /home/library/master/libraries/src/Application/CMSApplication.php:625 5 Joomla\CMS\Application\CMSApplication->initialiseApp() /home/library/master/libraries/src/Application/SiteApplication.php:686 4 Joomla\CMS\Application\SiteApplication->initialiseApp() /home/library/master/libraries/src/Application/SiteApplication.php:212 3 Joomla\CMS\Application\SiteApplication->doExecute() /home/library/master/libraries/src/Application/CMSApplication.php:196 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php(11) : eval()'d code:50 1 eval() JROOT/index.php:11 - Query Time: 0.65 ms After last query: 0.17 ms Query memory: 0.021 MB Memory before query: 6.054 MB Rows returned: 4
SELECT `element`,`name`,`client_id`,`extension_id`
FROM `JdKlzg_extensions`
WHERE `type` = 'language'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE JdKlzg_extensions ref extension extension 82 const 8 Using index condition; Using where Status Duration Starting 0.05 ms Checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.03 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.08 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() /home/library/master/libraries/joomla/database/driver.php:1695 10 JDatabaseDriver->loadObjectList() /home/library/master/libraries/src/Language/LanguageHelper.php:209 9 Joomla\CMS\Language\LanguageHelper::getInstalledLanguages() /home/library/master/plugins/system/languagefilter/languagefilter.php:110 8 PlgSystemLanguageFilter->__construct() /home/library/master/libraries/src/Plugin/PluginHelper.php:283 7 Joomla\CMS\Plugin\PluginHelper::import() /home/library/master/libraries/src/Plugin/PluginHelper.php:182 6 Joomla\CMS\Plugin\PluginHelper::importPlugin() /home/library/master/libraries/src/Application/CMSApplication.php:625 5 Joomla\CMS\Application\CMSApplication->initialiseApp() /home/library/master/libraries/src/Application/SiteApplication.php:686 4 Joomla\CMS\Application\SiteApplication->initialiseApp() /home/library/master/libraries/src/Application/SiteApplication.php:212 3 Joomla\CMS\Application\SiteApplication->doExecute() /home/library/master/libraries/src/Application/CMSApplication.php:196 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php(11) : eval()'d code:50 1 eval() JROOT/index.php:11 - Query Time: 2.04 ms After last query: 13.71 ms Query memory: 0.094 MB Memory before query: 8.830 MB Rows returned: 57
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 JdKlzg_menu AS m
LEFT JOIN JdKlzg_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 122 Using index condition; Using where; Using filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 library_m_arad.m.component_id 1 Using where Status Duration Starting 0.20 ms Checking permissions 0.04 ms Opening tables 0.05 ms After opening tables 0.03 ms System lock 0.03 ms Table lock 0.02 ms Init 0.04 ms Optimizing 0.03 ms Statistics 0.08 ms Preparing 0.04 ms Sorting result 0.02 ms Executing 0.02 ms Sending data 0.03 ms Creating sort index 0.97 ms End of update loop 0.05 ms Query end 0.03 ms Commit 0.03 ms Closing tables 0.03 ms Unlocking tables 0.03 ms Closing tables 0.03 ms Starting cleanup 0.03 ms Freeing items 0.03 ms Updating status 0.05 ms Reset for next command 0.05 ms # Caller File and line number 24 JDatabaseDriverMysqli->execute() /home/library/master/libraries/joomla/database/driver.php:1695 23 JDatabaseDriver->loadObjectList() /home/library/master/libraries/src/Menu/SiteMenu.php:93 22 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Same as call in the line below. 21 call_user_func_array() /home/library/master/libraries/src/Cache/Controller/CallbackController.php:173 20 Joomla\CMS\Cache\Controller\CallbackController->get() /home/library/master/libraries/src/Menu/SiteMenu.php:101 19 Joomla\CMS\Menu\SiteMenu->load() /home/library/master/libraries/src/Menu/AbstractMenu.php:76 18 Joomla\CMS\Menu\AbstractMenu->__construct() /home/library/master/libraries/src/Menu/SiteMenu.php:62 17 Joomla\CMS\Menu\SiteMenu->__construct() /home/library/master/libraries/src/Menu/AbstractMenu.php:131 16 Joomla\CMS\Menu\AbstractMenu::getInstance() /home/library/master/libraries/src/Application/CMSApplication.php:375 15 Joomla\CMS\Application\CMSApplication->getMenu() /home/library/master/libraries/src/Application/SiteApplication.php:275 14 Joomla\CMS\Application\SiteApplication->getMenu() /home/library/master/libraries/src/Router/SiteRouter.php:64 13 Joomla\CMS\Router\SiteRouter->__construct() /home/library/master/libraries/src/Router/Router.php:189 12 Joomla\CMS\Router\Router::getInstance() /home/library/master/libraries/src/Application/CMSApplication.php:491 11 Joomla\CMS\Application\CMSApplication::getRouter() /home/library/master/libraries/src/Application/SiteApplication.php:403 10 Joomla\CMS\Application\SiteApplication::getRouter() /home/library/master/plugins/system/languagefilter/languagefilter.php:145 9 PlgSystemLanguageFilter->onAfterInitialise() /home/library/master/libraries/joomla/event/event.php:70 8 JEvent->update() /home/library/master/libraries/joomla/event/dispatcher.php:160 7 JEventDispatcher->trigger() /home/library/master/libraries/src/Application/BaseApplication.php:108 6 Joomla\CMS\Application\BaseApplication->triggerEvent() /home/library/master/libraries/src/Application/CMSApplication.php:626 5 Joomla\CMS\Application\CMSApplication->initialiseApp() /home/library/master/libraries/src/Application/SiteApplication.php:686 4 Joomla\CMS\Application\SiteApplication->initialiseApp() /home/library/master/libraries/src/Application/SiteApplication.php:212 3 Joomla\CMS\Application\SiteApplication->doExecute() /home/library/master/libraries/src/Application/CMSApplication.php:196 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php(11) : eval()'d code:50 1 eval() JROOT/index.php:11 - Query Time: 0.94 ms After last query: 9.14 ms Query memory: 0.023 MB Memory before query: 9.687 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `JdKlzg_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE JdKlzg_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition Status Duration Starting 0.19 ms Checking permissions 0.05 ms Opening tables 0.04 ms After opening tables 0.03 ms System lock 0.02 ms Table lock 0.03 ms Init 0.03 ms Optimizing 0.03 ms Statistics 0.09 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.11 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.03 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() /home/library/master/libraries/joomla/database/driver.php:1656 15 JDatabaseDriver->loadObject() /home/library/master/libraries/src/Helper/LibraryHelper.php:167 14 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Same as call in the line below. 13 call_user_func_array() /home/library/master/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() /home/library/master/libraries/src/Helper/LibraryHelper.php:175 11 Joomla\CMS\Helper\LibraryHelper::loadLibrary() /home/library/master/libraries/src/Helper/LibraryHelper.php:43 10 Joomla\CMS\Helper\LibraryHelper::getLibrary() /home/library/master/libraries/src/Helper/LibraryHelper.php:90 9 Joomla\CMS\Helper\LibraryHelper::getParams() /home/library/master/libraries/src/Version.php:321 8 Joomla\CMS\Version->getMediaVersion() /home/library/master/libraries/src/Factory.php:778 7 Joomla\CMS\Factory::createDocument() /home/library/master/libraries/src/Factory.php:234 6 Joomla\CMS\Factory::getDocument() /home/library/master/libraries/src/Application/WebApplication.php:1129 5 Joomla\CMS\Application\WebApplication->loadDocument() /home/library/master/libraries/src/Application/SiteApplication.php:133 4 Joomla\CMS\Application\SiteApplication->dispatch() /home/library/master/libraries/src/Application/SiteApplication.php:233 3 Joomla\CMS\Application\SiteApplication->doExecute() /home/library/master/libraries/src/Application/CMSApplication.php:196 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php(11) : eval()'d code:50 1 eval() JROOT/index.php:11 - Query Time: 0.65 ms After last query: 0.20 ms Query memory: 0.005 MB Memory before query: 9.684 MB
UPDATE `JdKlzg_extensions`
SET `params` = '{\"mediaversion\":\"1cc66c3299208a5a2fafcf9db8aec692\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN not possible on query: UPDATE `JdKlzg_extensions` SET `params` = '{\"mediaversion\":\"1cc66c3299208a5a2fafcf9db8aec692\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.05 ms Checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init for update 0.08 ms Updating 0.14 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.05 ms Closing tables 0.03 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.03 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() /home/library/master/libraries/src/Helper/LibraryHelper.php:117 10 Joomla\CMS\Helper\LibraryHelper::saveParams() /home/library/master/libraries/src/Version.php:372 9 Joomla\CMS\Version->setMediaVersion() /home/library/master/libraries/src/Version.php:331 8 Joomla\CMS\Version->getMediaVersion() /home/library/master/libraries/src/Factory.php:778 7 Joomla\CMS\Factory::createDocument() /home/library/master/libraries/src/Factory.php:234 6 Joomla\CMS\Factory::getDocument() /home/library/master/libraries/src/Application/WebApplication.php:1129 5 Joomla\CMS\Application\WebApplication->loadDocument() /home/library/master/libraries/src/Application/SiteApplication.php:133 4 Joomla\CMS\Application\SiteApplication->dispatch() /home/library/master/libraries/src/Application/SiteApplication.php:233 3 Joomla\CMS\Application\SiteApplication->doExecute() /home/library/master/libraries/src/Application/CMSApplication.php:196 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php(11) : eval()'d code:50 1 eval() JROOT/index.php:11 - Query Time: 0.83 ms After last query: 1.91 ms Query memory: 0.019 MB Memory before query: 9.892 MB Rows returned: 1
SELECT id, home, template, s.params
FROM JdKlzg_template_styles as s
LEFT JOIN JdKlzg_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 NO INDEX KEY COULD BE USED NULL NULL 4 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 library_m_arad.s.template,const 1 Using index condition; Using where Status Duration Starting 0.09 ms Checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.03 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.05 ms Executing 0.02 ms Sending data 0.11 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.01 ms Closing tables 0.09 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.04 ms Reset for next command 0.04 ms # Caller File and line number 7 JDatabaseDriverMysqli->execute() /home/library/master/libraries/joomla/database/driver.php:1695 6 JDatabaseDriver->loadObjectList() /home/library/master/libraries/src/Application/SiteApplication.php:486 5 Joomla\CMS\Application\SiteApplication->getTemplate() /home/library/master/libraries/src/Application/SiteApplication.php:168 4 Joomla\CMS\Application\SiteApplication->dispatch() /home/library/master/libraries/src/Application/SiteApplication.php:233 3 Joomla\CMS\Application\SiteApplication->doExecute() /home/library/master/libraries/src/Application/CMSApplication.php:196 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php(11) : eval()'d code:50 1 eval() JROOT/index.php:11 - Query Time: 1.61 ms After last query: 20.59 ms Query memory: 0.028 MB Memory before query: 11.956 MB Rows returned: 41
SELECT `id`,`name`,`rules`,`parent_id`
FROM `JdKlzg_assets`
WHERE `name` IN ('root.1','com_admin','com_agroncross','com_agronreaders','com_agronsearch','com_ajax','com_akeeba','com_associations','com_cache','com_categories','com_checkin','com_chronoforms5','com_config','com_content','com_cpanel','com_fields','com_finder','com_import_contents','com_installer','com_jce','com_jevents','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_multisites','com_plugins','com_postinstall','com_redirect','com_search','com_slogin','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_xmap')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE JdKlzg_assets range idx_asset_name idx_asset_name 202 NULL 41 Using index condition Status Duration Starting 0.19 ms Checking permissions 0.03 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.08 ms Optimizing 0.03 ms Statistics 0.21 ms Preparing 0.05 ms Executing 0.02 ms Sending data 0.56 ms End of update loop 0.03 ms Query end 0.03 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.03 ms Updating status 0.04 ms Reset for next command 0.03 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() /home/library/master/libraries/joomla/database/driver.php:1695 18 JDatabaseDriver->loadObjectList() /home/library/master/libraries/src/Access/Access.php:429 17 Joomla\CMS\Access\Access::preloadComponents() /home/library/master/libraries/src/Access/Access.php:213 16 Joomla\CMS\Access\Access::preload() /home/library/master/libraries/src/Access/Access.php:531 15 Joomla\CMS\Access\Access::getAssetRules() /home/library/master/libraries/src/Access/Access.php:183 14 Joomla\CMS\Access\Access::check() /home/library/master/libraries/src/User/User.php:406 13 Joomla\CMS\User\User->authorise() /home/library/master/components/com_jevents/libraries/helper.php:2403 12 JEVHelper::isAdminUser() /home/library/master/components/com_jevents/libraries/helper.php:2485 11 JEVHelper::getAid() /home/library/master/components/com_jevents/libraries/datamodel.php:38 10 JEventsDataModel->__construct() /home/library/master/administrator/components/com_jevents/controllers/icalrepeat.php:36 9 AdminIcalrepeatController->__construct() /home/library/master/components/com_jevents/controllers/icalrepeat.php:20 8 ICalRepeatController->__construct() /home/library/master/components/com_jevents/jevents.php:249 7 require_once /home/library/master/components/com_jevents/jevents.php /home/library/master/libraries/src/Component/ComponentHelper.php:402 6 Joomla\CMS\Component\ComponentHelper::executeComponent() /home/library/master/libraries/src/Component/ComponentHelper.php:377 5 Joomla\CMS\Component\ComponentHelper::renderComponent() /home/library/master/libraries/src/Application/SiteApplication.php:194 4 Joomla\CMS\Application\SiteApplication->dispatch() /home/library/master/libraries/src/Application/SiteApplication.php:233 3 Joomla\CMS\Application\SiteApplication->doExecute() /home/library/master/libraries/src/Application/CMSApplication.php:196 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php(11) : eval()'d code:50 1 eval() JROOT/index.php:11 - Query Time: 2.71 ms After last query: 6.48 ms Query memory: 0.023 MB Memory before query: 12.685 MB Rows returned: 1
SELECT `id`
FROM `JdKlzg_finder_types`
WHERE `title` = 'Event'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE JdKlzg_finder_types const title title 402 const 1 Using index Status Duration Starting 0.09 ms Checking permissions 0.03 ms Opening tables 1.89 ms After opening tables 0.04 ms System lock 0.02 ms Table lock 0.02 ms Init 0.05 ms Optimizing 0.06 ms Statistics 0.13 ms Preparing 0.02 ms Unlocking tables 0.03 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.03 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.03 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() /home/library/master/libraries/joomla/database/driver.php:1734 15 JDatabaseDriver->loadResult() /home/library/master/administrator/components/com_finder/helpers/indexer/adapter.php:729 14 FinderIndexerAdapter->getTypeId() /home/library/master/administrator/components/com_finder/helpers/indexer/adapter.php:142 13 FinderIndexerAdapter->__construct() /home/library/master/plugins/finder/jevents/jevents.php:81 12 plgFinderJEvents->__construct() /home/library/master/libraries/src/Plugin/PluginHelper.php:283 11 Joomla\CMS\Plugin\PluginHelper::import() /home/library/master/libraries/src/Plugin/PluginHelper.php:182 10 Joomla\CMS\Plugin\PluginHelper::importPlugin() /home/library/master/administrator/components/com_jevents/controllers/icalrepeat.php:40 9 AdminIcalrepeatController->__construct() /home/library/master/components/com_jevents/controllers/icalrepeat.php:20 8 ICalRepeatController->__construct() /home/library/master/components/com_jevents/jevents.php:249 7 require_once /home/library/master/components/com_jevents/jevents.php /home/library/master/libraries/src/Component/ComponentHelper.php:402 6 Joomla\CMS\Component\ComponentHelper::executeComponent() /home/library/master/libraries/src/Component/ComponentHelper.php:377 5 Joomla\CMS\Component\ComponentHelper::renderComponent() /home/library/master/libraries/src/Application/SiteApplication.php:194 4 Joomla\CMS\Application\SiteApplication->dispatch() /home/library/master/libraries/src/Application/SiteApplication.php:233 3 Joomla\CMS\Application\SiteApplication->doExecute() /home/library/master/libraries/src/Application/CMSApplication.php:196 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php(11) : eval()'d code:50 1 eval() JROOT/index.php:11 - Query Time: 0.75 ms After last query: 2.33 ms Query memory: 0.023 MB Memory before query: 12.853 MB Rows returned: 1
SELECT `id`
FROM `JdKlzg_finder_types`
WHERE `title` = 'Category'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE JdKlzg_finder_types const title title 402 const 1 Using index Status Duration Starting 0.06 ms Checking permissions 0.02 ms Opening tables 0.15 ms After opening tables 0.03 ms System lock 0.02 ms Table lock 0.02 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.02 ms Unlocking tables 0.03 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.02 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.03 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() /home/library/master/libraries/joomla/database/driver.php:1734 14 JDatabaseDriver->loadResult() /home/library/master/administrator/components/com_finder/helpers/indexer/adapter.php:729 13 FinderIndexerAdapter->getTypeId() /home/library/master/administrator/components/com_finder/helpers/indexer/adapter.php:142 12 FinderIndexerAdapter->__construct() /home/library/master/libraries/src/Plugin/PluginHelper.php:283 11 Joomla\CMS\Plugin\PluginHelper::import() /home/library/master/libraries/src/Plugin/PluginHelper.php:182 10 Joomla\CMS\Plugin\PluginHelper::importPlugin() /home/library/master/administrator/components/com_jevents/controllers/icalrepeat.php:40 9 AdminIcalrepeatController->__construct() /home/library/master/components/com_jevents/controllers/icalrepeat.php:20 8 ICalRepeatController->__construct() /home/library/master/components/com_jevents/jevents.php:249 7 require_once /home/library/master/components/com_jevents/jevents.php /home/library/master/libraries/src/Component/ComponentHelper.php:402 6 Joomla\CMS\Component\ComponentHelper::executeComponent() /home/library/master/libraries/src/Component/ComponentHelper.php:377 5 Joomla\CMS\Component\ComponentHelper::renderComponent() /home/library/master/libraries/src/Application/SiteApplication.php:194 4 Joomla\CMS\Application\SiteApplication->dispatch() /home/library/master/libraries/src/Application/SiteApplication.php:233 3 Joomla\CMS\Application\SiteApplication->doExecute() /home/library/master/libraries/src/Application/CMSApplication.php:196 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php(11) : eval()'d code:50 1 eval() JROOT/index.php:11 - Query Time: 0.55 ms After last query: 0.76 ms Query memory: 0.023 MB Memory before query: 12.907 MB Rows returned: 1
SELECT `id`
FROM `JdKlzg_finder_types`
WHERE `title` = 'Article'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE JdKlzg_finder_types const title title 402 const 1 Using index Status Duration Starting 0.04 ms Checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Unlocking tables 0.03 ms Preparing 0.02 ms Executing 0.02 ms Sending data 0.02 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.03 ms Freeing items 0.03 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() /home/library/master/libraries/joomla/database/driver.php:1734 14 JDatabaseDriver->loadResult() /home/library/master/administrator/components/com_finder/helpers/indexer/adapter.php:729 13 FinderIndexerAdapter->getTypeId() /home/library/master/administrator/components/com_finder/helpers/indexer/adapter.php:142 12 FinderIndexerAdapter->__construct() /home/library/master/libraries/src/Plugin/PluginHelper.php:283 11 Joomla\CMS\Plugin\PluginHelper::import() /home/library/master/libraries/src/Plugin/PluginHelper.php:182 10 Joomla\CMS\Plugin\PluginHelper::importPlugin() /home/library/master/administrator/components/com_jevents/controllers/icalrepeat.php:40 9 AdminIcalrepeatController->__construct() /home/library/master/components/com_jevents/controllers/icalrepeat.php:20 8 ICalRepeatController->__construct() /home/library/master/components/com_jevents/jevents.php:249 7 require_once /home/library/master/components/com_jevents/jevents.php /home/library/master/libraries/src/Component/ComponentHelper.php:402 6 Joomla\CMS\Component\ComponentHelper::executeComponent() /home/library/master/libraries/src/Component/ComponentHelper.php:377 5 Joomla\CMS\Component\ComponentHelper::renderComponent() /home/library/master/libraries/src/Application/SiteApplication.php:194 4 Joomla\CMS\Application\SiteApplication->dispatch() /home/library/master/libraries/src/Application/SiteApplication.php:233 3 Joomla\CMS\Application\SiteApplication->doExecute() /home/library/master/libraries/src/Application/CMSApplication.php:196 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php(11) : eval()'d code:50 1 eval() JROOT/index.php:11 - Query Time: 1.24 ms After last query: 6.16 ms Query memory: 0.029 MB Memory before query: 13.556 MB Rows returned: 18
SHOW FULL COLUMNS
FROM `JdKlzg_jev_users`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `JdKlzg_jev_users`Status Duration Starting 0.07 ms Checking permissions 0.02 ms Closing tables 0.02 ms Opening tables 0.31 ms After opening tables 0.03 ms System lock 0.02 ms Table lock 0.02 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.03 ms Executing 0.02 ms Filling schema table 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms Checking permissions 0.10 ms Closing tables 0.02 ms Executing 0.02 ms Sending data 0.07 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.01 ms Closing tables 0.02 ms Removing tmp table 0.12 ms Closing tables 0.02 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.03 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() /home/library/master/libraries/joomla/database/driver.php:1695 20 JDatabaseDriver->loadObjectList() /home/library/master/libraries/joomla/database/driver/mysqli.php:445 19 JDatabaseDriverMysqli->getTableColumns() /home/library/master/libraries/src/Table/Table.php:245 18 Joomla\CMS\Table\Table->getFields() /home/library/master/libraries/src/Table/Table.php:164 17 Joomla\CMS\Table\Table->__construct() /home/library/master/administrator/components/com_jevents/tables/jevuser.php:69 16 TableUser->__construct() /home/library/master/components/com_jevents/libraries/helper.php:2343 15 JEVHelper::getAuthorisedUser() /home/library/master/components/com_jevents/libraries/helper.php:1727 14 JEVHelper::isEventPublisher() /home/library/master/components/com_jevents/libraries/dbmodel.php:3237 13 JEventsDBModel->listEventsById() /home/library/master/components/com_jevents/libraries/datamodel.php:724 12 JEventsDataModel->getEventData() /home/library/master/components/com_jevents/views/alternative/icalevent/view.html.php:36 11 AlternativeViewICalevent->detail() /home/library/master/administrator/components/com_jevents/views/abstract/abstract.php:74 10 JEventsAbstractView->display() /home/library/master/components/com_jevents/controllers/icalrepeat.php:151 9 ICalRepeatController->detail() /home/library/master/libraries/src/MVC/Controller/BaseController.php:710 8 Joomla\CMS\MVC\Controller\BaseController->execute() /home/library/master/components/com_jevents/jevents.php:299 7 require_once /home/library/master/components/com_jevents/jevents.php /home/library/master/libraries/src/Component/ComponentHelper.php:402 6 Joomla\CMS\Component\ComponentHelper::executeComponent() /home/library/master/libraries/src/Component/ComponentHelper.php:377 5 Joomla\CMS\Component\ComponentHelper::renderComponent() /home/library/master/libraries/src/Application/SiteApplication.php:194 4 Joomla\CMS\Application\SiteApplication->dispatch() /home/library/master/libraries/src/Application/SiteApplication.php:233 3 Joomla\CMS\Application\SiteApplication->doExecute() /home/library/master/libraries/src/Application/CMSApplication.php:196 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php(11) : eval()'d code:50 1 eval() JROOT/index.php:11 - Query Time: 1.33 ms After last query: 3.17 ms Query memory: 0.045 MB Memory before query: 13.845 MB Rows returned: 19Duplicate queries: #18
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM JdKlzg_modules AS m
LEFT JOIN JdKlzg_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN JdKlzg_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-06-09 13:53:06')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-06-09 13:53:06')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 448 OR mm.menuid <= 0)
AND m.language IN ('he-IL','*')
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds,idx_language published 1 const 21 Using index condition; Using where; Using filesort 1 SIMPLE mm ref PRIMARY PRIMARY 4 library_m_arad.m.id 1 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 library_m_arad.m.module,const 1 Using index condition; Using where Status Duration Starting 0.12 ms Checking permissions 0.03 ms Opening tables 0.06 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.06 ms Optimizing 0.05 ms Statistics 0.13 ms Preparing 0.06 ms Sorting result 0.03 ms Executing 0.02 ms Sending data 0.03 ms Creating sort index 0.40 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.04 ms Reset for next command 0.03 ms # Caller File and line number 23 JDatabaseDriverMysqli->execute() /home/library/master/libraries/joomla/database/driver.php:1695 22 JDatabaseDriver->loadObjectList() Same as call in the line below. 21 call_user_func_array() /home/library/master/libraries/src/Cache/Controller/CallbackController.php:173 20 Joomla\CMS\Cache\Controller\CallbackController->get() /home/library/master/libraries/src/Helper/ModuleHelper.php:432 19 Joomla\CMS\Helper\ModuleHelper::getModuleList() /home/library/master/libraries/src/Helper/ModuleHelper.php:362 18 Joomla\CMS\Helper\ModuleHelper::load() /home/library/master/libraries/src/Helper/ModuleHelper.php:334 17 Joomla\CMS\Helper\ModuleHelper::_load() /home/library/master/components/com_jevents/libraries/jevmodulehelper.php:22 16 JevModuleHelper::getVisibleModules() /home/library/master/components/com_jevents/libraries/filters.php:54 15 jevFilterProcessing->__construct() /home/library/master/components/com_jevents/libraries/filters.php:200 14 jevFilterProcessing::getInstance() /home/library/master/components/com_jevents/libraries/dbmodel.php:3263 13 JEventsDBModel->listEventsById() /home/library/master/components/com_jevents/libraries/datamodel.php:724 12 JEventsDataModel->getEventData() /home/library/master/components/com_jevents/views/alternative/icalevent/view.html.php:36 11 AlternativeViewICalevent->detail() /home/library/master/administrator/components/com_jevents/views/abstract/abstract.php:74 10 JEventsAbstractView->display() /home/library/master/components/com_jevents/controllers/icalrepeat.php:151 9 ICalRepeatController->detail() /home/library/master/libraries/src/MVC/Controller/BaseController.php:710 8 Joomla\CMS\MVC\Controller\BaseController->execute() /home/library/master/components/com_jevents/jevents.php:299 7 require_once /home/library/master/components/com_jevents/jevents.php /home/library/master/libraries/src/Component/ComponentHelper.php:402 6 Joomla\CMS\Component\ComponentHelper::executeComponent() /home/library/master/libraries/src/Component/ComponentHelper.php:377 5 Joomla\CMS\Component\ComponentHelper::renderComponent() /home/library/master/libraries/src/Application/SiteApplication.php:194 4 Joomla\CMS\Application\SiteApplication->dispatch() /home/library/master/libraries/src/Application/SiteApplication.php:233 3 Joomla\CMS\Application\SiteApplication->doExecute() /home/library/master/libraries/src/Application/CMSApplication.php:196 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php(11) : eval()'d code:50 1 eval() JROOT/index.php:11 - Query Time: 1.13 ms After last query: 0.50 ms Query memory: 0.045 MB Memory before query: 13.912 MB Rows returned: 19Duplicate queries: #17
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM JdKlzg_modules AS m
LEFT JOIN JdKlzg_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN JdKlzg_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-06-09 13:53:06')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-06-09 13:53:06')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 448 OR mm.menuid <= 0)
AND m.language IN ('he-IL','*')
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds,idx_language published 1 const 21 Using index condition; Using where; Using filesort 1 SIMPLE mm ref PRIMARY PRIMARY 4 library_m_arad.m.id 1 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 library_m_arad.m.module,const 1 Using index condition; Using where Status Duration Starting 0.09 ms Checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.05 ms Optimizing 0.04 ms Statistics 0.08 ms Preparing 0.05 ms Sorting result 0.02 ms Executing 0.02 ms Sending data 0.02 ms Creating sort index 0.39 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.03 ms # Caller File and line number 24 JDatabaseDriverMysqli->execute() /home/library/master/libraries/joomla/database/driver.php:1695 23 JDatabaseDriver->loadObjectList() Same as call in the line below. 22 call_user_func_array() /home/library/master/libraries/src/Cache/Controller/CallbackController.php:173 21 Joomla\CMS\Cache\Controller\CallbackController->get() /home/library/master/libraries/src/Helper/ModuleHelper.php:432 20 Joomla\CMS\Helper\ModuleHelper::getModuleList() /home/library/master/libraries/src/Helper/ModuleHelper.php:362 19 Joomla\CMS\Helper\ModuleHelper::load() /home/library/master/libraries/src/Helper/ModuleHelper.php:37 18 Joomla\CMS\Helper\ModuleHelper::getModule() /home/library/master/components/com_jevents/libraries/filters.php:307 17 jevFilter->__construct() /home/library/master/components/com_jevents/libraries/filters/Justmine.php:44 16 jevJustmineFilter->__construct() /home/library/master/components/com_jevents/libraries/filters.php:142 15 jevFilterProcessing->__construct() /home/library/master/components/com_jevents/libraries/filters.php:200 14 jevFilterProcessing::getInstance() /home/library/master/components/com_jevents/libraries/dbmodel.php:3263 13 JEventsDBModel->listEventsById() /home/library/master/components/com_jevents/libraries/datamodel.php:724 12 JEventsDataModel->getEventData() /home/library/master/components/com_jevents/views/alternative/icalevent/view.html.php:36 11 AlternativeViewICalevent->detail() /home/library/master/administrator/components/com_jevents/views/abstract/abstract.php:74 10 JEventsAbstractView->display() /home/library/master/components/com_jevents/controllers/icalrepeat.php:151 9 ICalRepeatController->detail() /home/library/master/libraries/src/MVC/Controller/BaseController.php:710 8 Joomla\CMS\MVC\Controller\BaseController->execute() /home/library/master/components/com_jevents/jevents.php:299 7 require_once /home/library/master/components/com_jevents/jevents.php /home/library/master/libraries/src/Component/ComponentHelper.php:402 6 Joomla\CMS\Component\ComponentHelper::executeComponent() /home/library/master/libraries/src/Component/ComponentHelper.php:377 5 Joomla\CMS\Component\ComponentHelper::renderComponent() /home/library/master/libraries/src/Application/SiteApplication.php:194 4 Joomla\CMS\Application\SiteApplication->dispatch() /home/library/master/libraries/src/Application/SiteApplication.php:233 3 Joomla\CMS\Application\SiteApplication->doExecute() /home/library/master/libraries/src/Application/CMSApplication.php:196 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php(11) : eval()'d code:50 1 eval() JROOT/index.php:11 - Query Time: 1.02 ms After last query: 1.73 ms Query memory: 0.026 MB Memory before query: 14.035 MB Rows returned: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `JdKlzg_categories` AS `c`
WHERE (c.extension='com_jevents' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND c.language IN ('he-IL','*')
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c range cat_idx,idx_access,idx_language cat_idx 207 NULL 3 Using index condition; Using where; Using filesort Status Duration Starting 0.11 ms Checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.06 ms Optimizing 0.03 ms Statistics 0.08 ms Preparing 0.04 ms Sorting result 0.03 ms Executing 0.03 ms Sending data 0.04 ms Creating sort index 0.18 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.03 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.04 ms Updating status 0.05 ms Reset for next command 0.06 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() /home/library/master/libraries/joomla/database/driver.php:1695 18 JDatabaseDriver->loadObjectList() /home/library/master/libraries/src/Categories/Categories.php:324 17 Joomla\CMS\Categories\Categories->_load() /home/library/master/components/com_jevents/helpers/category.php:47 16 JEventsCategories->_load() /home/library/master/libraries/src/Categories/Categories.php:184 15 Joomla\CMS\Categories\Categories->get() /home/library/master/components/com_jevents/libraries/dbmodel.php:77 14 JEventsDBModel->accessibleCategoryList() /home/library/master/components/com_jevents/libraries/dbmodel.php:3270 13 JEventsDBModel->listEventsById() /home/library/master/components/com_jevents/libraries/datamodel.php:724 12 JEventsDataModel->getEventData() /home/library/master/components/com_jevents/views/alternative/icalevent/view.html.php:36 11 AlternativeViewICalevent->detail() /home/library/master/administrator/components/com_jevents/views/abstract/abstract.php:74 10 JEventsAbstractView->display() /home/library/master/components/com_jevents/controllers/icalrepeat.php:151 9 ICalRepeatController->detail() /home/library/master/libraries/src/MVC/Controller/BaseController.php:710 8 Joomla\CMS\MVC\Controller\BaseController->execute() /home/library/master/components/com_jevents/jevents.php:299 7 require_once /home/library/master/components/com_jevents/jevents.php /home/library/master/libraries/src/Component/ComponentHelper.php:402 6 Joomla\CMS\Component\ComponentHelper::executeComponent() /home/library/master/libraries/src/Component/ComponentHelper.php:377 5 Joomla\CMS\Component\ComponentHelper::renderComponent() /home/library/master/libraries/src/Application/SiteApplication.php:194 4 Joomla\CMS\Application\SiteApplication->dispatch() /home/library/master/libraries/src/Application/SiteApplication.php:233 3 Joomla\CMS\Application\SiteApplication->doExecute() /home/library/master/libraries/src/Application/CMSApplication.php:196 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php(11) : eval()'d code:50 1 eval() JROOT/index.php:11 - Query Time: 0.76 ms After last query: 0.53 ms Query memory: 0.023 MB Memory before query: 14.094 MB Rows returned: 2
SELECT c.id
FROM JdKlzg_categories AS c
WHERE c.access IN (1,1)
AND c.published = 1
AND c.language in ('he-IL','*')
AND c.extension = 'com_jevents'
ORDER BY c.lft ascid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c range cat_idx,idx_access,idx_language cat_idx 207 NULL 2 Using index condition; Using where; Using filesort Status Duration Starting 0.07 ms Checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.03 ms Optimizing 0.04 ms Statistics 0.10 ms Preparing 0.04 ms Sorting result 0.02 ms Executing 0.02 ms Sending data 0.02 ms Creating sort index 0.08 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.03 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() /home/library/master/libraries/joomla/database/driver.php:1544 15 JDatabaseDriver->loadColumn() /home/library/master/components/com_jevents/libraries/dbmodel.php:186 14 JEventsDBModel->accessibleCategoryList() /home/library/master/components/com_jevents/libraries/dbmodel.php:3270 13 JEventsDBModel->listEventsById() /home/library/master/components/com_jevents/libraries/datamodel.php:724 12 JEventsDataModel->getEventData() /home/library/master/components/com_jevents/views/alternative/icalevent/view.html.php:36 11 AlternativeViewICalevent->detail() /home/library/master/administrator/components/com_jevents/views/abstract/abstract.php:74 10 JEventsAbstractView->display() /home/library/master/components/com_jevents/controllers/icalrepeat.php:151 9 ICalRepeatController->detail() /home/library/master/libraries/src/MVC/Controller/BaseController.php:710 8 Joomla\CMS\MVC\Controller\BaseController->execute() /home/library/master/components/com_jevents/jevents.php:299 7 require_once /home/library/master/components/com_jevents/jevents.php /home/library/master/libraries/src/Component/ComponentHelper.php:402 6 Joomla\CMS\Component\ComponentHelper::executeComponent() /home/library/master/libraries/src/Component/ComponentHelper.php:377 5 Joomla\CMS\Component\ComponentHelper::renderComponent() /home/library/master/libraries/src/Application/SiteApplication.php:194 4 Joomla\CMS\Application\SiteApplication->dispatch() /home/library/master/libraries/src/Application/SiteApplication.php:233 3 Joomla\CMS\Application\SiteApplication->doExecute() /home/library/master/libraries/src/Application/CMSApplication.php:196 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php(11) : eval()'d code:50 1 eval() JROOT/index.php:11 - Query Time: 1.95 ms After last query: 0.15 ms Query memory: 0.041 MB Memory before query: 14.109 MB Rows returned: 1
SELECT ev.*, ev.state as published, rpt.*, rr.*, det.* , GROUP_CONCAT(DISTINCT catmapcat.id
ORDER BY catmapcat.lft ASC SEPARATOR ',' ) as catids, ev.created as created , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup , YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup , HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn , ev.state as state
FROM (JdKlzg_jevents_vevent as ev )
INNER JOIN JdKlzg_jevents_repetition as rpt
ON rpt.eventid = ev.ev_id
INNER JOIN JdKlzg_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN JdKlzg_jevents_rrule as rr
ON rr.eventid = ev.ev_id
INNER JOIN JdKlzg_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
LEFT JOIN JdKlzg_jevents_catmap as catmap
ON catmap.evid = rpt.eventid
LEFT JOIN JdKlzg_categories AS catmapcat
ON catmap.catid = catmapcat.id
WHERE 1
AND ev.access IN (1,1)
AND icsf.access IN (1,1)
AND catmap.catid IN(-1,58,59)
AND rpt.rp_id = '969'
GROUP BY rpt.rp_idid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE icsf system PRIMARY NO INDEX KEY COULD BE USED NULL NULL 1 1 SIMPLE rpt const PRIMARY,eventid,eventstart,eventend,eventdetail PRIMARY 4 const 1 1 SIMPLE det const PRIMARY PRIMARY 4 const 1 1 SIMPLE ev const PRIMARY,icsid,evaccess PRIMARY 4 const 1 1 SIMPLE rr ref eventid eventid 4 const 1 1 SIMPLE catmap range key_event_category,key_evid key_event_category 8 NULL 3 Using where; Using index; Using join buffer (flat, BNL join) 1 SIMPLE catmapcat eq_ref PRIMARY PRIMARY 4 library_m_arad.catmap.catid 1 Status Duration Starting 0.13 ms Checking permissions 0.02 ms Opening tables 0.68 ms After opening tables 0.04 ms System lock 0.02 ms Table lock 0.02 ms Init 0.09 ms Optimizing 0.05 ms Statistics 0.18 ms Preparing 0.02 ms Unlocking tables 0.02 ms Preparing 0.13 ms Executing 0.04 ms Sending data 0.16 ms End of update loop 0.03 ms Removing tmp table 0.02 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.01 ms Closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.03 ms Updating status 0.03 ms Reset for next command 0.03 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() /home/library/master/libraries/joomla/database/driver.php:1695 14 JDatabaseDriver->loadObjectList() /home/library/master/components/com_jevents/libraries/dbmodel.php:3316 13 JEventsDBModel->listEventsById() /home/library/master/components/com_jevents/libraries/datamodel.php:724 12 JEventsDataModel->getEventData() /home/library/master/components/com_jevents/views/alternative/icalevent/view.html.php:36 11 AlternativeViewICalevent->detail() /home/library/master/administrator/components/com_jevents/views/abstract/abstract.php:74 10 JEventsAbstractView->display() /home/library/master/components/com_jevents/controllers/icalrepeat.php:151 9 ICalRepeatController->detail() /home/library/master/libraries/src/MVC/Controller/BaseController.php:710 8 Joomla\CMS\MVC\Controller\BaseController->execute() /home/library/master/components/com_jevents/jevents.php:299 7 require_once /home/library/master/components/com_jevents/jevents.php /home/library/master/libraries/src/Component/ComponentHelper.php:402 6 Joomla\CMS\Component\ComponentHelper::executeComponent() /home/library/master/libraries/src/Component/ComponentHelper.php:377 5 Joomla\CMS\Component\ComponentHelper::renderComponent() /home/library/master/libraries/src/Application/SiteApplication.php:194 4 Joomla\CMS\Application\SiteApplication->dispatch() /home/library/master/libraries/src/Application/SiteApplication.php:233 3 Joomla\CMS\Application\SiteApplication->doExecute() /home/library/master/libraries/src/Application/CMSApplication.php:196 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php(11) : eval()'d code:50 1 eval() JROOT/index.php:11 - Query Time: 2.25 ms After last query: 4.82 ms Query memory: 0.023 MB Memory before query: 14.654 MB Rows returned: 0
SELECT ju.id, ju.name, ju.username, ju.sendEmail, ju.email, cd.name as contactname,
CASE WHEN CHAR_LENGTH(cd.alias) THEN CONCAT_WS(':', cd.id, cd.alias) ELSE cd.id END as slug,
CASE WHEN CHAR_LENGTH(cat.alias) THEN CONCAT_WS(':', cat.id, cat.alias) ELSE cat.id END AS catslug
FROM JdKlzg_users AS ju
LEFT JOIN JdKlzg_contact_details AS cd
ON cd.user_id = ju.id
LEFT JOIN JdKlzg_categories AS cat
ON cat.id = cd.catid
WHERE block ='0'
AND cd.published =1
AND cd.access IN (1,1)
AND cat.access IN (1,1)
AND ju.id = 1000003id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ju const PRIMARY,idx_block PRIMARY 4 const 1 1 SIMPLE cd ref idx_access,idx_state,idx_catid idx_state 1 const 1 Using where 1 SIMPLE cat eq_ref PRIMARY,idx_access PRIMARY 4 library_m_arad.cd.catid 1 Using where Status Duration Starting 0.14 ms Checking permissions 0.02 ms Opening tables 1.31 ms After opening tables 0.04 ms System lock 0.02 ms Table lock 0.04 ms Init 0.08 ms Optimizing 0.05 ms Statistics 0.13 ms Preparing 0.02 ms Unlocking tables 0.01 ms Preparing 0.04 ms Executing 0.02 ms Sending data 0.06 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.03 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() /home/library/master/libraries/joomla/database/driver.php:1656 15 JDatabaseDriver->loadObject() /home/library/master/components/com_jevents/libraries/helper.php:2278 14 JEVHelper::getContact() /home/library/master/components/com_jevents/libraries/jeventshtml.php:635 13 JEventsHTML::getUserMailtoLink() /home/library/master/components/com_jevents/libraries/datamodel.php:756 12 JEventsDataModel->getEventData() /home/library/master/components/com_jevents/views/alternative/icalevent/view.html.php:36 11 AlternativeViewICalevent->detail() /home/library/master/administrator/components/com_jevents/views/abstract/abstract.php:74 10 JEventsAbstractView->display() /home/library/master/components/com_jevents/controllers/icalrepeat.php:151 9 ICalRepeatController->detail() /home/library/master/libraries/src/MVC/Controller/BaseController.php:710 8 Joomla\CMS\MVC\Controller\BaseController->execute() /home/library/master/components/com_jevents/jevents.php:299 7 require_once /home/library/master/components/com_jevents/jevents.php /home/library/master/libraries/src/Component/ComponentHelper.php:402 6 Joomla\CMS\Component\ComponentHelper::executeComponent() /home/library/master/libraries/src/Component/ComponentHelper.php:377 5 Joomla\CMS\Component\ComponentHelper::renderComponent() /home/library/master/libraries/src/Application/SiteApplication.php:194 4 Joomla\CMS\Application\SiteApplication->dispatch() /home/library/master/libraries/src/Application/SiteApplication.php:233 3 Joomla\CMS\Application\SiteApplication->doExecute() /home/library/master/libraries/src/Application/CMSApplication.php:196 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php(11) : eval()'d code:50 1 eval() JROOT/index.php:11 - Query Time: 0.67 ms After last query: 0.10 ms Query memory: 0.024 MB Memory before query: 14.672 MB Rows returned: 1
SELECT `id`
FROM `JdKlzg_users`
WHERE `id` = '1000003'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE JdKlzg_users const PRIMARY PRIMARY 4 const 1 Using index Status Duration Starting 0.05 ms Checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.01 ms Table lock 0.02 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.03 ms Unlocking tables 0.04 ms Preparing 0.03 ms Executing 0.03 ms Sending data 0.03 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.03 ms Starting cleanup 0.03 ms Freeing items 0.03 ms Updating status 0.04 ms Reset for next command 0.03 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() /home/library/master/libraries/joomla/database/driver.php:1734 16 JDatabaseDriver->loadResult() /home/library/master/components/com_jevents/libraries/helper.php:3220 15 JEVHelper::getUser() /home/library/master/components/com_jevents/libraries/helper.php:2285 14 JEVHelper::getContact() /home/library/master/components/com_jevents/libraries/jeventshtml.php:635 13 JEventsHTML::getUserMailtoLink() /home/library/master/components/com_jevents/libraries/datamodel.php:756 12 JEventsDataModel->getEventData() /home/library/master/components/com_jevents/views/alternative/icalevent/view.html.php:36 11 AlternativeViewICalevent->detail() /home/library/master/administrator/components/com_jevents/views/abstract/abstract.php:74 10 JEventsAbstractView->display() /home/library/master/components/com_jevents/controllers/icalrepeat.php:151 9 ICalRepeatController->detail() /home/library/master/libraries/src/MVC/Controller/BaseController.php:710 8 Joomla\CMS\MVC\Controller\BaseController->execute() /home/library/master/components/com_jevents/jevents.php:299 7 require_once /home/library/master/components/com_jevents/jevents.php /home/library/master/libraries/src/Component/ComponentHelper.php:402 6 Joomla\CMS\Component\ComponentHelper::executeComponent() /home/library/master/libraries/src/Component/ComponentHelper.php:377 5 Joomla\CMS\Component\ComponentHelper::renderComponent() /home/library/master/libraries/src/Application/SiteApplication.php:194 4 Joomla\CMS\Application\SiteApplication->dispatch() /home/library/master/libraries/src/Application/SiteApplication.php:233 3 Joomla\CMS\Application\SiteApplication->doExecute() /home/library/master/libraries/src/Application/CMSApplication.php:196 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php(11) : eval()'d code:50 1 eval() JROOT/index.php:11 - Query Time: 1.25 ms After last query: 0.82 ms Query memory: 0.030 MB Memory before query: 14.759 MB Rows returned: 16
SHOW FULL COLUMNS
FROM `JdKlzg_users`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `JdKlzg_users`Status Duration Starting 0.05 ms Checking permissions 0.02 ms Closing tables 0.02 ms Opening tables 0.33 ms After opening tables 0.03 ms System lock 0.01 ms Table lock 0.02 ms Init 0.02 ms Optimizing 0.03 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.02 ms Filling schema table 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms Checking permissions 0.11 ms Closing tables 0.03 ms Executing 0.03 ms Sending data 0.07 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.11 ms Closing tables 0.02 ms Unlocking tables 0.04 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.05 ms Reset for next command 0.03 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() /home/library/master/libraries/joomla/database/driver.php:1695 26 JDatabaseDriver->loadObjectList() /home/library/master/libraries/joomla/database/driver/mysqli.php:445 25 JDatabaseDriverMysqli->getTableColumns() /home/library/master/libraries/src/Table/Table.php:245 24 Joomla\CMS\Table\Table->getFields() /home/library/master/libraries/src/Table/Table.php:164 23 Joomla\CMS\Table\Table->__construct() /home/library/master/libraries/src/Table/User.php:40 22 Joomla\CMS\Table\User->__construct() /home/library/master/libraries/src/Table/Table.php:312 21 Joomla\CMS\Table\Table::getInstance() /home/library/master/libraries/src/User/User.php:611 20 Joomla\CMS\User\User::getTable() /home/library/master/libraries/src/User/User.php:888 19 Joomla\CMS\User\User->load() /home/library/master/libraries/src/User/User.php:248 18 Joomla\CMS\User\User->__construct() /home/library/master/libraries/src/User/User.php:301 17 Joomla\CMS\User\User::getInstance() /home/library/master/libraries/src/Factory.php:266 16 Joomla\CMS\Factory::getUser() /home/library/master/components/com_jevents/libraries/helper.php:3226 15 JEVHelper::getUser() /home/library/master/components/com_jevents/libraries/helper.php:2285 14 JEVHelper::getContact() /home/library/master/components/com_jevents/libraries/jeventshtml.php:635 13 JEventsHTML::getUserMailtoLink() /home/library/master/components/com_jevents/libraries/datamodel.php:756 12 JEventsDataModel->getEventData() /home/library/master/components/com_jevents/views/alternative/icalevent/view.html.php:36 11 AlternativeViewICalevent->detail() /home/library/master/administrator/components/com_jevents/views/abstract/abstract.php:74 10 JEventsAbstractView->display() /home/library/master/components/com_jevents/controllers/icalrepeat.php:151 9 ICalRepeatController->detail() /home/library/master/libraries/src/MVC/Controller/BaseController.php:710 8 Joomla\CMS\MVC\Controller\BaseController->execute() /home/library/master/components/com_jevents/jevents.php:299 7 require_once /home/library/master/components/com_jevents/jevents.php /home/library/master/libraries/src/Component/ComponentHelper.php:402 6 Joomla\CMS\Component\ComponentHelper::executeComponent() /home/library/master/libraries/src/Component/ComponentHelper.php:377 5 Joomla\CMS\Component\ComponentHelper::renderComponent() /home/library/master/libraries/src/Application/SiteApplication.php:194 4 Joomla\CMS\Application\SiteApplication->dispatch() /home/library/master/libraries/src/Application/SiteApplication.php:233 3 Joomla\CMS\Application\SiteApplication->doExecute() /home/library/master/libraries/src/Application/CMSApplication.php:196 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php(11) : eval()'d code:50 1 eval() JROOT/index.php:11 - Query Time: 0.62 ms After last query: 0.15 ms Query memory: 0.026 MB Memory before query: 14.800 MB Rows returned: 1
SELECT *
FROM `JdKlzg_users`
WHERE `id` = 1000003id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE JdKlzg_users const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.03 ms Checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.03 ms Init 0.04 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Unlocking tables 0.03 ms Preparing 0.02 ms Executing 0.02 ms Sending data 0.05 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() /home/library/master/libraries/joomla/database/driver.php:1459 21 JDatabaseDriver->loadAssoc() /home/library/master/libraries/src/Table/User.php:86 20 Joomla\CMS\Table\User->load() /home/library/master/libraries/src/User/User.php:891 19 Joomla\CMS\User\User->load() /home/library/master/libraries/src/User/User.php:248 18 Joomla\CMS\User\User->__construct() /home/library/master/libraries/src/User/User.php:301 17 Joomla\CMS\User\User::getInstance() /home/library/master/libraries/src/Factory.php:266 16 Joomla\CMS\Factory::getUser() /home/library/master/components/com_jevents/libraries/helper.php:3226 15 JEVHelper::getUser() /home/library/master/components/com_jevents/libraries/helper.php:2285 14 JEVHelper::getContact() /home/library/master/components/com_jevents/libraries/jeventshtml.php:635 13 JEventsHTML::getUserMailtoLink() /home/library/master/components/com_jevents/libraries/datamodel.php:756 12 JEventsDataModel->getEventData() /home/library/master/components/com_jevents/views/alternative/icalevent/view.html.php:36 11 AlternativeViewICalevent->detail() /home/library/master/administrator/components/com_jevents/views/abstract/abstract.php:74 10 JEventsAbstractView->display() /home/library/master/components/com_jevents/controllers/icalrepeat.php:151 9 ICalRepeatController->detail() /home/library/master/libraries/src/MVC/Controller/BaseController.php:710 8 Joomla\CMS\MVC\Controller\BaseController->execute() /home/library/master/components/com_jevents/jevents.php:299 7 require_once /home/library/master/components/com_jevents/jevents.php /home/library/master/libraries/src/Component/ComponentHelper.php:402 6 Joomla\CMS\Component\ComponentHelper::executeComponent() /home/library/master/libraries/src/Component/ComponentHelper.php:377 5 Joomla\CMS\Component\ComponentHelper::renderComponent() /home/library/master/libraries/src/Application/SiteApplication.php:194 4 Joomla\CMS\Application\SiteApplication->dispatch() /home/library/master/libraries/src/Application/SiteApplication.php:233 3 Joomla\CMS\Application\SiteApplication->doExecute() /home/library/master/libraries/src/Application/CMSApplication.php:196 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php(11) : eval()'d code:50 1 eval() JROOT/index.php:11 - Query Time: 1.51 ms After last query: 2.99 ms Query memory: 0.026 MB Memory before query: 15.565 MB Rows returned: 1
SELECT `g`.`id`,`g`.`title`
FROM `JdKlzg_usergroups` AS g
INNER JOIN `JdKlzg_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 1000003id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY PRIMARY 4 const 1 Using index 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 library_m_arad.m.group_id 1 Status Duration Starting 0.05 ms Checking permissions 0.02 ms Opening tables 0.86 ms After opening tables 0.05 ms System lock 0.02 ms Table lock 0.02 ms Init 0.03 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.04 ms Executing 0.02 ms Sending data 0.08 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.03 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() /home/library/master/libraries/joomla/database/driver.php:1500 21 JDatabaseDriver->loadAssocList() /home/library/master/libraries/src/Table/User.php:111 20 Joomla\CMS\Table\User->load() /home/library/master/libraries/src/User/User.php:891 19 Joomla\CMS\User\User->load() /home/library/master/libraries/src/User/User.php:248 18 Joomla\CMS\User\User->__construct() /home/library/master/libraries/src/User/User.php:301 17 Joomla\CMS\User\User::getInstance() /home/library/master/libraries/src/Factory.php:266 16 Joomla\CMS\Factory::getUser() /home/library/master/components/com_jevents/libraries/helper.php:3226 15 JEVHelper::getUser() /home/library/master/components/com_jevents/libraries/helper.php:2285 14 JEVHelper::getContact() /home/library/master/components/com_jevents/libraries/jeventshtml.php:635 13 JEventsHTML::getUserMailtoLink() /home/library/master/components/com_jevents/libraries/datamodel.php:756 12 JEventsDataModel->getEventData() /home/library/master/components/com_jevents/views/alternative/icalevent/view.html.php:36 11 AlternativeViewICalevent->detail() /home/library/master/administrator/components/com_jevents/views/abstract/abstract.php:74 10 JEventsAbstractView->display() /home/library/master/components/com_jevents/controllers/icalrepeat.php:151 9 ICalRepeatController->detail() /home/library/master/libraries/src/MVC/Controller/BaseController.php:710 8 Joomla\CMS\MVC\Controller\BaseController->execute() /home/library/master/components/com_jevents/jevents.php:299 7 require_once /home/library/master/components/com_jevents/jevents.php /home/library/master/libraries/src/Component/ComponentHelper.php:402 6 Joomla\CMS\Component\ComponentHelper::executeComponent() /home/library/master/libraries/src/Component/ComponentHelper.php:377 5 Joomla\CMS\Component\ComponentHelper::renderComponent() /home/library/master/libraries/src/Application/SiteApplication.php:194 4 Joomla\CMS\Application\SiteApplication->dispatch() /home/library/master/libraries/src/Application/SiteApplication.php:233 3 Joomla\CMS\Application\SiteApplication->doExecute() /home/library/master/libraries/src/Application/CMSApplication.php:196 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php(11) : eval()'d code:50 1 eval() JROOT/index.php:11 - Query Time: 0.80 ms After last query: 4.40 ms Query memory: 0.006 MB Memory before query: 15.892 MB
UPDATE JdKlzg_jevents_vevdetail
SET hits=(hits+1)
WHERE evdet_id='745'EXPLAIN not possible on query: UPDATE JdKlzg_jevents_vevdetail SET hits=(hits+1) WHERE evdet_id='745'Status Duration Starting 0.06 ms Checking permissions 0.02 ms Opening tables 0.26 ms After opening tables 0.03 ms System lock 0.02 ms Table lock 0.02 ms Init for update 0.05 ms Updating 0.09 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.02 ms Unlocking tables 0.03 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.03 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() /home/library/master/components/com_jevents/libraries/jicaleventdb.php:831 13 jIcalEventDB->updateHits() /home/library/master/components/com_jevents/libraries/datamodel.php:846 12 JEventsDataModel->getEventData() /home/library/master/components/com_jevents/views/alternative/icalevent/view.html.php:36 11 AlternativeViewICalevent->detail() /home/library/master/administrator/components/com_jevents/views/abstract/abstract.php:74 10 JEventsAbstractView->display() /home/library/master/components/com_jevents/controllers/icalrepeat.php:151 9 ICalRepeatController->detail() /home/library/master/libraries/src/MVC/Controller/BaseController.php:710 8 Joomla\CMS\MVC\Controller\BaseController->execute() /home/library/master/components/com_jevents/jevents.php:299 7 require_once /home/library/master/components/com_jevents/jevents.php /home/library/master/libraries/src/Component/ComponentHelper.php:402 6 Joomla\CMS\Component\ComponentHelper::executeComponent() /home/library/master/libraries/src/Component/ComponentHelper.php:377 5 Joomla\CMS\Component\ComponentHelper::renderComponent() /home/library/master/libraries/src/Application/SiteApplication.php:194 4 Joomla\CMS\Application\SiteApplication->dispatch() /home/library/master/libraries/src/Application/SiteApplication.php:233 3 Joomla\CMS\Application\SiteApplication->doExecute() /home/library/master/libraries/src/Application/CMSApplication.php:196 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php(11) : eval()'d code:50 1 eval() JROOT/index.php:11 - Query Time: 2.64 ms After last query: 3.90 ms Query memory: 0.025 MB Memory before query: 16.233 MB Rows returned: 1
SELECT *
FROM JdKlzg_jev_defaults
WHERE state=1
AND name= 'icalevent.detail_body'
AND value<>''
AND language in ('he-IL','*')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE JdKlzg_jev_defaults ref name,langcodename name 152 const 9 Using index condition; Using where Status Duration Starting 0.07 ms Checking permissions 0.02 ms Opening tables 1.92 ms After opening tables 0.03 ms System lock 0.02 ms Table lock 0.02 ms Init 0.06 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.04 ms Executing 0.02 ms Sending data 0.11 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.03 ms Updating status 0.03 ms Reset for next command 0.03 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() /home/library/master/libraries/joomla/database/driver.php:1695 18 JDatabaseDriver->loadObjectList() /home/library/master/templates/joomla-israel/html/com_jevents/helpers/defaultloadedfromtemplate.php:28 17 DefaultLoadedFromTemplate() /home/library/master/components/com_jevents/views/default/abstract/abstract.php:160 16 JEventsDefaultView->__call() /home/library/master/components/com_jevents/views/alternative/icalevent/tmpl/detail_body.php:39 15 include /home/library/master/components/com_jevents/views/alternative/icalevent/tmpl/detail_body.php /home/library/master/libraries/src/MVC/View/HtmlView.php:700 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() /home/library/master/components/com_jevents/views/alternative/icalevent/tmpl/detail.php:5 13 include /home/library/master/components/com_jevents/views/alternative/icalevent/tmpl/detail.php /home/library/master/libraries/src/MVC/View/HtmlView.php:700 12 Joomla\CMS\MVC\View\HtmlView->loadTemplate() /home/library/master/libraries/src/MVC/View/HtmlView.php:233 11 Joomla\CMS\MVC\View\HtmlView->display() /home/library/master/administrator/components/com_jevents/views/abstract/abstract.php:92 10 JEventsAbstractView->display() /home/library/master/components/com_jevents/controllers/icalrepeat.php:151 9 ICalRepeatController->detail() /home/library/master/libraries/src/MVC/Controller/BaseController.php:710 8 Joomla\CMS\MVC\Controller\BaseController->execute() /home/library/master/components/com_jevents/jevents.php:299 7 require_once /home/library/master/components/com_jevents/jevents.php /home/library/master/libraries/src/Component/ComponentHelper.php:402 6 Joomla\CMS\Component\ComponentHelper::executeComponent() /home/library/master/libraries/src/Component/ComponentHelper.php:377 5 Joomla\CMS\Component\ComponentHelper::renderComponent() /home/library/master/libraries/src/Application/SiteApplication.php:194 4 Joomla\CMS\Application\SiteApplication->dispatch() /home/library/master/libraries/src/Application/SiteApplication.php:233 3 Joomla\CMS\Application\SiteApplication->doExecute() /home/library/master/libraries/src/Application/CMSApplication.php:196 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php(11) : eval()'d code:50 1 eval() JROOT/index.php:11 - Query Time: 0.83 ms After last query: 0.53 ms Query memory: 0.028 MB Memory before query: 16.268 MB Rows returned: 4
SELECT `id`,`name`,`rules`,`parent_id`
FROM `JdKlzg_assets`
WHERE `name` LIKE 'com_jevents.%' OR `name` = 'com_jevents' OR `parent_id` = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE JdKlzg_assets ALL idx_asset_name,idx_parent_id NO INDEX KEY COULD BE USED NULL NULL 416 Using where Status Duration Starting 0.05 ms Checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.03 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.28 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.02 ms Closing tables 0.01 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller File and line number 26 JDatabaseDriverMysqli->execute() /home/library/master/libraries/joomla/database/driver.php:1695 25 JDatabaseDriver->loadObjectList() /home/library/master/libraries/src/Access/Access.php:359 24 Joomla\CMS\Access\Access::preloadPermissions() /home/library/master/libraries/src/Access/Access.php:226 23 Joomla\CMS\Access\Access::preload() /home/library/master/libraries/src/Access/Access.php:540 22 Joomla\CMS\Access\Access::getAssetRules() /home/library/master/libraries/src/Access/Access.php:183 21 Joomla\CMS\Access\Access::check() /home/library/master/libraries/src/User/User.php:406 20 Joomla\CMS\User\User->authorise() /home/library/master/components/com_jevents/libraries/helper.php:2708 19 JEVHelper::authoriseCategories() /home/library/master/components/com_jevents/libraries/helper.php:2191 18 JEVHelper::canDeleteEvent() /home/library/master/templates/joomla-israel/html/com_jevents/helpers/defaultloadedfromtemplate.php:683 17 DefaultLoadedFromTemplate() /home/library/master/components/com_jevents/views/default/abstract/abstract.php:160 16 JEventsDefaultView->__call() /home/library/master/components/com_jevents/views/alternative/icalevent/tmpl/detail_body.php:39 15 include /home/library/master/components/com_jevents/views/alternative/icalevent/tmpl/detail_body.php /home/library/master/libraries/src/MVC/View/HtmlView.php:700 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() /home/library/master/components/com_jevents/views/alternative/icalevent/tmpl/detail.php:5 13 include /home/library/master/components/com_jevents/views/alternative/icalevent/tmpl/detail.php /home/library/master/libraries/src/MVC/View/HtmlView.php:700 12 Joomla\CMS\MVC\View\HtmlView->loadTemplate() /home/library/master/libraries/src/MVC/View/HtmlView.php:233 11 Joomla\CMS\MVC\View\HtmlView->display() /home/library/master/administrator/components/com_jevents/views/abstract/abstract.php:92 10 JEventsAbstractView->display() /home/library/master/components/com_jevents/controllers/icalrepeat.php:151 9 ICalRepeatController->detail() /home/library/master/libraries/src/MVC/Controller/BaseController.php:710 8 Joomla\CMS\MVC\Controller\BaseController->execute() /home/library/master/components/com_jevents/jevents.php:299 7 require_once /home/library/master/components/com_jevents/jevents.php /home/library/master/libraries/src/Component/ComponentHelper.php:402 6 Joomla\CMS\Component\ComponentHelper::executeComponent() /home/library/master/libraries/src/Component/ComponentHelper.php:377 5 Joomla\CMS\Component\ComponentHelper::renderComponent() /home/library/master/libraries/src/Application/SiteApplication.php:194 4 Joomla\CMS\Application\SiteApplication->dispatch() /home/library/master/libraries/src/Application/SiteApplication.php:233 3 Joomla\CMS\Application\SiteApplication->doExecute() /home/library/master/libraries/src/Application/CMSApplication.php:196 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php(11) : eval()'d code:50 1 eval() JROOT/index.php:11 - Query Time: 1.60 ms After last query: 0.77 ms Query memory: 0.027 MB Memory before query: 16.316 MB Rows returned: 1
SELECT rpt.*,det.summary as title , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
FROM JdKlzg_jevents_repetition as rpt
LEFT JOIN JdKlzg_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
WHERE rpt.eventid=732
AND rpt.rp_id <> 969
AND rpt.startrepeat<='2025-02-19 17:30:00'
ORDER BY rpt.startrepeat DESC
limit 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rpt range PRIMARY,eventid,eventstart,eventend,startrepeat,startend eventstart 9 NULL 4 Using where 1 SIMPLE det eq_ref PRIMARY PRIMARY 4 library_m_arad.rpt.eventdetail_id 1 Status Duration Starting 0.08 ms Checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.04 ms Optimizing 0.03 ms Statistics 0.85 ms Preparing 0.09 ms Sorting result 0.03 ms Executing 0.02 ms Sending data 0.09 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.03 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() /home/library/master/libraries/joomla/database/driver.php:1656 21 JDatabaseDriver->loadObject() /home/library/master/components/com_jevents/libraries/jicaleventrepeat.php:415 20 jIcalEventRepeat->getAdjacentRepeats() /home/library/master/components/com_jevents/libraries/jicaleventrepeat.php:378 19 jIcalEventRepeat->prevRepeat() /home/library/master/components/com_jevents/libraries/jicaleventrepeat.php:327 18 jIcalEventRepeat->previousnextLinks() /home/library/master/templates/joomla-israel/html/com_jevents/helpers/defaultloadedfromtemplate.php:1100 17 DefaultLoadedFromTemplate() /home/library/master/components/com_jevents/views/default/abstract/abstract.php:160 16 JEventsDefaultView->__call() /home/library/master/components/com_jevents/views/alternative/icalevent/tmpl/detail_body.php:39 15 include /home/library/master/components/com_jevents/views/alternative/icalevent/tmpl/detail_body.php /home/library/master/libraries/src/MVC/View/HtmlView.php:700 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() /home/library/master/components/com_jevents/views/alternative/icalevent/tmpl/detail.php:5 13 include /home/library/master/components/com_jevents/views/alternative/icalevent/tmpl/detail.php /home/library/master/libraries/src/MVC/View/HtmlView.php:700 12 Joomla\CMS\MVC\View\HtmlView->loadTemplate() /home/library/master/libraries/src/MVC/View/HtmlView.php:233 11 Joomla\CMS\MVC\View\HtmlView->display() /home/library/master/administrator/components/com_jevents/views/abstract/abstract.php:92 10 JEventsAbstractView->display() /home/library/master/components/com_jevents/controllers/icalrepeat.php:151 9 ICalRepeatController->detail() /home/library/master/libraries/src/MVC/Controller/BaseController.php:710 8 Joomla\CMS\MVC\Controller\BaseController->execute() /home/library/master/components/com_jevents/jevents.php:299 7 require_once /home/library/master/components/com_jevents/jevents.php /home/library/master/libraries/src/Component/ComponentHelper.php:402 6 Joomla\CMS\Component\ComponentHelper::executeComponent() /home/library/master/libraries/src/Component/ComponentHelper.php:377 5 Joomla\CMS\Component\ComponentHelper::renderComponent() /home/library/master/libraries/src/Application/SiteApplication.php:194 4 Joomla\CMS\Application\SiteApplication->dispatch() /home/library/master/libraries/src/Application/SiteApplication.php:233 3 Joomla\CMS\Application\SiteApplication->doExecute() /home/library/master/libraries/src/Application/CMSApplication.php:196 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php(11) : eval()'d code:50 1 eval() JROOT/index.php:11 - Query Time: 0.78 ms After last query: 1.52 ms Query memory: 0.027 MB Memory before query: 16.381 MB Rows returned: 1
SELECT rpt.*,det.summary as title, YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
FROM JdKlzg_jevents_repetition as rpt
LEFT JOIN JdKlzg_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
WHERE rpt.eventid=732
AND rpt.rp_id <> 969
AND rpt.startrepeat>='2025-02-19 17:30:00'
ORDER BY rpt.startrepeat ASC
limit 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rpt range PRIMARY,eventid,eventstart,eventend,startrepeat,startend eventstart 9 NULL 7 Using where 1 SIMPLE det eq_ref PRIMARY PRIMARY 4 library_m_arad.rpt.eventdetail_id 1 Status Duration Starting 0.09 ms Checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.04 ms Init 0.04 ms Optimizing 0.04 ms Statistics 0.09 ms Preparing 0.05 ms Sorting result 0.02 ms Executing 0.02 ms Sending data 0.06 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.02 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() /home/library/master/libraries/joomla/database/driver.php:1656 21 JDatabaseDriver->loadObject() /home/library/master/components/com_jevents/libraries/jicaleventrepeat.php:431 20 jIcalEventRepeat->getAdjacentRepeats() /home/library/master/components/com_jevents/libraries/jicaleventrepeat.php:378 19 jIcalEventRepeat->prevRepeat() /home/library/master/components/com_jevents/libraries/jicaleventrepeat.php:327 18 jIcalEventRepeat->previousnextLinks() /home/library/master/templates/joomla-israel/html/com_jevents/helpers/defaultloadedfromtemplate.php:1100 17 DefaultLoadedFromTemplate() /home/library/master/components/com_jevents/views/default/abstract/abstract.php:160 16 JEventsDefaultView->__call() /home/library/master/components/com_jevents/views/alternative/icalevent/tmpl/detail_body.php:39 15 include /home/library/master/components/com_jevents/views/alternative/icalevent/tmpl/detail_body.php /home/library/master/libraries/src/MVC/View/HtmlView.php:700 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() /home/library/master/components/com_jevents/views/alternative/icalevent/tmpl/detail.php:5 13 include /home/library/master/components/com_jevents/views/alternative/icalevent/tmpl/detail.php /home/library/master/libraries/src/MVC/View/HtmlView.php:700 12 Joomla\CMS\MVC\View\HtmlView->loadTemplate() /home/library/master/libraries/src/MVC/View/HtmlView.php:233 11 Joomla\CMS\MVC\View\HtmlView->display() /home/library/master/administrator/components/com_jevents/views/abstract/abstract.php:92 10 JEventsAbstractView->display() /home/library/master/components/com_jevents/controllers/icalrepeat.php:151 9 ICalRepeatController->detail() /home/library/master/libraries/src/MVC/Controller/BaseController.php:710 8 Joomla\CMS\MVC\Controller\BaseController->execute() /home/library/master/components/com_jevents/jevents.php:299 7 require_once /home/library/master/components/com_jevents/jevents.php /home/library/master/libraries/src/Component/ComponentHelper.php:402 6 Joomla\CMS\Component\ComponentHelper::executeComponent() /home/library/master/libraries/src/Component/ComponentHelper.php:377 5 Joomla\CMS\Component\ComponentHelper::renderComponent() /home/library/master/libraries/src/Application/SiteApplication.php:194 4 Joomla\CMS\Application\SiteApplication->dispatch() /home/library/master/libraries/src/Application/SiteApplication.php:233 3 Joomla\CMS\Application\SiteApplication->doExecute() /home/library/master/libraries/src/Application/CMSApplication.php:196 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php(11) : eval()'d code:50 1 eval() JROOT/index.php:11 - Query Time: 2.27 ms After last query: 2.82 ms Query memory: 0.036 MB Memory before query: 16.415 MB Rows returned: 31
SHOW FULL COLUMNS
FROM `JdKlzg_content`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `JdKlzg_content`Status Duration Starting 0.07 ms Checking permissions 0.02 ms Closing tables 0.02 ms Opening tables 0.55 ms After opening tables 0.03 ms System lock 0.02 ms Table lock 0.02 ms Init 0.02 ms Optimizing 0.13 ms Statistics 0.02 ms Preparing 0.03 ms Executing 0.02 ms Filling schema table 0.02 ms Opening tables 0.14 ms After opening tables 0.04 ms Checking permissions 0.24 ms Closing tables 0.03 ms Executing 0.02 ms Sending data 0.07 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.47 ms Closing tables 0.03 ms Unlocking tables 0.04 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.03 ms # Caller File and line number 26 JDatabaseDriverMysqli->execute() /home/library/master/libraries/joomla/database/driver.php:1695 25 JDatabaseDriver->loadObjectList() /home/library/master/libraries/joomla/database/driver/mysqli.php:445 24 JDatabaseDriverMysqli->getTableColumns() /home/library/master/libraries/src/Table/Table.php:245 23 Joomla\CMS\Table\Table->getFields() /home/library/master/libraries/src/Table/Table.php:164 22 Joomla\CMS\Table\Table->__construct() /home/library/master/libraries/src/Table/Content.php:39 21 Joomla\CMS\Table\Content->__construct() /home/library/master/libraries/src/Table/Table.php:312 20 Joomla\CMS\Table\Table::getInstance() /home/library/master/components/com_jevents/views/default/helpers/defaultloadmodules.php:11 19 DefaultLoadModules() /home/library/master/components/com_jevents/views/default/abstract/abstract.php:160 18 JEventsDefaultView->__call() /home/library/master/templates/joomla-israel/html/com_jevents/helpers/defaultviewhelperheader16.php:16 17 DefaultViewHelperHeader16() /home/library/master/components/com_jevents/views/default/abstract/abstract.php:160 16 JEventsDefaultView->__call() /home/library/master/components/com_jevents/views/default/helpers/defaultviewhelperheader.php:5 15 DefaultViewHelperHeader() /home/library/master/components/com_jevents/views/default/abstract/abstract.php:160 14 JEventsDefaultView->__call() /home/library/master/components/com_jevents/views/alternative/icalevent/tmpl/detail.php:8 13 include /home/library/master/components/com_jevents/views/alternative/icalevent/tmpl/detail.php /home/library/master/libraries/src/MVC/View/HtmlView.php:700 12 Joomla\CMS\MVC\View\HtmlView->loadTemplate() /home/library/master/libraries/src/MVC/View/HtmlView.php:233 11 Joomla\CMS\MVC\View\HtmlView->display() /home/library/master/administrator/components/com_jevents/views/abstract/abstract.php:92 10 JEventsAbstractView->display() /home/library/master/components/com_jevents/controllers/icalrepeat.php:151 9 ICalRepeatController->detail() /home/library/master/libraries/src/MVC/Controller/BaseController.php:710 8 Joomla\CMS\MVC\Controller\BaseController->execute() /home/library/master/components/com_jevents/jevents.php:299 7 require_once /home/library/master/components/com_jevents/jevents.php /home/library/master/libraries/src/Component/ComponentHelper.php:402 6 Joomla\CMS\Component\ComponentHelper::executeComponent() /home/library/master/libraries/src/Component/ComponentHelper.php:377 5 Joomla\CMS\Component\ComponentHelper::renderComponent() /home/library/master/libraries/src/Application/SiteApplication.php:194 4 Joomla\CMS\Application\SiteApplication->dispatch() /home/library/master/libraries/src/Application/SiteApplication.php:233 3 Joomla\CMS\Application\SiteApplication->doExecute() /home/library/master/libraries/src/Application/CMSApplication.php:196 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php(11) : eval()'d code:50 1 eval() JROOT/index.php:11 - Query Time: 2.18 ms After last query: 6.31 ms Query memory: 0.030 MB Memory before query: 17.493 MB Rows returned: 1
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM JdKlzg_fields AS a
LEFT JOIN `JdKlzg_languages` AS l
ON l.lang_code = a.language
LEFT JOIN JdKlzg_users AS uc
ON uc.id=a.checked_out
LEFT JOIN JdKlzg_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN JdKlzg_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN JdKlzg_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_content.article'
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_context 767 const 1 Using index condition; Using where; Using filesort 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 func 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 library_m_arad.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 library_m_arad.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 library_m_arad.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 library_m_arad.a.group_id 1 Using where Status Duration Starting 0.23 ms Checking permissions 0.03 ms Opening tables 0.77 ms After opening tables 0.05 ms System lock 0.02 ms Table lock 0.02 ms Init 0.09 ms Optimizing 0.05 ms Statistics 0.14 ms Preparing 0.09 ms Sorting result 0.04 ms Executing 0.02 ms Sending data 0.03 ms Creating sort index 0.24 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.04 ms Updating status 0.04 ms Reset for next command 0.04 ms # Caller File and line number 28 JDatabaseDriverMysqli->execute() /home/library/master/libraries/joomla/database/driver.php:1695 27 JDatabaseDriver->loadObjectList() /home/library/master/libraries/src/MVC/Model/BaseDatabaseModel.php:308 26 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() /home/library/master/administrator/components/com_fields/models/fields.php:333 25 FieldsModelFields->_getList() /home/library/master/libraries/src/MVC/Model/ListModel.php:187 24 Joomla\CMS\MVC\Model\ListModel->getItems() /home/library/master/administrator/components/com_fields/helpers/fields.php:135 23 FieldsHelper::getFields() /home/library/master/plugins/system/fields/fields.php:488 22 PlgSystemFields->onContentPrepare() /home/library/master/libraries/joomla/event/event.php:70 21 JEvent->update() /home/library/master/libraries/joomla/event/dispatcher.php:160 20 JEventDispatcher->trigger() /home/library/master/components/com_jevents/views/default/helpers/defaultloadmodules.php:19 19 DefaultLoadModules() /home/library/master/components/com_jevents/views/default/abstract/abstract.php:160 18 JEventsDefaultView->__call() /home/library/master/templates/joomla-israel/html/com_jevents/helpers/defaultviewhelperheader16.php:16 17 DefaultViewHelperHeader16() /home/library/master/components/com_jevents/views/default/abstract/abstract.php:160 16 JEventsDefaultView->__call() /home/library/master/components/com_jevents/views/default/helpers/defaultviewhelperheader.php:5 15 DefaultViewHelperHeader() /home/library/master/components/com_jevents/views/default/abstract/abstract.php:160 14 JEventsDefaultView->__call() /home/library/master/components/com_jevents/views/alternative/icalevent/tmpl/detail.php:8 13 include /home/library/master/components/com_jevents/views/alternative/icalevent/tmpl/detail.php /home/library/master/libraries/src/MVC/View/HtmlView.php:700 12 Joomla\CMS\MVC\View\HtmlView->loadTemplate() /home/library/master/libraries/src/MVC/View/HtmlView.php:233 11 Joomla\CMS\MVC\View\HtmlView->display() /home/library/master/administrator/components/com_jevents/views/abstract/abstract.php:92 10 JEventsAbstractView->display() /home/library/master/components/com_jevents/controllers/icalrepeat.php:151 9 ICalRepeatController->detail() /home/library/master/libraries/src/MVC/Controller/BaseController.php:710 8 Joomla\CMS\MVC\Controller\BaseController->execute() /home/library/master/components/com_jevents/jevents.php:299 7 require_once /home/library/master/components/com_jevents/jevents.php /home/library/master/libraries/src/Component/ComponentHelper.php:402 6 Joomla\CMS\Component\ComponentHelper::executeComponent() /home/library/master/libraries/src/Component/ComponentHelper.php:377 5 Joomla\CMS\Component\ComponentHelper::renderComponent() /home/library/master/libraries/src/Application/SiteApplication.php:194 4 Joomla\CMS\Application\SiteApplication->dispatch() /home/library/master/libraries/src/Application/SiteApplication.php:233 3 Joomla\CMS\Application\SiteApplication->doExecute() /home/library/master/libraries/src/Application/CMSApplication.php:196 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php(11) : eval()'d code:50 1 eval() JROOT/index.php:11 - Query Time: 0.92 ms After last query: 8.38 ms Query memory: 0.021 MB Memory before query: 17.654 MB Rows returned: 2
SELECT language,id
FROM `JdKlzg_menu`
WHERE home = 1
AND published = 1
AND client_id = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE JdKlzg_menu ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 123 Using where Status Duration Starting 0.09 ms Checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.03 ms System lock 0.02 ms Table lock 0.02 ms Init 0.03 ms Optimizing 0.03 ms Statistics 0.05 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.30 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.03 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() /home/library/master/libraries/joomla/database/driver.php:1695 10 JDatabaseDriver->loadObjectList() /home/library/master/libraries/src/Language/Multilanguage.php:107 9 Joomla\CMS\Language\Multilanguage::getSiteHomePages() /home/library/master/plugins/system/languagefilter/languagefilter.php:751 8 PlgSystemLanguageFilter->onAfterDispatch() /home/library/master/libraries/joomla/event/event.php:70 7 JEvent->update() /home/library/master/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() /home/library/master/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() /home/library/master/libraries/src/Application/SiteApplication.php:199 4 Joomla\CMS\Application\SiteApplication->dispatch() /home/library/master/libraries/src/Application/SiteApplication.php:233 3 Joomla\CMS\Application\SiteApplication->doExecute() /home/library/master/libraries/src/Application/CMSApplication.php:196 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php(11) : eval()'d code:50 1 eval() JROOT/index.php:11 - Query Time: 0.81 ms After last query: 24.15 ms Query memory: 0.023 MB Memory before query: 18.398 MB Rows returned: 0
SELECT `c2`.`language`,`c2`.`id`
FROM `JdKlzg_menu` AS `c`
INNER JOIN `JdKlzg_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `JdKlzg_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `JdKlzg_menu` AS `c2`
ON a2.id = c2.`id`
WHERE c.id = 448id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.14 ms Checking permissions 0.03 ms Opening tables 0.06 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.03 ms Optimizing 0.04 ms Statistics 0.10 ms Preparing 0.02 ms Executing 0.04 ms End of update loop 0.02 ms Query end 0.03 ms Commit 0.03 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.03 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() /home/library/master/libraries/joomla/database/driver.php:1695 15 JDatabaseDriver->loadObjectList() /home/library/master/libraries/src/Language/Associations.php:115 14 Joomla\CMS\Language\Associations::getAssociations() /home/library/master/administrator/components/com_menus/helpers/menus.php:321 13 MenusHelper::getAssociations() /home/library/master/modules/mod_languages/helper.php:58 12 ModLanguagesHelper::getList() /home/library/master/modules/mod_languages/mod_languages.php:17 11 include /home/library/master/modules/mod_languages/mod_languages.php /home/library/master/libraries/src/Helper/ModuleHelper.php:200 10 Joomla\CMS\Helper\ModuleHelper::renderModule() /home/library/master/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 9 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() /home/library/master/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 8 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() /home/library/master/libraries/src/Document/HtmlDocument.php:491 7 Joomla\CMS\Document\HtmlDocument->getBuffer() /home/library/master/libraries/src/Document/HtmlDocument.php:783 6 Joomla\CMS\Document\HtmlDocument->_renderTemplate() /home/library/master/libraries/src/Document/HtmlDocument.php:557 5 Joomla\CMS\Document\HtmlDocument->render() /home/library/master/libraries/src/Application/CMSApplication.php:1044 4 Joomla\CMS\Application\CMSApplication->render() /home/library/master/libraries/src/Application/SiteApplication.php:778 3 Joomla\CMS\Application\SiteApplication->render() /home/library/master/libraries/src/Application/CMSApplication.php:202 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php(11) : eval()'d code:50 1 eval() JROOT/index.php:11
30 Query Types Logged, Sorted by Occurrences.
טבלאות SELECT:
3 × SELECT `id`
FROM `JdKlzg_finder_types`2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `JdKlzg_assets`2 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM JdKlzg_modules AS m
LEFT JOIN JdKlzg_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN JdKlzg_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `JdKlzg_extensions`1 × SELECT `data`
FROM `JdKlzg_session`1 × SELECT ju.id, ju.name, ju.username, ju.sendEmail, ju.email, cd.name as contactname,
CASE WHEN CHAR_LENGTH(cd.alias) THEN CONCAT_WS(':', cd.id, cd.alias) ELSE cd.id END as slug,
CASE WHEN CHAR_LENGTH(cat.alias) THEN CONCAT_WS(':', cat.id, cat.alias) ELSE cat.id END AS catslug
FROM JdKlzg_users AS ju
LEFT JOIN JdKlzg_contact_details AS cd
ON cd.user_id = ju.id
LEFT JOIN JdKlzg_categories AS cat
ON cat.id = cd.catid1 × SELECT language,id
FROM `JdKlzg_menu`1 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM JdKlzg_fields AS a
LEFT JOIN `JdKlzg_languages` AS l
ON l.lang_code = a.language
LEFT JOIN JdKlzg_users AS uc
ON uc.id=a.checked_out
LEFT JOIN JdKlzg_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN JdKlzg_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN JdKlzg_fields_groups AS g
ON g.id = a.group_id1 × SELECT rpt.*,det.summary as title, YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
FROM JdKlzg_jevents_repetition as rpt
LEFT JOIN JdKlzg_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id1 × SELECT rpt.*,det.summary as title , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
FROM JdKlzg_jevents_repetition as rpt
LEFT JOIN JdKlzg_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id1 × SELECT *
FROM JdKlzg_jev_defaults1 × SELECT `g`.`id`,`g`.`title`
FROM `JdKlzg_usergroups` AS g
INNER JOIN `JdKlzg_user_usergroup_map` AS m
ON m.group_id = g.id1 × SELECT *
FROM `JdKlzg_users`1 × SELECT `id`
FROM `JdKlzg_users`1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `JdKlzg_categories` AS `c`1 × SELECT ev.*, ev.state as published, rpt.*, rr.*, det.* , GROUP_CONCAT(DISTINCT catmapcat.id
ORDER BY catmapcat.lft ASC SEPARATOR ',' ) as catids, ev.created as created , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup , YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup , HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn , ev.state as state
FROM (JdKlzg_jevents_vevent as ev )
INNER JOIN JdKlzg_jevents_repetition as rpt
ON rpt.eventid = ev.ev_id
INNER JOIN JdKlzg_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN JdKlzg_jevents_rrule as rr
ON rr.eventid = ev.ev_id
INNER JOIN JdKlzg_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
LEFT JOIN JdKlzg_jevents_catmap as catmap
ON catmap.evid = rpt.eventid
LEFT JOIN JdKlzg_categories AS catmapcat
ON catmap.catid = catmapcat.id1 × SELECT c.id
FROM JdKlzg_categories AS c1 × SELECT id, home, template, s.params
FROM JdKlzg_template_styles as s
LEFT JOIN JdKlzg_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × 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 JdKlzg_menu AS m
LEFT JOIN JdKlzg_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `element`,`name`,`client_id`,`extension_id`
FROM `JdKlzg_extensions`1 × SELECT *
FROM JdKlzg_languages1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM JdKlzg_extensions1 × SELECT b.id
FROM JdKlzg_usergroups AS a
LEFT JOIN JdKlzg_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `JdKlzg_viewlevels1 × SELECT `c2`.`language`,`c2`.`id`
FROM `JdKlzg_menu` AS `c`
INNER JOIN `JdKlzg_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `JdKlzg_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `JdKlzg_menu` AS `c2`
ON a2.id = c2.`id`
טבלאות אחרות:
1 × UPDATE `JdKlzg_extensions`
SET `params` = '{\"mediaversion\":\"1cc66c3299208a5a2fafcf9db8aec692\"}'1 × SHOW FULL COLUMNS
FROM `JdKlzg_jev_users1 × SHOW FULL COLUMNS
FROM `JdKlzg_users1 × UPDATE JdKlzg_jevents_vevdetail
SET hits=(hits+1)1 × SHOW FULL COLUMNS
FROM `JdKlzg_content