Below is the text of the page https://www.shkodin.com/ stored 2023-12-27 by archive.org.ua. The original page over time could change. View as original html

Gallery with subgalleries

[https://www.shkodin.com/] Menu Benefits Gallery Light Galleries Gallery Image Gallery Grand Layouts Gallery with subgalleries Gallery without subgalleries Single image/video Grid 6 - 1 6 Columns 5 Columns 4 Columns 3 Columns 2 Columns 1 Column Designs Default design Masonry design Pinterest design Polaroids design Classic design Front-end Manager Gallery Source Tag Gallery YouTube, Vimeo, MP4 Video Gallery Photo & Video Gallery Options Ratings Watermark AJAX pagination Comments Modules & Plugins Slideshow Module Demo Content Plugin Demo Search Plugin Demo Map Module Demo Latest Module Demo Showcases Beauty industry Buy Now Gallery with subgalleries 04 January 2017 5 21 3 With FW Gallery displaying a gallery/galleries is an easy process that can be completed in a matter of minutes. In order to display a gallery or multiple galleries on a single page, follow the steps outlined in our documentation page . Order by: Alphabetically Reverse Alphabetically Newest First Oldest First Ordering 5 Galleries Fashion 20 4 Jan 2017 Lorem ipsum dolor si… Gallery with ratings 20 1 Apr 2014 Lorem ipsum dolor si… Portrait 20 4 Jan 2017 Lorem ipsum dolor si… Landscapes 20 4 Jan 2017 Lorem ipsum dolor si… Clothes 20 12 Jan 2017 Taking good quality&… Order by: Alphabetically Reverse Alphabetically Newest First Oldest First Ordering Voting 21 Images, 3 Videos photography_01 5 (1) Autumn, City, People, Sky, Weather 04 Jan 2017 Ut quis varius elit.… photography_02 0 (0) Autumn, Autumn, Autumn, Autumn, Autumn, Autumn, Autumn, Autumn, Autumn, Autumn, Autumn, City, City, City, City, City, City, City, City, City, City, City, Yellow, Yellow, Yellow, Yellow, Yellow, Yellow, Yellow, Yellow, Yellow, Yellow, Yellow 05 Jan 2017 Some copyright info here. All rights reserved. FW Gallery provides … photography_03 0 (0) City, People, Sky 06 Jan 2017 Ut quis varius elit.… photography_04 5 (1) Green, Sky, Yellow 17 Jan 2017 Ut quis varius elit.… photography_05 0 (0) Dark, Sky, Space 08 Jan 2017 Ut quis varius elit.… photography_06 0 (0) Beautiful, Sun, Water 12 Jan 2017 Ut quis varius elit.… photography_07 5 (1) Desert, Nature, Sky 01 Jan 2017 Ut quis varius elit.… photography_08 0 (0) Dark, Mountains, Sky 02 Jan 2017 Ut quis varius elit.… photography_09 5 (2) Green, Mountains, Nature, Sky, Sunset 03 Jan 2017 Ut quis varius elit.… photography_10 5 (1) Sky, Water, Weather 05 Jan 2017 Ut quis varius elit.… photography_11 0 (0) Dark, Nature, Sky, Water, Weather 05 Jan 2017 Ut quis varius elit.… photography_12 0 (0) Dark, Green, Mountains, Weather 05 Jan 2017 Ut quis varius elit.… photography_13 0 (0) 07 Jan 2017 Ut quis varius elit.… photography_14 0 (0) Dark, Fire, Night, People, Sky 05 Jan 2017 Ut quis varius elit.… photography_15 5 (1) City, Evening, Lights, Sky 05 Jan 2017 Ut quis varius elit.… photography_16 0 (0) Blue, Buildings, HDR, Sky, Yellow 05 Jan 2017 Ut quis varius elit.… Start Prev 1 2 Next End © 2018 FW Gallery demo website by Fastw3b . All rights reserved. Joomla! Debug Console Session { " __default " : { " session " : { " counter " : 1, " timer " : { " start " : 1703710962, " last " : 1703710962, " now " : 1703710962 } }, " registry " : {}, " user " : { " id " : 0, " name " : null , " username " : null , " email " : null , " password " : null , " password_clear " : "" , " block " : null , " sendEmail " : 0, " registerDate " : null , " lastvisitDate " : null , " activation " : null , " params " : null , " groups " : [], " guest " : 1, " lastResetTime " : null , " resetCount " : null , " requireReset " : null , " aid " : 0 }, " plg_system_languagefilter " : { " language " : "en-GB" } } } Profile Information Time Memory Time: 7.02 ms / 7.02 ms Memory: 0.405 MB / 0.74 MB Application: afterLoad Time: 23.15 ms / 30.18 ms Memory: 1.114 MB / 1.85 MB Application: afterInitialise Time: 7.65 ms / 37.83 ms Memory: 0.181 MB / 2.03 MB Application: afterRoute Time: 0.67 ms / 38.50 ms Memory: 0.028 MB / 2.06 MB Application: beforeRenderComponent com_fwgallery Time: 10.66 ms / 49.16 ms Memory: 0.224 MB / 2.29 MB Application: Before Access::preloadComponents (all components) Time: 0.61 ms / 49.77 ms Memory: 0.058 MB / 2.34 MB Application: After Access::preloadComponents (all components) Time: 0.01 ms / 49.79 ms Memory: 0.060 MB / 2.40 MB Application: Before Access::getAssetRules (id:1 name:root.1) Time: 0.35 ms / 50.14 ms Memory: 0.008 MB / 2.41 MB Application: After Access::getAssetRules (id:1 name:root.1) Time: 3.71 ms / 53.85 ms Memory: 0.026 MB / 2.44 MB Application: Before Access::getAssetRules (id:8 name:com_content) Time: 0.03 ms / 53.88 ms Memory: 0.008 MB / 2.45 MB Application: After Access::getAssetRules (id:8 name:com_content) Time: 27.43 ms / 81.31 ms Memory: 0.234 MB / 2.68 MB Application: afterRenderComponent com_fwgallery Time: 2.76 ms / 84.07 ms Memory: 0.022 MB / 2.70 MB Application: afterDispatch Time: 2.22 ms / 86.29 ms Memory: 0.033 MB / 2.73 MB Application: beforeRenderModule mod_custom (Copyright) Time: 0.42 ms / 86.71 ms Memory: 0.006 MB / 2.74 MB Application: afterRenderModule mod_custom (Copyright) Time: 0.03 ms / 86.74 ms Memory: 0.000 MB / 2.74 MB Application: beforeRenderModule mod_menu (Main Menu) Time: 7.37 ms / 94.11 ms Memory: 0.243 MB / 2.98 MB Application: afterRenderModule mod_menu (Main Menu) Time: 1.10 ms / 95.20 ms Memory: 0.057 MB / 3.04 MB Application: afterRender Database queries total: 15.09 ms Memory Usage 3.54 MB ( 3,713,928 Bytes ) Database Queries 26 Queries Logged 15.09 ms Query Time: 0.19 ms Query memory: 0.023 MB Memory before query: 1.021 MB Rows returned: 0 SELECT `data` FROM ` jos_session ` WHERE `session_id` = '19d9639524d4341bdcc0cf093a0ef96d' Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jos_session const PRIMARY PRIMARY 194 const 1 Profile Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms init 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.00 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms freeing items 0.00 ms updating status 0.01 ms cleaning up 0.00 ms Call Stack # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Same as call in the line below. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:660 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:620 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:758 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 [ Add xdebug.file_link_format directive to your php.ini file to have links for files. ] Query Time: 0.09 ms After last query: 0.83 ms Query memory: 0.020 MB Memory before query: 1.035 MB Rows returned: 0 SELECT `session_id` FROM ` jos_session ` WHERE `session_id` = '19d9639524d4341bdcc0cf093a0ef96d' LIMIT 1 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jos_session const PRIMARY PRIMARY 194 const 1 Using index Profile Status Duration starting 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms init 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.00 ms executing 0.00 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms freeing items 0.00 ms updating status 0.01 ms cleaning up 0.00 ms Call Stack # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:153 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 [ Add xdebug.file_link_format directive to your php.ini file to have links for files. ] Query Time: 0.74 ms After last query: 0.03 ms Query memory: 0.004 MB Memory before query: 1.040 MB INSERT INTO ` jos_session ` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('19d9639524d4341bdcc0cf093a0ef96d', 1, 1703710962, 0, '', 0) Explain EXPLAIN not possible on query: INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('19d9639524d4341bdcc0cf093a0ef96d', 1, 1703710962, 0, '', 0) Profile Status Duration starting 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms init 0.01 ms update 0.03 ms Waiting for query cache lock 0.00 ms update 0.00 ms end 0.00 ms query end 0.64 ms closing tables 0.00 ms Unlocking tables 0.00 ms freeing items 0.00 ms updating status 0.01 ms cleaning up 0.00 ms Call Stack # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:153 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 [ Add xdebug.file_link_format directive to your php.ini file to have links for files. ] Query Time: 0.27 ms After last query: 1.33 ms Query memory: 0.055 MB Memory before query: 1.071 MB Rows returned: 39 SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM ` jos_extensions ` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jos_extensions ref extension extension 82 const 39 Using index condition; Using where Profile Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms init 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.11 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms freeing items 0.00 ms updating status 0.01 ms cleaning up 0.00 ms Call Stack # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Same as call in the line below. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [ Add xdebug.file_link_format directive to your php.ini file to have links for files. ] Query Time: 0.14 ms After last query: 0.92 ms Query memory: 0.021 MB Memory before query: 1.118 MB Rows returned: 4 SELECT id, rules FROM ` jos_viewlevels ` Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jos_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 4 Profile Status Duration starting 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms init 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.01 ms freeing items 0.00 ms updating status 0.01 ms cleaning up 0.00 ms Call Stack # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1500 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:321 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [ Add xdebug.file_link_format directive to your php.ini file to have links for files. ] Query Time: 0.18 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 1.129 MB Rows returned: 2 SELECT b.id FROM jos_usergroups AS a LEFT JOIN jos_usergroups AS b ON b.lft < = a.lft AND b.rgt > = a.rgt WHERE a.id = 9 Explain id 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 3 Using where; Using index Profile Status Duration starting 0.02 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms init 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.00 ms Unlocking tables 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms freeing items 0.00 ms updating status 0.01 ms cleaning up 0.00 ms Call Stack # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1544 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:321 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [ Add xdebug.file_link_format directive to your php.ini file to have links for files. ] Query Time: 0.93 ms After last query: 0.07 ms Query memory: 0.035 MB Memory before query: 1.150 MB Rows returned: 177 SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM jos_extensions WHERE enabled = 1 AND type = 'plugin' AND state IN (0,1) AND access IN (1,1,5) ORDER BY ordering Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jos_extensions ref extension extension 82 const 197 Using index condition; Using where; Using filesort Profile Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms init 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.00 ms Sorting result 0.54 ms Sending data 0.20 ms end 0.01 ms query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.01 ms freeing items 0.00 ms updating status 0.01 ms cleaning up 0.00 ms Call Stack # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:354 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:359 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [ Add xdebug.file_link_format directive to your php.ini file to have links for files. ] Query Time: 0.19 ms After last query: 0.55 ms Query memory: 0.021 MB Memory before query: 1.250 MB Rows returned: 7 SELECT * FROM jos_languages WHERE published = 1 ORDER BY ordering ASC Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jos_languages ALL NULL NO INDEX KEY COULD BE USED NULL NULL 7 Using where; Using filesort Profile Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms init 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sorting result 0.02 ms Sending data 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms freeing items 0.00 ms updating status 0.01 ms cleaning up 0.00 ms Call Stack # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Language/LanguageHelper.php:67 4 Joomla\CMS\Language\LanguageHelper::detectLanguage() JROOT/libraries/src/Application/SiteApplication.php:653 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [ Add xdebug.file_link_format directive to your php.ini file to have links for files. ] Query Time: 0.32 ms After last query: 4.26 ms Query memory: 0.023 MB Memory before query: 1.597 MB Rows returned: 28 SELECT `element`,`name`,`client_id`,`extension_id` FROM ` jos_extensions ` WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 1 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jos_extensions ref extension extension 82 const 28 Using index condition; Using where Profile Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms init 0.02 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.02 ms executing 0.00 ms Sending data 0.09 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.01 ms freeing items 0.00 ms updating status 0.01 ms cleaning up 0.00 ms Call Stack # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 9 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:209 8 Joomla\CMS\Language\LanguageHelper::getInstalledLanguages() JROOT/plugins/system/languagefilter/languagefilter.php:110 7 PlgSystemLanguageFilter->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:625 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [ Add xdebug.file_link_format directive to your php.ini file to have links for files. ] Query Time: 0.15 ms After last query: 1.65 ms Query memory: 0.020 MB Memory before query: 1.655 MB Rows returned: 1 SELECT count(1) FROM ` jos_session ` WHERE `session_id` = '' AND client_id = 1 AND guest = 0 Explain id 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 Profile Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms init 0.01 ms optimizing 0.02 ms statistics 0.02 ms preparing 0.00 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms freeing items 0.00 ms updating status 0.01 ms cleaning up 0.00 ms Call Stack # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 9 JDatabaseDriver->loadResult() JROOT/plugins/system/arktypography/arktypography.php:53 8 plgSystemARKtypography->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:626 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [ Add xdebug.file_link_format directive to your php.ini file to have links for files. ] Query Time: 0.53 ms After last query: 1.53 ms Query memory: 0.073 MB Memory before query: 1.687 MB Rows returned: 44 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 jos_menu AS m LEFT JOIN jos_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.lft Explain id 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 61 Using index condition; Using where; Using filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 demo.m.component_id 1 Using where Profile Status Duration starting 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms init 0.02 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.00 ms Sorting result 0.15 ms Sending data 0.19 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.01 ms freeing items 0.00 ms updating status 0.01 ms cleaning up 0.01 ms Call Stack # Caller File and line number 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 21 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Same as call in the line below. 20 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 19 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 18 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:76 17 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 16 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:131 15 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:375 14 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 13 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:64 12 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 11 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:491 10 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 9 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/plugins/system/languagefilter/languagefilter.php:145 8 PlgSystemLanguageFilter->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:626 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [ Add xdebug.file_link_format directive to your php.ini file to have links for files. ] Query Time: 0.24 ms After last query: 6.18 ms Query memory: 0.024 MB Memory before query: 2.017 MB Rows returned: 1 SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM ` jos_extensions ` WHERE `type` = 'library' AND `element` = 'joomla' Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jos_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition Profile Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms init 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms freeing items 0.00 ms updating status 0.01 ms cleaning up 0.00 ms Call Stack # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1656 18 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 17 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 14 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 13 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 12 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/arktypography/arktypography.php:115 8 plgSystemARKtypography->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1122 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [ Add xdebug.file_link_format directive to your php.ini file to have links for files. ] Query Time: 0.53 ms After last query: 0.07 ms Query memory: 0.006 MB Memory before query: 2.010 MB UPDATE ` jos_extensions ` SET `params` = '{\"mediaversion\":\"2997cbb1aac1a5be0d72359ec33c5959\"}' WHERE `type` = 'library' AND `element` = 'joomla' Explain EXPLAIN not possible on query: UPDATE `jos_extensions` SET `params` = '{\"mediaversion\":\"2997cbb1aac1a5be0d72359ec33c5959\"}' WHERE `type` = 'library' AND `element` = 'joomla' Profile Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 ms init 0.04 ms updating 0.04 ms end 0.00 ms Waiting for query cache lock 0.00 ms end 0.02 ms query end 0.35 ms closing tables 0.00 ms Unlocking tables 0.01 ms freeing items 0.00 ms updating status 0.01 ms cleaning up 0.00 ms Call Stack # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 13 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 12 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/arktypography/arktypography.php:115 8 plgSystemARKtypography->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1122 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [ Add xdebug.file_link_format directive to your php.ini file to have links for files. ] Query Time: 0.17 ms After last query: 0.74 ms Query memory: 0.036 MB Memory before query: 2.028 MB Rows returned: 1 SELECT params FROM ` jos_extensions ` WHERE `element` = 'com_arkeditor' AND `type` = 'component' Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jos_extensions ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 Using index condition; Using where Profile Status Duration starting 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms init 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms freeing items 0.00 ms updating status 0.01 ms cleaning up 0.00 ms Call Stack # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 9 JDatabaseDriver->loadResult() JROOT/plugins/system/arktypography/arktypography.php:127 8 plgSystemARKtypography->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1122 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [ Add xdebug.file_link_format directive to your php.ini file to have links for files. ] Query Time: 0.23 ms After last query: 0.79 ms Query memory: 0.019 MB Memory before query: 2.056 MB Rows returned: 4 SELECT id, home, template, s.params FROM jos_template_styles as s LEFT JOIN jos_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 = 1 Explain id 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 6 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 demo.s.template,const 1 Using index condition; Using where Profile Status Duration starting 0.02 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms init 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.02 ms executing 0.00 ms Sending data 0.05 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms freeing items 0.00 ms updating status 0.01 ms cleaning up 0.00 ms Call Stack # Caller File and line number 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 5 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 4 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/Application/SiteApplication.php:168 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [ Add xdebug.file_link_format directive to your php.ini file to have links for files. ] Query Time: 0.59 ms After last query: 6.59 ms Query memory: 0.028 MB Memory before query: 2.211 MB Rows returned: 16 SHOW FULL COLUMNS FROM ` jos_fwg_projects ` Explain EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `jos_fwg_projects` Profile Status Duration starting 0.03 ms checking permissions 0.00 ms closing tables 0.00 ms Opening tables 0.20 ms After opening tables 0.00 ms System lock 0.01 ms Table lock 0.00 ms init 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Filling schema table 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms checking permissions 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms closing tables 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.06 ms closing tables 0.00 ms Unlocking tables 0.00 ms freeing items 0.00 ms updating status 0.01 ms cleaning up 0.00 ms Call Stack # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 19 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:445 18 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 17 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 16 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_fwgallery/tables/category.php:36 15 TableCategory->__construct() JROOT/libraries/src/Table/Table.php:312 14 Joomla\CMS\Table\Table::getInstance() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:382 13 Joomla\CMS\MVC\Model\BaseDatabaseModel->_createTable() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:468 12 Joomla\CMS\MVC\Model\BaseDatabaseModel->getTable() JROOT/components/com_fwgallery/models/gallery.php:207 11 fwGalleryModelGallery->getObj() JROOT/components/com_fwgallery/views/gallery/view.html.php:78 10 fwGalleryViewGallery->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_fwgallery/controller.php:22 8 fwGalleryController->galleries() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_fwgallery/fwgallery.php:24 6 require_once JROOT/components/com_fwgallery/fwgallery.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [ Add xdebug.file_link_format directive to your php.ini file to have links for files. ] Query Time: 0.80 ms After last query: 0.66 ms Query memory: 0.023 MB Memory before query: 2.242 MB Rows returned: 1 SELECT c. * , ( SELECT u.name FROM jos_users AS u WHERE u.id = c.user_id LIMIT 1) AS _user_name, ( SELECT COUNT ( * ) FROM jos_fwg_projects_tags AS tf WHERE tf.project_id = c.id) AS _tags_exists, ( SELECT COUNT ( * ) FROM jos_fwg_files AS f WHERE f.project_id = c.id AND f.`type_id` = 1) AS _images_qty, ( SELECT COUNT ( * ) FROM jos_fwg_files AS f WHERE f.project_id = c.id AND f.`type_id` = 2) AS _videos_qty, ( SELECT COUNT ( * ) FROM jos_fwg_projects_tags AS pt, jos_fwg_files_tags AS ft, jos_fwg_files AS f WHERE pt.project_id = c.id AND ft.tag_id = pt.tag_id AND f.id = ft.file_id AND f.`type_id` = 1) AS _tags_images_qty, ( SELECT COUNT ( * ) FROM jos_fwg_projects_tags AS pt, jos_fwg_files_tags AS ft, jos_fwg_files AS f WHERE pt.project_id = c.id AND ft.tag_id = pt.tag_id AND f.id = ft.file_id AND f.`type_id` = 2) AS _tags_videos_qty, pg.title AS _group_name FROM jos_fwg_projects AS c LEFT JOIN jos_usergroups AS pg ON pg.id = c.gid WHERE c.id = 17 Explain id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY c const PRIMARY PRIMARY 4 const 1 1 PRIMARY pg const PRIMARY PRIMARY 4 const 0 unique row not found 7 SUBQUERY pt ref tag_id,project_id project_id 4 const 1 7 SUBQUERY ft ref tag_id,file_id tag_id 4 demo.pt.tag_id 5 7 SUBQUERY f eq_ref PRIMARY PRIMARY 4 demo.ft.file_id 1 Using where 6 SUBQUERY pt ref tag_id,project_id project_id 4 const 1 6 SUBQUERY ft ref tag_id,file_id tag_id 4 demo.pt.tag_id 5 6 SUBQUERY f eq_ref PRIMARY PRIMARY 4 demo.ft.file_id 1 Using where 5 SUBQUERY f ref project_id project_id 4 const 21 Using where 4 SUBQUERY f ref project_id project_id 4 const 21 Using where 3 SUBQUERY tf ref project_id project_id 4 const 1 Using index 2 SUBQUERY NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Profile Status Duration starting 0.10 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms init 0.04 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.00 ms Unlocking tables 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.02 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.10 ms executing 0.00 ms Sending data 0.09 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.00 ms Unlocking tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.00 ms Call Stack # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1656 13 JDatabaseDriver->loadObject() JROOT/administrator/components/com_fwgallery/tables/category.php:56 12 TableCategory->load() JROOT/components/com_fwgallery/models/gallery.php:208 11 fwGalleryModelGallery->getObj() JROOT/components/com_fwgallery/views/gallery/view.html.php:78 10 fwGalleryViewGallery->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_fwgallery/controller.php:22 8 fwGalleryController->galleries() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_fwgallery/fwgallery.php:24 6 require_once JROOT/components/com_fwgallery/fwgallery.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [ Add xdebug.file_link_format directive to your php.ini file to have links for files. ] Query Time: 0.52 ms After last query: 2.30 ms Query memory: 0.028 MB Memory before query: 2.291 MB Rows returned: 39 SELECT `id`,`name`,`rules`,`parent_id` FROM ` jos_assets ` WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_arkeditor','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_fwgallery','com_fwgallerylight','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper') Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jos_assets ALL idx_asset_name NO INDEX KEY COULD BE USED NULL NULL 117 Using where Profile Status Duration starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms init 0.05 ms optimizing 0.01 ms statistics 0.10 ms preparing 0.01 ms executing 0.00 ms Sending data 0.20 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms freeing items 0.00 ms updating status 0.01 ms cleaning up 0.00 ms Call Stack # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 17 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 16 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 15 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 14 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 13 Joomla\CMS\User\User->authorise() JROOT/components/com_fwgallery/models/gallery.php:60 12 fwGalleryModelGallery->_getSubCategoriesWhereClause() JROOT/components/com_fwgallery/models/gallery.php:90 11 fwGalleryModelGallery->loadSubCategories() JROOT/components/com_fwgallery/views/gallery/view.html.php:121 10 fwGalleryViewGallery->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_fwgallery/controller.php:22 8 fwGalleryController->galleries() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_fwgallery/fwgallery.php:24 6 require_once JROOT/components/com_fwgallery/fwgallery.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [ Add xdebug.file_link_format directive to your php.ini file to have links for files. ] Query Time: 2.63 ms After last query: 0.44 ms Query memory: 0.024 MB Memory before query: 2.410 MB Rows returned: 5 SELECT p. * , p.user_id AS _user_id, u.name AS _user_name, ( SELECT COUNT ( * ) FROM jos_fwg_files AS f WHERE f.project_id = p.id AND f.published = 1 AND f.`type_id` = 1) AS _images_qty, ( SELECT COUNT ( * ) FROM jos_fwg_files AS f WHERE f.project_id = p.id AND f.published = 1 AND f.`type_id` = 2) AS _videos_qty, ( SELECT COUNT ( * ) FROM jos_fwg_projects_tags AS pt, jos_fwg_files_tags AS ft, jos_fwg_files AS f WHERE pt.project_id = p.id AND f.published = 1 AND ft.tag_id = pt.tag_id AND f.id = ft.file_id AND f.`type_id` = 1) AS _tags_images_qty, ( SELECT COUNT ( * ) FROM jos_fwg_projects_tags AS pt, jos_fwg_files_tags AS ft, jos_fwg_files AS f WHERE pt.project_id = p.id AND f.published = 1 AND ft.tag_id = pt.tag_id AND f.id = ft.file_id AND f.`type_id` = 2) AS _tags_videos_qty, ( SELECT COUNT ( * ) FROM jos_fwg_projects AS pp WHERE pp.parent = p.id AND pp.published = 1) AS _subfolders FROM jos_fwg_projects AS p LEFT JOIN jos_users AS u ON (u.id = p.user_id) LEFT JOIN jos_usergroups AS pg ON (pg.id = p.gid) WHERE p.parent IN (17) AND p.published = 1 AND (p.gid = 0 OR p.gid IS NULL ) ORDER BY p.ordering LIMIT 0, 6 Explain id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY p ref published,gid published 1 const 32 Using where; Using filesort 1 PRIMARY u eq_ref PRIMARY PRIMARY 4 demo.p.user_id 1 Using where 6 DEPENDENT SUBQUERY pp ref published published 1 const 32 Using where 5 DEPENDENT SUBQUERY pt ALL tag_id,project_id NO INDEX KEY COULD BE USED NULL NULL 4 Using where 5 DEPENDENT SUBQUERY ft ref tag_id,file_id tag_id 4 demo.pt.tag_id 5 5 DEPENDENT SUBQUERY f eq_ref PRIMARY PRIMARY 4 demo.ft.file_id 1 Using where 4 DEPENDENT SUBQUERY pt ALL tag_id,project_id NO INDEX KEY COULD BE USED NULL NULL 4 Using where 4 DEPENDENT SUBQUERY ft ref tag_id,file_id tag_id 4 demo.pt.tag_id 5 4 DEPENDENT SUBQUERY f eq_ref PRIMARY PRIMARY 4 demo.ft.file_id 1 Using where 3 DEPENDENT SUBQUERY f ref project_id project_id 4 demo.p.id 16 Using where 2 DEPENDENT SUBQUERY f ref project_id project_id 4 demo.p.id 16 Using where Profile Status Duration checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.00 ms init 0.04 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.00 ms Unlocking tables 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sorting result 0.17 ms Sending data 0.06 ms executing 0.01 ms Sending data 0.11 ms executing 0.00 ms Sending data 0.10 ms executing 0.00 ms Sending data 0.10 ms executing 0.00 ms Sending data 0.02 ms executing 0.00 ms Sending data 0.16 ms executing 0.00 ms Sending data 0.08 ms executing 0.00 ms Sending data 0.07 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.13 ms executing 0.00 ms Sending data 0.11 ms executing 0.00 ms Sending data 0.08 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.13 ms executing 0.00 ms Sending data 0.08 ms executing 0.00 ms Sending data 0.08 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.13 ms executing 0.00 ms Sending data 0.11 ms executing 0.00 ms Sending data 0.10 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.12 ms end 0.01 ms query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.01 ms freeing items 0.00 ms removing tmp table 0.01 ms freeing items 0.00 ms removing tmp table 0.01 ms freeing items 0.00 ms removing tmp table 0.01 ms freeing items 0.00 ms removing tmp table 0.00 ms freeing items 0.00 ms removing tmp table 0.00 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.00 ms Call Stack # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 12 JDatabaseDriver->loadObjectList() JROOT/components/com_fwgallery/models/gallery.php:95 11 fwGalleryModelGallery->loadSubCategories() JROOT/components/com_fwgallery/views/gallery/view.html.php:121 10 fwGalleryViewGallery->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_fwgallery/controller.php:22 8 fwGalleryController->galleries() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_fwgallery/fwgallery.php:24 6 require_once JROOT/components/com_fwgallery/fwgallery.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [ Add xdebug.file_link_format directive to your php.ini file to have links for files. ] Query Time: 0.33 ms After last query: 0.66 ms Query memory: 0.022 MB Memory before query: 2.428 MB Rows returned: 1 SELECT COUNT ( * ) FROM jos_fwg_projects AS p LEFT JOIN jos_users AS u ON (u.id = p.user_id) LEFT JOIN jos_usergroups AS pg ON (pg.id = p.gid) WHERE p.parent IN (17) AND p.published = 1 AND (p.gid = 0 OR p.gid IS NULL ) Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE p ref published,gid published 1 const 32 Using where Profile Status Duration starting 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms init 0.01 ms optimizing 0.02 ms statistics 0.03 ms preparing 0.00 ms Unlocking tables 0.01 ms executing 0.00 ms Sending data 0.13 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.01 ms freeing items 0.00 ms updating status 0.01 ms cleaning up 0.00 ms Call Stack # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 13 JDatabaseDriver->loadResult() JROOT/components/com_fwgallery/models/gallery.php:134 12 fwGalleryModelGallery->getGQty() JROOT/components/com_fwgallery/models/gallery.php:143 11 fwGalleryModelGallery->getGPagination() JROOT/components/com_fwgallery/views/gallery/view.html.php:122 10 fwGalleryViewGallery->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_fwgallery/controller.php:22 8 fwGalleryController->galleries() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_fwgallery/fwgallery.php:24 6 require_once JROOT/components/com_fwgallery/fwgallery.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [ Add xdebug.file_link_format directive to your php.ini file to have links for files. ] Query Time: 1.67 ms After last query: 0.12 ms Query memory: 0.034 MB Memory before query: 2.446 MB Rows returned: 16 SELECT f. * , p.user_id AS _user_id, p.color AS _color, u.name AS _user_name, p.name AS _project_name, t.name AS _type_name, t.plugin AS _plugin_name, CASE WHEN ( SELECT COUNT ( * ) FROM jos_fwg_files_vote AS v LEFT JOIN jos_users AS u ON u.id = v.user_id WHERE v.file_id = f.id) > 0 THEN ( SELECT SUM (v.value) FROM jos_fwg_files_vote AS v LEFT JOIN jos_users AS u ON u.id = v.user_id WHERE v.file_id = f.id)/( SELECT COUNT ( * ) FROM jos_fwg_files_vote AS v LEFT JOIN jos_users AS u ON u.id = v.user_id WHERE v.file_id = f.id) ELSE 0 END AS _rating_value, ( SELECT SUM (v.value) FROM jos_fwg_files_vote AS v LEFT JOIN jos_users AS u ON u.id = v.user_id WHERE v.file_id = f.id) AS _rating_sum, ( SELECT COUNT ( * ) FROM jos_fwg_files_vote AS v LEFT JOIN jos_users AS u ON u.id = v.user_id WHERE v.file_id = f.id) AS _rating_count, ( SELECT COUNT ( * ) FROM jos_fwg_files_vote AS v LEFT JOIN jos_users AS u ON u.id = v.user_id WHERE v.file_id = f.id AND v.value < 0) AS _negative_rating_count, 1 AS _is_voted, '' AS _tags FROM jos_fwg_files AS f LEFT JOIN jos_fwg_types AS t ON t.id = f.type_id LEFT JOIN jos_fwg_projects AS p ON f.project_id = p.id LEFT JOIN jos_users AS u ON u.id = f.user_id LEFT JOIN jos_usergroups AS pg ON (pg.id = p.gid) WHERE (f.project_id IN (17) OR f.id IN ( SELECT ft.file_id FROM jos_fwg_projects_tags AS pt, jos_fwg_files_tags AS ft WHERE pt.project_id IN (17) AND pt.tag_id = ft.tag_id)) AND f.published = 1 AND p.published = 1 AND (p.gid = 0 OR p.gid IS NULL ) ORDER BY f.ordering LIMIT 0, 16 Explain id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY f ALL project_id NO INDEX KEY COULD BE USED NULL NULL 514 Using where; Using filesort 1 PRIMARY t eq_ref PRIMARY PRIMARY 4 demo.f.type_id 1 1 PRIMARY u eq_ref PRIMARY PRIMARY 4 demo.f.user_id 1 Using where 1 PRIMARY p eq_ref PRIMARY,published,gid PRIMARY 4 demo.f.project_id 1 Using where 8 MATERIALIZED pt ref tag_id,project_id project_id 4 const 1 8 MATERIALIZED ft ref tag_id,file_id tag_id 4 demo.pt.tag_id 5 7 DEPENDENT SUBQUERY v ref file_id,value file_id 4 demo.f.id 1 Using where 6 DEPENDENT SUBQUERY v ref file_id file_id 4 demo.f.id 1 5 DEPENDENT SUBQUERY v ref file_id file_id 4 demo.f.id 1 4 DEPENDENT SUBQUERY v ref file_id file_id 4 demo.f.id 1 3 DEPENDENT SUBQUERY v ref file_id file_id 4 demo.f.id 1 2 DEPENDENT SUBQUERY v ref file_id file_id 4 demo.f.id 1 Profile Status Duration Sending data 0.00 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.02 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.00 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.00 ms executing 0.00 ms Sending data 0.00 ms executing 0.00 ms Sending data 0.00 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.00 ms executing 0.00 ms Sending data 0.00 ms executing 0.00 ms Sending data 0.00 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.00 ms executing 0.00 ms Sending data 0.00 ms executing 0.00 ms Sending data 0.00 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.00 ms executing 0.00 ms Sending data 0.00 ms executing 0.00 ms Sending data 0.00 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.00 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.00 ms executing 0.00 ms Sending data 0.00 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.00 ms executing 0.00 ms Sending data 0.00 ms executing 0.00 ms Sending data 0.00 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.01 ms freeing items 0.00 ms removing tmp table 0.00 ms freeing items 0.00 ms removing tmp table 0.00 ms freeing items 0.00 ms removing tmp table 0.00 ms freeing items 0.00 ms removing tmp table 0.00 ms freeing items 0.00 ms removing tmp table 0.00 ms freeing items 0.00 ms removing tmp table 0.00 ms freeing items 0.01 ms removing tmp table 0.00 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms Call Stack # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 12 JDatabaseDriver->loadObjectList() JROOT/components/com_fwgallery/models/gallery.php:278 11 fwGalleryModelGallery->getList() JROOT/components/com_fwgallery/views/gallery/view.html.php:123 10 fwGalleryViewGallery->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_fwgallery/controller.php:22 8 fwGalleryController->galleries() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_fwgallery/fwgallery.php:24 6 require_once JROOT/components/com_fwgallery/fwgallery.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [ Add xdebug.file_link_format directive to your php.ini file to have links for files. ] Query Time: 0.46 ms After last query: 0.05 ms Query memory: 0.031 MB Memory before query: 2.506 MB Rows returned: 87 SELECT t.id, t.name, ft.file_id FROM jos_fwg_files_tags AS ft, jos_fwg_tags AS t WHERE ft.tag_id = t.id AND ft.file_id IN (1018,1019,1020,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1031,1032,1033) ORDER BY t.name Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ft ALL tag_id,file_id NO INDEX KEY COULD BE USED NULL NULL 349 Using where; Using temporary; Using filesort 1 SIMPLE t eq_ref PRIMARY PRIMARY 4 demo.ft.tag_id 1 Profile Status Duration starting 0.02 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms init 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Creating tmp table 0.01 ms Copying to tmp table 0.23 ms Sorting result 0.04 ms Sending data 0.02 ms end 0.00 ms removing tmp table 0.00 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms freeing items 0.00 ms updating status 0.01 ms cleaning up 0.00 ms Call Stack # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 12 JDatabaseDriver->loadObjectList() JROOT/components/com_fwgallery/models/gallery.php:284 11 fwGalleryModelGallery->getList() JROOT/components/com_fwgallery/views/gallery/view.html.php:123 10 fwGalleryViewGallery->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_fwgallery/controller.php:22 8 fwGalleryController->galleries() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_fwgallery/fwgallery.php:24 6 require_once JROOT/components/com_fwgallery/fwgallery.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [ Add xdebug.file_link_format directive to your php.ini file to have links for files. ] Query Time: 2.12 ms After last query: 0.08 ms Query memory: 0.022 MB Memory before query: 2.522 MB Rows returned: 1 SELECT COUNT ( * ) FROM jos_fwg_files AS f LEFT JOIN jos_fwg_projects AS p ON f.project_id = p.id LEFT JOIN jos_usergroups AS pg ON (pg.id = p.gid) WHERE (f.project_id IN (17) OR f.id IN ( SELECT ft.file_id FROM jos_fwg_projects_tags AS pt, jos_fwg_files_tags AS ft WHERE pt.project_id IN (17) AND pt.tag_id = ft.tag_id)) AND f.published = 1 AND p.published = 1 AND (p.gid = 0 OR p.gid IS NULL ) Explain id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY p ref PRIMARY,published,gid published 1 const 32 Using where 1 PRIMARY f ref project_id project_id 4 demo.p.id 16 Using where 2 MATERIALIZED pt ref tag_id,project_id project_id 4 const 1 2 MATERIALIZED ft ref tag_id,file_id tag_id 4 demo.pt.tag_id 5 Profile Status Duration starting 0.02 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms init 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.00 ms Unlocking tables 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms executing 0.00 ms Sending data 0.83 ms removing tmp table 0.00 ms Sending data 1.05 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.01 ms freeing items 0.01 ms removing tmp table 0.00 ms freeing items 0.00 ms updating status 0.01 ms cleaning up 0.00 ms Call Stack # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 13 JDatabaseDriver->loadResult() JROOT/components/com_fwgallery/models/gallery.php:223 12 fwGalleryModelGallery->getQty() JROOT/components/com_fwgallery/models/gallery.php:231 11 fwGalleryModelGallery->getPagination() JROOT/components/com_fwgallery/views/gallery/view.html.php:124 10 fwGalleryViewGallery->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_fwgallery/controller.php:22 8 fwGalleryController->galleries() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_fwgallery/fwgallery.php:24 6 require_once JROOT/components/com_fwgallery/fwgallery.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [ Add xdebug.file_link_format directive to your php.ini file to have links for files. ] Query Time: 0.27 ms After last query: 23.08 ms Query memory: 0.020 MB Memory before query: 2.683 MB Rows returned: 1 SELECT language,id FROM ` jos_menu ` WHERE home = 1 AND published = 1 AND client_id = 0 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jos_menu ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 62 Using where Profile Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms init 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.08 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.01 ms freeing items 0.00 ms updating status 0.01 ms cleaning up 0.00 ms Call Stack # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 9 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/Multilanguage.php:107 8 Joomla\CMS\Language\Multilanguage::getSiteHomePages() JROOT/plugins/system/languagefilter/languagefilter.php:751 7 PlgSystemLanguageFilter->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [ Add xdebug.file_link_format directive to your php.ini file to have links for files. ] Query Time: 0.29 ms After last query: 0.45 ms Query memory: 0.021 MB Memory before query: 2.693 MB Rows returned: 0 SELECT `c2`.`language`,`c2`.`id` FROM ` jos_menu ` AS `c` INNER JOIN ` jos_associations ` AS `a` ON a.id = c.`id` AND a.context = 'com_menus.item' INNER JOIN ` jos_associations ` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN ` jos_menu ` AS `c2` ON a2.id = c2.`id` WHERE c.id = 366 Explain id 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 Profile Status Duration starting 0.02 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.11 ms preparing 0.00 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms freeing items 0.00 ms updating status 0.01 ms cleaning up 0.00 ms Call Stack # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/Associations.php:115 9 Joomla\CMS\Language\Associations::getAssociations() JROOT/administrator/components/com_menus/helpers/menus.php:321 8 MenusHelper::getAssociations() JROOT/plugins/system/languagefilter/languagefilter.php:768 7 PlgSystemLanguageFilter->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [ Add xdebug.file_link_format directive to your php.ini file to have links for files. ] Query Time: 0.50 ms After last query: 2.28 ms Query memory: 0.023 MB Memory before query: 2.742 MB Rows returned: 4 SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN jos_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 < = '2023-12-27 21:02:42') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down > = '2023-12-27 21:02:42') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 366 OR mm.menuid < = 0) AND m.language IN ('en- GB ',' * ') ORDER BY m.position, m.ordering Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds,idx_language published 1 const 27 Using index condition; Using where; Using filesort 1 SIMPLE mm ref PRIMARY PRIMARY 4 demo.m.id 1 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 demo.m.module,const 1 Using index condition; Using where Profile Status Duration starting 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms init 0.02 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.03 ms executing 0.00 ms Sorting result 0.18 ms Sending data 0.08 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.00 ms Call Stack # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 14 JDatabaseDriver->loadObjectList() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:432 11 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:362 10 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 9 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:581 8 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/fwallery18/index.php:32 7 require JROOT/templates/fwallery18/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [ Add xdebug.file_link_format directive to your php.ini file to have links for files. ] 25 Query Types Logged, Sorted by Occurrences. SELECT Tables: 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM ` jos_extensions ` 1 × SELECT `data` FROM ` jos_session ` 1 × SELECT c. * , ( SELECT u.name FROM jos_users AS u 1 × SELECT `c2`.`language`,`c2`.`id` FROM ` jos_menu ` AS `c` INNER JOIN ` jos_associations ` AS `a` ON a.id = c.`id` AND a.context = 'com_menus.item' INNER JOIN ` jos_associations ` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN ` jos_menu ` AS `c2` ON a2.id = c2.`id` 1 × SELECT language,id FROM ` jos_menu ` 1 × SELECT COUNT ( * ) FROM jos_fwg_files AS f LEFT JOIN jos_fwg_projects AS p ON f.project_id = p.id LEFT JOIN jos_usergroups AS pg ON (pg.id = p.gid) 1 × SELECT t.id, t.name, ft.file_id FROM jos_fwg_files_tags AS ft, jos_fwg_tags AS t 1 × SELECT f. * , p.user_id AS _user_id, p.color AS _color, u.name AS _user_name, p.name AS _project_name, t.name AS _type_name, t.plugin AS _plugin_name, CASE WHEN ( SELECT COUNT ( * ) FROM jos_fwg_files_vote AS v LEFT JOIN jos_users AS u ON u.id = v.user_id 1 × SELECT COUNT ( * ) FROM jos_fwg_projects AS p LEFT JOIN jos_users AS u ON (u.id = p.user_id) LEFT JOIN jos_usergroups AS pg ON (pg.id = p.gid) 1 × SELECT p. * , p.user_id AS _user_id, u.name AS _user_name, ( SELECT COUNT ( * ) FROM jos_fwg_files AS f 1 × SELECT `id`,`name`,`rules`,`parent_id` FROM ` jos_assets ` 1 × SELECT id, home, template, s.params FROM jos_template_styles as s LEFT JOIN jos_extensions as e ON e.element = s.template AND e.type = 'template' AND e.client_id = s.client_id 1 × SELECT `session_id` FROM ` jos_session ` 1 × SELECT params FROM ` jos_extensions ` 1 × 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 jos_menu AS m LEFT JOIN jos_extensions AS e ON m.component_id = e.extension_id 1 × SELECT count(1) FROM ` jos_session ` 1 × SELECT `element`,`name`,`client_id`,`extension_id` FROM ` jos_extensions ` 1 × SELECT * FROM jos_languages 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM jos_extensions 1 × SELECT b.id FROM jos_usergroups AS a LEFT JOIN jos_usergroups AS b ON b.lft < = a.lft AND b.rgt > = a.rgt 1 × SELECT id, rules FROM ` jos_viewlevels 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN jos_extensions AS e ON e.element = m.module AND e.client_id = m.client_id OTHER Tables: 1 × INSERT INTO ` jos_session ` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('19d9639524d4341bdcc0cf093a0ef96d', 1, 1703710962, 0, '', 0 1 × UPDATE ` jos_extensions ` SET `params` = '{\"mediaversion\":\"2997cbb1aac1a5be0d72359ec33c5959\"}' 1 × SHOW FULL COLUMNS FROM ` jos_fwg_projects