??COM_YOORECIPE_RECIPE?? Creamy Strawberry Vanilla Vegan Ice Cream

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1713474304,
                "last": 1713474304,
                "now": 1713474304
            },
            "token": "DFaoTdrGnop0Cx8rnuwp6flzZz38HELU"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "com_mailto": {
            "links": {
                "58bbfe4adc400e69cd332889a22fb7ae5501f87a": {
                    "link": "http:\/\/ecopeaceful.com\/component\/yoorecipe\/recipe\/19-creamy-strawberry-vanilla-vegan-ice-cream",
                    "expiry": 1713474304
                }
            }
        }
    }
}

Profile Information

Time

Memory

**Time**: 82.73 ms / 82.73 ms **Memory**: 0.875 MB / 1.10 MB Application: afterLoad

**Time**: 554.73 ms / 637.45 ms **Memory**: 5.848 MB / 6.94 MB Application: afterInitialise

**Time**: 83.42 ms / 720.88 ms **Memory**: 1.270 MB / 8.21 MB Application: afterRoute

**Time**: 0.36 ms / 721.23 ms **Memory**: 0.038 MB / 8.25 MB Application: beforeRenderComponent com_yoorecipe

**Time**: 98.89 ms / 820.12 ms **Memory**: 1.396 MB / 9.65 MB Application: Before Access::preloadComponents (all components)

**Time**: 1.90 ms / 822.02 ms **Memory**: 0.115 MB / 9.76 MB Application: After Access::preloadComponents (all components)

**Time**: 0.07 ms / 822.10 ms **Memory**: 0.000 MB / 9.76 MB Application: Before Access::getAssetRules (id:50 name:com_yoorecipe)

**Time**: 2.65 ms / 824.75 ms **Memory**: 0.024 MB / 9.78 MB Application: After Access::getAssetRules (id:50 name:com_yoorecipe)

**Time**: 56.38 ms / 881.13 ms **Memory**: 1.000 MB / 10.78 MB Application: afterRenderComponent com_yoorecipe

**Time**: 4.64 ms / 885.77 ms **Memory**: 0.075 MB / 10.85 MB Application: afterDispatch

**Time**: 19.24 ms / 905.01 ms **Memory**: 0.267 MB / 11.12 MB Application: beforeRenderModule mod_custom (Copyright)

**Time**: 2.05 ms / 907.06 ms **Memory**: 0.013 MB / 11.14 MB Application: afterRenderRawModule mod_custom (Copyright)

**Time**: 0.03 ms / 907.08 ms **Memory**: 0.000 MB / 11.13 MB Application: beforeRenderModule mod_custom (Copyright)

**Time**: 1.96 ms / 909.04 ms **Memory**: 0.010 MB / 11.14 MB Application: afterRenderModule mod_custom (Copyright)

**Time**: 0.74 ms / 909.78 ms **Memory**: 0.002 MB / 11.14 MB Application: beforeRenderModule mod_custom (Website Green Hosted)

**Time**: 0.17 ms / 909.95 ms **Memory**: 0.006 MB / 11.15 MB Application: afterRenderRawModule mod_custom (Website Green Hosted)

**Time**: 0.02 ms / 909.96 ms **Memory**: 0.000 MB / 11.14 MB Application: beforeRenderModule mod_custom (Website Green Hosted)

**Time**: 0.33 ms / 910.30 ms **Memory**: 0.004 MB / 11.15 MB Application: afterRenderModule mod_custom (Website Green Hosted)

**Time**: 0.60 ms / 910.90 ms **Memory**: 0.001 MB / 11.15 MB Application: beforeRenderModule mod_custom (Google AdSense - Position-11)

**Time**: 0.16 ms / 911.06 ms **Memory**: 0.006 MB / 11.15 MB Application: afterRenderRawModule mod_custom (Google AdSense - Position-11)

**Time**: 0.01 ms / 911.07 ms **Memory**: 0.000 MB / 11.15 MB Application: beforeRenderModule mod_custom (Google AdSense - Position-11)

**Time**: 0.28 ms / 911.36 ms **Memory**: 0.003 MB / 11.15 MB Application: afterRenderModule mod_custom (Google AdSense - Position-11)

**Time**: 0.66 ms / 912.02 ms **Memory**: 0.021 MB / 11.18 MB Application: beforeRenderModule mod_jnews (Newsletter SignUp!)

**Time**: 62.13 ms / 974.15 ms **Memory**: 0.480 MB / 11.66 MB Application: afterRenderRawModule mod_jnews (Newsletter SignUp!)

**Time**: 0.04 ms / 974.20 ms **Memory**: 0.000 MB / 11.61 MB Application: beforeRenderModule mod_jnews (Newsletter SignUp!)

**Time**: 0.40 ms / 974.60 ms **Memory**: 0.003 MB / 11.61 MB Application: afterRenderModule mod_jnews (Newsletter SignUp!)

**Time**: 0.81 ms / 975.41 ms **Memory**: 0.011 MB / 11.62 MB Application: beforeRenderModule mod_fbfanbox (Facebook FanBox)

**Time**: 1.10 ms / 976.52 ms **Memory**: 0.016 MB / 11.64 MB Application: afterRenderRawModule mod_fbfanbox (Facebook FanBox)

**Time**: 0.03 ms / 976.54 ms **Memory**: 0.000 MB / 11.63 MB Application: beforeRenderModule mod_fbfanbox (Facebook FanBox)

**Time**: 0.34 ms / 976.89 ms **Memory**: 0.004 MB / 11.63 MB Application: afterRenderModule mod_fbfanbox (Facebook FanBox)

**Time**: 0.66 ms / 977.55 ms **Memory**: 0.000 MB / 11.62 MB Application: beforeRenderModule mod_custom (Google Adsense - sidebar-2)

**Time**: 0.18 ms / 977.73 ms **Memory**: 0.006 MB / 11.63 MB Application: afterRenderRawModule mod_custom (Google Adsense - sidebar-2)

**Time**: 0.01 ms / 977.74 ms **Memory**: 0.000 MB / 11.62 MB Application: beforeRenderModule mod_custom (Google Adsense - sidebar-2)

**Time**: 0.32 ms / 978.06 ms **Memory**: 0.004 MB / 11.63 MB Application: afterRenderModule mod_custom (Google Adsense - sidebar-2)

**Time**: 0.46 ms / 978.52 ms **Memory**: 0.000 MB / 11.62 MB Application: beforeRenderModule mod_roksprocket (RokSprocket)

**Time**: 86.78 ms / 1065.29 ms **Memory**: 1.132 MB / 12.75 MB Application: afterRenderRawModule mod_roksprocket (RokSprocket)

**Time**: 0.23 ms / 1065.52 ms **Memory**: 0.000 MB / 12.13 MB Application: beforeRenderModule mod_roksprocket (RokSprocket)

**Time**: 0.42 ms / 1065.94 ms **Memory**: 0.003 MB / 12.13 MB Application: afterRenderModule mod_roksprocket (RokSprocket)

**Time**: 0.18 ms / 1066.12 ms **Memory**: 0.000 MB / 12.13 MB Application: beforeRenderModule mod_fakeonlinepro (Visitor Counter)

**Time**: 1.10 ms / 1067.21 ms **Memory**: 0.013 MB / 12.14 MB Application: afterRenderRawModule mod_fakeonlinepro (Visitor Counter)

**Time**: 0.19 ms / 1067.41 ms **Memory**: 0.028 MB / 12.17 MB Application: beforeRenderModule mod_universal_ajaxlivesearch (Live Search)

**Time**: 7.84 ms / 1075.24 ms **Memory**: 0.123 MB / 12.30 MB Application: afterRenderRawModule mod_universal_ajaxlivesearch (Live Search)

**Time**: 85.19 ms / 1160.43 ms **Memory**: 1.111 MB / 13.41 MB Application: afterRender

**Database queries total: 56.18 ms**

Memory Usage

Database Queries

83 Queries Logged 56.18 ms

28 duplicate found!

**2 duplicates**: #10 #11

**2 duplicates**: #22 #24

**8 duplicates**: #41 #42 #67 #68 #75 #76 #82 #83

**4 duplicates**: #43 #44 #69 #70

**4 duplicates**: #45 #46 #71 #72

**2 duplicates**: #54 #55

**2 duplicates**: #57 #61

**2 duplicates**: #59 #63

**2 duplicates**: #80 #81

**Query Time: 1.00 ms** **Query memory: 0.021 MB Memory before query: 1.649 MB** **Rows returned: 0**

SELECT `data`

  FROM `ersq_session`

  WHERE `session_id` = 'r866umb8gt8k7oq0rdj4bab3q2'

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

**Profile**

Status	Duration
starting	0.04 ms
checking permissions	0.03 ms
Opening tables	0.24 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.43 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 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.18 ms** **After last query: 4.43 ms** **Query memory: 0.013 MB Memory before query: 1.707 MB** **Rows returned: 0**

SELECT `session_id`

  FROM `ersq_session`

  WHERE `session_id` = 'r866umb8gt8k7oq0rdj4bab3q2' 
  LIMIT 1

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	Using index

**Profile**

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

**Call Stack**

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

**Query Time: 0.21 ms** **After last query: 0.15 ms** **Query memory: 0.010 MB Memory before query: 1.724 MB**

INSERT INTO `ersq_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('r866umb8gt8k7oq0rdj4bab3q2', 1, 1713474304, 0, '', 0)

**Explain**

**EXPLAIN not possible on query: INSERT INTO `ersq_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('r866umb8gt8k7oq0rdj4bab3q2', 1, 1713474304, 0, '', 0)**

**Profile**

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
update	0.07 ms
end	0.00 ms
query end	0.03 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 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: 1.18 ms** **After last query: 13.01 ms** **Query memory: 0.026 MB Memory before query: 1.833 MB** **Rows returned: 52**

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

  FROM `ersq_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_extensions	NULL	ref	extension	extension	82	const	58	1.00	Using where

**Profile**

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.74 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.20 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 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.41 ms** **After last query: 8.87 ms** **Query memory: 0.015 MB Memory before query: 1.963 MB** **Rows returned: 4**

SELECT id, rules

  FROM `ersq_viewlevels`

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_viewlevels	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	4	100.00	NULL

**Profile**

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.24 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 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.01 ms
freeing items	0.02 ms
cleaning up	0.01 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.38 ms** **After last query: 0.17 ms** **Query memory: 0.015 MB Memory before query: 1.987 MB** **Rows returned: 2**

SELECT b.id

  FROM ersq_usergroups AS a

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

  WHERE a.id = 9

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	b	NULL	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	100.00	Using where; Using index

**Profile**

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.16 ms
init	0.01 ms
System lock	0.01 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.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

**Call Stack**

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.96 ms** **After last query: 2.49 ms** **Query memory: 0.021 MB Memory before query: 2.030 MB** **Rows returned: 144**

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

  FROM ersq_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_extensions	NULL	ref	extension	extension	82	const	202	0.60	Using index condition; Using where; Using filesort

**Profile**

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.71 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 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.88 ms** **After last query: 70.33 ms** **Query memory: 0.020 MB Memory before query: 2.777 MB** **Rows returned: 1**

SELECT `value`

  FROM `ersq_admintools_storage`

  WHERE `key` = 'cparams'

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_admintools_storage	NULL	const	PRIMARY	PRIMARY	402	const	1	100.00	NULL

**Profile**

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.41 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.30 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.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

**Call Stack**

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_admintools/Helper/Storage.php:123
12	Akeeba\AdminTools\Admin\Helper\Storage->load()	JROOT/administrator/components/com_admintools/Helper/Storage.php:53
11	Akeeba\AdminTools\Admin\Helper\Storage->__construct()	JROOT/administrator/components/com_admintools/Helper/Storage.php:41
10	Akeeba\AdminTools\Admin\Helper\Storage::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:278
9	plgSystemAdmintools->loadComponentParameters()	JROOT/plugins/system/admintools/admintools/main.php:874
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:110
7	plgSystemAdmintools->__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: 4.11 ms** **Query memory: 0.018 MB Memory before query: 2.817 MB** **Rows returned: 0**

SELECT *

  FROM `ersq_admintools_wafexceptions`

  WHERE NOT(`option` LIKE 'com_%')

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

**Profile**

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.45 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.02 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

**Call Stack**

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
11	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/admintools/main.php:592
10	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT/plugins/system/admintools/admintools/main.php:503
9	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:883
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:110
7	plgSystemAdmintools->__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.58 ms** **After last query: 64.13 ms** **Query memory: 0.020 MB Memory before query: 3.457 MB** **Rows returned: 1**

**Duplicate queries**: #11

SELECT template

  FROM ersq_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_home	NO INDEX KEY COULD BE USED	NULL	NULL	5	20.00	Using where

**Profile**

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

**Call Stack**

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
13	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
7	plgSystemRokCommon->__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.18 ms** **After last query: 0.19 ms** **Query memory: 0.021 MB Memory before query: 3.476 MB** **Rows returned: 1**

**Duplicate queries**: #10

SELECT template

  FROM ersq_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_home	NO INDEX KEY COULD BE USED	NULL	NULL	5	20.00	Using where

**Profile**

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

**Call Stack**

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
14	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
7	plgSystemRokCommon->__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: 1.31 ms** **After last query: 11.26 ms** **Query memory: 0.016 MB Memory before query: 3.672 MB** **Rows returned: 2**

SELECT extension, file, type

  FROM ersq_rokcommon_configs

  ORDER BY priority

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_rokcommon_configs	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	100.00	Using filesort

**Profile**

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.55 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.32 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

**Call Stack**

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rokcommon/rokcommon.php:131
8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:75
7	plgSystemRokCommon->__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.37 ms** **After last query: 32.73 ms** **Query memory: 0.012 MB Memory before query: 4.049 MB**

UPDATE ersq_extensions

  SET enabled=1

  WHERE `type`='plugin' 
  AND `element`='jacontenttype' 
  AND `folder`='ajax'

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	ersq_extensions	NULL	range	element_clientid,element_folder_clientid,extension	element_folder_clientid	804	const,const	1	100.00	Using where

**Profile**

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.07 ms
updating	0.06 ms
end	0.00 ms
query end	0.05 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

**Call Stack**

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/jacontenttype/jacontenttype.php:61
8	PlgSystemJacontenttype->_check()	JROOT/plugins/system/jacontenttype/jacontenttype.php:43
7	PlgSystemJacontenttype->__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.45 ms** **After last query: 52.11 ms** **Query memory: 0.028 MB Memory before query: 4.750 MB** **Rows returned: 1**

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

  FROM `ersq_extensions`

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

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

**Profile**

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.06 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.02 ms
cleaning up	0.01 ms

**Call Stack**

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
20	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
19	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	*Same as call in the line below.*
18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
16	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
15	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
14	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
13	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
12	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
11	Joomla\CMS\Factory::getDocument()	JROOT/joobi/node/api/addon/joomla30/joomla30.php:236
10	APIPage::encoding()	JROOT/joobi/node/api/addon/joomla30/joomla30.php:1751
9	WApplication_joomla30::make()	JROOT/joobi/entry.php:57
8	include JROOT/joobi/entry.php	JROOT/plugins/system/users_system_plugin/users_system_plugin.php:11
7	require_once JROOT/plugins/system/users_system_plugin/users_system_plugin.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
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: 2.30 ms** **After last query: 0.56 ms** **Query memory: 0.020 MB Memory before query: 4.758 MB**

UPDATE `ersq_extensions`

  SET `params` = '{\"mediaversion\":\"7b413b89302c416d23e377edf877b8b3\"}'

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

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	ersq_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

**Profile**

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.06 ms
updating	0.06 ms
end	0.01 ms
query end	2.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

**Call Stack**

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
15	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
14	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
13	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
12	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
11	Joomla\CMS\Factory::getDocument()	JROOT/joobi/node/api/addon/joomla30/joomla30.php:236
10	APIPage::encoding()	JROOT/joobi/node/api/addon/joomla30/joomla30.php:1751
9	WApplication_joomla30::make()	JROOT/joobi/entry.php:57
8	include JROOT/joobi/entry.php	JROOT/plugins/system/users_system_plugin/users_system_plugin.php:11
7	require_once JROOT/plugins/system/users_system_plugin/users_system_plugin.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
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: 1.90 ms** **After last query: 120.58 ms** **Query memory: 0.019 MB Memory before query: 6.202 MB** **Rows returned: 1**

SHOW VARIABLES LIKE "collation_database"

**Explain**

**EXPLAIN not possible on query: SHOW VARIABLES LIKE "collation_database"**

**Profile**

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

**Call Stack**

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
13	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/database/driver/mysqli.php:342
12	JDatabaseDriverMysqli->getCollation()	JROOT/plugins/system/admintools/feature/utf8mb4.php:28
11	AtsystemFeatureUtf8mb4->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:753
10	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:135
9	plgSystemAdmintools->onAfterInitialise()	*Same as call in the line below.*
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/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.87 ms** **After last query: 0.40 ms** **Query memory: 0.019 MB Memory before query: 6.226 MB** **Rows returned: 0**

SELECT `source`,`keepurlparams`

  FROM `ersq_admintools_redirects`

  WHERE ((`dest` = 'component/yoorecipe/recipe/19') OR (`dest` = 'component/yoorecipe/recipe/19?Itemid=101') OR ('component/yoorecipe/recipe/19?Itemid=101' LIKE `dest`)) 
  AND `published` = '1'

  ORDER BY `ordering` DESC 
  LIMIT 1

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

**Profile**

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.63 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

**Call Stack**

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1767
12	JDatabaseDriver->loadRow()	JROOT/plugins/system/admintools/feature/urlredir.php:89
11	AtsystemFeatureUrlredir->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:753
10	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:135
9	plgSystemAdmintools->onAfterInitialise()	*Same as call in the line below.*
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/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.35 ms** **After last query: 2.03 ms** **Query memory: 0.018 MB Memory before query: 6.253 MB** **Rows returned: 1**

SELECT params

  FROM ersq_extensions

  WHERE type = "plugin" 
  AND folder = "system" 
  AND element = 'jsnextfw'

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_folder_clientid	804	const,const	1	10.00	Using where

**Profile**

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

**Call Stack**

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
11	JDatabaseDriver->loadResult()	JROOT/plugins/system/jsnextfw/includes/helper.php:169
10	JsnExtFwHelper::getSettings()	JROOT/plugins/system/jsnextfw/jsnextfw.php:137
9	PlgSystemJsnExtFw->onAfterInitialise()	*Same as call in the line below.*
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/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.28 ms** **After last query: 2.95 ms** **Query memory: 0.018 MB Memory before query: 6.276 MB** **Rows returned: 1**

SELECT params

  FROM ersq_extensions

  WHERE type = "component" 
  AND element = 'com_poweradmin2'

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

**Profile**

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.07 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.02 ms
cleaning up	0.01 ms

**Call Stack**

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
12	JDatabaseDriver->loadResult()	JROOT/plugins/system/jsnextfw/includes/helper.php:179
11	JsnExtFwHelper::getSettings()	JROOT/administrator/components/com_poweradmin2/helpers/poweradmin2.php:150
10	JSNPowerAdmin2Helper::getConfig()	JROOT/plugins/system/poweradmin2/poweradmin2.php:290
9	plgSystemPowerAdmin2->onAfterInitialise()	*Same as call in the line below.*
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/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.84 ms** **After last query: 13.72 ms** **Query memory: 0.024 MB Memory before query: 6.435 MB** **Rows returned: 18**

SHOW FULL COLUMNS 
  FROM `ersq_extensions`

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Extension.php:32
11	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:312
10	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/roksprocket/roksprocket.php:45
9	plgSystemRokSprocket->onAfterInitialise()	*Same as call in the line below.*
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/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.34 ms** **After last query: 1.53 ms** **Query memory: 0.016 MB Memory before query: 6.510 MB** **Rows returned: 1**

SELECT `extension_id`

  FROM `ersq_extensions`

  WHERE type = 'component' 
  AND element = 'com_roksprocket'

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

**Profile**

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 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.02 ms
cleaning up	0.01 ms

**Call Stack**

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
11	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
10	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:49
9	plgSystemRokSprocket->onAfterInitialise()	*Same as call in the line below.*
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/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.20 ms** **After last query: 0.20 ms** **Query memory: 0.020 MB Memory before query: 6.528 MB** **Rows returned: 1**

**Duplicate queries**: #24

SELECT *

  FROM ersq_extensions

  WHERE `extension_id` = '10455'

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_extensions	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

**Profile**

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

**Call Stack**

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
10	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:54
9	plgSystemRokSprocket->onAfterInitialise()	*Same as call in the line below.*
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.24 ms** **After last query: 0.15 ms** **Query memory: 0.016 MB Memory before query: 6.542 MB** **Rows returned: 1**

SELECT `extension_id`

  FROM `ersq_extensions`

  WHERE type = 'module' 
  AND element = 'mod_roksprocket'

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

**Profile**

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.07 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.03 ms
cleaning up	0.01 ms

**Call Stack**

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
11	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
10	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:72
9	plgSystemRokSprocket->onAfterInitialise()	*Same as call in the line below.*
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/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.34 ms** **After last query: 0.12 ms** **Query memory: 0.020 MB Memory before query: 6.559 MB** **Rows returned: 1**

**Duplicate queries**: #22

SELECT *

  FROM ersq_extensions

  WHERE `extension_id` = '10455'

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_extensions	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

**Profile**

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

**Call Stack**

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
10	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:76
9	plgSystemRokSprocket->onAfterInitialise()	*Same as call in the line below.*
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/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.64 ms** **After last query: 50.66 ms** **Query memory: 0.020 MB Memory before query: 6.840 MB** **Rows returned: 1**

select email 
  from ersq_users 
  where id=575 
  LIMIT 1

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_users	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

**Profile**

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

**Call Stack**

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
14	JDatabaseDriver->loadResult()	JROOT/plugins/system/bfstop/helpers/db.php:307
13	BFStopDBHelper->getUserEmailWhere()	JROOT/plugins/system/bfstop/helpers/db.php:320
12	BFStopDBHelper->getUserEmailByID()	JROOT/plugins/system/bfstop/helpers/notify.php:23
11	BFStopNotifier->__construct()	JROOT/plugins/system/bfstop/bfstop.php:197
10	plgSystembfstop->init()	JROOT/plugins/system/bfstop/bfstop.php:369
9	plgSystembfstop->onAfterInitialise()	*Same as call in the line below.*
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/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.77 ms** **After last query: 0.31 ms** **Query memory: 0.017 MB Memory before query: 6.864 MB** **Rows returned: 0**

SELECT id, ipaddress 
  from ersq_bfstop_allowlist 
  WHERE (ipaddress='3.141.24.134' 
  AND LOCATE('/', ipaddress) = 0)

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_bfstop_allowlist	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	4	25.00	Using where

**Profile**

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

**Call Stack**

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/bfstop/helpers/db.php:188
11	BFStopDBHelper->checkForEntries()	JROOT/plugins/system/bfstop/helpers/db.php:224
10	BFStopDBHelper->isIPOnAllowList()	JROOT/plugins/system/bfstop/bfstop.php:388
9	plgSystembfstop->onAfterInitialise()	*Same as call in the line below.*
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/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.22 ms** **After last query: 0.10 ms** **Query memory: 0.017 MB Memory before query: 6.880 MB** **Rows returned: 0**

SELECT id, ipaddress 
  from ersq_bfstop_allowlist 
  WHERE ((LOCATE('/', ipaddress) != 0 
  AND LOCATE('.', ipaddress) != 0 
  AND (INET_ATON('3.141.24.134') & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1)) = (INET_ATON(SUBSTR(ipaddress, 1, LOCATE("/", ipaddress)-1)) & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1))))

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_bfstop_allowlist	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	4	100.00	Using where

**Profile**

Status	Duration
starting	0.07 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 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.02 ms
cleaning up	0.01 ms

**Call Stack**

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/bfstop/helpers/db.php:188
11	BFStopDBHelper->checkForEntries()	JROOT/plugins/system/bfstop/helpers/db.php:225
10	BFStopDBHelper->isIPOnAllowList()	JROOT/plugins/system/bfstop/bfstop.php:388
9	plgSystembfstop->onAfterInitialise()	*Same as call in the line below.*
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/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: 1.60 ms** **After last query: 0.14 ms** **Query memory: 0.018 MB Memory before query: 6.898 MB** **Rows returned: 0**

SELECT id, ipaddress, crdate, duration 
  FROM ersq_bfstop_bannedip b 
  WHERE (ipaddress='3.141.24.134' 
  AND LOCATE('/', ipaddress) = 0) 
  AND (b.duration=0 OR DATE_ADD(b.crdate, INTERVAL b.duration MINUTE) >= '2024-04-18 16:05:04') 
  AND NOT EXISTS (SELECT 1 
  FROM ersq_bfstop_unblock u 
  WHERE b.id = u.block_id)

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	b	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	674	10.00	Using where
2	DEPENDENT SUBQUERY	u	NULL	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

**Profile**

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

**Call Stack**

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/bfstop/helpers/db.php:188
11	BFStopDBHelper->checkForEntries()	JROOT/plugins/system/bfstop/helpers/db.php:214
10	BFStopDBHelper->isIPBlocked()	JROOT/plugins/system/bfstop/bfstop.php:392
9	plgSystembfstop->onAfterInitialise()	*Same as call in the line below.*
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/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.45 ms** **After last query: 0.12 ms** **Query memory: 0.018 MB Memory before query: 6.915 MB** **Rows returned: 0**

SELECT id, ipaddress, crdate, duration 
  FROM ersq_bfstop_bannedip b 
  WHERE ((LOCATE('/', ipaddress) != 0 
  AND LOCATE('.', ipaddress) != 0 
  AND (INET_ATON('3.141.24.134') & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1)) = (INET_ATON(SUBSTR(ipaddress, 1, LOCATE("/", ipaddress)-1)) & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1)))) 
  AND (b.duration=0 OR DATE_ADD(b.crdate, INTERVAL b.duration MINUTE) >= '2024-04-18 16:05:04') 
  AND NOT EXISTS (SELECT 1 
  FROM ersq_bfstop_unblock u 
  WHERE b.id = u.block_id)

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	b	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	674	100.00	Using where
2	DEPENDENT SUBQUERY	u	NULL	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

**Profile**

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

**Call Stack**

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/bfstop/helpers/db.php:188
11	BFStopDBHelper->checkForEntries()	JROOT/plugins/system/bfstop/helpers/db.php:215
10	BFStopDBHelper->isIPBlocked()	JROOT/plugins/system/bfstop/bfstop.php:392
9	plgSystembfstop->onAfterInitialise()	*Same as call in the line below.*
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/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: 1.03 ms** **After last query: 14.38 ms** **Query memory: 0.037 MB Memory before query: 7.036 MB** **Rows returned: 57**

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM ersq_menu AS m

  LEFT JOIN ersq_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	97	3.33	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	joomlaxl_jmln2.m.component_id	1	100.00	Using where

**Profile**

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.30 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.45 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

**Call Stack**

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	*Same as call in the line below.*
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
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.42 ms** **After last query: 41.28 ms** **Query memory: 0.018 MB Memory before query: 7.776 MB** **Rows returned: 3**

SELECT id, home, template, s.params

  FROM ersq_template_styles as s

  LEFT JOIN ersq_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	5	20.00	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	joomlaxl_jmln2.s.template,const	1	4.41	Using index condition; Using where

**Profile**

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

**Call Stack**

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
11	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/t3/includes/core/t3.php:345
10	T3::detect()	JROOT/plugins/system/t3/t3.php:81
9	plgSystemT3->onAfterRoute()	*Same as call in the line below.*
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/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.63 ms** **After last query: 13.26 ms** **Query memory: 0.023 MB Memory before query: 7.887 MB** **Rows returned: 1**

SELECT *

  FROM ersq_languages

  WHERE published=1

  ORDER BY ordering ASC

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
13	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
12	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/components/com_k2/helpers/utilities.php:243
11	K2HelperUtilities::getParams()	JROOT/administrator/components/com_k2/helpers/html.php:235
10	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:438
9	plgSystemK2->onAfterRoute()	*Same as call in the line below.*
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/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: 1.49 ms** **After last query: 11.40 ms** **Query memory: 0.029 MB Memory before query: 8.180 MB** **Rows returned: 82**

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

  FROM ersq_modules AS m

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

  LEFT JOIN ersq_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 <= '2024-04-18 21:05:04') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-18 21:05:04') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 101 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	PRIMARY,published,newsfeeds	published	1	const	36	1.10	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	joomlaxl_jmln2.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	joomlaxl_jmln2.m.id	16	40.00	Using where; Using index

**Profile**

Status	Duration
starting	0.07 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.31 ms
init	0.03 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.71 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.03 ms
freeing items	0.02 ms
cleaning up	0.01 ms

**Call Stack**

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	*Same as call in the line below.*
15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:432
13	Joomla\CMS\Helper\_ModuleHelper::getModuleList()	JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:362
12	Joomla\CMS\Helper\_ModuleHelper::load()	JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:37
11	Joomla\CMS\Helper\_ModuleHelper::getModule()	JROOT/plugins/system/mijoshopjquery/mijoshopjquery.php:85
10	plgSystemMijoshopJquery->_checkUp()	JROOT/plugins/system/mijoshopjquery/mijoshopjquery.php:36
9	plgSystemMijoshopJquery->onAfterRoute()	*Same as call in the line below.*
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/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: 1.79 ms** **After last query: 22.98 ms** **Query memory: 0.018 MB Memory before query: 8.727 MB** **Rows returned: 0**

SELECT id, title, creation_date, infos, user_id

  FROM ersq_yoorecipe_shoppinglists as sl

  WHERE user_id = '0'

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sl	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	431	10.00	Using where

**Profile**

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

**Call Stack**

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_yoorecipe/models/shoppinglists.php:85
10	YooRecipeModelShoppingLists->getShoppingListsByUserId()	JROOT/components/com_yoorecipe/views/recipe/view.html.php:34
9	YooRecipeViewRecipe->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_yoorecipe/yoorecipe.php:55
6	require_once JROOT/components/com_yoorecipe/yoorecipe.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: 4.71 ms** **After last query: 11.81 ms** **Query memory: 0.033 MB Memory before query: 8.940 MB** **Rows returned: 8**

SELECT r.id, r.access, r.title, r.alias, r.description, r.created_by, r.preparation, r.notes, r.serving_type_id,r.nb_persons, r.difficulty, r.cost, r.sugar, r.carbs, r.fat, r.saturated_fat, r.cholesterol, r.proteins, r.fibers, r.salt,r.kcal, r.kjoule, r.diet, r.veggie, r.gluten_free, r.lactose_free, r.creation_date, r.publish_up,r.publish_down, r.preparation_time, r.cook_time, r.wait_time, r.picture, r.video, r.published, r.cuisine,r.validated, r.featured, r.nb_views, r.note, r.language, l.title as language_title, st.code as servings_type_code,r.metakey, r.metadata, r.use_slider, r.price,
  CASE WHEN CHARACTER_LENGTH(r.alias) THEN CONCAT_WS(':', r.id, r.alias) ELSE r.id END as slug,
  CASE WHEN CHARACTER_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,
  CASE WHEN fr.recipe_id = r.id THEN 1 ELSE 0 END as favourite,ua.username AS author_name,ua.email AS author_email,ag.title AS access_level

  FROM ersq_yoorecipe as r

  LEFT JOIN ersq_users ua 
  ON ua.id = r.created_by

  LEFT JOIN ersq_yoorecipe_categories cc 
  on cc.recipe_id = r.id

  LEFT JOIN ersq_categories c 
  on cc.cat_id  = c.id

  LEFT JOIN ersq_yoorecipe_favourites AS fr 
  ON fr.recipe_id = r.id 
  AND fr.user_id = '0'

  LEFT JOIN ersq_languages AS l 
  ON l.lang_code = r.language

  LEFT JOIN ersq_yoorecipe_serving_types st 
  ON st.id = r.serving_type_id

  LEFT JOIN ersq_viewlevels AS ag 
  ON ag.id = r.access

  WHERE r.id = '19'

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	ua	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	cc	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	219	100.00	Using where
1	SIMPLE	c	NULL	eq_ref	PRIMARY	PRIMARY	4	joomlaxl_jmln2.cc.cat_id	1	100.00	NULL
1	SIMPLE	fr	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	const	1	100.00	NULL
1	SIMPLE	st	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	ag	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where

**Profile**

Status	Duration
starting	0.24 ms
checking permissions	0.00 ms
checking permissions	0.01 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.01 ms
Opening tables	2.28 ms
init	0.12 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.65 ms
preparing	0.04 ms
executing	0.00 ms
Sending data	1.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.10 ms
freeing items	0.04 ms
cleaning up	0.07 ms

**Call Stack**

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_yoorecipe/models/yoorecipe.php:334
10	YooRecipeModelYooRecipe->getRecipeById()	JROOT/components/com_yoorecipe/views/recipe/view.html.php:50
9	YooRecipeViewRecipe->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_yoorecipe/yoorecipe.php:55
6	require_once JROOT/components/com_yoorecipe/yoorecipe.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.11 ms** **After last query: 1.73 ms** **Query memory: 0.019 MB Memory before query: 9.022 MB** **Rows returned: 1**

SELECT id, label

  FROM ersq_yoorecipe_ingredients_groups

  WHERE recipe_id = 19

  ORDER BY ordering asc

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_yoorecipe_ingredients_groups	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	67	10.00	Using where; Using filesort

**Profile**

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.41 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.47 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

**Call Stack**

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_yoorecipe/models/ingredientsgroups.php:218
11	YooRecipeModelIngredientsGroups->getIngredientsGroupsByRecipeId()	JROOT/administrator/components/com_yoorecipe/models/yoorecipe.php:341
10	YooRecipeModelYooRecipe->getRecipeById()	JROOT/components/com_yoorecipe/views/recipe/view.html.php:50
9	YooRecipeViewRecipe->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_yoorecipe/yoorecipe.php:55
6	require_once JROOT/components/com_yoorecipe/yoorecipe.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.52 ms** **After last query: 0.13 ms** **Query memory: 0.020 MB Memory before query: 9.041 MB** **Rows returned: 7**

SELECT i.id, i.recipe_id, i.ordering, i.quantity, i.unit, i.description, i.group_id

  FROM ersq_yoorecipe_ingredients i

  WHERE group_id = 186

  ORDER BY ordering asc

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	i	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	156	10.00	Using where; Using filesort

**Profile**

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.67 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.62 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

**Call Stack**

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_yoorecipe/models/ingredients.php:73
11	YooRecipeModelIngredients->getIngredientsByGroupId()	JROOT/administrator/components/com_yoorecipe/models/yoorecipe.php:343
10	YooRecipeModelYooRecipe->getRecipeById()	JROOT/components/com_yoorecipe/views/recipe/view.html.php:50
9	YooRecipeViewRecipe->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_yoorecipe/yoorecipe.php:55
6	require_once JROOT/components/com_yoorecipe/yoorecipe.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.23 ms** **After last query: 0.93 ms** **Query memory: 0.018 MB Memory before query: 9.105 MB** **Rows returned: 8**

SELECT cat_id

  FROM ersq_yoorecipe_categories

  WHERE recipe_id = '19'

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_yoorecipe_categories	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	219	10.00	Using where

**Profile**

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.02 ms
executing	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.02 ms
cleaning up	0.01 ms

**Call Stack**

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
12	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_yoorecipe/models/crosscategory.php:93
11	YooRecipeModelCrossCategory->getRecipeCategoriesIds()	JROOT/administrator/components/com_yoorecipe/models/yoorecipe.php:349
10	YooRecipeModelYooRecipe->getRecipeById()	JROOT/components/com_yoorecipe/views/recipe/view.html.php:50
9	YooRecipeViewRecipe->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_yoorecipe/yoorecipe.php:55
6	require_once JROOT/components/com_yoorecipe/yoorecipe.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 2.03 ms** **After last query: 0.63 ms** **Query memory: 0.018 MB Memory before query: 9.147 MB** **Rows returned: 0**

SELECT month_id

  FROM ersq_yoorecipe_seasons

  WHERE recipe_id = '19'

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

**Profile**

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	1.86 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

**Call Stack**

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
12	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_yoorecipe/models/seasons.php:37
11	YooRecipeModelSeasons->getRecipeSeasonsIds()	JROOT/administrator/components/com_yoorecipe/models/yoorecipe.php:354
10	YooRecipeModelYooRecipe->getRecipeById()	JROOT/components/com_yoorecipe/views/recipe/view.html.php:50
9	YooRecipeViewRecipe->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_yoorecipe/yoorecipe.php:55
6	require_once JROOT/components/com_yoorecipe/yoorecipe.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 2.61 ms** **After last query: 0.81 ms** **Query memory: 0.021 MB Memory before query: 9.190 MB** **Rows returned: 2**

SELECT r.id, r.recipe_id, r.note, r.author, r.user_id, r.comment, r.abuse, r.published, r.creation_date,ua.username AS author_name

  FROM ersq_yoorecipe_reviews r

  LEFT JOIN ersq_users ua 
  ON ua.id = r.user_id

  WHERE recipe_id = '19'

  ORDER BY creation_date desc

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	452	10.00	Using where; Using filesort
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	joomlaxl_jmln2.r.user_id	1	100.00	NULL

**Profile**

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.61 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	1.74 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

**Call Stack**

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_yoorecipe/models/reviews.php:70
11	YooRecipeModelReviews->getReviewsByRecipeId()	JROOT/administrator/components/com_yoorecipe/models/yoorecipe.php:359
10	YooRecipeModelYooRecipe->getRecipeById()	JROOT/components/com_yoorecipe/views/recipe/view.html.php:50
9	YooRecipeViewRecipe->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_yoorecipe/yoorecipe.php:55
6	require_once JROOT/components/com_yoorecipe/yoorecipe.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.50 ms** **After last query: 37.41 ms** **Query memory: 0.021 MB Memory before query: 9.461 MB** **Rows returned: 1**

**Duplicate queries**: #42 #67 #68 #75 #76 #82 #83

select `params` 
  from ersq_ijseo_config

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_ijseo_config	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

**Profile**

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.22 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 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.03 ms
freeing items	0.02 ms
cleaning up	0.01 ms

**Call Stack**

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
15	JDatabase->query()	JROOT/plugins/system/ijseo/ijseo.php:756
14	plgSystemIjseo->getComponentParams()	JROOT/plugins/system/ijseo/ijseo.php:765
13	plgSystemIjseo->onContentPrepare()	*Same as call in the line below.*
12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/components/com_yoorecipe/views/recipe/view.html.php:65
9	YooRecipeViewRecipe->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_yoorecipe/yoorecipe.php:55
6	require_once JROOT/components/com_yoorecipe/yoorecipe.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.14 ms** **After last query: 0.14 ms** **Query memory: 0.021 MB Memory before query: 9.481 MB** **Rows returned: 1**

**Duplicate queries**: #41 #67 #68 #75 #76 #82 #83

select `params` 
  from ersq_ijseo_config

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_ijseo_config	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

**Profile**

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

**Call Stack**

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
15	JDatabaseDriver->loadColumn()	JROOT/plugins/system/ijseo/ijseo.php:757
14	plgSystemIjseo->getComponentParams()	JROOT/plugins/system/ijseo/ijseo.php:765
13	plgSystemIjseo->onContentPrepare()	*Same as call in the line below.*
12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/components/com_yoorecipe/views/recipe/view.html.php:65
9	YooRecipeViewRecipe->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_yoorecipe/yoorecipe.php:55
6	require_once JROOT/components/com_yoorecipe/yoorecipe.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.30 ms** **After last query: 0.26 ms** **Query memory: 0.020 MB Memory before query: 9.508 MB** **Rows returned: 1**

**Duplicate queries**: #44 #69 #70

select max(`checkdate`) 
  from ersq_ijseo_keys 
  limit 0,1

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_ijseo_keys	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

**Profile**

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

**Call Stack**

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
14	JDatabase->query()	JROOT/plugins/system/ijseo/ijseo.php:776
13	plgSystemIjseo->onContentPrepare()	*Same as call in the line below.*
12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/components/com_yoorecipe/views/recipe/view.html.php:65
9	YooRecipeViewRecipe->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_yoorecipe/yoorecipe.php:55
6	require_once JROOT/components/com_yoorecipe/yoorecipe.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.13 ms** **After last query: 0.13 ms** **Query memory: 0.020 MB Memory before query: 9.527 MB** **Rows returned: 1**

**Duplicate queries**: #43 #69 #70

select max(`checkdate`) 
  from ersq_ijseo_keys 
  limit 0,1

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_ijseo_keys	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

**Profile**

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

**Call Stack**

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
14	JDatabaseDriver->loadColumn()	JROOT/plugins/system/ijseo/ijseo.php:777
13	plgSystemIjseo->onContentPrepare()	*Same as call in the line below.*
12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/components/com_yoorecipe/views/recipe/view.html.php:65
9	YooRecipeViewRecipe->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_yoorecipe/yoorecipe.php:55
6	require_once JROOT/components/com_yoorecipe/yoorecipe.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.20 ms** **After last query: 0.17 ms** **Query memory: 0.021 MB Memory before query: 9.546 MB** **Rows returned: 0**

**Duplicate queries**: #46 #71 #72

select * 
  from ersq_ijseo_keys as a 
  where 1<=(SELECT DATEDIFF('2024-04-18 21:05:04',a.checkdate)) OR a.checkdate='0000-00-00 00:00:00' 
  order by checkdate asc 
  limit 0,10

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
14	JDatabase->query()	JROOT/plugins/system/ijseo/ijseo.php:786
13	plgSystemIjseo->onContentPrepare()	*Same as call in the line below.*
12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/components/com_yoorecipe/views/recipe/view.html.php:65
9	YooRecipeViewRecipe->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_yoorecipe/yoorecipe.php:55
6	require_once JROOT/components/com_yoorecipe/yoorecipe.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.15 ms** **After last query: 0.11 ms** **Query memory: 0.021 MB Memory before query: 9.566 MB** **Rows returned: 0**

**Duplicate queries**: #45 #71 #72

select * 
  from ersq_ijseo_keys as a 
  where 1<=(SELECT DATEDIFF('2024-04-18 21:05:04',a.checkdate)) OR a.checkdate='0000-00-00 00:00:00' 
  order by checkdate asc 
  limit 0,10

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
14	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/ijseo/ijseo.php:789
13	plgSystemIjseo->onContentPrepare()	*Same as call in the line below.*
12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/components/com_yoorecipe/views/recipe/view.html.php:65
9	YooRecipeViewRecipe->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_yoorecipe/yoorecipe.php:55
6	require_once JROOT/components/com_yoorecipe/yoorecipe.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: 10.46 ms** **Query memory: 0.015 MB Memory before query: 9.629 MB**

UPDATE ersq_yoorecipe

  SET nb_views = '8847'

  WHERE id = '19'

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	ersq_yoorecipe	NULL	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

**Profile**

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.03 ms
updating	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

**Call Stack**

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_yoorecipe/models/yoorecipe.php:380
10	YooRecipeModelYooRecipe->incrementViewCountOfRecipe()	JROOT/components/com_yoorecipe/views/recipe/view.html.php:71
9	YooRecipeViewRecipe->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_yoorecipe/yoorecipe.php:55
6	require_once JROOT/components/com_yoorecipe/yoorecipe.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.13 ms** **After last query: 0.56 ms** **Query memory: 0.024 MB Memory before query: 9.657 MB** **Rows returned: 52**

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

  FROM `ersq_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_admintools','com_ajax','com_akeeba','com_associations','com_banners','com_bfstop','com_cache','com_categories','com_checkin','com_comprofiler','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_dbreplacer','com_fields','com_finder','com_flexicontact','com_ijoomla_seo','com_installer','com_jaextmanager','com_jce','com_jnews','com_joomlaupdate','com_jusertube','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_mijoshop','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_poweradmin2','com_privacy','com_redirect','com_roksprocket','com_search','com_securitycheck','com_tags','com_templates','com_universal_ajax_live_search','com_users','com_weblinks','com_wrapper','com_yoorecipe')

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_assets	NULL	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	475	11.16	Using where

**Profile**

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

**Call Stack**

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
14	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
13	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
12	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
11	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
10	Joomla\CMS\User\User->authorise()	JROOT/components/com_yoorecipe/views/recipe/view.html.php:76
9	YooRecipeViewRecipe->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_yoorecipe/yoorecipe.php:55
6	require_once JROOT/components/com_yoorecipe/yoorecipe.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.40 ms** **Query memory: 0.024 MB Memory before query: 9.783 MB** **Rows returned: 8**

SELECT c.id, c.parent_id, c.lft, c.rgt, c.level, c.path, c.extension, c.title, c.alias, c.note, c.description, c.published, c.checked_out, c.checked_out_time, c.access, c.params, c.metadesc, c.metakey, c.metadata , c.created_user_id, c.created_time, c.modified_user_id, c.modified_time, c.hits, c.language

  FROM ersq_categories c

  LEFT JOIN ersq_yoorecipe_categories cc 
  on cc.cat_id = c.id

  WHERE cc.recipe_id = '19' 
  AND c.published = 1

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cc	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	219	10.00	Using where
1	SIMPLE	c	NULL	eq_ref	PRIMARY	PRIMARY	4	joomlaxl_jmln2.cc.cat_id	1	10.00	Using where

**Profile**

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

**Call Stack**

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_yoorecipe/models/categories.php:399
10	YooRecipeModelCategories->getRecipeCategories()	JROOT/components/com_yoorecipe/views/recipe/view.html.php:85
9	YooRecipeViewRecipe->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_yoorecipe/yoorecipe.php:55
6	require_once JROOT/components/com_yoorecipe/yoorecipe.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.98 ms** **After last query: 7.44 ms** **Query memory: 0.026 MB Memory before query: 9.880 MB** **Rows returned: 9**

SELECT `m`.`tag_id`,`t`.*

  FROM `ersq_contentitem_tag_map` AS m 

  INNER JOIN `ersq_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_yoorecipe.recipe' 
  AND `m`.`content_item_id` = 19 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	698	1.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	joomlaxl_jmln2.m.tag_id	1	100.00	Using where

**Profile**

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

**Call Stack**

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
10	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_yoorecipe/views/recipe/view.html.php:90
9	YooRecipeViewRecipe->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_yoorecipe/yoorecipe.php:55
6	require_once JROOT/components/com_yoorecipe/yoorecipe.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.32 ms** **After last query: 0.38 ms** **Query memory: 0.017 MB Memory before query: 9.948 MB** **Rows returned: 1**

SELECT count(id)

  FROM ersq_yoorecipe_mealplanners_queues

  WHERE recipe_id = '19' 
  AND user_id = '0'

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
11	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_yoorecipe/models/mealplannerqueue.php:243
10	YooRecipeModelMealPlannerQueue->isRecipeQueued()	JROOT/components/com_yoorecipe/views/recipe/view.html.php:94
9	YooRecipeViewRecipe->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_yoorecipe/yoorecipe.php:55
6	require_once JROOT/components/com_yoorecipe/yoorecipe.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: 5.08 ms** **After last query: 0.28 ms** **Query memory: 0.041 MB Memory before query: 9.972 MB** **Rows returned: 7**

SELECT r.id, r.access, r.title, r.alias, r.description, r.created_by, r.preparation, r.notes, r.serving_type_id, r.nb_persons, r.difficulty, r.cost, r.sugar, r.carbs, r.fat, r.saturated_fat, r.cholesterol, r.proteins, r.fibers, r.salt, r.kcal, r.kjoule, r.diet, r.veggie, r.gluten_free, r.lactose_free, r.creation_date, r.publish_up, r.publish_down, r.preparation_time, r.cook_time, r.wait_time, r.picture, r.video, r.published, r.validated, r.featured, r.nb_views, r.note, r.language

  FROM ersq_yoorecipe r

  LEFT JOIN ersq_yoorecipe_categories cc 
  on cc.recipe_id = r.id

  WHERE cc.cat_id IN ('40','44','81','84','11','23','58','67') 
  AND r.title REGEXP 'Creamy|Strawberry|Vanilla|Vegan|Cream' 
  AND r.published = 1 
  AND r.validated = 1 
  AND r.id != '19' 
  AND r.language IN ('en-US','*')

  GROUP BY r.id

  ORDER BY r.title asc 
  LIMIT 10

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r	NULL	ref	PRIMARY,published	published	2	const,const	23	20.00	Using where; Using temporary; Using filesort
1	SIMPLE	cc	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	219	5.00	Using where; Using join buffer (Block Nested Loop)

**Profile**

Status	Duration
starting	1.79 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.10 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
Creating tmp table	0.04 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	2.51 ms
Creating sort index	0.35 ms
end	0.00 ms
query end	0.02 ms
removing tmp table	0.05 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.02 ms

**Call Stack**

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_yoorecipe/models/yoorecipe.php:491
10	YooRecipeModelYooRecipe->getSimilarRecipes()	JROOT/components/com_yoorecipe/views/recipe/view.html.php:99
9	YooRecipeViewRecipe->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_yoorecipe/yoorecipe.php:55
6	require_once JROOT/components/com_yoorecipe/yoorecipe.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.57 ms** **After last query: 3.09 ms** **Query memory: 0.025 MB Memory before query: 10.132 MB** **Rows returned: 77**

SELECT id, title, alias, parent_id, level, lft, rgt, language,
  CASE WHEN CHARACTER_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END as slug

  FROM ersq_categories

  WHERE extension = 'com_yoorecipe' 
  and published = 1

  ORDER BY lft asc

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_categories	NULL	ALL	cat_idx	NO INDEX KEY COULD BE USED	NULL	NULL	111	69.37	Using where; Using filesort

**Profile**

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

**Call Stack**

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_yoorecipe/models/categories.php:204
10	YooRecipeModelCategories->getAllPublishedCategories()	JROOT/components/com_yoorecipe/views/recipe/view.html.php:109
9	YooRecipeViewRecipe->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_yoorecipe/yoorecipe.php:55
6	require_once JROOT/components/com_yoorecipe/yoorecipe.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.43 ms** **After last query: 37.88 ms** **Query memory: 0.016 MB Memory before query: 10.787 MB** **Rows returned: 0**

**Duplicate queries**: #55

select `menutype` 
  from ersq_menu 
  where  1=1  
  and link like '%option=com_yoorecipe%' 
  and link like '%view=recipe%' 
  and link like '%id=19%' 
  and `published`=1

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_menu	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	194	0.52	Using where

**Profile**

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

**Call Stack**

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
11	JDatabase->query()	JROOT/plugins/system/ijseo/ijseo.php:173
10	plgSystemIjseo->isMenu()	JROOT/plugins/system/ijseo/ijseo.php:112
9	plgSystemIjseo->getMetaValues()	JROOT/plugins/system/ijseo/ijseo.php:60
8	plgSystemIjseo->onAfterDispatch()	*Same as call in the line below.*
7	call_user_func_array()	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.28 ms** **After last query: 0.07 ms** **Query memory: 0.017 MB Memory before query: 10.802 MB** **Rows returned: 0**

**Duplicate queries**: #54

select `menutype` 
  from ersq_menu 
  where  1=1  
  and link like '%option=com_yoorecipe%' 
  and link like '%view=recipe%' 
  and link like '%id=19%' 
  and `published`=1

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_menu	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	194	0.52	Using where

**Profile**

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

**Call Stack**

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
11	JDatabaseDriver->loadColumn()	JROOT/plugins/system/ijseo/ijseo.php:174
10	plgSystemIjseo->isMenu()	JROOT/plugins/system/ijseo/ijseo.php:112
9	plgSystemIjseo->getMetaValues()	JROOT/plugins/system/ijseo/ijseo.php:60
8	plgSystemIjseo->onAfterDispatch()	*Same as call in the line below.*
7	call_user_func_array()	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.55 ms** **After last query: 18.43 ms** **Query memory: 0.015 MB Memory before query: 10.970 MB** **Rows returned: 0**

SELECT * 
  FROM ersq_jsn_poweradmin2_menu_assets 
  WHERE menuId = 101 
  AND type = 'css';

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

**Profile**

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.25 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

**Call Stack**

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
9	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_poweradmin2/helpers/poweradmin2.php:530
8	JSNPowerAdmin2Helper::getCustomAssets()	JROOT/plugins/system/poweradmin2/poweradmin2.php:826
7	plgSystemPowerAdmin2->onBeforeRender()	*Same as call in the line below.*
6	call_user_func_array()	JROOT/libraries/joomla/event/dispatcher.php:165
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1034
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.14 ms** **After last query: 0.08 ms** **Query memory: 0.014 MB Memory before query: 10.983 MB** **Rows returned: 1**

**Duplicate queries**: #61

SELECT parent_id 
  FROM ersq_menu 
  WHERE id = 101;

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_menu	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

**Profile**

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

**Call Stack**

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
9	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_poweradmin2/helpers/poweradmin2.php:544
8	JSNPowerAdmin2Helper::getCustomAssets()	JROOT/plugins/system/poweradmin2/poweradmin2.php:826
7	plgSystemPowerAdmin2->onBeforeRender()	*Same as call in the line below.*
6	call_user_func_array()	JROOT/libraries/joomla/event/dispatcher.php:165
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1034
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.11 ms** **After last query: 0.08 ms** **Query memory: 0.015 MB Memory before query: 10.995 MB** **Rows returned: 0**

SELECT * 
  FROM ersq_jsn_poweradmin2_menu_assets 
  WHERE menuId = 1 
  AND type = 'css';

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

**Profile**

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

**Call Stack**

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
9	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_poweradmin2/helpers/poweradmin2.php:548
8	JSNPowerAdmin2Helper::getCustomAssets()	JROOT/plugins/system/poweradmin2/poweradmin2.php:826
7	plgSystemPowerAdmin2->onBeforeRender()	*Same as call in the line below.*
6	call_user_func_array()	JROOT/libraries/joomla/event/dispatcher.php:165
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1034
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.09 ms** **After last query: 0.06 ms** **Query memory: 0.014 MB Memory before query: 11.008 MB** **Rows returned: 1**

**Duplicate queries**: #63

SELECT parent_id 
  FROM ersq_menu 
  WHERE id = 1;

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_menu	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

**Profile**

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

**Call Stack**

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
9	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_poweradmin2/helpers/poweradmin2.php:544
8	JSNPowerAdmin2Helper::getCustomAssets()	JROOT/plugins/system/poweradmin2/poweradmin2.php:826
7	plgSystemPowerAdmin2->onBeforeRender()	*Same as call in the line below.*
6	call_user_func_array()	JROOT/libraries/joomla/event/dispatcher.php:165
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1034
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.09 ms** **After last query: 0.06 ms** **Query memory: 0.015 MB Memory before query: 11.021 MB** **Rows returned: 0**

SELECT * 
  FROM ersq_jsn_poweradmin2_menu_assets 
  WHERE menuId = 101 
  AND type = 'js';

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

**Profile**

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
executing	0.00 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

**Call Stack**

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
9	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_poweradmin2/helpers/poweradmin2.php:530
8	JSNPowerAdmin2Helper::getCustomAssets()	JROOT/plugins/system/poweradmin2/poweradmin2.php:826
7	plgSystemPowerAdmin2->onBeforeRender()	*Same as call in the line below.*
6	call_user_func_array()	JROOT/libraries/joomla/event/dispatcher.php:165
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1034
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.07 ms** **After last query: 0.05 ms** **Query memory: 0.014 MB Memory before query: 11.034 MB** **Rows returned: 1**

**Duplicate queries**: #57

SELECT parent_id 
  FROM ersq_menu 
  WHERE id = 101;

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_menu	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

**Profile**

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

**Call Stack**

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
9	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_poweradmin2/helpers/poweradmin2.php:544
8	JSNPowerAdmin2Helper::getCustomAssets()	JROOT/plugins/system/poweradmin2/poweradmin2.php:826
7	plgSystemPowerAdmin2->onBeforeRender()	*Same as call in the line below.*
6	call_user_func_array()	JROOT/libraries/joomla/event/dispatcher.php:165
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1034
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.08 ms** **After last query: 0.05 ms** **Query memory: 0.015 MB Memory before query: 11.047 MB** **Rows returned: 0**

SELECT * 
  FROM ersq_jsn_poweradmin2_menu_assets 
  WHERE menuId = 1 
  AND type = 'js';

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

**Profile**

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
executing	0.00 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

**Call Stack**

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
9	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_poweradmin2/helpers/poweradmin2.php:548
8	JSNPowerAdmin2Helper::getCustomAssets()	JROOT/plugins/system/poweradmin2/poweradmin2.php:826
7	plgSystemPowerAdmin2->onBeforeRender()	*Same as call in the line below.*
6	call_user_func_array()	JROOT/libraries/joomla/event/dispatcher.php:165
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1034
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.07 ms** **After last query: 0.05 ms** **Query memory: 0.014 MB Memory before query: 11.060 MB** **Rows returned: 1**

**Duplicate queries**: #59

SELECT parent_id 
  FROM ersq_menu 
  WHERE id = 1;

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_menu	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

**Profile**

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

**Call Stack**

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
9	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_poweradmin2/helpers/poweradmin2.php:544
8	JSNPowerAdmin2Helper::getCustomAssets()	JROOT/plugins/system/poweradmin2/poweradmin2.php:826
7	plgSystemPowerAdmin2->onBeforeRender()	*Same as call in the line below.*
6	call_user_func_array()	JROOT/libraries/joomla/event/dispatcher.php:165
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1034
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.93 ms** **After last query: 66.80 ms** **Query memory: 0.032 MB Memory before query: 11.473 MB** **Rows returned: 3**

SHOW FULL COLUMNS 
  FROM `ersq_jnews_xonfig`

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
17	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jnews/classes/class.xonfig15.php:14
16	jNews_Config->__construct()	JROOT/administrator/components/com_jnews/classes/class.jnews.php:42
15	require_once JROOT/administrator/components/com_jnews/classes/class.jnews.php	JROOT/modules/mod_jnews/mod_jnews.php:26
14	include JROOT/modules/mod_jnews/mod_jnews.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:227
13	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	*Same as call in the line below.*
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:610
9	Joomla\CMS\Helper\_ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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.51 ms** **After last query: 0.22 ms** **Query memory: 0.034 MB Memory before query: 11.510 MB** **Rows returned: 278**

SELECT * 
  FROM `ersq_jnews_xonfig`

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_jnews_xonfig	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	278	100.00	NULL

**Profile**

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

**Call Stack**

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jnews/classes/class.xonfig15.php:53
16	jNews_Config->loadConfig()	JROOT/administrator/components/com_jnews/classes/class.jnews.php:43
15	require_once JROOT/administrator/components/com_jnews/classes/class.jnews.php	JROOT/modules/mod_jnews/mod_jnews.php:26
14	include JROOT/modules/mod_jnews/mod_jnews.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:227
13	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	*Same as call in the line below.*
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:610
9	Joomla\CMS\Helper\_ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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.19 ms** **After last query: 0.92 ms** **Query memory: 0.033 MB Memory before query: 11.600 MB** **Rows returned: 2**

SELECT * 
  FROM `ersq_jnews_lists` 
  WHERE `published` = 1

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_jnews_lists	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	50.00	Using where

**Profile**

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

**Call Stack**

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jnews/classes/class.lists.php:284
16	jNews_Lists::getSpecifiedLists()	JROOT/administrator/components/com_jnews/classes/class.module.php:124
15	jnews_module->normal()	JROOT/modules/mod_jnews/mod_jnews.php:32
14	include JROOT/modules/mod_jnews/mod_jnews.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:227
13	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	*Same as call in the line below.*
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:610
9	Joomla\CMS\Helper\_ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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: 90.16 ms** **Query memory: 0.030 MB Memory before query: 12.618 MB** **Rows returned: 1**

**Duplicate queries**: #41 #42 #68 #75 #76 #82 #83

select `params` 
  from ersq_ijseo_config

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_ijseo_config	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

**Profile**

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

**Call Stack**

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
22	JDatabase->query()	JROOT/plugins/system/ijseo/ijseo.php:756
21	plgSystemIjseo->getComponentParams()	JROOT/plugins/system/ijseo/ijseo.php:765
20	plgSystemIjseo->onContentPrepare()	*Same as call in the line below.*
19	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
17	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
16	JHtmlContent::prepare()	*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/modules/mod_roksprocket/lib/ModRokSprocket.php:24
12	ModRokSprocket->render()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:39
11	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:227
10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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.11 ms** **After last query: 0.10 ms** **Query memory: 0.029 MB Memory before query: 12.648 MB** **Rows returned: 1**

**Duplicate queries**: #41 #42 #67 #75 #76 #82 #83

select `params` 
  from ersq_ijseo_config

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_ijseo_config	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

**Profile**

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

**Call Stack**

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
22	JDatabaseDriver->loadColumn()	JROOT/plugins/system/ijseo/ijseo.php:757
21	plgSystemIjseo->getComponentParams()	JROOT/plugins/system/ijseo/ijseo.php:765
20	plgSystemIjseo->onContentPrepare()	*Same as call in the line below.*
19	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
17	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
16	JHtmlContent::prepare()	*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/modules/mod_roksprocket/lib/ModRokSprocket.php:24
12	ModRokSprocket->render()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:39
11	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:227
10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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.12 ms** **After last query: 0.17 ms** **Query memory: 0.028 MB Memory before query: 12.683 MB** **Rows returned: 1**

**Duplicate queries**: #43 #44 #70

select max(`checkdate`) 
  from ersq_ijseo_keys 
  limit 0,1

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_ijseo_keys	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

**Profile**

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

**Call Stack**

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
21	JDatabase->query()	JROOT/plugins/system/ijseo/ijseo.php:776
20	plgSystemIjseo->onContentPrepare()	*Same as call in the line below.*
19	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
17	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
16	JHtmlContent::prepare()	*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/modules/mod_roksprocket/lib/ModRokSprocket.php:24
12	ModRokSprocket->render()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:39
11	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:227
10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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.10 ms** **After last query: 0.07 ms** **Query memory: 0.028 MB Memory before query: 12.709 MB** **Rows returned: 1**

**Duplicate queries**: #43 #44 #69

select max(`checkdate`) 
  from ersq_ijseo_keys 
  limit 0,1

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_ijseo_keys	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

**Profile**

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

**Call Stack**

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
21	JDatabaseDriver->loadColumn()	JROOT/plugins/system/ijseo/ijseo.php:777
20	plgSystemIjseo->onContentPrepare()	*Same as call in the line below.*
19	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
17	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
16	JHtmlContent::prepare()	*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/modules/mod_roksprocket/lib/ModRokSprocket.php:24
12	ModRokSprocket->render()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:39
11	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:227
10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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.20 ms** **After last query: 0.12 ms** **Query memory: 0.029 MB Memory before query: 12.736 MB** **Rows returned: 0**

**Duplicate queries**: #45 #46 #72

select * 
  from ersq_ijseo_keys as a 
  where 1<=(SELECT DATEDIFF('2024-04-18 21:05:04',a.checkdate)) OR a.checkdate='0000-00-00 00:00:00' 
  order by checkdate asc 
  limit 0,10

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
21	JDatabase->query()	JROOT/plugins/system/ijseo/ijseo.php:786
20	plgSystemIjseo->onContentPrepare()	*Same as call in the line below.*
19	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
17	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
16	JHtmlContent::prepare()	*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/modules/mod_roksprocket/lib/ModRokSprocket.php:24
12	ModRokSprocket->render()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:39
11	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:227
10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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.14 ms** **After last query: 0.07 ms** **Query memory: 0.029 MB Memory before query: 12.763 MB** **Rows returned: 0**

**Duplicate queries**: #45 #46 #71

select * 
  from ersq_ijseo_keys as a 
  where 1<=(SELECT DATEDIFF('2024-04-18 21:05:04',a.checkdate)) OR a.checkdate='0000-00-00 00:00:00' 
  order by checkdate asc 
  limit 0,10

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
21	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/ijseo/ijseo.php:789
20	plgSystemIjseo->onContentPrepare()	*Same as call in the line below.*
19	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
17	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
16	JHtmlContent::prepare()	*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/modules/mod_roksprocket/lib/ModRokSprocket.php:24
12	ModRokSprocket->render()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:39
11	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:227
10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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.60 ms** **After last query: 9.80 ms** **Query memory: 0.020 MB Memory before query: 12.286 MB** **Rows returned: 9**

SELECT extension_id, name 
  FROM ersq_extensions 
  WHERE type = 'plugin' 
  AND folder = 'search' 
  AND enabled =1 
  AND access IN (1,1,5) 
  ORDER BY ordering

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_extensions	NULL	ref	extension	extension	82	const	202	0.30	Using index condition; Using where; Using filesort

**Profile**

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.19 ms
end	0.00 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.03 ms
cleaning up	0.01 ms

**Call Stack**

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1805
12	JDatabaseDriver->loadRowList()	JROOT/modules/mod_universal_ajaxlivesearch/mod_universal_ajaxlivesearch.php:196
11	include JROOT/modules/mod_universal_ajaxlivesearch/mod_universal_ajaxlivesearch.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:227
10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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.31 ms** **After last query: 13.73 ms** **Query memory: 0.024 MB Memory before query: 12.988 MB** **Rows returned: 0**

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

  FROM ersq_modules AS m

  WHERE m.id = 95 
  AND m.published = 1 
  AND m.access IN (1,1,5)

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

**Profile**

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

**Call Stack**

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
16	JDatabaseDriver->loadObject()	JROOT/plugins/system/t3/includes/menu/megamenu.php:329
15	T3MenuMegamenu->module()	JROOT/plugins/system/t3/includes/menu/megamenu.php:301
14	T3MenuMegamenu->mega()	JROOT/plugins/system/t3/includes/menu/megamenu.php:256
13	T3MenuMegamenu->item()	JROOT/plugins/system/t3/includes/menu/megamenu.php:231
12	T3MenuMegamenu->nav()	JROOT/plugins/system/t3/includes/menu/megamenu.php:307
11	T3MenuMegamenu->mega()	JROOT/plugins/system/t3/includes/menu/megamenu.php:256
10	T3MenuMegamenu->item()	JROOT/plugins/system/t3/includes/menu/megamenu.php:231
9	T3MenuMegamenu->nav()	JROOT/plugins/system/t3/includes/menu/megamenu.php:184
8	T3MenuMegamenu->render()	JROOT/plugins/system/t3/includes/renderer/megamenurender.php:86
7	JDocumentRendererMegamenuRender->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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: 42.41 ms** **Query memory: 0.016 MB Memory before query: 13.151 MB** **Rows returned: 1**

**Duplicate queries**: #41 #42 #67 #68 #76 #82 #83

select `params` 
  from ersq_ijseo_config

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_ijseo_config	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

**Profile**

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

**Call Stack**

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
11	JDatabase->query()	JROOT/plugins/system/ijseo/ijseo.php:33
10	plgSystemIjseo->getParams()	JROOT/plugins/system/ijseo/ijseo.php:1216
9	plgSystemIjseo->titleplg()	JROOT/plugins/system/ijseo/ijseo.php:1212
8	plgSystemIjseo->onAfterRender()	*Same as call in the line below.*
7	call_user_func_array()	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/CMSApplication.php:1050
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.10 ms** **After last query: 0.07 ms** **Query memory: 0.016 MB Memory before query: 13.166 MB** **Rows returned: 1**

**Duplicate queries**: #41 #42 #67 #68 #75 #82 #83

select `params` 
  from ersq_ijseo_config

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_ijseo_config	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

**Profile**

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

**Call Stack**

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
11	JDatabaseDriver->loadColumn()	JROOT/plugins/system/ijseo/ijseo.php:34
10	plgSystemIjseo->getParams()	JROOT/plugins/system/ijseo/ijseo.php:1216
9	plgSystemIjseo->titleplg()	JROOT/plugins/system/ijseo/ijseo.php:1212
8	plgSystemIjseo->onAfterRender()	*Same as call in the line below.*
7	call_user_func_array()	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/CMSApplication.php:1050
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.30 ms** **After last query: 8.53 ms** **Query memory: 0.015 MB Memory before query: 13.193 MB**

REPLACE INTO `ersq_jnews_xonfig` (`akey`, `text`, `value`)  
  VALUES ( 'nextdate' , '1713474905' , '0' )

**Explain**

**EXPLAIN not possible on query: REPLACE INTO `ersq_jnews_xonfig` (`akey`, `text`, `value`) VALUES ( 'nextdate' , '1713474905' , '0' )**

**Profile**

Status	Duration
starting	0.07 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
update	0.09 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

**Call Stack**

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
11	JDatabase->query()	JROOT/administrator/components/com_jnews/classes/class.xonfig15.php:99
10	jNews_Config->insert()	JROOT/administrator/components/com_jnews/classes/class.xonfig15.php:112
9	jNews_Config->update()	JROOT/plugins/system/jnewscron/jnewscron.php:49
8	plgSystemJnewscron->onAfterRender()	*Same as call in the line below.*
7	call_user_func_array()	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/CMSApplication.php:1050
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.15 ms** **After last query: 0.50 ms** **Query memory: 0.015 MB Memory before query: 13.210 MB**

REPLACE INTO `ersq_jnews_xonfig` (`akey`, `text`, `value`)  
  VALUES ( 'lastdate' , '1713474305' , '0' )

**Explain**

**EXPLAIN not possible on query: REPLACE INTO `ersq_jnews_xonfig` (`akey`, `text`, `value`) VALUES ( 'lastdate' , '1713474305' , '0' )**

**Profile**

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
update	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

**Call Stack**

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
11	JDatabase->query()	JROOT/administrator/components/com_jnews/classes/class.xonfig15.php:99
10	jNews_Config->insert()	JROOT/administrator/components/com_jnews/classes/class.xonfig15.php:112
9	jNews_Config->update()	JROOT/plugins/system/jnewscron/jnewscron.php:99
8	plgSystemJnewscron->onAfterRender()	*Same as call in the line below.*
7	call_user_func_array()	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/CMSApplication.php:1050
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.20 ms** **After last query: 14.97 ms** **Query memory: 0.014 MB Memory before query: 13.338 MB** **Rows returned: 1**

SELECT params 
  FROM `ersq_ijseo_config`

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_ijseo_config	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

**Profile**

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 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.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

**Call Stack**

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
9	JDatabaseDriver->loadColumn()	JROOT/plugins/content/ijseo_plugin/ijseo_plugin.php:1198
8	plgContentIjseo_plugin->onAfterRender()	*Same as call in the line below.*
7	call_user_func_array()	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/CMSApplication.php:1050
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.59 ms** **After last query: 2.23 ms** **Query memory: 0.018 MB Memory before query: 13.511 MB** **Rows returned: 0**

**Duplicate queries**: #81

SELECT i.*
            
  FROM ersq_ijseo_ilinks AS i
            
  LEFT JOIN ersq_ijseo_ilinks_articles AS ia 
  ON i.id = ia.ilink_id
            
  WHERE ( i.published =1 
  AND ia.article_id = ''  
  AND i.include_in = 1 )
            OR ( i.published =1 
  AND i.include_in = 0 )

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	i	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
1	SIMPLE	ia	NULL	ref	PRIMARY	PRIMARY	4	joomlaxl_jmln2.i.id	1	100.00	Using where; Using index

**Profile**

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

**Call Stack**

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
9	JDatabase->query()	JROOT/plugins/content/ijseo_plugin/ijseo_plugin.php:1238
8	plgContentIjseo_plugin->onAfterRender()	*Same as call in the line below.*
7	call_user_func_array()	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/CMSApplication.php:1050
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.19 ms** **After last query: 0.06 ms** **Query memory: 0.018 MB Memory before query: 13.525 MB** **Rows returned: 0**

**Duplicate queries**: #80

SELECT i.*
            
  FROM ersq_ijseo_ilinks AS i
            
  LEFT JOIN ersq_ijseo_ilinks_articles AS ia 
  ON i.id = ia.ilink_id
            
  WHERE ( i.published =1 
  AND ia.article_id = ''  
  AND i.include_in = 1 )
            OR ( i.published =1 
  AND i.include_in = 0 )

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	i	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
1	SIMPLE	ia	NULL	ref	PRIMARY	PRIMARY	4	joomlaxl_jmln2.i.id	1	100.00	Using where; Using index

**Profile**

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

**Call Stack**

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
9	JDatabaseDriver->loadAssocList()	JROOT/plugins/content/ijseo_plugin/ijseo_plugin.php:1239
8	plgContentIjseo_plugin->onAfterRender()	*Same as call in the line below.*
7	call_user_func_array()	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/CMSApplication.php:1050
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.11 ms** **After last query: 0.23 ms** **Query memory: 0.016 MB Memory before query: 13.538 MB** **Rows returned: 1**

**Duplicate queries**: #41 #42 #67 #68 #75 #76 #83

select `params` 
  from ersq_ijseo_config

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_ijseo_config	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

**Profile**

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

**Call Stack**

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
11	JDatabase->query()	JROOT/plugins/content/ijseo_plugin/ijseo_plugin.php:32
10	plgContentIjseo_plugin->getParams()	JROOT/plugins/content/ijseo_plugin/ijseo_plugin.php:1399
9	plgContentIjseo_plugin->titleplg()	JROOT/plugins/content/ijseo_plugin/ijseo_plugin.php:1395
8	plgContentIjseo_plugin->onAfterRender()	*Same as call in the line below.*
7	call_user_func_array()	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/CMSApplication.php:1050
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.08 ms** **After last query: 0.05 ms** **Query memory: 0.016 MB Memory before query: 13.553 MB** **Rows returned: 1**

**Duplicate queries**: #41 #42 #67 #68 #75 #76 #82

select `params` 
  from ersq_ijseo_config

**Explain**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ersq_ijseo_config	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

**Profile**

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

**Call Stack**

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
11	JDatabaseDriver->loadColumn()	JROOT/plugins/content/ijseo_plugin/ijseo_plugin.php:33
10	plgContentIjseo_plugin->getParams()	JROOT/plugins/content/ijseo_plugin/ijseo_plugin.php:1399
9	plgContentIjseo_plugin->titleplg()	JROOT/plugins/content/ijseo_plugin/ijseo_plugin.php:1395
8	plgContentIjseo_plugin->onAfterRender()	*Same as call in the line below.*
7	call_user_func_array()	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/CMSApplication.php:1050
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.**]

55 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

**8 × select `params` 
  from ersq_ijseo_confi**

**4 × SELECT parent_id 
  FROM ersq_menu**

**4 × SELECT * 
  FROM ersq_jsn_poweradmin2_menu_assets**

**4 × select * 
  from ersq_ijseo_keys as a**

**4 × select max(`checkdate`) 
  from ersq_ijseo_keys 
  limit 0,**

**2 × SELECT params 
  FROM ersq_extensions**

**2 × SELECT * 
  FROM ersq_extensions**

**2 × SELECT id, ipaddress, crdate, duration 
  FROM ersq_bfstop_bannedip b**

**2 × SELECT id, ipaddress 
  from ersq_bfstop_allowlist**

**2 × select `menutype` 
  from ersq_menu**

**2 × SELECT `extension_id` 
  FROM `ersq_extensions`**

**2 × SELECT template 
  FROM ersq_template_styles as s**

**2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `ersq_extensions`**

**2 × SELECT i.*
             
  FROM ersq_ijseo_ilinks AS i
             
  LEFT JOIN ersq_ijseo_ilinks_articles AS ia 
  ON i.id = ia.ilink_id**

**1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `ersq_contentitem_tag_map` AS m  
  INNER JOIN `ersq_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`**

**1 × SELECT c.id, c.parent_id, c.lft, c.rgt, c.level, c.path, c.extension, c.title, c.alias, c.note, c.description, c.published, c.checked_out, c.checked_out_time, c.access, c.params, c.metadesc, c.metakey, c.metadata , c.created_user_id, c.created_time, c.modified_user_id, c.modified_time, c.hits, c.language 
  FROM ersq_categories c 
  LEFT JOIN ersq_yoorecipe_categories cc 
  on cc.cat_id = c.id**

**1 × SELECT params 
  FROM `ersq_ijseo_config**

**1 × SELECT count(id) 
  FROM ersq_yoorecipe_mealplanners_queues**

**1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `ersq_assets`**

**1 × SELECT r.id, r.access, r.title, r.alias, r.description, r.created_by, r.preparation, r.notes, r.serving_type_id, r.nb_persons, r.difficulty, r.cost, r.sugar, r.carbs, r.fat, r.saturated_fat, r.cholesterol, r.proteins, r.fibers, r.salt, r.kcal, r.kjoule, r.diet, r.veggie, r.gluten_free, r.lactose_free, r.creation_date, r.publish_up, r.publish_down, r.preparation_time, r.cook_time, r.wait_time, r.picture, r.video, r.published, r.validated, r.featured, r.nb_views, r.note, r.language 
  FROM ersq_yoorecipe r 
  LEFT JOIN ersq_yoorecipe_categories cc 
  on cc.recipe_id = r.id**

**1 × SELECT * 
  FROM `ersq_jnews_xonfig**

**1 × SELECT r.id, r.recipe_id, r.note, r.author, r.user_id, r.comment, r.abuse, r.published, r.creation_date,ua.username AS author_name 
  FROM ersq_yoorecipe_reviews r 
  LEFT JOIN ersq_users ua 
  ON ua.id = r.user_id**

**1 × SELECT * 
  FROM `ersq_jnews_lists`**

**1 × SELECT extension_id, name 
  FROM ersq_extensions**

**1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params 
  FROM ersq_modules AS m**

**1 × SELECT id, title, alias, parent_id, level, lft, rgt, language,
  CASE WHEN CHARACTER_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END as slug 
  FROM ersq_categories**

**1 × SELECT r.id, r.access, r.title, r.alias, r.description, r.created_by, r.preparation, r.notes, r.serving_type_id,r.nb_persons, r.difficulty, r.cost, r.sugar, r.carbs, r.fat, r.saturated_fat, r.cholesterol, r.proteins, r.fibers, r.salt,r.kcal, r.kjoule, r.diet, r.veggie, r.gluten_free, r.lactose_free, r.creation_date, r.publish_up,r.publish_down, r.preparation_time, r.cook_time, r.wait_time, r.picture, r.video, r.published, r.cuisine,r.validated, r.featured, r.nb_views, r.note, r.language, l.title as language_title, st.code as servings_type_code,r.metakey, r.metadata, r.use_slider, r.price,
  CASE WHEN CHARACTER_LENGTH(r.alias) THEN CONCAT_WS(':', r.id, r.alias) ELSE r.id END as slug,
  CASE WHEN CHARACTER_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,
  CASE WHEN fr.recipe_id = r.id THEN 1 ELSE 0 END as favourite,ua.username AS author_name,ua.email AS author_email,ag.title AS access_level 
  FROM ersq_yoorecipe as r 
  LEFT JOIN ersq_users ua 
  ON ua.id = r.created_by 
  LEFT JOIN ersq_yoorecipe_categories cc 
  on cc.recipe_id = r.id 
  LEFT JOIN ersq_categories c 
  on cc.cat_id  = c.id 
  LEFT JOIN ersq_yoorecipe_favourites AS fr 
  ON fr.recipe_id = r.id 
  AND fr.user_id = '0' 
  LEFT JOIN ersq_languages AS l 
  ON l.lang_code = r.language 
  LEFT JOIN ersq_yoorecipe_serving_types st 
  ON st.id = r.serving_type_id 
  LEFT JOIN ersq_viewlevels AS ag 
  ON ag.id = r.access**

**1 × SELECT * 
  FROM `ersq_admintools_wafexceptions`**

**1 × SELECT extension, file, type 
  FROM ersq_rokcommon_configs**

**1 × SELECT `source`,`keepurlparams` 
  FROM `ersq_admintools_redirects`**

**1 × SELECT `value` 
  FROM `ersq_admintools_storage`**

**1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM ersq_extensions**

**1 × SELECT `session_id` 
  FROM `ersq_session`**

**1 × SELECT id, rules 
  FROM `ersq_viewlevels**

**1 × SELECT b.id 
  FROM ersq_usergroups AS a 
  LEFT JOIN ersq_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt**

**1 × select email 
  from ersq_users**

**1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM ersq_menu AS m 
  LEFT JOIN ersq_extensions AS e 
  ON m.component_id = e.extension_id**

**1 × SELECT id, label 
  FROM ersq_yoorecipe_ingredients_groups**

**1 × SELECT i.id, i.recipe_id, i.ordering, i.quantity, i.unit, i.description, i.group_id 
  FROM ersq_yoorecipe_ingredients i**

**1 × SELECT cat_id 
  FROM ersq_yoorecipe_categories**

**1 × SELECT `data` 
  FROM `ersq_session`**

**1 × SELECT id, title, creation_date, infos, user_id 
  FROM ersq_yoorecipe_shoppinglists as sl**

**1 × SELECT id, home, template, s.params 
  FROM ersq_template_styles as s 
  LEFT JOIN ersq_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id**

**1 × SELECT * 
  FROM ersq_languages**

**1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM ersq_modules AS m 
  LEFT JOIN ersq_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN ersq_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id**

**1 × SELECT month_id 
  FROM ersq_yoorecipe_seasons**

OTHER Tables:

**1 × SHOW FULL COLUMNS 
  FROM `ersq_jnews_xonfig**

**1 × REPLACE INTO `ersq_jnews_xonfig` (`akey`, `text`, `value`)  
  VALUES ( 'nextdate' , '1713474905' , '0'**

**1 × REPLACE INTO `ersq_jnews_xonfig` (`akey`, `text`, `value`)  
  VALUES ( 'lastdate' , '1713474305' , '0'**

**1 × UPDATE ersq_yoorecipe 
  SET nb_views = '8847'**

**1 × SHOW FULL COLUMNS 
  FROM `ersq_extensions**

**1 × UPDATE ersq_extensions 
  SET enabled=1**

**1 × UPDATE `ersq_extensions` 
  SET `params` = '{\"mediaversion\":\"7b413b89302c416d23e377edf877b8b3\"}'**

**1 × SHOW VARIABLES LIKE "collation_database**

**1 × INSERT INTO `ersq_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('r866umb8gt8k7oq0rdj4bab3q2', 1, 1713474304, 0, '', 0**

Parsing errors in language files

Language Files Loaded

**Loaded** : JROOT/language/en-US/en-US.ini
**Loaded** : JROOT/language/en-US/en-US.lib_joomla.ini
**Loaded** : JROOT/language/en-GB/en-GB.lib_fof30.ini
**Not loaded** : JROOT/language/en-US/en-US.lib_fof30.ini
**Not loaded** : JROOT/administrator/language/en-US/en-US.plg_system_admintools.ini
**Not loaded** : JROOT/plugins/system/admintools/language/en-US/en-US.plg_system_admintools.ini
**Not loaded** : JROOT/administrator/language/en-US/en-US.plg_system_jsnextfw.ini
**Not loaded** : JROOT/plugins/system/jsnextfw/language/en-US/en-US.plg_system_jsnextfw.ini
**Not loaded** : JROOT/language/en-US/en-US.plg_system_jsnextfw.ini
**Not loaded** : JROOT/administrator/language/en-US/en-US.plg_system_poweradmin2.ini
**Not loaded** : JROOT/plugins/system/poweradmin2/language/en-US/en-US.plg_system_poweradmin2.ini
**Not loaded** : JROOT/plugins/system/cachecleaner/language/en-US/en-US.plg_system_cachecleaner.ini
**Not loaded** : JROOT/administrator/language/en-US/en-US.plg_system_tjupdates.ini
**Loaded** : JROOT/administrator/language/en-US/en-US.plg_system_actionlogs.ini
**Not loaded** : JROOT/plugins/actionlog/dbreplacer/language/en-US/en-US.plg_actionlog_dbreplacer.ini
**Loaded** : JROOT/administrator/language/en-US/en-US.plg_actionlog_joomla.ini
**Loaded** : JROOT/administrator/language/en-US/en-US.plg_system_logrotation.ini
**Not loaded** : JROOT/administrator/language/en-US/en-US.plg_system_tjassetsloader.ini
**Not loaded** : JROOT/plugins/system/regularlabs/language/en-US/en-US.plg_system_regularlabs.ini
**Loaded** : JROOT/administrator/language/en-US/en-US.plg_system_updatenotification.ini
**Not loaded** : JROOT/administrator/language/en-US/en-US.plg_system_jacontenttype.ini
**Not loaded** : JROOT/plugins/system/jacontenttype/language/en-US/en-US.plg_system_jacontenttype.ini
**Not loaded** : JROOT/plugins/system/modulesanywhere/language/en-US/en-US.plg_system_modulesanywhere.ini
**Loaded** : JROOT/language/en-GB/en-GB.com_mijoshop.ini
**Not loaded** : JROOT/language/en-US/en-US.com_mijoshop.ini
**Loaded** : JROOT/administrator/language/en-GB/en-GB.com_mijoshop.old.ini
**Not loaded** : JROOT/administrator/language/en-US/en-US.com_mijoshop.old.ini
**Loaded** : JROOT/administrator/language/en-US/en-US.plg_system_logout.ini
**Not loaded** : JROOT/language/en-US/en-US.jsnextfw.ini
**Not loaded** : JROOT/language/en-US/en-US.com_poweradmin2.ini
**Not loaded** : JROOT/administrator/language/en-US/en-US.plg_poweradmin_powerpack.ini
**Not loaded** : JROOT/administrator/language/en-US/en-US.com_securitycheck.ini
**Not loaded** : JROOT/administrator/language/en-US/en-US.plg_system_lazydbbackup.ini
**Not loaded** : JROOT/plugins/system/lazydbbackup/language/en-US/en-US.plg_system_lazydbbackup.ini
**Not loaded** : JROOT/administrator/language/en-US/en-US.plg_system_t3.ini
**Not loaded** : JROOT/plugins/system/t3/language/en-US/en-US.plg_system_t3.ini
**Not loaded** : JROOT/language/en-US/en-US.com_k2.ini
**Not loaded** : JROOT/plugins/system/k2/language/en-US/en-US.com_k2.ini
**Not loaded** : JROOT/administrator/language/en-US/en-US.com_k2.dates.ini
**Not loaded** : JROOT/plugins/system/k2/language/en-US/en-US.com_k2.dates.ini
**Not loaded** : JROOT/language/en-US/en-US.tpl_t3_blank.ini
**Not loaded** : JROOT/templates/t3_blank/language/en-US/en-US.tpl_t3_blank.ini
**Not loaded** : JROOT/language/en-US/en-US.com_yoorecipe.ini
**Not loaded** : JROOT/components/com_yoorecipe/language/en-US/en-US.com_yoorecipe.ini
**Not loaded** : JROOT/administrator/language/en-US/en-US.com_yoorecipe.ini
**Loaded** : JROOT/administrator/language/en-US/en-US.ini
**Not loaded** : JROOT/administrator/language/en-US/en-US.plg_content_yoorecipe.ini
**Not loaded** : JROOT/plugins/content/yoorecipe/language/en-US/en-US.plg_content_yoorecipe.ini
**Not loaded** : JROOT/administrator/language/en-US/en-US.plg_content_authorinfobox.ini
**Not loaded** : JROOT/plugins/content/authorinfobox/language/en-US/en-US.plg_content_authorinfobox.ini
**Not loaded** : JROOT/administrator/language/en-US/en-US.plg_system_jcemediabox.ini
**Not loaded** : JROOT/plugins/system/jcemediabox/language/en-US/en-US.plg_system_jcemediabox.ini
**Not loaded** : JROOT/administrator/language/en-US/en-US.plg_system_n3tcopylink.ini
**Not loaded** : JROOT/plugins/system/n3tcopylink/language/en-US/en-US.plg_system_n3tcopylink.ini
**Loaded** : JROOT/language/en-US/en-US.mod_custom.ini
**Not loaded** : JROOT/language/en-US/en-US.mod_jnews.ini
**Not loaded** : JROOT/modules/mod_jnews/language/en-US/en-US.mod_jnews.ini
**Not loaded** : JROOT/language/en-US/en-US.mod_fbfanbox.ini
**Not loaded** : JROOT/modules/mod_fbfanbox/language/en-US/en-US.mod_fbfanbox.ini
**Not loaded** : JROOT/language/en-US/en-US.mod_roksprocket.ini
**Not loaded** : JROOT/modules/mod_roksprocket/language/en-US/en-US.mod_roksprocket.ini
**Not loaded** : JROOT/language/en-GB/en-GB.com_roksprocket.ini
**Not loaded** : JROOT/language/en-US/en-US.com_roksprocket.ini
**Loaded** : JROOT/components/com_roksprocket/language/en-GB/en-GB.com_roksprocket.ini
**Not loaded** : JROOT/components/com_roksprocket/language/en-US/en-US.com_roksprocket.ini
**Loaded** : JROOT/components/com_roksprocket/layouts/mosaic/language/en-GB/en-GB.roksprocket_layout_mosaic.ini
**Not loaded** : JROOT/components/com_roksprocket/layouts/mosaic/language/en-US/en-US.roksprocket_layout_mosaic.ini
**Loaded** : JROOT/components/com_roksprocket/layouts/grids/language/en-GB/en-GB.roksprocket_layout_grids.ini
**Not loaded** : JROOT/components/com_roksprocket/layouts/grids/language/en-US/en-US.roksprocket_layout_grids.ini
**Loaded** : JROOT/components/com_roksprocket/layouts/quotes/language/en-GB/en-GB.roksprocket_layout_quotes.ini
**Not loaded** : JROOT/components/com_roksprocket/layouts/quotes/language/en-US/en-US.roksprocket_layout_quotes.ini
**Loaded** : JROOT/components/com_roksprocket/layouts/sliders/language/en-GB/en-GB.roksprocket_layout_sliders.ini
**Not loaded** : JROOT/components/com_roksprocket/layouts/sliders/language/en-US/en-US.roksprocket_layout_sliders.ini
**Loaded** : JROOT/components/com_roksprocket/layouts/headlines/language/en-GB/en-GB.roksprocket_layout_headlines.ini
**Not loaded** : JROOT/components/com_roksprocket/layouts/headlines/language/en-US/en-US.roksprocket_layout_headlines.ini
**Loaded** : JROOT/components/com_roksprocket/layouts/tables/language/en-GB/en-GB.roksprocket_layout_tables.ini
**Not loaded** : JROOT/components/com_roksprocket/layouts/tables/language/en-US/en-US.roksprocket_layout_tables.ini
**Loaded** : JROOT/components/com_roksprocket/layouts/tabs/language/en-GB/en-GB.roksprocket_layout_tabs.ini
**Not loaded** : JROOT/components/com_roksprocket/layouts/tabs/language/en-US/en-US.roksprocket_layout_tabs.ini
**Loaded** : JROOT/components/com_roksprocket/layouts/lists/language/en-GB/en-GB.roksprocket_layout_lists.ini
**Not loaded** : JROOT/components/com_roksprocket/layouts/lists/language/en-US/en-US.roksprocket_layout_lists.ini
**Loaded** : JROOT/components/com_roksprocket/layouts/strips/language/en-GB/en-GB.roksprocket_layout_strips.ini
**Not loaded** : JROOT/components/com_roksprocket/layouts/strips/language/en-US/en-US.roksprocket_layout_strips.ini
**Loaded** : JROOT/components/com_roksprocket/layouts/features/language/en-GB/en-GB.roksprocket_layout_features.ini
**Not loaded** : JROOT/components/com_roksprocket/layouts/features/language/en-US/en-US.roksprocket_layout_features.ini
**Not loaded** : JROOT/language/en-US/en-US.mod_fakeonlinepro.ini
**Not loaded** : JROOT/modules/mod_fakeonlinepro/language/en-US/en-US.mod_fakeonlinepro.ini
**Not loaded** : JROOT/language/en-US/en-US.mod_universal_ajaxlivesearch.ini
**Not loaded** : JROOT/modules/mod_universal_ajaxlivesearch/language/en-US/en-US.mod_universal_ajaxlivesearch.ini
**Loaded** : JROOT/administrator/language/en-US/en-US.plg_system_debug.ini

Untranslated Strings


# JROOT/plugins/system/securitycheck/securitycheck.php

COM_SECURITYCHECK_NOT_APPLICABLE="SECURITYCHECK NOT APPLICABLE"

# JROOT/libraries/src/Language/Text.php

COM_YOORECIPE_ADD_REVIEW="YOORECIPE ADD REVIEW"
COM_YOORECIPE_ADD_TWITTER="YOORECIPE ADD TWITTER"
COM_YOORECIPE_BY="YOORECIPE BY"
COM_YOORECIPE_CATEGORY="YOORECIPE CATEGORY"
COM_YOORECIPE_CLOSE="YOORECIPE CLOSE"
COM_YOORECIPE_COPYRIGHTED_TEXT="YOORECIPE COPYRIGHTED TEXT"
COM_YOORECIPE_DAY="YOORECIPE DAY"
COM_YOORECIPE_EDIT_REVIEW="YOORECIPE EDIT REVIEW"
COM_YOORECIPE_EMAIL_ERROR="YOORECIPE EMAIL ERROR"
COM_YOORECIPE_ENIGMA_ERROR="YOORECIPE ENIGMA ERROR"
COM_YOORECIPE_ERROR_FORBIDDEN_DELETE_OPERATION="YOORECIPE ERROR FORBIDDEN DELETE OPERATION"
COM_YOORECIPE_ERROR_OCCURED="YOORECIPE ERROR OCCURED"
COM_YOORECIPE_FOR="YOORECIPE FOR"
COM_YOORECIPE_GO_TOP="YOORECIPE GO TOP"
COM_YOORECIPE_HOUR="YOORECIPE HOUR"
COM_YOORECIPE_MIN="YOORECIPE MIN"
COM_YOORECIPE_NAME="YOORECIPE NAME"
COM_YOORECIPE_NAME_ERROR="YOORECIPE NAME ERROR"
COM_YOORECIPE_PENDING_APPROVAL="YOORECIPE PENDING APPROVAL"
COM_YOORECIPE_RECIPE="YOORECIPE RECIPE"
COM_YOORECIPE_RECIPES_INGREDIENTS="YOORECIPE RECIPES INGREDIENTS"
COM_YOORECIPE_RECIPES_PREPARATION_SEO_OPTIMISED="YOORECIPE RECIPES PREPARATION SEO OPTIMISED"
COM_YOORECIPE_RECIPES_PREPARATION_TIME="YOORECIPE RECIPES PREPARATION TIME"
COM_YOORECIPE_REVIEWS="YOORECIPE REVIEWS"
COM_YOORECIPE_REVIEW_ERROR="YOORECIPE REVIEW ERROR"
COM_YOORECIPE_REVIEW_NOT_ADDED="YOORECIPE REVIEW NOT ADDED"
COM_YOORECIPE_SAVE_CHANGES="YOORECIPE SAVE CHANGES"
COM_YOORECIPE_SEE_FULL_REVIEW="YOORECIPE SEE FULL REVIEW"
COM_YOORECIPE_SERVING_TYPE_BATCHES="YOORECIPE SERVING TYPE BATCHES"
COM_YOORECIPE_SIMILAR_RECIPES="YOORECIPE SIMILAR RECIPES"
COM_YOORECIPE_YOORECIPE_INTERMEDIATE_LABEL="YOORECIPE YOORECIPE INTERMEDIATE LABEL"
COM_YOORECIPE_YOORECIPE_SUPER_EASY_LABEL="YOORECIPE YOORECIPE SUPER EASY LABEL"
DBREPLACER="DBREPLACER"
JCEMEDIABOX_CANCEL="CANCEL"
JCEMEDIABOX_CLOSE="CLOSE"
JCEMEDIABOX_NEXT="NEXT"
JCEMEDIABOX_NUMBERS="NUMBERS"
JCEMEDIABOX_PREVIOUS="PREVIOUS"
LOADING_CONTAINER_CONFIG_FILE_FOR_S_FROM_S="container config file for %s from %s"
PLG_SYSTEM_N3TCOPYLINK_DEFAULT_SUFFIX="SYSTEM N3TCOPYLINK DEFAULT SUFFIX"
RECIPE="Recipe"
REGISTERING_LIBRARY_PATH_S_FOR_S="library path %s for %s"
SEARCH_NEXT="NEXT"
SEARCH_PREV="PREV"

Sprouting Guide - How to Sprout in Mason Jar

Our EcoPeaceful - Sustainable Veganic Desert Food Forest Project

Features of our 100% Organic Nut Milk Bag

EXPOSED! Fake Organic Hemp Nut Milk Bags Sold on Amazon!

The Often Hidden REALITIES about Plastic!

SALE at Amazon! EcoPeaceful Hemp & Organic Cotton Nut Milk Bags

WARNING! Products Labeled "Organic", with GMOs, SEWAGE Sludge, TOXINS...

CocoWhite oil pulling or DIY? Busting CocoWhite's Myths & Marketing Strategy

Addressing the "plants feel pain" claim, with sound reasoning and science!

Creamy Strawberry Vanilla Vegan Ice Cream

??COM_YOORECIPE_SIMILAR_RECIPES??

??COM_YOORECIPE_RECIPES_INGREDIENTS??

??Recipe??

??COM_YOORECIPE_RECIPES_PREPARATION_SEO_OPTIMISED??

??COM_YOORECIPE_REVIEWS??

??COM_YOORECIPE_ADD_REVIEW??

Newsletter SignUp!

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

83 Queries Logged 56.18 ms

28 duplicate found!

55 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

Parsing errors in language files

Language Files Loaded

Untranslated Strings

Creamy Strawberry Vanilla Vegan Ice Cream

??COM_YOORECIPE_SIMILAR_RECIPES??

??COM_YOORECIPE_RECIPES_INGREDIENTS??

??Recipe??

??COM_YOORECIPE_RECIPES_PREPARATION_SEO_OPTIMISED??

??COM_YOORECIPE_REVIEWS??

??COM_YOORECIPE_EDIT_REVIEW??

??COM_YOORECIPE_ADD_REVIEW??

Newsletter SignUp!

**Joomla! Debug Console**

**Session**

**Profile Information**

**Time**

**Memory**

**Memory Usage**

**Database Queries**

**83 Queries Logged** 56.18 ms

**28 duplicate found!**

**55 Query Types Logged, Sorted by Occurrences.**

**SELECT Tables:**

**OTHER Tables:**

**Parsing errors in language files**

**Language Files Loaded**

**Untranslated Strings**

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

83 Queries Logged 56.18 ms

28 duplicate found!

55 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

Parsing errors in language files

Language Files Loaded

Untranslated Strings