Sign up

Choose your language

Bulgaria

Join us!

Welcome to our community - tell us about yourself and sign up

Thanks for visiting our site! Hope you enjoy your stay!

Login Form

Language

Latest products

12,00 € each Bulgarian rose water 10 items in stock

Cart

The cart is empty

Groups in Bulgaria

Bourgas

Open

1 User

Varna

Open

1 User

Plovdiv

Open

1 User

Sofia

Open

2 Users

Latest activity

sebastian posted on sebastian wall

sebastian blogged vratsa

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1579799835,
                "last": 1579799835,
                "now": 1579799835
            },
            "token": "jkLrHmCoB8wxSCNCwMyMt1Rn7wq2yuhT"
        },
        "registry": {
            "com_hikashop": {
                "user_id": 0,
                "zone_id": "73"
            }
        },
        "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: 4.51 ms / 4.51 ms Memory: 0.570 MB / 0.94 MB Application: afterLoad

Time: 20.05 ms / 24.56 ms Memory: 1.262 MB / 2.20 MB Application: afterInitialise

Time: 9.75 ms / 34.31 ms Memory: 0.633 MB / 2.83 MB Application: afterRoute

Time: 0.18 ms / 34.49 ms Memory: 0.004 MB / 2.84 MB Application: beforeRenderComponent com_comprofiler

Time: 21.03 ms / 55.52 ms Memory: 2.290 MB / 5.13 MB Application: Before Access::preloadComponents (all components)

Time: 0.93 ms / 56.45 ms Memory: 0.061 MB / 5.19 MB Application: After Access::preloadComponents (all components)

Time: 0.03 ms / 56.48 ms Memory: 0.000 MB / 5.18 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Time: 0.18 ms / 56.66 ms Memory: 0.009 MB / 5.19 MB Application: After Access::getAssetRules (id:1 name:root.1)

Time: 7.66 ms / 64.32 ms Memory: 0.293 MB / 5.49 MB Application: afterRenderComponent com_comprofiler

Time: 1.76 ms / 66.08 ms Memory: 0.030 MB / 5.52 MB Application: afterDispatch

Time: 27.08 ms / 93.16 ms Memory: 2.798 MB / 8.31 MB Application: beforeRenderModule mod_cbcontent (CB Content)

Time: 0.21 ms / 93.37 ms Memory: 0.008 MB / 8.32 MB Application: afterRenderModule mod_cbcontent (CB Content)

Time: 0.29 ms / 93.65 ms Memory: 0.000 MB / 8.32 MB Application: beforeRenderModule mod_login (Login Form)

Time: 1.50 ms / 95.15 ms Memory: 0.027 MB / 8.35 MB Application: afterRenderModule mod_login (Login Form)

Time: 0.09 ms / 95.25 ms Memory: 0.009 MB / 8.36 MB Application: beforeRenderModule mod_cbgallery (Gallery)

Time: 2.48 ms / 97.73 ms Memory: 0.097 MB / 8.45 MB Application: afterRenderModule mod_cbgallery (Gallery)

Time: 0.07 ms / 97.80 ms Memory: 0.000 MB / 8.42 MB Application: beforeRenderModule mod_languages (Language)

Time: 1.22 ms / 99.01 ms Memory: 0.018 MB / 8.43 MB Application: afterRenderModule mod_languages (Language)

Time: 0.05 ms / 99.06 ms Memory: 0.000 MB / 8.43 MB Application: beforeRenderModule mod_comprofileronline (Online)

Time: 0.84 ms / 99.90 ms Memory: 0.029 MB / 8.46 MB Application: afterRenderModule mod_comprofileronline (Online)

Time: 0.05 ms / 99.95 ms Memory: 0.000 MB / 8.45 MB Application: beforeRenderModule mod_whosonline (Who's Online )

Time: 1.31 ms / 101.26 ms Memory: 0.054 MB / 8.51 MB Application: afterRenderModule mod_whosonline (Who's Online )

Time: 0.06 ms / 101.32 ms Memory: 0.002 MB / 8.51 MB Application: beforeRenderModule mod_hikashop (Latest products)

Time: 14.52 ms / 115.84 ms Memory: 1.059 MB / 9.57 MB Application: afterRenderModule mod_hikashop (Latest products)

Time: 0.06 ms / 115.91 ms Memory: 0.000 MB / 9.54 MB Application: beforeRenderModule mod_hikashop_cart (Cart )

Time: 1.36 ms / 117.27 ms Memory: 0.045 MB / 9.58 MB Application: afterRenderModule mod_hikashop_cart (Cart )

Time: 0.05 ms / 117.32 ms Memory: 0.000 MB / 9.57 MB Application: beforeRenderModule mod_cbgroupjive (Groups in Bulgaria)

Time: 5.24 ms / 122.56 ms Memory: 0.285 MB / 9.85 MB Application: afterRenderModule mod_cbgroupjive (Groups in Bulgaria)

Time: 0.54 ms / 123.09 ms Memory: 0.000 MB / 9.84 MB Application: beforeRenderModule mod_cbcontent (CB Content)

Time: 0.17 ms / 123.27 ms Memory: 0.005 MB / 9.84 MB Application: afterRenderModule mod_cbcontent (CB Content)

Time: 0.97 ms / 124.24 ms Memory: 0.000 MB / 9.84 MB Application: beforeRenderModule mod_cbpblatest (Latest activity)

Time: 9.26 ms / 133.50 ms Memory: 0.430 MB / 10.27 MB Application: afterRenderModule mod_cbpblatest (Latest activity)

Time: 26.15 ms / 159.65 ms Memory: 0.735 MB / 11.00 MB Application: afterRender

Database queries total: 32.16 ms

Memory Usage

Database Queries

74 Queries Logged 32.16 ms

4 duplicate found!

2 duplicates: #32 #33

2 duplicates: #39 #61

Query Time: 0.33 ms Query memory: 0.025 MB Memory before query: 1.206 MB Rows returned: 0

SELECT `data`

  FROM `jTodd7_session`

  WHERE `session_id` = 'd4j52srup6g15l19kc5bapn9c7'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jTodd7_session	const	PRIMARY	PRIMARY	194	const	1

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 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.15 ms After last query: 0.33 ms Query memory: 0.022 MB Memory before query: 1.221 MB Rows returned: 0

SELECT `session_id`

  FROM `jTodd7_session`

  WHERE `session_id` = 'd4j52srup6g15l19kc5bapn9c7' 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.01 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
freeing items	0.01 ms
logging slow query	0.00 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: 2.56 ms After last query: 0.11 ms Query memory: 0.004 MB Memory before query: 1.289 MB

INSERT INTO `jTodd7_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('d4j52srup6g15l19kc5bapn9c7', 1, 1579799835, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `jTodd7_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('d4j52srup6g15l19kc5bapn9c7', 1, 1579799835, 0, '', 0)

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.00 ms
init	0.01 ms
update	0.08 ms
Waiting for query cache lock	0.00 ms
update	0.00 ms
end	0.00 ms
query end	2.36 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 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.46 ms After last query: 0.49 ms Query memory: 0.030 MB Memory before query: 1.324 MB Rows returned: 40

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

  FROM `jTodd7_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	jTodd7_extensions	ref	extension	extension	82	const	42	Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.18 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.01 ms
logging slow query	0.00 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.15 ms After last query: 0.53 ms Query memory: 0.023 MB Memory before query: 1.360 MB Rows returned: 5

SELECT id, rules

  FROM `jTodd7_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
logging slow query	0.00 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.21 ms After last query: 0.11 ms Query memory: 0.022 MB Memory before query: 1.372 MB Rows returned: 2

SELECT b.id

  FROM jTodd7_usergroups AS a

  LEFT JOIN jTodd7_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.03 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.04 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
freeing items	0.01 ms
logging slow query	0.00 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: 1.78 ms After last query: 0.25 ms Query memory: 0.044 MB Memory before query: 1.394 MB Rows returned: 132

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

  FROM jTodd7_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	jTodd7_extensions	ref	extension	extension	82	const	222	Using where; Using filesort

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.86 ms
Sending data	0.55 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.01 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.26 ms After last query: 0.78 ms Query memory: 0.025 MB Memory before query: 1.477 MB Rows returned: 3

SELECT *

  FROM jTodd7_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.03 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 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.25 ms After last query: 3.28 ms Query memory: 0.024 MB Memory before query: 1.933 MB Rows returned: 6

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

  FROM `jTodd7_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	jTodd7_extensions	ref	extension	extension	82	const	6	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
logging slow query	0.00 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.63 ms After last query: 3.43 ms Query memory: 0.054 MB Memory before query: 2.011 MB Rows returned: 33

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

  LEFT JOIN jTodd7_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	49	Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	joomla.m.component_id	1

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
Sorting result	0.14 ms
Sending data	0.19 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 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/communitybuilder/communitybuilder.php:300
8	plgSystemCommunityBuilder->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.31 ms After last query: 2.73 ms Query memory: 0.024 MB Memory before query: 2.353 MB Rows returned: 6

SELECT id, home, template, s.params

  FROM jTodd7_template_styles as s

  LEFT JOIN jTodd7_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	8	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	joomla.s.template,const	1	Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.07 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 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/Application/SiteApplication.php:486
10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/gantry5/gantry5.php:195
9	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:57
8	plgSystemGantry5->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.22 ms After last query: 1.32 ms Query memory: 0.032 MB Memory before query: 2.509 MB Rows returned: 1

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

  FROM `jTodd7_extensions`

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

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 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.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
30	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
29	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
28	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
27	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
26	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
25	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
24	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
23	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
22	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
21	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/HTML/HTMLHelper.php:731
20	Joomla\CMS\HTML\HTMLHelper::script()	Same as call in the line below.
19	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
18	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
17	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/jquery.php:52
16	JHtmlJquery::framework()	Same as call in the line below.
15	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
14	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
13	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/jf_sirena/jf/jf_particle_class.php:16
12	include_once JROOT/templates/jf_sirena/jf/jf_particle_class.php	JROOT/templates/jf_sirena/includes/theme.php:31
11	include_once JROOT/templates/jf_sirena/includes/theme.php	JROOT/templates/jf_sirena/includes/gantry.php:40
10	include JROOT/templates/jf_sirena/includes/gantry.php	JROOT/plugins/system/gantry5/gantry5.php:205
9	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:57
8	plgSystemGantry5->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: 2.21 ms After last query: 0.21 ms Query memory: 0.012 MB Memory before query: 2.507 MB

UPDATE `jTodd7_extensions`

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

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

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.00 ms
init	0.05 ms
Updating	0.05 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.01 ms
query end	1.98 ms
closing tables	0.02 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
25	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
24	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
23	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
22	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
21	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/HTML/HTMLHelper.php:731
20	Joomla\CMS\HTML\HTMLHelper::script()	Same as call in the line below.
19	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
18	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
17	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/jquery.php:52
16	JHtmlJquery::framework()	Same as call in the line below.
15	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
14	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
13	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/jf_sirena/jf/jf_particle_class.php:16
12	include_once JROOT/templates/jf_sirena/jf/jf_particle_class.php	JROOT/templates/jf_sirena/includes/theme.php:31
11	include_once JROOT/templates/jf_sirena/includes/theme.php	JROOT/templates/jf_sirena/includes/gantry.php:40
10	include JROOT/templates/jf_sirena/includes/gantry.php	JROOT/plugins/system/gantry5/gantry5.php:205
9	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:57
8	plgSystemGantry5->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: 2.59 ms Query memory: 0.026 MB Memory before query: 2.754 MB Rows returned: 4

SELECT s.id, s.template, s.home, s.title AS long_title, s.params

  FROM jTodd7_template_styles AS s

  WHERE s.client_id = 0 
  AND s.template = 'jf_sirena'

  ORDER BY s.id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	index	idx_template	PRIMARY	4	NULL	8	Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry5/classes/Gantry/Joomla/StyleHelper.php:46
14	Gantry\Joomla\StyleHelper::loadStyles()	JROOT/libraries/gantry5/classes/Gantry/Framework/Assignments.php:50
13	Gantry\Framework\Assignments->loadAssignments()	JROOT/libraries/gantry5/classes/Gantry/Component/Assignments/AbstractAssignments.php:303
12	Gantry\Component\Assignments\AbstractAssignments->init()	JROOT/libraries/gantry5/classes/Gantry/Component/Assignments/AbstractAssignments.php:104
11	Gantry\Component\Assignments\AbstractAssignments->scores()	JROOT/libraries/gantry5/classes/Gantry/Component/Assignments/AbstractAssignments.php:91
10	Gantry\Component\Assignments\AbstractAssignments->select()	JROOT/plugins/system/gantry5/gantry5.php:246
9	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:57
8	plgSystemGantry5->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.18 ms After last query: 2.36 ms Query memory: 0.028 MB Memory before query: 3.170 MB Rows returned: 1

SELECT `params`
 
  FROM `jTodd7_comprofiler_plugin`
 
  WHERE `id` = 1

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
23	JDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:345
22	CBLib\Database\Driver\CmsDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CB/Application/CBConfig.php:43
21	CB\Application\CBConfig::getConfig()	JROOT/libraries/CBLib/CB/Application/CBApplication.php:45
20	CB\Application\CBApplication::CB\Application\{closure}()	Same as call in the line below.
19	call_user_func_array()	JROOT/libraries/CBLib/CBLib/Application/Config.php:38
18	CBLib\Application\Config::setMainConfig()	JROOT/libraries/CBLib/CBLib/Core/CBLib.php:70
17	CBLib\Core\CBLib::CBLib\Core\{closure}()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:605
16	CBLib\DependencyInjection\Container->build()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:496
15	CBLib\DependencyInjection\Container->make()	JROOT/libraries/CBLib/CBLib/Application/Application.php:179
14	CBLib\Application\Application::__callStatic()	JROOT/libraries/CBLib/CB/Application/CBConfig.php:77
13	CB\Application\CBConfig::loadLegacyCBueConfig()	JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:109
12	CB\Legacy\LegacyFoundationFunctions->__construct()	Same as call in the line below.
11	ReflectionClass->newInstanceArgs()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:643
10	CBLib\DependencyInjection\Container->build()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:496
9	CBLib\DependencyInjection\Container->make()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:132
8	CBLib\DependencyInjection\Container->get()	JROOT/administrator/components/com_comprofiler/plugin.foundation.php:33
7	include_once JROOT/administrator/components/com_comprofiler/plugin.foundation.php	JROOT/components/com_comprofiler/comprofiler.php:60
6	require_once JROOT/components/com_comprofiler/comprofiler.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.44 ms After last query: 1.66 ms Query memory: 0.036 MB Memory before query: 3.341 MB Rows returned: 18

SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup
 
  FROM `jTodd7_comprofiler_plugin`
 
  WHERE `published` = 1
 
  AND `viewaccesslevel` IN (1,5)
 
  AND `type` = 'user'
 
  ORDER BY `ordering`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jTodd7_comprofiler_plugin	ref	idx_folder,type_pub_order	type_pub_order	304	const,const	18	Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.00 ms
Sending data	0.13 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
11	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:394
10	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:446
9	CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:181
8	cbPluginHandler->loadPluginGroup()	JROOT/components/com_comprofiler/comprofiler.php:924
7	registerForm()	JROOT/components/com_comprofiler/comprofiler.php:127
6	require_once JROOT/components/com_comprofiler/comprofiler.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.41 ms After last query: 3.39 ms Query memory: 0.052 MB Memory before query: 4.359 MB Rows returned: 31

SELECT *
 
  FROM `jTodd7_comprofiler_plugin_autoactions`
 
  WHERE `trigger` != ''
 
  AND `published` = 1
 
  ORDER BY `ordering` ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jTodd7_comprofiler_plugin_autoactions	ref	published	published	4	const	31	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.00 ms
Sending data	0.17 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
38	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
37	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:394
36	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:446
35	CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList()	JROOT/components/com_comprofiler/plugin/user/plug_cbautoactions/cbautoactions.php:194
34	require_once JROOT/components/com_comprofiler/plugin/user/plug_cbautoactions/cbautoactions.php	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:402
33	cbPluginHandler->_loadPluginFile()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:238
32	cbPluginHandler->loadPluginGroup()	JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/cbactivity.php:23
31	require_once JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/cbactivity.php	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:402
30	cbPluginHandler->_loadPluginFile()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:238
29	cbPluginHandler->loadPluginGroup()	JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.php:22
28	require_once JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.php	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:402
27	cbPluginHandler->_loadPluginFile()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:238
26	cbPluginHandler->loadPluginGroup()	JROOT/components/com_comprofiler/plugin/user/plug_cbinvites/cbinvites.php:24
25	require_once JROOT/components/com_comprofiler/plugin/user/plug_cbinvites/cbinvites.php	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:402
24	cbPluginHandler->_loadPluginFile()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:238
23	cbPluginHandler->loadPluginGroup()	JROOT/components/com_comprofiler/plugin/user/plug_cbprivacy/cbprivacy.php:14
22	require_once JROOT/components/com_comprofiler/plugin/user/plug_cbprivacy/cbprivacy.php	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:402
21	cbPluginHandler->_loadPluginFile()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:238
20	cbPluginHandler->loadPluginGroup()	JROOT/components/com_comprofiler/plugin/user/plug_cbprofileupdatelogger/cb.pulog.php:23
19	require_once JROOT/components/com_comprofiler/plugin/user/plug_cbprofileupdatelogger/cb.pulog.php	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:402
18	cbPluginHandler->_loadPluginFile()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:238
17	cbPluginHandler->loadPluginGroup()	JROOT/components/com_comprofiler/plugin/user/plug_cbblogs/cbblogs.php:22
16	require_once JROOT/components/com_comprofiler/plugin/user/plug_cbblogs/cbblogs.php	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:402
15	cbPluginHandler->_loadPluginFile()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:238
14	cbPluginHandler->loadPluginGroup()	JROOT/components/com_comprofiler/plugin/user/plug_cbforums/cbforums.php:20
13	require_once JROOT/components/com_comprofiler/plugin/user/plug_cbforums/cbforums.php	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:402
12	cbPluginHandler->_loadPluginFile()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:238
11	cbPluginHandler->loadPluginGroup()	JROOT/components/com_comprofiler/plugin/user/plug_cbarticles/cbarticles.php:22
10	require_once JROOT/components/com_comprofiler/plugin/user/plug_cbarticles/cbarticles.php	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:402
9	cbPluginHandler->_loadPluginFile()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:238
8	cbPluginHandler->loadPluginGroup()	JROOT/components/com_comprofiler/comprofiler.php:924
7	registerForm()	JROOT/components/com_comprofiler/comprofiler.php:127
6	require_once JROOT/components/com_comprofiler/comprofiler.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.35 ms After last query: 4.34 ms Query memory: 0.041 MB Memory before query: 4.772 MB Rows returned: 7

SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup
 
  FROM `jTodd7_comprofiler_plugin`
 
  WHERE `published` = 1
 
  AND `viewaccesslevel` IN (1,5)
 
  AND `type` = 'user/plug_cbgroupjive/plugins'
 
  ORDER BY `ordering`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jTodd7_comprofiler_plugin	ref	idx_folder,type_pub_order	type_pub_order	304	const,const	7	Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.00 ms
Sending data	0.07 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
32	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:394
31	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:446
30	CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:181
29	cbPluginHandler->loadPluginGroup()	JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.php:23
28	require_once JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.php	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:402
27	cbPluginHandler->_loadPluginFile()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:238
26	cbPluginHandler->loadPluginGroup()	JROOT/components/com_comprofiler/plugin/user/plug_cbinvites/cbinvites.php:24
25	require_once JROOT/components/com_comprofiler/plugin/user/plug_cbinvites/cbinvites.php	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:402
24	cbPluginHandler->_loadPluginFile()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:238
23	cbPluginHandler->loadPluginGroup()	JROOT/components/com_comprofiler/plugin/user/plug_cbprivacy/cbprivacy.php:14
22	require_once JROOT/components/com_comprofiler/plugin/user/plug_cbprivacy/cbprivacy.php	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:402
21	cbPluginHandler->_loadPluginFile()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:238
20	cbPluginHandler->loadPluginGroup()	JROOT/components/com_comprofiler/plugin/user/plug_cbprofileupdatelogger/cb.pulog.php:23
19	require_once JROOT/components/com_comprofiler/plugin/user/plug_cbprofileupdatelogger/cb.pulog.php	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:402
18	cbPluginHandler->_loadPluginFile()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:238
17	cbPluginHandler->loadPluginGroup()	JROOT/components/com_comprofiler/plugin/user/plug_cbblogs/cbblogs.php:22
16	require_once JROOT/components/com_comprofiler/plugin/user/plug_cbblogs/cbblogs.php	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:402
15	cbPluginHandler->_loadPluginFile()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:238
14	cbPluginHandler->loadPluginGroup()	JROOT/components/com_comprofiler/plugin/user/plug_cbforums/cbforums.php:20
13	require_once JROOT/components/com_comprofiler/plugin/user/plug_cbforums/cbforums.php	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:402
12	cbPluginHandler->_loadPluginFile()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:238
11	cbPluginHandler->loadPluginGroup()	JROOT/components/com_comprofiler/plugin/user/plug_cbarticles/cbarticles.php:22
10	require_once JROOT/components/com_comprofiler/plugin/user/plug_cbarticles/cbarticles.php	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:402
9	cbPluginHandler->_loadPluginFile()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:238
8	cbPluginHandler->loadPluginGroup()	JROOT/components/com_comprofiler/comprofiler.php:924
7	registerForm()	JROOT/components/com_comprofiler/comprofiler.php:127
6	require_once JROOT/components/com_comprofiler/comprofiler.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.70 ms After last query: 2.13 ms Query memory: 0.031 MB Memory before query: 4.890 MB Rows returned: 16

SHOW FULL COLUMNS 
  FROM `jTodd7_users`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `jTodd7_users`

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.24 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.02 ms
Opening tables	0.02 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.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.01 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.05 ms
closing tables	0.00 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
15	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
14	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
13	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:40
12	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:312
11	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
10	Joomla\CMS\User\User::getTable()	JROOT/libraries/CBLib/CB/Database/Table/UserTable.php:180
9	CB\Database\Table\UserTable->_reinitNonComprofileVars()	JROOT/libraries/CBLib/CB/Database/Table/UserTable.php:120
8	CB\Database\Table\UserTable->__construct()	JROOT/components/com_comprofiler/comprofiler.php:951
7	registerForm()	JROOT/components/com_comprofiler/comprofiler.php:127
6	require_once JROOT/components/com_comprofiler/comprofiler.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.29 ms After last query: 2.55 ms Query memory: 0.028 MB Memory before query: 5.004 MB Rows returned: 1

SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup
 
  FROM `jTodd7_comprofiler_plugin`
 
  WHERE `published` = 1
 
  AND `viewaccesslevel` IN (1,5)
 
  AND `type` = 'templates'
 
  ORDER BY `ordering`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jTodd7_comprofiler_plugin	ref	idx_folder,type_pub_order	type_pub_order	304	const,const	1	Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
13	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:394
12	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:446
11	CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:181
10	cbPluginHandler->loadPluginGroup()	JROOT/components/com_comprofiler/comprofiler.html.php:329
9	HTML_comprofiler::_cbTemplateLoad()	JROOT/components/com_comprofiler/comprofiler.html.php:929
8	HTML_comprofiler::registerForm()	JROOT/components/com_comprofiler/comprofiler.php:958
7	registerForm()	JROOT/components/com_comprofiler/comprofiler.php:127
6	require_once JROOT/components/com_comprofiler/comprofiler.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.47 ms After last query: 1.06 ms Query memory: 0.037 MB Memory before query: 5.061 MB Rows returned: 20

SELECT * 
  FROM jTodd7_comprofiler_tabs t
 
  WHERE t.enabled = 1
 
  ORDER BY t.ordering_register, t.position, t.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	enabled_position_ordering,orderedit_enabled_pos_order,orderreg_enabled_pos_order	NO INDEX KEY COULD BE USED	NULL	NULL	22	Using where; Using filesort

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.08 ms
Sending data	0.16 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
13	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:394
12	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:446
11	CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:841
10	cbTabs->_getTabsDb()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:702
9	cbTabs->getEditTabs()	JROOT/components/com_comprofiler/comprofiler.html.php:948
8	HTML_comprofiler::registerForm()	JROOT/components/com_comprofiler/comprofiler.php:958
7	registerForm()	JROOT/components/com_comprofiler/comprofiler.php:127
6	require_once JROOT/components/com_comprofiler/comprofiler.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.70 ms After last query: 0.33 ms Query memory: 0.035 MB Memory before query: 5.090 MB Rows returned: 9

SELECT f.* 
  FROM jTodd7_comprofiler_fields f
 
  INNER JOIN jTodd7_comprofiler_tabs AS t 
  ON (f.tabid = t.tabid)
 
  WHERE f.published = 1 
  AND f.registration > 0 
  AND t.enabled = 1
 
  ORDER BY t.ordering_register, t.position, t.ordering, f.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	f	ALL	tabid_pub_prof_order,registration_published_order	NO INDEX KEY COULD BE USED	NULL	NULL	56	Using where; Using temporary; Using filesort
1	SIMPLE	t	eq_ref	PRIMARY,enabled_position_ordering,orderedit_enabled_pos_order,orderreg_enabled_pos_order	PRIMARY	4	joomla.f.tabid	1	Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
Creating tmp table	0.17 ms
executing	0.00 ms
Copying to tmp table	0.13 ms
Sorting result	0.05 ms
Sending data	0.04 ms
end	0.00 ms
removing tmp table	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
13	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:394
12	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:446
11	CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:953
10	cbTabs->_getTabFieldsDb()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:708
9	cbTabs->getEditTabs()	JROOT/components/com_comprofiler/comprofiler.html.php:948
8	HTML_comprofiler::registerForm()	JROOT/components/com_comprofiler/comprofiler.php:958
7	registerForm()	JROOT/components/com_comprofiler/comprofiler.php:127
6	require_once JROOT/components/com_comprofiler/comprofiler.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.70 ms After last query: 0.47 ms Query memory: 0.033 MB Memory before query: 5.132 MB Rows returned: 40

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

  FROM `jTodd7_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_comprofiler','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djimageslider','com_fields','com_finder','com_gantry5','com_hikashop','com_installer','com_joomlaupdate','com_kunena','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_wrapper')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jTodd7_assets	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	196	Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.07 ms
optimizing	0.01 ms
statistics	0.11 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.35 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
23	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
22	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
21	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
20	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
19	Joomla\CMS\User\User->authorise()	JROOT/libraries/CBLib/CBLib/Cms/Joomla/Joomla3/CmsUser.php:291
18	CBLib\Cms\Joomla\Joomla3\CmsUser->isAuthorizedToPerformActionOnAsset()	JROOT/libraries/CBLib/CBLib/Entity/User/User.php:216
17	CBLib\Entity\User\User->isAuthorizedToPerformActionOnAsset()	JROOT/libraries/CBLib/CBLib/Entity/User/User.php:277
16	CBLib\Entity\User\User->isSuperAdmin()	JROOT/libraries/CBLib/CBLib/Entity/User/User.php:233
15	CBLib\Entity\User\User->canViewAccessLevel()	JROOT/libraries/CBLib/CBLib/Entity/User/User.php:308
14	CBLib\Entity\User\User->isGlobalModerator()	JROOT/components/com_comprofiler/plugin/libraries/CB/Plugin/Privacy/Trigger/FieldTrigger.php:70
13	CB\Plugin\Privacy\Trigger\FieldTrigger->fieldsFetch()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:885
12	cbPluginHandler->call()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:1298
11	cbPluginHandler->trigger()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1000
10	cbTabs->_getTabFieldsDb()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:708
9	cbTabs->getEditTabs()	JROOT/components/com_comprofiler/comprofiler.html.php:948
8	HTML_comprofiler::registerForm()	JROOT/components/com_comprofiler/comprofiler.php:958
7	registerForm()	JROOT/components/com_comprofiler/comprofiler.php:127
6	require_once JROOT/components/com_comprofiler/comprofiler.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.37 ms After last query: 5.33 ms Query memory: 0.023 MB Memory before query: 5.477 MB Rows returned: 1

SELECT `params`
 
  FROM `jTodd7_modules`
 
  WHERE `module` = 'mod_cblogin'
 
  AND `published` = 1
 
  AND `access` IN  (1, 5) 
 
  AND `language` IN ( 'en-GB', '*', '' )
 
  ORDER BY `position`, `ordering` 
  LIMIT 0, 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jTodd7_modules	ref	published,newsfeeds,idx_language	newsfeeds	204	const,const	1	Using where; Using filesort

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.06 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
11	JDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:345
10	CBLib\Database\Driver\CmsDatabaseDriver->loadResult()	JROOT/components/com_comprofiler/comprofiler.php:2300
9	checkCBPostIsHTTPS()	JROOT/components/com_comprofiler/comprofiler.html.php:997
8	HTML_comprofiler::registerForm()	JROOT/components/com_comprofiler/comprofiler.php:958
7	registerForm()	JROOT/components/com_comprofiler/comprofiler.php:127
6	require_once JROOT/components/com_comprofiler/comprofiler.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.41 ms After last query: 0.20 ms Query memory: 0.023 MB Memory before query: 5.486 MB Rows returned: 0

SELECT `id`
 
  FROM `jTodd7_menu`
 
  WHERE ( `link` LIKE 'index.php?option=com_comprofiler&view=saveregisters%' OR `link` LIKE 'index.php?option=com_comprofiler&task=saveregisters%' )
 
  AND `published` = 1
 
  AND `access` IN ( 1,5 )
 
  AND `language` IN ( 'en-GB', '*', '' )
 
  AND `client_id` = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jTodd7_menu	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	50	Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.18 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
12	JDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:345
11	CBLib\Database\Driver\CmsDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:222
10	getCBprofileItemid()	JROOT/libraries/CBLib/CB/Legacy/CBframework.php:967
9	CBframework->viewUrl()	JROOT/components/com_comprofiler/comprofiler.html.php:997
8	HTML_comprofiler::registerForm()	JROOT/components/com_comprofiler/comprofiler.php:958
7	registerForm()	JROOT/components/com_comprofiler/comprofiler.php:127
6	require_once JROOT/components/com_comprofiler/comprofiler.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.35 ms After last query: 0.12 ms Query memory: 0.024 MB Memory before query: 5.493 MB Rows returned: 2

SELECT `id`
 
  FROM `jTodd7_menu`
 
  WHERE ( `link` = 'index.php?option=com_comprofiler&view=userprofile' OR `link` = 'index.php?option=com_comprofiler&task=userprofile' OR `link` = 'index.php?option=com_comprofiler' )
 
  AND `published` = 1
 
  AND `access` IN ( 1,5 )
 
  AND `language` IN ( 'en-GB', '*', '' )
 
  AND `client_id` = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jTodd7_menu	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	50	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.00 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.14 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
12	JDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:345
11	CBLib\Database\Driver\CmsDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:242
10	getCBprofileItemid()	JROOT/libraries/CBLib/CB/Legacy/CBframework.php:967
9	CBframework->viewUrl()	JROOT/components/com_comprofiler/comprofiler.html.php:997
8	HTML_comprofiler::registerForm()	JROOT/components/com_comprofiler/comprofiler.php:958
7	registerForm()	JROOT/components/com_comprofiler/comprofiler.php:127
6	require_once JROOT/components/com_comprofiler/comprofiler.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.24 ms After last query: 1.29 ms Query memory: 0.022 MB Memory before query: 5.490 MB Rows returned: 4

SELECT language,id

  FROM `jTodd7_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	jTodd7_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	50	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.07 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
logging slow query	0.00 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.24 ms After last query: 0.45 ms Query memory: 0.023 MB Memory before query: 5.504 MB Rows returned: 0

SELECT `c2`.`language`,`c2`.`id`

  FROM `jTodd7_menu` AS `c`

  INNER JOIN `jTodd7_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item'

  INNER JOIN `jTodd7_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key`

  INNER JOIN `jTodd7_menu` AS `c2` 
  ON a2.id = c2.`id`

  WHERE c.id = 116

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.05 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
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 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.92 ms After last query: 13.63 ms Query memory: 0.051 MB Memory before query: 6.859 MB Rows returned: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM jTodd7_fields AS a

  LEFT JOIN `jTodd7_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN jTodd7_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN jTodd7_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN jTodd7_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN jTodd7_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'mod_custom.content' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Using filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	joomla.a.language	1
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	joomla.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	joomla.a.access	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	joomla.a.created_user_id	1
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	joomla.a.group_id	1	Using where

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
Opening tables	0.03 ms
System lock	0.02 ms
init	0.05 ms
optimizing	0.02 ms
statistics	0.14 ms
preparing	0.03 ms
Creating tmp table	0.26 ms
executing	0.00 ms
Copying to tmp table	0.03 ms
Sorting result	0.02 ms
Sending data	0.02 ms
end	0.00 ms
removing tmp table	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
56	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
55	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
54	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
53	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
52	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
51	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:488
50	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
49	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
48	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
47	JHtmlContent::prepare()	Same as call in the line below.
46	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
45	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
44	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:161
43	Gantry\Framework\Platform->filter()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:675
42	Twig_Template->getAttribute()	JROOT/cache/gantry5/jf_sirena/twig/b7/b7ca1f2a987737facadf95ee783ba9c831080536a40c9b93b939c1348e2ce68b.php:35
41	__TwigTemplate_f0691f0865b306c634f6027bc151c25264ba43ac7a61e3fbd5d31086a6b5ef27->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215
40	Twig_Template->displayBlock()	JROOT/cache/gantry5/jf_sirena/twig/9c/9c5b462d5ee0e2b82ff6a779b632d430743d87bbb7033f09eff3e11a92c6ff1c.php:62
39	__TwigTemplate_b0f548c500e532ba1fda164a0c0a2eaf89d5783ac1dbfaeb32105e4aaedef21b->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
38	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
37	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/b7/b7ca1f2a987737facadf95ee783ba9c831080536a40c9b93b939c1348e2ce68b.php:24
36	__TwigTemplate_f0691f0865b306c634f6027bc151c25264ba43ac7a61e3fbd5d31086a6b5ef27->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
34	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/9c/9cbd2b452d3d580a1e9506f68e6831e561a01948504b3a47cd69f4a22b616e2c.php:60
33	__TwigTemplate_c16b9457a1bdbfa609326a1d14218e93a74b5cbc3fd7d45bcf20b915fb14c9dc->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766
27	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
26	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
22	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
21	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:673
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/jf_sirena/twig/bb/bbb39e4eaa34caaa7d11829d625dc8e04b419b197d84c841996f966ddee3ae90.php:36
19	__TwigTemplate_bc34790340fb12f47cf42cf0c13b2adc8a78982ad2918899582ad76c95e1a6af->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
17	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/e4/e4c81d8901b6ce50e08f7f0aa035a72f6c05938e39806b4130b879583e410bbc.php:24
16	__TwigTemplate_22dc06cce989244fb8d3f5fcf813569067a187e115969bbda614a61d61bc90d9->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
14	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/20/20e7a7c67372d5209373149e79614021a466682b9a8e1634daadc4d12dcafcdd.php:24
13	__TwigTemplate_74b153afd6133d347f63d3d8674c7f1afb660a9692be2782a015f45aa9be032e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/jf_sirena/index.php:23
7	require JROOT/templates/jf_sirena/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.]

Query Time: 0.16 ms After last query: 1.22 ms Query memory: 0.036 MB Memory before query: 6.978 MB Rows returned: 6

SELECT a.menutype

  FROM jTodd7_menu_types AS a

  WHERE a.client_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	6	Using where

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	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
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
42	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
41	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_menus/helpers/menus.php:154
40	MenusHelper::getMenuTypes()	JROOT/libraries/gantry5/classes/Gantry/Framework/Menu.php:71
39	Gantry\Framework\Menu->getMenus()	JROOT/libraries/gantry5/classes/Gantry/Component/Menu/AbstractMenu.php:115
38	Gantry\Component\Menu\AbstractMenu->instance()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:675
37	Twig_Template->getAttribute()	JROOT/cache/gantry5/jf_sirena/twig/03/03555e3483a49d51d89944831cfe09e63c396f5b1a387bdb0cd95e51ec6175ad.php:20
36	__TwigTemplate_145b2b43ed1ad45db7ef9ad9d300565921f4c31239a228f0a41b5c871ca4e5a8->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
34	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/9c/9cbd2b452d3d580a1e9506f68e6831e561a01948504b3a47cd69f4a22b616e2c.php:60
33	__TwigTemplate_c16b9457a1bdbfa609326a1d14218e93a74b5cbc3fd7d45bcf20b915fb14c9dc->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766
27	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
26	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
22	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
21	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:673
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/jf_sirena/twig/bb/bbb39e4eaa34caaa7d11829d625dc8e04b419b197d84c841996f966ddee3ae90.php:36
19	__TwigTemplate_bc34790340fb12f47cf42cf0c13b2adc8a78982ad2918899582ad76c95e1a6af->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
17	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/e4/e4c81d8901b6ce50e08f7f0aa035a72f6c05938e39806b4130b879583e410bbc.php:24
16	__TwigTemplate_22dc06cce989244fb8d3f5fcf813569067a187e115969bbda614a61d61bc90d9->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
14	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/20/20e7a7c67372d5209373149e79614021a466682b9a8e1634daadc4d12dcafcdd.php:24
13	__TwigTemplate_74b153afd6133d347f63d3d8674c7f1afb660a9692be2782a015f45aa9be032e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/jf_sirena/index.php:23
7	require JROOT/templates/jf_sirena/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.]

Query Time: 0.49 ms After last query: 5.45 ms Query memory: 0.065 MB Memory before query: 7.777 MB Rows returned: 282

SELECT * 
  FROM jTodd7_hikashop_config

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.27 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
53	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
52	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/config.php:16
51	hikashopConfigClass->load()	JROOT/administrator/components/com_hikashop/helpers/helper.php:970
50	hikashop_config()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2677
49	include_once JROOT/administrator/components/com_hikashop/helpers/helper.php	JROOT/components/com_hikashop/router.php:33
48	_HikashopBuildRoute()	JROOT/components/com_hikashop/router.php:26
47	HikashopBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
46	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
45	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
44	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
43	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
42	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:131
41	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:80
40	Joomla\CMS\Router\Route::_()	JROOT/libraries/gantry5/classes/Gantry/Framework/Menu.php:377
39	Gantry\Framework\Menu->getList()	JROOT/libraries/gantry5/classes/Gantry/Component/Menu/AbstractMenu.php:154
38	Gantry\Component\Menu\AbstractMenu->instance()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:675
37	Twig_Template->getAttribute()	JROOT/cache/gantry5/jf_sirena/twig/03/03555e3483a49d51d89944831cfe09e63c396f5b1a387bdb0cd95e51ec6175ad.php:20
36	__TwigTemplate_145b2b43ed1ad45db7ef9ad9d300565921f4c31239a228f0a41b5c871ca4e5a8->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
34	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/9c/9cbd2b452d3d580a1e9506f68e6831e561a01948504b3a47cd69f4a22b616e2c.php:60
33	__TwigTemplate_c16b9457a1bdbfa609326a1d14218e93a74b5cbc3fd7d45bcf20b915fb14c9dc->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766
27	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
26	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
22	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
21	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:673
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/jf_sirena/twig/bb/bbb39e4eaa34caaa7d11829d625dc8e04b419b197d84c841996f966ddee3ae90.php:36
19	__TwigTemplate_bc34790340fb12f47cf42cf0c13b2adc8a78982ad2918899582ad76c95e1a6af->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
17	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/e4/e4c81d8901b6ce50e08f7f0aa035a72f6c05938e39806b4130b879583e410bbc.php:24
16	__TwigTemplate_22dc06cce989244fb8d3f5fcf813569067a187e115969bbda614a61d61bc90d9->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
14	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/20/20e7a7c67372d5209373149e79614021a466682b9a8e1634daadc4d12dcafcdd.php:24
13	__TwigTemplate_74b153afd6133d347f63d3d8674c7f1afb660a9692be2782a015f45aa9be032e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/jf_sirena/index.php:23
7	require JROOT/templates/jf_sirena/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.]

Query Time: 1.16 ms After last query: 2.66 ms Query memory: 0.110 MB Memory before query: 8.084 MB Rows returned: 28

Duplicate queries: #33

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

  FROM jTodd7_modules AS m

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

  LEFT JOIN jTodd7_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 <= '2020-01-23 17:17:15') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-01-23 17:17:15') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 116 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	46	Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	joomla.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	joomla.m.module,const	1	Using where

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.00 ms
Sorting result	0.29 ms
Sending data	0.49 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
50	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
49	JDatabaseDriver->loadObjectList()	Same as call in the line below.
48	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
47	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
46	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
45	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
44	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:233
43	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:675
42	Twig_Template->getAttribute()	JROOT/cache/gantry5/jf_sirena/twig/cd/cdee8e0755a16e360ddb1e15078b6fc95207fcc2af1e4aecfc70c2df831e4152.php:32
41	__TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215
40	Twig_Template->displayBlock()	JROOT/cache/gantry5/jf_sirena/twig/9c/9c5b462d5ee0e2b82ff6a779b632d430743d87bbb7033f09eff3e11a92c6ff1c.php:62
39	__TwigTemplate_b0f548c500e532ba1fda164a0c0a2eaf89d5783ac1dbfaeb32105e4aaedef21b->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
38	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
37	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/cd/cdee8e0755a16e360ddb1e15078b6fc95207fcc2af1e4aecfc70c2df831e4152.php:24
36	__TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
34	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/b6/b69079ac547c4f2142950c448c66a1d7453d2d0cb8174c9a2937b29bb21db10d.php:42
33	__TwigTemplate_24d13b45559483d220f13be7b946cda7f2e614d78ce82344c17a7f904122f38a->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766
27	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
26	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
22	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
21	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:673
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/jf_sirena/twig/bb/bbb39e4eaa34caaa7d11829d625dc8e04b419b197d84c841996f966ddee3ae90.php:36
19	__TwigTemplate_bc34790340fb12f47cf42cf0c13b2adc8a78982ad2918899582ad76c95e1a6af->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
17	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/e4/e4c81d8901b6ce50e08f7f0aa035a72f6c05938e39806b4130b879583e410bbc.php:24
16	__TwigTemplate_22dc06cce989244fb8d3f5fcf813569067a187e115969bbda614a61d61bc90d9->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
14	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/20/20e7a7c67372d5209373149e79614021a466682b9a8e1634daadc4d12dcafcdd.php:24
13	__TwigTemplate_74b153afd6133d347f63d3d8674c7f1afb660a9692be2782a015f45aa9be032e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/jf_sirena/index.php:23
7	require JROOT/templates/jf_sirena/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.]

Query Time: 0.98 ms After last query: 0.65 ms Query memory: 0.084 MB Memory before query: 8.225 MB Rows returned: 28

Duplicate queries: #32

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

  FROM jTodd7_modules AS m

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

  LEFT JOIN jTodd7_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 <= '2020-01-23 17:17:15') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-01-23 17:17:15') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 116 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	46	Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	joomla.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	joomla.m.module,const	1	Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.00 ms
Sorting result	0.24 ms
Sending data	0.38 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
50	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
49	JDatabaseDriver->loadObjectList()	Same as call in the line below.
48	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
47	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
46	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:276
45	Gantry\Framework\Platform->getModuleList()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:269
44	Gantry\Framework\Platform->getModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:183
43	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:675
42	Twig_Template->getAttribute()	JROOT/cache/gantry5/jf_sirena/twig/6f/6fe03ec6d6ad500d7fc4a24cdcf0e4061b6f43980ba7a17c01cf932b18a9c96b.php:32
41	__TwigTemplate_f3feb6f59057cb6f0fefae2d07294835121a7f90df2bbd27de32a25de1941299->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215
40	Twig_Template->displayBlock()	JROOT/cache/gantry5/jf_sirena/twig/9c/9c5b462d5ee0e2b82ff6a779b632d430743d87bbb7033f09eff3e11a92c6ff1c.php:62
39	__TwigTemplate_b0f548c500e532ba1fda164a0c0a2eaf89d5783ac1dbfaeb32105e4aaedef21b->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
38	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
37	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/6f/6fe03ec6d6ad500d7fc4a24cdcf0e4061b6f43980ba7a17c01cf932b18a9c96b.php:24
36	__TwigTemplate_f3feb6f59057cb6f0fefae2d07294835121a7f90df2bbd27de32a25de1941299->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
34	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/b6/b69079ac547c4f2142950c448c66a1d7453d2d0cb8174c9a2937b29bb21db10d.php:42
33	__TwigTemplate_24d13b45559483d220f13be7b946cda7f2e614d78ce82344c17a7f904122f38a->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766
27	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
26	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
22	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
21	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:673
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/jf_sirena/twig/bb/bbb39e4eaa34caaa7d11829d625dc8e04b419b197d84c841996f966ddee3ae90.php:36
19	__TwigTemplate_bc34790340fb12f47cf42cf0c13b2adc8a78982ad2918899582ad76c95e1a6af->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
17	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/e4/e4c81d8901b6ce50e08f7f0aa035a72f6c05938e39806b4130b879583e410bbc.php:24
16	__TwigTemplate_22dc06cce989244fb8d3f5fcf813569067a187e115969bbda614a61d61bc90d9->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
14	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/20/20e7a7c67372d5209373149e79614021a466682b9a8e1634daadc4d12dcafcdd.php:24
13	__TwigTemplate_74b153afd6133d347f63d3d8674c7f1afb660a9692be2782a015f45aa9be032e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/jf_sirena/index.php:23
7	require JROOT/templates/jf_sirena/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.]

Query Time: 0.33 ms After last query: 4.24 ms Query memory: 0.039 MB Memory before query: 8.425 MB Rows returned: 1

SELECT COUNT( a.`id` )
 
  FROM `jTodd7_comprofiler_plugin_gallery_folders` AS a
 
  LEFT JOIN `jTodd7_comprofiler` AS cb 
  ON cb.`id` = a.`user_id`
 
  LEFT JOIN `jTodd7_users` AS j 
  ON j.`id` = cb.`id`
 
  WHERE cb.`approved` = 1
 
  AND cb.`confirmed` = 1
 
  AND j.`block` = 0
 
  AND a.`asset` IN  ('profile.0', 'profile.0.uploads')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	asset_published_date	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
1	SIMPLE	j	eq_ref	PRIMARY,idx_block	PRIMARY	4	joomla.a.user_id	1	Using where
1	SIMPLE	cb	eq_ref	PRIMARY,apprconfbanid	PRIMARY	4	joomla.a.user_id	1	Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.06 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.01 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
51	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
50	JDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:345
49	CBLib\Database\Driver\CmsDatabaseDriver->loadResult()	JROOT/components/com_comprofiler/plugin/libraries/CB/Plugin/Gallery/Gallery.php:916
48	CB\Plugin\Gallery\Gallery->folders()	JROOT/modules/mod_cbgallery/mod_cbgallery.php:67
47	include JROOT/modules/mod_cbgallery/mod_cbgallery.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
46	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
45	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
44	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
43	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:675
42	Twig_Template->getAttribute()	JROOT/cache/gantry5/jf_sirena/twig/cd/cdee8e0755a16e360ddb1e15078b6fc95207fcc2af1e4aecfc70c2df831e4152.php:32
41	__TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215
40	Twig_Template->displayBlock()	JROOT/cache/gantry5/jf_sirena/twig/9c/9c5b462d5ee0e2b82ff6a779b632d430743d87bbb7033f09eff3e11a92c6ff1c.php:62
39	__TwigTemplate_b0f548c500e532ba1fda164a0c0a2eaf89d5783ac1dbfaeb32105e4aaedef21b->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
38	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
37	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/cd/cdee8e0755a16e360ddb1e15078b6fc95207fcc2af1e4aecfc70c2df831e4152.php:24
36	__TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
34	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/b6/b69079ac547c4f2142950c448c66a1d7453d2d0cb8174c9a2937b29bb21db10d.php:42
33	__TwigTemplate_24d13b45559483d220f13be7b946cda7f2e614d78ce82344c17a7f904122f38a->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766
27	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
26	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
22	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
21	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:673
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/jf_sirena/twig/bb/bbb39e4eaa34caaa7d11829d625dc8e04b419b197d84c841996f966ddee3ae90.php:36
19	__TwigTemplate_bc34790340fb12f47cf42cf0c13b2adc8a78982ad2918899582ad76c95e1a6af->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
17	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/e4/e4c81d8901b6ce50e08f7f0aa035a72f6c05938e39806b4130b879583e410bbc.php:24
16	__TwigTemplate_22dc06cce989244fb8d3f5fcf813569067a187e115969bbda614a61d61bc90d9->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
14	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/20/20e7a7c67372d5209373149e79614021a466682b9a8e1634daadc4d12dcafcdd.php:24
13	__TwigTemplate_74b153afd6133d347f63d3d8674c7f1afb660a9692be2782a015f45aa9be032e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/jf_sirena/index.php:23
7	require JROOT/templates/jf_sirena/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.]

Query Time: 0.27 ms After last query: 0.14 ms Query memory: 0.039 MB Memory before query: 8.448 MB Rows returned: 1

SELECT COUNT( a.`id` )
 
  FROM `jTodd7_comprofiler_plugin_gallery_items` AS a
 
  LEFT JOIN `jTodd7_comprofiler` AS cb 
  ON cb.`id` = a.`user_id`
 
  LEFT JOIN `jTodd7_users` AS j 
  ON j.`id` = cb.`id`
 
  WHERE cb.`approved` = 1
 
  AND cb.`confirmed` = 1
 
  AND j.`block` = 0
 
  AND a.`asset` IN  ('profile.0', 'profile.0.uploads')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	asset_folder_published_date	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where
1	SIMPLE	j	eq_ref	PRIMARY,idx_block	PRIMARY	4	joomla.a.user_id	1	Using where
1	SIMPLE	cb	eq_ref	PRIMARY,apprconfbanid	PRIMARY	4	joomla.a.user_id	1	Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.05 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.01 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
51	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
50	JDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:345
49	CBLib\Database\Driver\CmsDatabaseDriver->loadResult()	JROOT/components/com_comprofiler/plugin/libraries/CB/Plugin/Gallery/Gallery.php:1254
48	CB\Plugin\Gallery\Gallery->items()	JROOT/modules/mod_cbgallery/mod_cbgallery.php:67
47	include JROOT/modules/mod_cbgallery/mod_cbgallery.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
46	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
45	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
44	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
43	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:675
42	Twig_Template->getAttribute()	JROOT/cache/gantry5/jf_sirena/twig/cd/cdee8e0755a16e360ddb1e15078b6fc95207fcc2af1e4aecfc70c2df831e4152.php:32
41	__TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215
40	Twig_Template->displayBlock()	JROOT/cache/gantry5/jf_sirena/twig/9c/9c5b462d5ee0e2b82ff6a779b632d430743d87bbb7033f09eff3e11a92c6ff1c.php:62
39	__TwigTemplate_b0f548c500e532ba1fda164a0c0a2eaf89d5783ac1dbfaeb32105e4aaedef21b->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
38	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
37	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/cd/cdee8e0755a16e360ddb1e15078b6fc95207fcc2af1e4aecfc70c2df831e4152.php:24
36	__TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
34	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/b6/b69079ac547c4f2142950c448c66a1d7453d2d0cb8174c9a2937b29bb21db10d.php:42
33	__TwigTemplate_24d13b45559483d220f13be7b946cda7f2e614d78ce82344c17a7f904122f38a->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766
27	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
26	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
22	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
21	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:673
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/jf_sirena/twig/bb/bbb39e4eaa34caaa7d11829d625dc8e04b419b197d84c841996f966ddee3ae90.php:36
19	__TwigTemplate_bc34790340fb12f47cf42cf0c13b2adc8a78982ad2918899582ad76c95e1a6af->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
17	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/e4/e4c81d8901b6ce50e08f7f0aa035a72f6c05938e39806b4130b879583e410bbc.php:24
16	__TwigTemplate_22dc06cce989244fb8d3f5fcf813569067a187e115969bbda614a61d61bc90d9->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
14	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/20/20e7a7c67372d5209373149e79614021a466682b9a8e1634daadc4d12dcafcdd.php:24
13	__TwigTemplate_74b153afd6133d347f63d3d8674c7f1afb660a9692be2782a015f45aa9be032e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/jf_sirena/index.php:23
7	require JROOT/templates/jf_sirena/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.]

Query Time: 0.24 ms After last query: 1.89 ms Query memory: 0.039 MB Memory before query: 8.461 MB Rows returned: 0

SELECT DISTINCT `userid`
 
  FROM `jTodd7_session`
 
  WHERE `client_id` = 0
 
  AND `guest` = 0
 
  ORDER BY `time` DESC 
  LIMIT 0, 30

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jTodd7_session	ref	client_id_guest	client_id_guest	4	const,const	1	Using where; Using temporary; Using filesort

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
Creating tmp table	0.02 ms
executing	0.00 ms
Copying to tmp table	0.01 ms
Sorting result	0.01 ms
Sending data	0.01 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
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
50	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
49	JDatabaseDriver->loadColumn()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:370
48	CBLib\Database\Driver\CmsDatabaseDriver->loadResultArray()	JROOT/modules/mod_comprofileronline/mod_comprofileronline.php:350
47	include JROOT/modules/mod_comprofileronline/mod_comprofileronline.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
46	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
45	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
44	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
43	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:675
42	Twig_Template->getAttribute()	JROOT/cache/gantry5/jf_sirena/twig/cd/cdee8e0755a16e360ddb1e15078b6fc95207fcc2af1e4aecfc70c2df831e4152.php:32
41	__TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215
40	Twig_Template->displayBlock()	JROOT/cache/gantry5/jf_sirena/twig/9c/9c5b462d5ee0e2b82ff6a779b632d430743d87bbb7033f09eff3e11a92c6ff1c.php:62
39	__TwigTemplate_b0f548c500e532ba1fda164a0c0a2eaf89d5783ac1dbfaeb32105e4aaedef21b->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
38	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
37	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/cd/cdee8e0755a16e360ddb1e15078b6fc95207fcc2af1e4aecfc70c2df831e4152.php:24
36	__TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
34	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/b6/b69079ac547c4f2142950c448c66a1d7453d2d0cb8174c9a2937b29bb21db10d.php:42
33	__TwigTemplate_24d13b45559483d220f13be7b946cda7f2e614d78ce82344c17a7f904122f38a->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766
27	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
26	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
22	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
21	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:673
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/jf_sirena/twig/bb/bbb39e4eaa34caaa7d11829d625dc8e04b419b197d84c841996f966ddee3ae90.php:36
19	__TwigTemplate_bc34790340fb12f47cf42cf0c13b2adc8a78982ad2918899582ad76c95e1a6af->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
17	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/e4/e4c81d8901b6ce50e08f7f0aa035a72f6c05938e39806b4130b879583e410bbc.php:24
16	__TwigTemplate_22dc06cce989244fb8d3f5fcf813569067a187e115969bbda614a61d61bc90d9->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
14	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/20/20e7a7c67372d5209373149e79614021a466682b9a8e1634daadc4d12dcafcdd.php:24
13	__TwigTemplate_74b153afd6133d347f63d3d8674c7f1afb660a9692be2782a015f45aa9be032e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/jf_sirena/index.php:23
7	require JROOT/templates/jf_sirena/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.]

Query Time: 0.21 ms After last query: 0.49 ms Query memory: 0.043 MB Memory before query: 8.479 MB Rows returned: 62

SELECT guest, client_id

  FROM jTodd7_session

  WHERE client_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jTodd7_session	ref	client_id_guest	client_id_guest	2	const	62	Using where; Using index

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
50	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
49	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_whosonline/helper.php:45
48	ModWhosonlineHelper::getOnlineCount()	JROOT/modules/mod_whosonline/mod_whosonline.php:19
47	include JROOT/modules/mod_whosonline/mod_whosonline.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
46	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
45	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
44	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
43	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:675
42	Twig_Template->getAttribute()	JROOT/cache/gantry5/jf_sirena/twig/cd/cdee8e0755a16e360ddb1e15078b6fc95207fcc2af1e4aecfc70c2df831e4152.php:32
41	__TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215
40	Twig_Template->displayBlock()	JROOT/cache/gantry5/jf_sirena/twig/9c/9c5b462d5ee0e2b82ff6a779b632d430743d87bbb7033f09eff3e11a92c6ff1c.php:62
39	__TwigTemplate_b0f548c500e532ba1fda164a0c0a2eaf89d5783ac1dbfaeb32105e4aaedef21b->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
38	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
37	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/cd/cdee8e0755a16e360ddb1e15078b6fc95207fcc2af1e4aecfc70c2df831e4152.php:24
36	__TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
34	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/b6/b69079ac547c4f2142950c448c66a1d7453d2d0cb8174c9a2937b29bb21db10d.php:42
33	__TwigTemplate_24d13b45559483d220f13be7b946cda7f2e614d78ce82344c17a7f904122f38a->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766
27	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
26	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
22	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
21	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:673
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/jf_sirena/twig/bb/bbb39e4eaa34caaa7d11829d625dc8e04b419b197d84c841996f966ddee3ae90.php:36
19	__TwigTemplate_bc34790340fb12f47cf42cf0c13b2adc8a78982ad2918899582ad76c95e1a6af->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
17	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/e4/e4c81d8901b6ce50e08f7f0aa035a72f6c05938e39806b4130b879583e410bbc.php:24
16	__TwigTemplate_22dc06cce989244fb8d3f5fcf813569067a187e115969bbda614a61d61bc90d9->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
14	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/20/20e7a7c67372d5209373149e79614021a466682b9a8e1634daadc4d12dcafcdd.php:24
13	__TwigTemplate_74b153afd6133d347f63d3d8674c7f1afb660a9692be2782a015f45aa9be032e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/jf_sirena/index.php:23
7	require JROOT/templates/jf_sirena/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.]

Query Time: 0.44 ms After last query: 0.20 ms Query memory: 0.039 MB Memory before query: 8.502 MB Rows returned: 0

SELECT `a`.`username`,`a`.`userid`,`a`.`client_id`

  FROM jTodd7_session AS a

  WHERE `a`.`userid` != 0 
  AND `a`.`client_id` = 0

  GROUP BY `a`.`username`,`a`.`userid`,`a`.`client_id`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	range	userid,client_id_guest	userid	5	NULL	2	Using where; Using temporary; Using filesort

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
Creating tmp table	0.16 ms
executing	0.00 ms
Copying to tmp table	0.03 ms
Sorting result	0.02 ms
Sending data	0.01 ms
end	0.00 ms
removing tmp table	0.04 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
50	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
49	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_whosonline/helper.php:118
48	ModWhosonlineHelper::getOnlineUserNames()	JROOT/modules/mod_whosonline/mod_whosonline.php:24
47	include JROOT/modules/mod_whosonline/mod_whosonline.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
46	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
45	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
44	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
43	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:675
42	Twig_Template->getAttribute()	JROOT/cache/gantry5/jf_sirena/twig/cd/cdee8e0755a16e360ddb1e15078b6fc95207fcc2af1e4aecfc70c2df831e4152.php:32
41	__TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215
40	Twig_Template->displayBlock()	JROOT/cache/gantry5/jf_sirena/twig/9c/9c5b462d5ee0e2b82ff6a779b632d430743d87bbb7033f09eff3e11a92c6ff1c.php:62
39	__TwigTemplate_b0f548c500e532ba1fda164a0c0a2eaf89d5783ac1dbfaeb32105e4aaedef21b->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
38	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
37	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/cd/cdee8e0755a16e360ddb1e15078b6fc95207fcc2af1e4aecfc70c2df831e4152.php:24
36	__TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
34	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/b6/b69079ac547c4f2142950c448c66a1d7453d2d0cb8174c9a2937b29bb21db10d.php:42
33	__TwigTemplate_24d13b45559483d220f13be7b946cda7f2e614d78ce82344c17a7f904122f38a->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766
27	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
26	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
22	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
21	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:673
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/jf_sirena/twig/bb/bbb39e4eaa34caaa7d11829d625dc8e04b419b197d84c841996f966ddee3ae90.php:36
19	__TwigTemplate_bc34790340fb12f47cf42cf0c13b2adc8a78982ad2918899582ad76c95e1a6af->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
17	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/e4/e4c81d8901b6ce50e08f7f0aa035a72f6c05938e39806b4130b879583e410bbc.php:24
16	__TwigTemplate_22dc06cce989244fb8d3f5fcf813569067a187e115969bbda614a61d61bc90d9->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
14	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/20/20e7a7c67372d5209373149e79614021a466682b9a8e1634daadc4d12dcafcdd.php:24
13	__TwigTemplate_74b153afd6133d347f63d3d8674c7f1afb660a9692be2782a015f45aa9be032e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/jf_sirena/index.php:23
7	require JROOT/templates/jf_sirena/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.]

Query Time: 0.26 ms After last query: 1.74 ms Query memory: 0.041 MB Memory before query: 8.786 MB Rows returned: 0

Duplicate queries: #61

SELECT cart.cart_id 
  FROM jTodd7_hikashop_cart AS cart  
  WHERE (cart.cart_type = 'cart') 
  AND (cart.session_id = 'd4j52srup6g15l19kc5bapn9c7')  
  ORDER BY cart.cart_current DESC, cart.cart_modified DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cart	ref	session_id	session_id	767	const	1	Using where; Using filesort

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.03 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
55	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
54	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_hikashop/classes/cart.php:68
53	hikashopCartClass->getCurrentCartId()	JROOT/administrator/components/com_hikashop/classes/cart.php:91
52	hikashopCartClass->get()	JROOT/administrator/components/com_hikashop/helpers/helper.php:338
51	hikashop_getZone()	JROOT/components/com_hikashop/views/product/view.html.php:397
50	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
49	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:655
48	hikashop_getLayout()	JROOT/modules/mod_hikashop/mod_hikashop.php:73
47	include JROOT/modules/mod_hikashop/mod_hikashop.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
46	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
45	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
44	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
43	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:675
42	Twig_Template->getAttribute()	JROOT/cache/gantry5/jf_sirena/twig/cd/cdee8e0755a16e360ddb1e15078b6fc95207fcc2af1e4aecfc70c2df831e4152.php:32
41	__TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215
40	Twig_Template->displayBlock()	JROOT/cache/gantry5/jf_sirena/twig/9c/9c5b462d5ee0e2b82ff6a779b632d430743d87bbb7033f09eff3e11a92c6ff1c.php:62
39	__TwigTemplate_b0f548c500e532ba1fda164a0c0a2eaf89d5783ac1dbfaeb32105e4aaedef21b->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
38	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
37	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/cd/cdee8e0755a16e360ddb1e15078b6fc95207fcc2af1e4aecfc70c2df831e4152.php:24
36	__TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
34	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/b6/b69079ac547c4f2142950c448c66a1d7453d2d0cb8174c9a2937b29bb21db10d.php:42
33	__TwigTemplate_24d13b45559483d220f13be7b946cda7f2e614d78ce82344c17a7f904122f38a->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766
27	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
26	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
22	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
21	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:673
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/jf_sirena/twig/bb/bbb39e4eaa34caaa7d11829d625dc8e04b419b197d84c841996f966ddee3ae90.php:36
19	__TwigTemplate_bc34790340fb12f47cf42cf0c13b2adc8a78982ad2918899582ad76c95e1a6af->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
17	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/e4/e4c81d8901b6ce50e08f7f0aa035a72f6c05938e39806b4130b879583e410bbc.php:24
16	__TwigTemplate_22dc06cce989244fb8d3f5fcf813569067a187e115969bbda614a61d61bc90d9->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
14	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/20/20e7a7c67372d5209373149e79614021a466682b9a8e1634daadc4d12dcafcdd.php:24
13	__TwigTemplate_74b153afd6133d347f63d3d8674c7f1afb660a9692be2782a015f45aa9be032e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/jf_sirena/index.php:23
7	require JROOT/templates/jf_sirena/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.]

Query Time: 0.28 ms After last query: 0.24 ms Query memory: 0.052 MB Memory before query: 8.814 MB Rows returned: 1

SELECT a.*,b.* 
  FROM jTodd7_hikashop_category AS a 
  LEFT JOIN jTodd7_hikashop_file AS b 
  ON a.category_id = b.file_ref_id 
  AND b.file_type = 'category' 
  WHERE a.category_id = 2 
  LIMIT 1

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	ref	file_type	file_type	767	const	1

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
53	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
52	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/classes/category.php:35
51	hikashopCategoryClass->get()	JROOT/components/com_hikashop/views/product/view.html.php:450
50	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
49	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:655
48	hikashop_getLayout()	JROOT/modules/mod_hikashop/mod_hikashop.php:73
47	include JROOT/modules/mod_hikashop/mod_hikashop.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
46	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
45	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
44	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
43	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:675
42	Twig_Template->getAttribute()	JROOT/cache/gantry5/jf_sirena/twig/cd/cdee8e0755a16e360ddb1e15078b6fc95207fcc2af1e4aecfc70c2df831e4152.php:32
41	__TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215
40	Twig_Template->displayBlock()	JROOT/cache/gantry5/jf_sirena/twig/9c/9c5b462d5ee0e2b82ff6a779b632d430743d87bbb7033f09eff3e11a92c6ff1c.php:62
39	__TwigTemplate_b0f548c500e532ba1fda164a0c0a2eaf89d5783ac1dbfaeb32105e4aaedef21b->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
38	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
37	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/cd/cdee8e0755a16e360ddb1e15078b6fc95207fcc2af1e4aecfc70c2df831e4152.php:24
36	__TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
34	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/b6/b69079ac547c4f2142950c448c66a1d7453d2d0cb8174c9a2937b29bb21db10d.php:42
33	__TwigTemplate_24d13b45559483d220f13be7b946cda7f2e614d78ce82344c17a7f904122f38a->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766
27	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
26	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
22	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
21	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:673
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/jf_sirena/twig/bb/bbb39e4eaa34caaa7d11829d625dc8e04b419b197d84c841996f966ddee3ae90.php:36
19	__TwigTemplate_bc34790340fb12f47cf42cf0c13b2adc8a78982ad2918899582ad76c95e1a6af->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
17	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/e4/e4c81d8901b6ce50e08f7f0aa035a72f6c05938e39806b4130b879583e410bbc.php:24
16	__TwigTemplate_22dc06cce989244fb8d3f5fcf813569067a187e115969bbda614a61d61bc90d9->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
14	Twig_Template->display()	JROOT/cache/gantry5/jf_sirena/twig/20/20e7a7c67372d5209373149e79614021a466682b9a8e1634daadc4d12dcafcdd.php:24
13	__TwigTemplate_74b153afd6133d347f63d3d8674c7f1afb660a9692be2782a015f45aa9be032e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/jf_sirena/index.php:23
7	require JROOT/templates/jf_sirena/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.]

Query Time: 0.18 ms After last query: 0.11 ms Query memory: 0.048 MB Memory before query: 8.842 MB Rows returned: 1