Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1503087177,
                "last": 1503087177,
                "now": 1503087177
            }
        },
        "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
        }
    }
}

Profile Information

Time

Memory

**Time**: 2.46 ms / 2.46 ms **Memory**: 0.197 MB / 0.40 MB Application: afterLoad

**Time**: 48.63 ms / 51.08 ms **Memory**: 1.878 MB / 2.28 MB Application: afterInitialise

**Time**: 10.65 ms / 61.73 ms **Memory**: 0.308 MB / 2.59 MB Application: afterRoute

**Time**: 2.27 ms / 64.00 ms **Memory**: 0.047 MB / 2.64 MB Application: beforeRenderComponent com_content

**Time**: 30.77 ms / 94.78 ms **Memory**: 0.251 MB / 2.89 MB Application: Before JAccess::preloadComponents (all components)

**Time**: 0.87 ms / 95.65 ms **Memory**: 0.096 MB / 2.98 MB Application: After JAccess::preloadComponents (all components)

**Time**: 0.06 ms / 95.71 ms **Memory**: 0.000 MB / 2.98 MB Application: Before JAccess::getAssetRules (id:8 name:com_content)

**Time**: 0.33 ms / 96.04 ms **Memory**: 0.018 MB / 2.99 MB Application: After JAccess::getAssetRules (id:8 name:com_content)

**Time**: 19.78 ms / 115.82 ms **Memory**: 0.245 MB / 3.24 MB Application: afterRenderComponent com_content

**Time**: 1.35 ms / 117.17 ms **Memory**: 0.025 MB / 3.26 MB Application: afterDispatch

**Time**: 40.43 ms / 157.61 ms **Memory**: 0.466 MB / 3.73 MB Application: beforeRenderModule mod_menu (Bottom Menu (EN))

**Time**: 7.91 ms / 165.52 ms **Memory**: 0.060 MB / 3.79 MB Application: afterRenderModule mod_menu (Bottom Menu (EN))

**Time**: 0.22 ms / 165.74 ms **Memory**: 0.007 MB / 3.80 MB Application: beforeRenderModule mod_joomimg (Gallery)

**Time**: 107.11 ms / 272.85 ms **Memory**: 3.664 MB / 7.46 MB Application: afterRenderModule mod_joomimg (Gallery)

**Time**: 0.85 ms / 273.70 ms **Memory**: 0.000 MB / 6.97 MB Application: beforeRenderModule mod_junewsultra (News)

**Time**: 58.51 ms / 332.22 ms **Memory**: 0.245 MB / 7.22 MB Application: afterRenderModule mod_junewsultra (News)

**Time**: 0.31 ms / 332.53 ms **Memory**: 0.000 MB / 7.16 MB Application: beforeRenderModule mod_jdownloads_latest (Recent publications)

**Time**: 23.43 ms / 355.96 ms **Memory**: 0.240 MB / 7.40 MB Application: Before JAccess::preloadPermissions (com_jdownloads)

**Time**: 2.27 ms / 358.23 ms **Memory**: 0.272 MB / 7.67 MB Application: After JAccess::preloadPermissions (com_jdownloads)

**Time**: 0.08 ms / 358.31 ms **Memory**: 0.000 MB / 7.66 MB Application: Before JAccess::getAssetRules (id:2093 name:com_jdownloads.download.163)

**Time**: 0.14 ms / 358.45 ms **Memory**: 0.010 MB / 7.67 MB Application: After JAccess::getAssetRules (id:2093 name:com_jdownloads.download.163)

**Time**: 2.14 ms / 360.59 ms **Memory**: 0.023 MB / 7.69 MB Application: afterRenderModule mod_jdownloads_latest (Recent publications)

**Time**: 0.28 ms / 360.86 ms **Memory**: 0.000 MB / 7.65 MB Application: beforeRenderModule mod_s5_accordion_menu (Left Menu (EN))

**Time**: 9.89 ms / 370.75 ms **Memory**: 0.023 MB / 7.67 MB Application: afterRenderModule mod_s5_accordion_menu (Left Menu (EN))

**Time**: 0.28 ms / 371.03 ms **Memory**: 0.011 MB / 7.68 MB Application: beforeRenderModule mod_junewsultra (In Focus)

**Time**: 4.83 ms / 375.86 ms **Memory**: 0.103 MB / 7.79 MB Application: afterRenderModule mod_junewsultra (In Focus)

**Time**: 0.13 ms / 375.99 ms **Memory**: 0.000 MB / 7.74 MB Application: beforeRenderModule mod_djmediatools (Our Voices)

**Time**: 19.01 ms / 395.00 ms **Memory**: 0.289 MB / 8.03 MB Application: afterRenderModule mod_djmediatools (Our Voices)

**Time**: 0.21 ms / 395.21 ms **Memory**: 0.000 MB / 7.98 MB Application: beforeRenderModule mod_languages (Language switcher)

**Time**: 18.36 ms / 413.56 ms **Memory**: 0.064 MB / 8.04 MB Application: afterRenderModule mod_languages (Language switcher)

**Time**: 175.94 ms / 589.50 ms **Memory**: 0.362 MB / 8.40 MB Application: afterRender

**Database queries total: 86.47 ms**

Memory Usage

Database Queries

101 Queries Logged 86.47 ms

7 duplicate found!

**3 duplicates**: #11 #15 #101

**2 duplicates**: #14 #27

**2 duplicates**: #25 #26

**Query Time: 1.14 ms** **Query memory: 0.008 MB Memory before query: 0.902 MB**

DELETE 

  FROM `v4egt_session`

  WHERE `time` < '1503086277'

**Explain**

**EXPLAIN not possible on query: DELETE FROM `v4egt_session` WHERE `time` < '1503086277'**

**Profile**

Error
MySql have_profiling = off

**Call Stack**

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:822
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:413
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.16 ms** **After last query: 0.35 ms** **Query memory: 0.020 MB Memory before query: 0.924 MB** **Rows returned: 0**

SELECT `data`

  FROM `v4egt_session`

  WHERE `session_id` = 'qsifjtbv4983o7646iojlja465'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	v4egt_session	const	PRIMARY	PRIMARY	575	const	1

**Profile**

**No SHOW PROFILE (maybe because there are more than 100 queries)**

**Call Stack**

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
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:82
10	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:648
9	JSession->_start()	JROOT/libraries/joomla/session/session.php:608
8	JSession->start()	JROOT/libraries/joomla/session/session.php:486
7	JSession->get()	JROOT/libraries/joomla/session/session.php:443
6	JSession->isNew()	JROOT/libraries/cms/application/cms.php:829
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:413
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.12 ms** **After last query: 0.69 ms** **Query memory: 0.012 MB Memory before query: 0.977 MB** **Rows returned: 0**

SELECT `session_id`

  FROM `v4egt_session`

  WHERE `session_id` = 'qsifjtbv4983o7646iojlja465' 
  LIMIT 1

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	v4egt_session	const	PRIMARY	PRIMARY	575	const	1	Using index

**Profile**

**No SHOW PROFILE (maybe because there are more than 100 queries)**

**Call Stack**

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:831
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:413
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.49 ms** **After last query: 0.23 ms** **Query memory: 0.009 MB Memory before query: 0.992 MB**

INSERT INTO `v4egt_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('qsifjtbv4983o7646iojlja465', 1, '1503087177', 0, '', 0)

**Explain**

**EXPLAIN not possible on query: INSERT INTO `v4egt_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('qsifjtbv4983o7646iojlja465', 1, '1503087177', 0, '', 0)**

**Profile**

**No SHOW PROFILE (maybe because there are more than 100 queries)**

**Call Stack**

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:216
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:831
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:413
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.57 ms** **After last query: 0.79 ms** **Query memory: 0.019 MB Memory before query: 1.047 MB** **Rows returned: 38**

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `v4egt_extensions`

  WHERE `type` = 'component'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	v4egt_extensions	ref	extension	extension	62	const	38	Using where

**Profile**

**No SHOW PROFILE (maybe because there are more than 100 queries)**

**Call Stack**

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/component/helper.php:447
9	JComponentHelper::{closure}()	*Same as call in the line below.*
8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:455
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:111
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:593
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.05 ms** **After last query: 1.03 ms** **Query memory: 0.014 MB Memory before query: 1.133 MB** **Rows returned: 3**

SELECT id, rules

  FROM `v4egt_viewlevels`

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	v4egt_viewlevels	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3

**Profile**

**No SHOW PROFILE (maybe because there are more than 100 queries)**

**Call Stack**

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1061
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:309
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.04 ms** **After last query: 0.21 ms** **Query memory: 0.015 MB Memory before query: 1.156 MB** **Rows returned: 2**

SELECT b.id

  FROM v4egt_usergroups AS a

  LEFT JOIN v4egt_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 8

**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	4	Using where; Using index

**Profile**

**No SHOW PROFILE (maybe because there are more than 100 queries)**

**Call Stack**

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:978
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1093
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:309
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 1.28 ms** **After last query: 0.36 ms** **Query memory: 0.018 MB Memory before query: 1.194 MB** **Rows returned: 86**

SELECT `folder` AS `type`,`element` AS `name`,`params`

  FROM v4egt_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,2,3)

  ORDER BY ordering

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	v4egt_extensions	ref	extension	extension	62	const	111	Using where; Using filesort

**Profile**

**No SHOW PROFILE (maybe because there are more than 100 queries)**

**Call Stack**

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:327
9	JPluginHelper::{closure}()	*Same as call in the line below.*
8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/plugin/helper.php:332
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.09 ms** **After last query: 25.17 ms** **Query memory: 0.017 MB Memory before query: 1.798 MB** **Rows returned: 2**

SELECT *

  FROM v4egt_languages

  WHERE published=1

  ORDER BY ordering ASC

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	v4egt_languages	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where; Using filesort

**Profile**

**No SHOW PROFILE (maybe because there are more than 100 queries)**

**Call Stack**

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:148
8	JLanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:98
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:271
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:181
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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.34 ms** **Query memory: 0.015 MB Memory before query: 1.821 MB** **Rows returned: 6**

SELECT `element`,`name`,`client_id`,`extension_id`

  FROM `v4egt_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	v4egt_extensions	ref	extension	extension	62	const	6	Using where

**Profile**

**No SHOW PROFILE (maybe because there are more than 100 queries)**

**Call Stack**

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:207
8	JLanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:109
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:271
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:181
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 2.88 ms** **After last query: 2.43 ms** **Query memory: 0.022 MB Memory before query: 1.936 MB** **Rows returned: 415**

**Duplicate queries**: #15 #101

SHOW TABLES

**Explain**

**EXPLAIN not possible on query: SHOW TABLES**

**Profile**

**No SHOW PROFILE (maybe because there are more than 100 queries)**

**Call Stack**

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
11	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:497
10	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jdownloads/jdownloads.php:78
9	plgSystemjdownloads->onAfterInitialise()	*Same as call in the line below.*
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:684
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.55 ms** **After last query: 0.83 ms** **Query memory: 0.014 MB Memory before query: 2.026 MB** **Rows returned: 0**

SELECT file_id 
  from v4egt_jdownloads_files 
  WHERE published = 1 
  AND use_timeframe = 1 
  AND publish_to != '0000-00-00 00:00:00' 
  AND publish_to <= '2017-08-18 23:12:57'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	v4egt_jdownloads_files	ref	idx_published	idx_published	1	const	90	Using where

**Profile**

**No SHOW PROFILE (maybe because there are more than 100 queries)**

**Call Stack**

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
10	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jdownloads/jdownloads.php:106
9	plgSystemjdownloads->onAfterInitialise()	*Same as call in the line below.*
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:684
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.25 ms** **After last query: 0.11 ms** **Query memory: 0.014 MB Memory before query: 2.040 MB** **Rows returned: 0**

SELECT file_id 
  from v4egt_jdownloads_files 
  WHERE published = 0 
  AND use_timeframe = 1 
  AND publish_from != '0000-00-00 00:00:00' 
  AND publish_from <= '2017-08-18 23:12:57'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	v4egt_jdownloads_files	ref	idx_published	idx_published	1	const	31	Using where

**Profile**

**No SHOW PROFILE (maybe because there are more than 100 queries)**

**Call Stack**

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
10	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jdownloads/jdownloads.php:114
9	plgSystemjdownloads->onAfterInitialise()	*Same as call in the line below.*
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:684
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.98 ms** **After last query: 0.76 ms** **Query memory: 0.038 MB Memory before query: 2.057 MB** **Rows returned: 35**

**Duplicate queries**: #27

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 v4egt_menu AS m

  LEFT JOIN v4egt_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	36	Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	sgpinformns.m.component_id	1

**Profile**

**No SHOW PROFILE (maybe because there are more than 100 queries)**

**Call Stack**

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:88
22	JMenuSite->{closure}()	*Same as call in the line below.*
21	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
20	JCacheControllerCallback->get()	JROOT/libraries/cms/menu/site.php:96
19	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
18	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
17	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:129
16	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:444
15	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
14	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:59
13	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:198
12	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:549
11	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:402
10	JApplicationSite::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:130
9	PlgSystemLanguageFilter->onAfterInitialise()	*Same as call in the line below.*
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:684
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 2.70 ms** **After last query: 6.25 ms** **Query memory: 0.022 MB Memory before query: 2.463 MB** **Rows returned: 415**

**Duplicate queries**: #11 #101

SHOW TABLES

**Explain**

**EXPLAIN not possible on query: SHOW TABLES**

**Profile**

**No SHOW PROFILE (maybe because there are more than 100 queries)**

**Call Stack**

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
11	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:497
10	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jdownloads/jdownloads.php:353
9	plgSystemjdownloads->onAfterRoute()	*Same as call in the line below.*
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1155
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.28 ms** **After last query: 1.05 ms** **Query memory: 0.025 MB Memory before query: 2.506 MB** **Rows returned: 1**

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `v4egt_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	v4egt_extensions	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	Using where

**Profile**

**No SHOW PROFILE (maybe because there are more than 100 queries)**

**Call Stack**

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
19	JDatabaseDriver->loadObject()	JROOT/libraries/cms/library/helper.php:166
18	JLibraryHelper::{closure}()	*Same as call in the line below.*
17	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
16	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:174
15	JLibraryHelper::loadLibrary()	JROOT/libraries/cms/library/helper.php:42
14	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:89
13	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:270
12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
10	JFactory::getDocument()	JROOT/plugins/system/cssconfig/cssconfig.php:53
9	plgSystemCSSConfig->onAfterRoute()	*Same as call in the line below.*
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1155
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.99 ms** **After last query: 0.35 ms** **Query memory: 0.018 MB Memory before query: 2.513 MB**

UPDATE `v4egt_extensions`

  SET `params` = '{\"mediaversion\":\"eb1a6b2427c5f9c45e75fd08e3952214\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

**Explain**

**EXPLAIN not possible on query: UPDATE `v4egt_extensions` SET `params` = '{\"mediaversion\":\"eb1a6b2427c5f9c45e75fd08e3952214\"}' WHERE `type` = 'library' AND `element` = 'joomla'**

**Profile**

**No SHOW PROFILE (maybe because there are more than 100 queries)**

**Call Stack**

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
14	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
13	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
10	JFactory::getDocument()	JROOT/plugins/system/cssconfig/cssconfig.php:53
9	plgSystemCSSConfig->onAfterRoute()	*Same as call in the line below.*
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1155
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.39 ms** **After last query: 1.11 ms** **Query memory: 0.010 MB Memory before query: 2.624 MB** **Rows returned: 6**

SELECT id, home, template, s.params

  FROM v4egt_template_styles as s

  LEFT JOIN v4egt_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	9	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	sgpinformns.s.template,const	1	Using where

**Profile**

**No SHOW PROFILE (maybe because there are more than 100 queries)**

**Call Stack**

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:485
4	JApplicationSite->getTemplate()	JROOT/libraries/cms/application/site.php:165
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.13 ms** **After last query: 32.39 ms** **Query memory: 0.029 MB Memory before query: 2.893 MB** **Rows returned: 38**

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `v4egt_assets`

  WHERE `name` IN ('root.1','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djmediatools','com_fields','com_finder','com_installer','com_jce','com_jdownloads','com_joomgallery','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_rsform','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	v4egt_assets	range	idx_asset_name	idx_asset_name	152	NULL	39	Using where

**Profile**

**No SHOW PROFILE (maybe because there are more than 100 queries)**

**Call Stack**

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
19	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
18	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
17	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
16	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
15	JUser->authorise()	JROOT/components/com_content/models/articles.php:113
14	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:42
13	ContentModelFeatured->populateState()	JROOT/libraries/legacy/model/legacy.php:434
12	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:422
11	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:54
10	ContentViewFeatured->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 1.74 ms** **After last query: 4.18 ms** **Query memory: 0.031 MB Memory before query: 3.032 MB** **Rows returned: 0**

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating, 
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

  FROM v4egt_content AS a

  LEFT JOIN v4egt_categories AS c 
  ON c.id = a.catid

  LEFT JOIN v4egt_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN v4egt_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN v4egt_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN v4egt_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.featured = 1 
  AND a.access IN (1,1,2,3) 
  AND c.access IN (1,1,2,3) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-08-18 20:12:57') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-08-18 20:12:57') 
  AND a.language in ('en-GB','*')

  ORDER BY c.lft,  
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC , a.created DESC  
  LIMIT 9

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_featured_catid,idx_language	idx_featured_catid	1	const	1	Using where; Using temporary; Using filesort
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	sgpinformns.a.created_by	1
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	sgpinformns.a.modified_by	1
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	sgpinformns.a.catid	1	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	sgpinformns.c.parent_id	1
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	sgpinformns.a.id	1

**Profile**

**No SHOW PROFILE (maybe because there are more than 100 queries)**

**Call Stack**

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
15	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
14	JModelList->getItems()	JROOT/components/com_content/models/articles.php:536
13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:100
12	ContentModelFeatured->getItems()	JROOT/libraries/legacy/view/legacy.php:422
11	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:55
10	ContentViewFeatured->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.41 ms** **After last query: 3.30 ms** **Query memory: 0.021 MB Memory before query: 3.069 MB** **Rows returned: 1**

SELECT COUNT(*)

  FROM v4egt_content AS a

  LEFT JOIN v4egt_categories AS c 
  ON c.id = a.catid

  LEFT JOIN v4egt_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN v4egt_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN v4egt_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN v4egt_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.featured = 1 
  AND a.access IN (1,1,2,3) 
  AND c.access IN (1,1,2,3) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-08-18 20:12:57') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-08-18 20:12:57') 
  AND a.language in ('en-GB','*')

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_featured_catid,idx_language	idx_featured_catid	1	const	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	sgpinformns.a.created_by	1	Using index
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	sgpinformns.a.modified_by	1	Using index
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	sgpinformns.a.catid	1	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	sgpinformns.c.parent_id	1	Using index
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	sgpinformns.a.id	1	Using index

**Profile**

**No SHOW PROFILE (maybe because there are more than 100 queries)**

**Call Stack**

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:334
14	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:281
13	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:231
12	JModelList->getPagination()	JROOT/libraries/legacy/view/legacy.php:422
11	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:56
10	ContentViewFeatured->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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: 13.12 ms** **Query memory: 0.016 MB Memory before query: 3.278 MB** **Rows returned: 1**

SELECT * 
  FROM v4egt_template_styles 
  WHERE template = 'corpway';

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	v4egt_template_styles	ref	idx_template	idx_template	152	const	1	Using where

**Profile**

**No SHOW PROFILE (maybe because there are more than 100 queries)**

**Call Stack**

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
10	JDatabaseDriver->loadAssocList()	JROOT/templates/corpway/vertex/parameters.php:19
9	getTemplateName()	JROOT/templates/corpway/vertex/parameters.php:167
8	require_once JROOT/templates/corpway/vertex/parameters.php	JROOT/templates/corpway/index.php:22
7	require JROOT/templates/corpway/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.22 ms** **After last query: 0.20 ms** **Query memory: 0.020 MB Memory before query: 3.295 MB** **Rows returned: 0**

SELECT * 
  FROM v4egt_menu 
  WHERE template_style_id IN (17) 
  AND alias = 'home'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	v4egt_menu	ref	idx_alias	idx_alias	302	const	3	Using where

**Profile**

**No SHOW PROFILE (maybe because there are more than 100 queries)**

**Call Stack**

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
10	JDatabaseDriver->loadAssocList()	JROOT/templates/corpway/vertex/parameters.php:40
9	getTemplateName()	JROOT/templates/corpway/vertex/parameters.php:167
8	require_once JROOT/templates/corpway/vertex/parameters.php	JROOT/templates/corpway/index.php:22
7	require JROOT/templates/corpway/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 1.65 ms** **After last query: 11.17 ms** **Query memory: 0.025 MB Memory before query: 3.509 MB** **Rows returned: 8**

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM v4egt_modules AS m

  LEFT JOIN v4egt_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN v4egt_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 <= '2017-08-18 20:12:57') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-08-18 20:12:57') 
  AND m.access IN (1,1,2,3) 
  AND m.client_id = 0 
  AND (mm.menuid = 177 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	range	PRIMARY,published,newsfeeds,idx_language	published	5	NULL	32	Using where; Using filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	sgpinformns.m.module,const	1	Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	sgpinformns.m.id	3	Using where; Using index

**Profile**

**No SHOW PROFILE (maybe because there are more than 100 queries)**

**Call Stack**

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	*Same as call in the line below.*
14	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
13	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:424
12	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:360
11	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
10	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
9	JDocumentHtml->countModules()	JROOT/templates/corpway/vertex/module_calcs.php:15
8	require_once JROOT/templates/corpway/vertex/module_calcs.php	JROOT/templates/corpway/index.php:24
7	require JROOT/templates/corpway/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.35 ms** **After last query: 7.29 ms** **Query memory: 0.017 MB Memory before query: 3.569 MB** **Rows returned: 1**

**Duplicate queries**: #26

SELECT menutype  
  FROM  v4egt_menu 
  WHERE language = 'en-GB' 
  AND home = 1

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	v4egt_menu	ref	idx_language	idx_language	21	const	17	Using where

**Profile**

**No SHOW PROFILE (maybe because there are more than 100 queries)**

**Call Stack**

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
11	JDatabaseDriver->loadResult()	JROOT/templates/corpway/vertex/responsive/responsive_mobile_menu.php:139
10	include JROOT/templates/corpway/vertex/responsive/responsive_mobile_menu.php	JROOT/templates/corpway/vertex/responsive/responsive_mobile_sidebar.php:70
9	require JROOT/templates/corpway/vertex/responsive/responsive_mobile_sidebar.php	JROOT/templates/corpway/vertex/includes/vertex_includes_top.php:4
8	require_once JROOT/templates/corpway/vertex/includes/vertex_includes_top.php	JROOT/templates/corpway/index.php:260
7	require JROOT/templates/corpway/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.05 ms** **After last query: 7.32 ms** **Query memory: 0.014 MB Memory before query: 3.780 MB** **Rows returned: 1**

**Duplicate queries**: #25

SELECT menutype  
  FROM  v4egt_menu 
  WHERE language = 'en-GB' 
  AND home = 1

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	v4egt_menu	ref	idx_language	idx_language	21	const	17	Using where

**Profile**

**No SHOW PROFILE (maybe because there are more than 100 queries)**

**Call Stack**

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
9	JDatabaseDriver->loadResult()	JROOT/templates/corpway/vertex/s5flex_menu/default.php:45
8	include JROOT/templates/corpway/vertex/s5flex_menu/default.php	JROOT/templates/corpway/index.php:363
7	require JROOT/templates/corpway/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.97 ms** **After last query: 0.54 ms** **Query memory: 0.032 MB Memory before query: 3.832 MB** **Rows returned: 35**

**Duplicate queries**: #14

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 v4egt_menu AS m

  LEFT JOIN v4egt_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	36	Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	sgpinformns.m.component_id	1

**Profile**

**No SHOW PROFILE (maybe because there are more than 100 queries)**

**Call Stack**

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:88
16	JMenuSite->{closure}()	*Same as call in the line below.*
15	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
14	JCacheControllerCallback->get()	JROOT/libraries/cms/menu/site.php:96
13	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
12	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
11	JMenuSite->__construct()	JROOT/templates/corpway/vertex/s5flex_menu/helpers.php:41
10	S5modMainMenuHelper::getList()	JROOT/templates/corpway/vertex/s5flex_menu/helpers.php:141
9	S5modMainMenuHelper->S5buildXML()	JROOT/templates/corpway/vertex/s5flex_menu/default.php:54
8	include JROOT/templates/corpway/vertex/s5flex_menu/default.php	JROOT/templates/corpway/index.php:363
7	require JROOT/templates/corpway/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 6.63 ms** **After last query: 22.57 ms** **Query memory: 0.053 MB Memory before query: 4.119 MB** **Rows returned: 296**

SHOW FULL COLUMNS 
  FROM `v4egt_joomgallery_config`

**Explain**

**EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `v4egt_joomgallery_config`**

**Profile**

**No SHOW PROFILE (maybe because there are more than 100 queries)**

**Call Stack**

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
19	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
18	JTable->__construct()	JROOT/administrator/components/com_joomgallery/tables/joomgalleryconfig.php:334
17	TableJoomgalleryConfig->__construct()	JROOT/libraries/joomla/table/table.php:311
16	JTable::getInstance()	JROOT/administrator/components/com_joomgallery/helpers/config.php:366
15	JoomConfig->__construct()	JROOT/administrator/components/com_joomgallery/helpers/config.php:429
14	JoomConfig::getInstance()	JROOT/components/com_joomgallery/helpers/ambit.php:147
13	JoomAmbit->__construct()	JROOT/components/com_joomgallery/helpers/ambit.php:220
12	JoomAmbit::getInstance()	JROOT/components/com_joomgallery/interface.php:102
11	JoomInterface->__construct()	JROOT/modules/mod_joomimg/mod_joomimg.php:43
10	include JROOT/modules/mod_joomimg/mod_joomimg.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 1.08 ms** **After last query: 3.92 ms** **Query memory: 0.105 MB Memory before query: 4.809 MB** **Rows returned: 1**

SELECT *

  FROM v4egt_joomgallery_config

  WHERE `id` = '1'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	v4egt_joomgallery_config	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1

**Profile**

**No SHOW PROFILE (maybe because there are more than 100 queries)**

**Call Stack**

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
17	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
16	JTable->load()	JROOT/administrator/components/com_joomgallery/helpers/config.php:367
15	JoomConfig->__construct()	JROOT/administrator/components/com_joomgallery/helpers/config.php:429
14	JoomConfig::getInstance()	JROOT/components/com_joomgallery/helpers/ambit.php:147
13	JoomAmbit->__construct()	JROOT/components/com_joomgallery/helpers/ambit.php:220
12	JoomAmbit::getInstance()	JROOT/components/com_joomgallery/interface.php:102
11	JoomInterface->__construct()	JROOT/modules/mod_joomimg/mod_joomimg.php:43
10	include JROOT/modules/mod_joomimg/mod_joomimg.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 1.50 ms** **After last query: 11.69 ms** **Query memory: 0.031 MB Memory before query: 4.965 MB** **Rows returned: 157**

SELECT c.cid, c.parent_id, c.name, c.access, c.published, c.hidden, c.owner

  FROM v4egt_joomgallery_catg AS c

  WHERE lft > 0 
  AND c.published = 1 
  AND c.access IN (1,1,2,3) 
  AND (c.password = '' OR c.cid IN (0))

  ORDER BY c.lft

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	159	Using where; Using filesort

**Profile**

**No SHOW PROFILE (maybe because there are more than 100 queries)**

**Call Stack**

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_joomgallery/helpers/ambit.php:492
13	JoomAmbit->getCategoryStructure()	JROOT/modules/mod_joomimg/helper.php:440
12	modJoomImagesHelper->getDBImages()	JROOT/modules/mod_joomimg/helper.php:47
11	modJoomImagesHelper->fillObject()	JROOT/modules/mod_joomimg/mod_joomimg.php:52
10	include JROOT/modules/mod_joomimg/mod_joomimg.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 1.97 ms** **After last query: 1.18 ms** **Query memory: 0.025 MB Memory before query: 5.249 MB** **Rows returned: 156**

SELECT catid, COUNT(id) as piccount, SUM(hits) as hitcount

  FROM v4egt_joomgallery

  WHERE approved  = 1 
  AND published = 1 
  AND hidden    = 0 
  AND access IN (1,1,2,3)

  GROUP BY catid

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	v4egt_joomgallery	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	941	Using where; Using temporary; Using filesort

**Profile**

**No SHOW PROFILE (maybe because there are more than 100 queries)**

**Call Stack**

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_joomgallery/helpers/ambit.php:508
13	JoomAmbit->getCategoryStructure()	JROOT/modules/mod_joomimg/helper.php:440
12	modJoomImagesHelper->getDBImages()	JROOT/modules/mod_joomimg/helper.php:47
11	modJoomImagesHelper->fillObject()	JROOT/modules/mod_joomimg/mod_joomimg.php:52
10	include JROOT/modules/mod_joomimg/mod_joomimg.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 17.89 ms** **After last query: 1.65 ms** **Query memory: 0.041 MB Memory before query: 5.401 MB** **Rows returned: 300**

SELECT p.id AS id, p.catid, p.imgthumbname, p.imgfilename, p.imgtitle,p.imgtext,c.cid AS ccid, c.catpath AS catpath

  FROM v4egt_joomgallery AS p

  LEFT JOIN v4egt_joomgallery_catg AS c 
  ON c.cid = p.catid

  WHERE c.published = 1 
  AND c.access IN (1,1,2,3) 
  AND p.published = 1 
  AND p.approved = 1 
  AND p.access IN (1,1,2,3) 
  AND p.catid IN (4,174,169,168,167,162,161,160,159,158,157,156,155,154,153,152,151,150,149,148,147,146,145,144,143,141,140,138,137,136,135,134,133,132,131,130,129,128,127,125,123,122,121,119,118,117,116,115,114,113,112,111,109,108,107,105,103,102,101,100,99,98,97,96,95,94,93,92,91,90,89,88,87,86,85,84,83,82,81,80,79,78,77,76,75,74,73,72,71,70,69,68,67,66,65,64,63,62,61,60,59,58,57,56,55,3,106,104,54,53,52,51,50,49,48,47,46,45,44,43,42,41,40,39,38,37,36,35,34,33,32,31,30,29,28,27,26,25,24,23,22,21,20,19,18,17,16,15,14,13,12,11,8,7,10,9,6) 
  AND p.catid IN (3,106,104,54,53,52,51,50,49,48,47,46,45,44,43,42,41,40,39,38,37,36,35,34,33,32,31,30,29,28,27,26,25,24,23,22,21,20,19,18,17,16,15,14,13,12,11,8,7,10,9,6) 
  AND c.hidden    = 0 
  AND c.in_hidden = 0 
  AND p.hidden    = 0

  ORDER BY rand() 
  LIMIT 300

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	159	Using where; Using temporary; Using filesort
1	SIMPLE	p	ref	idx_catid	idx_catid	4	sgpinformns.c.cid	6	Using where

**Profile**

**No SHOW PROFILE (maybe because there are more than 100 queries)**

**Call Stack**

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
13	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_joomimg/helper.php:518
12	modJoomImagesHelper->getDBImages()	JROOT/modules/mod_joomimg/helper.php:47
11	modJoomImagesHelper->fillObject()	JROOT/modules/mod_joomimg/mod_joomimg.php:52
10	include JROOT/modules/mod_joomimg/mod_joomimg.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.79 ms** **After last query: 4.02 ms** **Query memory: 0.021 MB Memory before query: 5.956 MB** **Rows returned: 0**

SELECT id

  FROM v4egt_menu

  WHERE link LIKE '%com_joomgallery%view=gallery%' 
  AND access IN (1,1,2,3) 
  AND published = 1 
  AND client_id = 0 
  AND (language = 'en-GB' OR language = '' OR language = '*')

  ORDER BY id DESC

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	v4egt_menu	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	37	Using where; Using filesort

**Profile**

**No SHOW PROFILE (maybe because there are more than 100 queries)**

**Call Stack**

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/helpers/ambit.php:426
14	JoomAmbit->getItemid()	JROOT/components/com_joomgallery/interface.php:304
13	JoomInterface->getJoomId()	JROOT/components/com_joomgallery/interface.php:325
12	JoomInterface->route()	JROOT/modules/mod_joomimg/tmpl/slideshow.php:95
11	require JROOT/modules/mod_joomimg/tmpl/slideshow.php	JROOT/modules/mod_joomimg/mod_joomimg.php:65
10	include JROOT/modules/mod_joomimg/mod_joomimg.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.47 ms** **After last query: 0.19 ms** **Query memory: 0.021 MB Memory before query: 5.977 MB** **Rows returned: 1**

SELECT id

  FROM v4egt_menu

  WHERE link LIKE '%com_joomgallery%' 
  AND access IN (1,1,2,3) 
  AND published = 1 
  AND client_id = 0 
  AND (language = 'en-GB' OR language = '' OR language = '*')

  ORDER BY id DESC

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	v4egt_menu	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	37	Using where; Using filesort

**Profile**

**No SHOW PROFILE (maybe because there are more than 100 queries)**

**Call Stack**

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/helpers/ambit.php:438
14	JoomAmbit->getItemid()	JROOT/components/com_joomgallery/interface.php:304
13	JoomInterface->getJoomId()	JROOT/components/com_joomgallery/interface.php:325
12	JoomInterface->route()	JROOT/modules/mod_joomimg/tmpl/slideshow.php:95
11	require JROOT/modules/mod_joomimg/tmpl/slideshow.php	JROOT/modules/mod_joomimg/mod_joomimg.php:65
10	include JROOT/modules/mod_joomimg/mod_joomimg.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.16 ms** **After last query: 0.45 ms** **Query memory: 0.027 MB Memory before query: 5.998 MB** **Rows returned: 1**

SELECT alias

  FROM v4egt_joomgallery_catg

  WHERE cid = 54

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	v4egt_joomgallery_catg	const	PRIMARY	PRIMARY	4	const	1

**Profile**

**No SHOW PROFILE (maybe because there are more than 100 queries)**

**Call Stack**

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
20	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/router.php:310
19	JoomGalleryBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:519
17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
15	JRouter->build()	JROOT/libraries/cms/router/site.php:149
14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
13	JRoute::_()	JROOT/components/com_joomgallery/interface.php:327
12	JoomInterface->route()	JROOT/modules/mod_joomimg/tmpl/slideshow.php:95
11	require JROOT/modules/mod_joomimg/tmpl/slideshow.php	JROOT/modules/mod_joomimg/mod_joomimg.php:65
10	include JROOT/modules/mod_joomimg/mod_joomimg.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.13 ms** **After last query: 0.44 ms** **Query memory: 0.027 MB Memory before query: 6.026 MB** **Rows returned: 1**

SELECT alias

  FROM v4egt_joomgallery_catg

  WHERE cid = 49

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	v4egt_joomgallery_catg	const	PRIMARY	PRIMARY	4	const	1

**Profile**

**No SHOW PROFILE (maybe because there are more than 100 queries)**

**Call Stack**

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
20	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/router.php:310
19	JoomGalleryBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:519
17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
15	JRouter->build()	JROOT/libraries/cms/router/site.php:149
14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
13	JRoute::_()	JROOT/components/com_joomgallery/interface.php:327
12	JoomInterface->route()	JROOT/modules/mod_joomimg/tmpl/slideshow.php:95
11	require JROOT/modules/mod_joomimg/tmpl/slideshow.php	JROOT/modules/mod_joomimg/mod_joomimg.php:65
10	include JROOT/modules/mod_joomimg/mod_joomimg.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.12 ms** **After last query: 0.42 ms** **Query memory: 0.027 MB Memory before query: 6.053 MB** **Rows returned: 1**

SELECT alias

  FROM v4egt_joomgallery_catg

  WHERE cid = 45

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	v4egt_joomgallery_catg	const	PRIMARY	PRIMARY	4	const	1

**Profile**

**No SHOW PROFILE (maybe because there are more than 100 queries)**

**Call Stack**

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
20	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/router.php:310
19	JoomGalleryBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:519
17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
15	JRouter->build()	JROOT/libraries/cms/router/site.php:149
14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
13	JRoute::_()	JROOT/components/com_joomgallery/interface.php:327
12	JoomInterface->route()	JROOT/modules/mod_joomimg/tmpl/slideshow.php:95
11	require JROOT/modules/mod_joomimg/tmpl/slideshow.php	JROOT/modules/mod_joomimg/mod_joomimg.php:65
10	include JROOT/modules/mod_joomimg/mod_joomimg.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.11 ms** **After last query: 0.41 ms** **Query memory: 0.027 MB Memory before query: 6.080 MB** **Rows returned: 1**

SELECT alias

  FROM v4egt_joomgallery_catg

  WHERE cid = 32

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	v4egt_joomgallery_catg	const	PRIMARY	PRIMARY	4	const	1

**Profile**

**No SHOW PROFILE (maybe because there are more than 100 queries)**

**Call Stack**

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
20	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/router.php:310
19	JoomGalleryBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:519
17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
15	JRouter->build()	JROOT/libraries/cms/router/site.php:149
14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
13	JRoute::_()	JROOT/components/com_joomgallery/interface.php:327
12	JoomInterface->route()	JROOT/modules/mod_joomimg/tmpl/slideshow.php:95
11	require JROOT/modules/mod_joomimg/tmpl/slideshow.php	JROOT/modules/mod_joomimg/mod_joomimg.php:65
10	include JROOT/modules/mod_joomimg/mod_joomimg.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.11 ms** **After last query: 0.40 ms** **Query memory: 0.027 MB Memory before query: 6.107 MB** **Rows returned: 1**

SELECT alias

  FROM v4egt_joomgallery_catg

  WHERE cid = 30

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	v4egt_joomgallery_catg	const	PRIMARY	PRIMARY	4	const	1

**Profile**

**No SHOW PROFILE (maybe because there are more than 100 queries)**

**Call Stack**

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
20	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/router.php:310
19	JoomGalleryBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:519
17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
15	JRouter->build()	JROOT/libraries/cms/router/site.php:149
14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
13	JRoute::_()	JROOT/components/com_joomgallery/interface.php:327
12	JoomInterface->route()	JROOT/modules/mod_joomimg/tmpl/slideshow.php:95
11	require JROOT/modules/mod_joomimg/tmpl/slideshow.php	JROOT/modules/mod_joomimg/mod_joomimg.php:65
10	include JROOT/modules/mod_joomimg/mod_joomimg.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.11 ms** **After last query: 0.40 ms** **Query memory: 0.027 MB Memory before query: 6.134 MB** **Rows returned: 1**

SELECT alias

  FROM v4egt_joomgallery_catg

  WHERE cid = 34

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	v4egt_joomgallery_catg	const	PRIMARY	PRIMARY	4	const	1

**Profile**

**No SHOW PROFILE (maybe because there are more than 100 queries)**

**Call Stack**

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
20	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/router.php:310
19	JoomGalleryBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:519
17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
15	JRouter->build()	JROOT/libraries/cms/router/site.php:149
14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
13	JRoute::_()	JROOT/components/com_joomgallery/interface.php:327
12	JoomInterface->route()	JROOT/modules/mod_joomimg/tmpl/slideshow.php:95
11	require JROOT/modules/mod_joomimg/tmpl/slideshow.php	JROOT/modules/mod_joomimg/mod_joomimg.php:65
10	include JROOT/modules/mod_joomimg/mod_joomimg.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.11 ms** **After last query: 0.39 ms** **Query memory: 0.027 MB Memory before query: 6.161 MB** **Rows returned: 1**

About Us

Our Projects

Do you have an Idea?

Resources

Contact Us

In Focus

Art for Environment Campaign: Symphonic Orchestra Concert on the Water, June 30

Our Voices

About Us

Our Projects

Do you have an Idea?

Resources

Contact Us

Gallery

News

GEF SGP KNOWLEDGE FAIR

GEF SGP Ukraine conducted a Workshop on Project Cycle Management

PROJECT MANAGEMENT TRAINING FOR THE GRANT PROJECTS ADMINISTERED BY THE UNDP/GEF SMALL GRANTS PROGRAMME

Recent publications

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

101 Queries Logged 86.47 ms

7 duplicate found!

In Focus

Our Voices

Gallery

News

Recent publications

**Joomla! Debug Console**

**Session**

**Profile Information**

**Time**

**Memory**

**Memory Usage**

**Database Queries**

**101 Queries Logged** 86.47 ms

**7 duplicate found!**

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

101 Queries Logged 86.47 ms

7 duplicate found!