Get the confidence of our experience

Take a look inside TherapyEd's best-selling NPTE Review & Study Guide.

Order 20+ books, save $10 per book
Order 40+ books, save $15 per book
Order 60+ books, save $20 per book

Discount applied automatically at check out. No coupon required.

Strict Standards: Non-static method modRquotesHelper::getRandomRquote() should not be called statically in /home/therapye/public_html/modules/mod_rquotes/mod_rquotes.php on line 39

Strict Standards: Only variables should be assigned by reference in /home/therapye/public_html/modules/mod_rquotes/helper.php on line 29

Strict Standards: Non-static method modRquotesHelper::renderRquote() should not be called statically in /home/therapye/public_html/modules/mod_rquotes/tmpl/default.php on line 18

Strict Standards: Only variables should be assigned by reference in /home/therapye/public_html/templates/website/html/mod_rquotes/_rquote.php on line 15

Great instructor! 10/10. This course is awesome. I feel more prepared for my exam studying. Information was presented in a clear and concise manner!!

Elizabeth N., Creighton University

See More Testimonials

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1529314711,
                "last": 1529314711,
                "now": 1529314711
            }
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Profile Information

Time

Memory

Time: 12.37 ms / 12.37 ms Memory: 1.818 MB / 2.07 MB Application: afterLoad

Time: 62.16 ms / 74.52 ms Memory: 7.731 MB / 9.80 MB Application: afterInitialise

Time: 20.67 ms / 95.19 ms Memory: 2.355 MB / 12.15 MB Application: afterRoute

Time: 0.91 ms / 96.10 ms Memory: 0.048 MB / 12.20 MB Application: beforeRenderComponent com_content

Time: 4.47 ms / 100.57 ms Memory: 0.672 MB / 12.87 MB Application: Before Access::preloadComponents (all components)

Time: 0.44 ms / 101.00 ms Memory: 0.087 MB / 12.96 MB Application: After Access::preloadComponents (all components)

Time: 0.09 ms / 101.09 ms Memory: 0.000 MB / 12.96 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Time: 0.51 ms / 101.59 ms Memory: 0.049 MB / 13.00 MB Application: After Access::getAssetRules (id:8 name:com_content)

Time: 53.67 ms / 155.26 ms Memory: 5.377 MB / 18.38 MB Application: afterRenderComponent com_content

Time: 1.26 ms / 156.52 ms Memory: 0.150 MB / 18.53 MB Application: afterDispatch

Time: 22.75 ms / 179.27 ms Memory: 0.326 MB / 18.86 MB Application: beforeRenderModule mod_menu (Header Menu)

Time: 2.24 ms / 181.51 ms Memory: 0.118 MB / 18.98 MB Application: afterRenderModule mod_menu (Header Menu)

Time: 0.05 ms / 181.56 ms Memory: 0.000 MB / 18.97 MB Application: beforeRenderModule mod_custom (Tagline w/ SLP)

Time: 0.60 ms / 182.16 ms Memory: 0.011 MB / 18.98 MB Application: afterRenderModule mod_custom (Tagline w/ SLP)

Time: 0.09 ms / 182.25 ms Memory: 0.000 MB / 18.97 MB Application: beforeRenderModule mod_menu (Main Menu)

Time: 14.11 ms / 196.36 ms Memory: 0.748 MB / 19.72 MB Application: afterRenderModule mod_menu (Main Menu)

Time: 0.19 ms / 196.55 ms Memory: 0.000 MB / 19.71 MB Application: beforeRenderModule mod_custom (Home Spotlight)

Time: 0.21 ms / 196.76 ms Memory: 0.007 MB / 19.72 MB Application: afterRenderModule mod_custom (Home Spotlight)

Time: 0.07 ms / 196.83 ms Memory: 0.000 MB / 19.71 MB Application: beforeRenderModule mod_custom (Discipline Callouts)

Time: 0.19 ms / 197.02 ms Memory: 0.007 MB / 19.72 MB Application: afterRenderModule mod_custom (Discipline Callouts)

Time: 0.12 ms / 197.14 ms Memory: 0.000 MB / 19.72 MB Application: beforeRenderModule mod_custom (Video Callout)

Time: 0.19 ms / 197.33 ms Memory: 0.007 MB / 19.73 MB Application: afterRenderModule mod_custom (Video Callout)

Time: 0.04 ms / 197.37 ms Memory: 0.000 MB / 19.72 MB Application: beforeRenderModule mod_custom (Bulk Book Callout)

Time: 0.18 ms / 197.55 ms Memory: 0.007 MB / 19.73 MB Application: afterRenderModule mod_custom (Bulk Book Callout)

Time: 0.08 ms / 197.63 ms Memory: 0.000 MB / 19.73 MB Application: beforeRenderModule mod_rquotes (Testimonials)

Time: 3.08 ms / 200.71 ms Memory: 0.097 MB / 19.83 MB Application: afterRenderModule mod_rquotes (Testimonials)

Time: 0.05 ms / 200.76 ms Memory: 0.000 MB / 19.82 MB Application: beforeRenderModule mod_custom (See More Testimonials Button)

Time: 0.19 ms / 200.95 ms Memory: 0.007 MB / 19.82 MB Application: afterRenderModule mod_custom (See More Testimonials Button)

Time: 0.08 ms / 201.03 ms Memory: 0.000 MB / 19.82 MB Application: beforeRenderModule mod_footer (Copyright)

Time: 0.80 ms / 201.82 ms Memory: 0.014 MB / 19.83 MB Application: afterRenderModule mod_footer (Copyright)

Time: 0.04 ms / 201.86 ms Memory: 0.000 MB / 19.83 MB Application: beforeRenderModule mod_rsform (Newsletter Signup Form)

Time: 13.27 ms / 215.13 ms Memory: 1.680 MB / 21.51 MB Application: afterRenderModule mod_rsform (Newsletter Signup Form)

Time: 0.07 ms / 215.20 ms Memory: 0.000 MB / 21.51 MB Application: beforeRenderModule mod_menu (Footer Menu)

Time: 1.11 ms / 216.31 ms Memory: 0.035 MB / 21.54 MB Application: afterRenderModule mod_menu (Footer Menu)

Time: 0.05 ms / 216.35 ms Memory: 0.000 MB / 21.53 MB Application: beforeRenderModule mod_custom (Facebook Button)

Time: 0.19 ms / 216.54 ms Memory: 0.007 MB / 21.54 MB Application: afterRenderModule mod_custom (Facebook Button)

Time: 5.58 ms / 222.13 ms Memory: 0.205 MB / 21.74 MB Application: afterRender

Database queries total: 44.93 ms

Memory Usage

Database Queries

48 Queries Logged 44.93 ms

3 duplicate found!

3 duplicates: #32 #34 #39

Query Time: 1.48 ms Query memory: 0.019 MB Memory before query: 4.258 MB Rows returned: 0

SELECT `data`

  FROM `ted_session`

  WHERE `session_id` = '2ca7d1da9d73d754d4e6c4198562d682'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ted_session	const	PRIMARY	PRIMARY	766	const	1	100.00	NULL

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.95 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.03 ms
optimizing	0.01 ms
statistics	0.24 ms
executing	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.07 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.18 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
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:755
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
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:343
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.13 ms After last query: 1.36 ms Query memory: 0.011 MB Memory before query: 4.434 MB Rows returned: 0

SELECT `session_id`

  FROM `ted_session`

  WHERE `session_id` = '2ca7d1da9d73d754d4e6c4198562d682' 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ted_session	const	PRIMARY	PRIMARY	766	const	1	100.00	Using index

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.02 ms
optimizing	0.00 ms
statistics	0.02 ms
executing	0.00 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.19 ms
cleaning up	0.06 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:152
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
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:343
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.47 ms After last query: 0.13 ms Query memory: 0.010 MB Memory before query: 4.450 MB

INSERT INTO `ted_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('2ca7d1da9d73d754d4e6c4198562d682', 1, '1529314711', 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `ted_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('2ca7d1da9d73d754d4e6c4198562d682', 1, '1529314711', 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.17 ms
Waiting for query cache lock	0.00 ms
update	0.05 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:152
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
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:343
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.85 ms After last query: 2.59 ms Query memory: 0.014 MB Memory before query: 4.777 MB Rows returned: 40

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

  FROM `ted_extensions`

  WHERE `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ted_extensions	ref	extension	extension	82	const	40	100.00	Using index condition

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.17 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.46 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:423
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:431
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:497
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:596
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:195
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: 2.26 ms Query memory: 0.013 MB Memory before query: 5.082 MB Rows returned: 5

SELECT id, rules

  FROM `ted_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
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:310
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:606
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:195
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.04 ms After last query: 0.13 ms Query memory: 0.014 MB Memory before query: 5.106 MB Rows returned: 2

SELECT b.id

  FROM ted_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profile

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
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:310
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:606
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:195
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.90 ms After last query: 0.63 ms Query memory: 0.013 MB Memory before query: 5.201 MB Rows returned: 72

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

  FROM ted_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ted_extensions	ref	extension	extension	82	const	115	100.00	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.02 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.60 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.11 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:343
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:348
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:606
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:195
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: 33.22 ms Query memory: 0.018 MB Memory before query: 9.551 MB Rows returned: 96

SELECT *

  FROM ted_j2store_configurations

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_j2store/helpers/config.php:20
13	J2Config->__construct()	JROOT/administrator/components/com_j2store/helpers/config.php:28
12	J2Config::getInstance()	JROOT/administrator/components/com_j2store/helpers/j2store.php:72
11	J2Store::config()	JROOT/plugins/system/j2store/j2store.php:146
10	plgSystemJ2Store->onJ2StoreCronTask()	JROOT/plugins/system/j2store/j2store.php:126
9	plgSystemJ2Store->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:623
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:195
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.32 ms After last query: 3.40 ms Query memory: 0.023 MB Memory before query: 10.121 MB Rows returned: 66

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

  LEFT JOIN ted_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	71	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	therapye_liveupdated2.m.component_id	1	100.00	Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.03 ms
optimizing	0.01 ms
statistics	0.21 ms
preparing	0.03 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.62 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Creating sort index	0.06 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Creating sort index	0.06 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Creating sort index	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.36 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
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:374
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:488
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:405
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1070
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.52 ms After last query: 9.37 ms Query memory: 0.023 MB Memory before query: 11.400 MB Rows returned: 1

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

  FROM `ted_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ted_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using index condition

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.02 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.20 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.06 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.09 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
19	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
18	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
15	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
14	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
13	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/eim/eim.php:22
9	plgSystemEIM->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:1080
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:195
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.70 ms After last query: 0.22 ms Query memory: 0.018 MB Memory before query: 11.407 MB

UPDATE `ted_extensions`

  SET `params` = '{\"mediaversion\":\"1c710a7ba7541b0dbeedc19060414190\"}'

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

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.04 ms
updating	0.05 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	1.49 ms
query end	0.03 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.08 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
14	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
13	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/eim/eim.php:22
9	plgSystemEIM->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:1080
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.46 ms After last query: 1.86 ms Query memory: 0.014 MB Memory before query: 11.719 MB Rows returned: 3

SELECT id, home, template, s.params

  FROM ted_template_styles as s

  LEFT JOIN ted_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	5	100.00	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	therapye_liveupdated2.s.template,const	1	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.19 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:488
10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/eim/eim.php:26
9	plgSystemEIM->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:1080
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:195
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: 3.32 ms Query memory: 0.009 MB Memory before query: 12.174 MB Rows returned: 1

SELECT *

  FROM ted_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
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:195
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: 5.25 ms Query memory: 0.022 MB Memory before query: 12.880 MB Rows returned: 34

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

  FROM `ted_assets`

  WHERE `name` IN ('root.1','com_admin','com_ajax','com_akeeba','com_cache','com_categories','com_checkin','com_config','com_content','com_contenthistory','com_cpanel','com_fields','com_installer','com_j2migration','com_j2store','com_jmap','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_plugins','com_postinstall','com_redirect','com_rquote','com_rsform','com_schuweb_sitemap','com_securitycheck','com_tags','com_templates','com_users','com_wrapper')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ted_assets	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	305	11.48	Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:248
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.92 ms After last query: 1.46 ms Query memory: 0.020 MB Memory before query: 13.088 MB Rows returned: 30

SHOW FULL COLUMNS 
  FROM `ted_content`

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	1.26 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.02 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.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.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.28 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
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/Content.php:39
11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:312
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:250
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.41 ms After last query: 3.39 ms Query memory: 0.015 MB Memory before query: 13.494 MB Rows returned: 1

SELECT *

  FROM ted_content

  WHERE `id` = '1'

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.15 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
10	Joomla\CMS\Table\Table->load()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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: 3.51 ms After last query: 0.20 ms Query memory: 0.014 MB Memory before query: 13.509 MB

UPDATE ted_content

  SET `hits` = (`hits` + 1)

  WHERE `id` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ted_content	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.01 ms
init	0.01 ms
System lock	0.03 ms
updating	0.05 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	3.25 ms
query end	0.04 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1242
10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:252
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.18 ms After last query: 1.83 ms Query memory: 0.017 MB Memory before query: 13.735 MB Rows returned: 1

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM ted_content AS a

  INNER JOIN ted_categories AS c 
  on c.id = a.catid

  LEFT JOIN ted_users AS u 
  on u.id = a.created_by

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

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

  WHERE a.id = 1 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-06-18 09:38:31') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-06-18 09:38:31') 
  AND (a.state = 1 OR a.state =2)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.25 ms
init	0.00 ms
checking query cache for query	0.10 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.05 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.49 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.02 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:148
12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:423
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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: 2.21 ms Query memory: 0.016 MB Memory before query: 13.943 MB Rows returned: 0

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

  FROM `ted_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 1 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
11	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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: 9.64 ms Query memory: 0.027 MB Memory before query: 15.422 MB Rows returned: 3

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `ted_categories` AS `s`

  INNER JOIN `ted_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 19

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using filesort
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	32	59.38	Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:314
20	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
19	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:197
18	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
17	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:479
14	PlgSystemFields->onContentPrepare()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.67 ms Query memory: 0.024 MB Memory before query: 15.529 MB Rows returned: 0

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

  FROM ted_fields AS a

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

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

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

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

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

  LEFT JOIN `ted_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (19,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

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

Profile

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:479
14	PlgSystemFields->onContentPrepare()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.84 ms Query memory: 0.027 MB Memory before query: 17.583 MB Rows returned: 206

SHOW TABLES

Explain

EXPLAIN not possible on query: SHOW TABLES

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
checking permissions	0.58 ms
Sending data	0.06 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	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
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
22	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:487
21	JDatabaseDriverMysqli->getTableList()	JROOT/libraries/f0f/database/driver/joomla.php:251
20	F0FDatabaseDriverJoomla->getTableList()	JROOT/libraries/f0f/table/table.php:2082
19	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:536
18	F0FTable->__construct()	JROOT/administrator/components/com_j2store/tables/product.php:63
17	J2StoreTableProduct->__construct()	JROOT/libraries/f0f/table/table.php:433
16	F0FTable::getAnInstance()	JROOT/plugins/content/j2store/j2store.php:82
15	plgContentJ2Store->defaultPosition()	JROOT/plugins/content/j2store/j2store.php:60
14	plgContentJ2Store->onContentPrepare()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.83 ms After last query: 0.22 ms Query memory: 0.027 MB Memory before query: 17.649 MB Rows returned: 21

SHOW FULL COLUMNS 
  FROM `ted_j2store_products`

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	1.27 ms
init	0.01 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.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.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.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.27 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
20	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/table/table.php:2167
19	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:536
18	F0FTable->__construct()	JROOT/administrator/components/com_j2store/tables/product.php:63
17	J2StoreTableProduct->__construct()	JROOT/libraries/f0f/table/table.php:433
16	F0FTable::getAnInstance()	JROOT/plugins/content/j2store/j2store.php:82
15	plgContentJ2Store->defaultPosition()	JROOT/plugins/content/j2store/j2store.php:60
14	plgContentJ2Store->onContentPrepare()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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: 0.48 ms Query memory: 0.029 MB Memory before query: 17.734 MB Rows returned: 5

SHOW FULL COLUMNS 
  FROM `ted_j2store_productimages`

Explain

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

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.45 ms
init	0.00 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.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.21 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
21	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/table/table.php:2167
20	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:2365
19	F0FTable->getQueryJoinFields()	JROOT/libraries/f0f/table/table.php:539
18	F0FTable->__construct()	JROOT/administrator/components/com_j2store/tables/product.php:63
17	J2StoreTableProduct->__construct()	JROOT/libraries/f0f/table/table.php:433
16	F0FTable::getAnInstance()	JROOT/plugins/content/j2store/j2store.php:82
15	plgContentJ2Store->defaultPosition()	JROOT/plugins/content/j2store/j2store.php:60
14	plgContentJ2Store->onContentPrepare()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.82 ms After last query: 0.16 ms Query memory: 0.029 MB Memory before query: 17.774 MB Rows returned: 5

SHOW FULL COLUMNS 
  FROM `ted_j2store_manufacturers`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
21	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/table/table.php:2167
20	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:2365
19	F0FTable->getQueryJoinFields()	JROOT/libraries/f0f/table/table.php:539
18	F0FTable->__construct()	JROOT/administrator/components/com_j2store/tables/product.php:63
17	J2StoreTableProduct->__construct()	JROOT/libraries/f0f/table/table.php:433
16	F0FTable::getAnInstance()	JROOT/plugins/content/j2store/j2store.php:82
15	plgContentJ2Store->defaultPosition()	JROOT/plugins/content/j2store/j2store.php:60
14	plgContentJ2Store->onContentPrepare()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.81 ms After last query: 0.16 ms Query memory: 0.029 MB Memory before query: 17.813 MB Rows returned: 5

SHOW FULL COLUMNS 
  FROM `ted_j2store_vendors`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
21	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/table/table.php:2167
20	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:2365
19	F0FTable->getQueryJoinFields()	JROOT/libraries/f0f/table/table.php:539
18	F0FTable->__construct()	JROOT/administrator/components/com_j2store/tables/product.php:63
17	J2StoreTableProduct->__construct()	JROOT/libraries/f0f/table/table.php:433
16	F0FTable::getAnInstance()	JROOT/plugins/content/j2store/j2store.php:82
15	plgContentJ2Store->defaultPosition()	JROOT/plugins/content/j2store/j2store.php:60
14	plgContentJ2Store->onContentPrepare()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.90 ms After last query: 0.16 ms Query memory: 0.029 MB Memory before query: 17.853 MB Rows returned: 20

SHOW FULL COLUMNS 
  FROM `ted_j2store_addresses`

Explain

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

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.44 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
Opening tables	0.01 ms
checking permissions	0.02 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.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.21 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
21	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/table/table.php:2167
20	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:2365
19	F0FTable->getQueryJoinFields()	JROOT/libraries/f0f/table/table.php:539
18	F0FTable->__construct()	JROOT/administrator/components/com_j2store/tables/product.php:63
17	J2StoreTableProduct->__construct()	JROOT/libraries/f0f/table/table.php:433
16	F0FTable::getAnInstance()	JROOT/plugins/content/j2store/j2store.php:82
15	plgContentJ2Store->defaultPosition()	JROOT/plugins/content/j2store/j2store.php:60
14	plgContentJ2Store->onContentPrepare()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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: 2.63 ms Query memory: 0.025 MB Memory before query: 18.048 MB Rows returned: 0

SELECT ted_j2store_products.*,`ted_j2store_productimages`.`j2store_productimage_id`,`ted_j2store_productimages`.`main_image`,`ted_j2store_productimages`.`thumb_image`,`ted_j2store_productimages`.`additional_images`,`ted_j2store_manufacturers`.`brand_desc_id`,`ted_j2store_addresses`.`first_name` AS manufacturer_first_name,`ted_j2store_addresses`.`last_name` AS manufacturer_last_name,`ted_j2store_addresses`.`company` AS manufacturer

  FROM ted_j2store_products

  LEFT JOIN `ted_j2store_productimages` 
  ON `ted_j2store_products`.`j2store_product_id` = `ted_j2store_productimages`.`product_id`

  LEFT JOIN `ted_j2store_manufacturers` 
  ON `ted_j2store_products`.`manufacturer_id` = `ted_j2store_manufacturers`.`j2store_manufacturer_id`

  LEFT JOIN `ted_j2store_vendors` 
  ON `ted_j2store_products`.`vendor_id` = `ted_j2store_vendors`.`j2store_vendor_id`

  LEFT JOIN `ted_j2store_addresses` 
  ON `ted_j2store_manufacturers`.`address_id` = `ted_j2store_addresses`.`j2store_address_id`

  WHERE `ted_j2store_products`.`product_source` = 'com_content' 
  AND `ted_j2store_products`.`product_source_id` = '1' 
  AND `ted_j2store_products`.`enabled` = '1' 
  AND `ted_j2store_products`.`visibility` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
20	JDatabaseDriver->loadAssoc()	JROOT/libraries/f0f/database/driver/joomla.php:291
19	F0FDatabaseDriverJoomla->loadAssoc()	JROOT/libraries/f0f/table/table.php:949
18	F0FTable->load()	JROOT/administrator/components/com_j2store/tables/product.php:91
17	J2StoreTableProduct->load()	JROOT/administrator/components/com_j2store/tables/product.php:193
16	J2StoreTableProduct->get_product_by_source()	JROOT/plugins/content/j2store/j2store.php:84
15	plgContentJ2Store->defaultPosition()	JROOT/plugins/content/j2store/j2store.php:60
14	plgContentJ2Store->onContentPrepare()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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: 20.06 ms After last query: 6.93 ms Query memory: 0.018 MB Memory before query: 18.761 MB Rows returned: 87

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

  FROM ted_modules AS m

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

  LEFT JOIN ted_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 <= '2018-06-18 09:38:31') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-06-18 09:38:31') 
  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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	53	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	therapye_liveupdated2.m.id	1	100.00	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	therapye_liveupdated2.m.module,const	1	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	18.21 ms
init	0.01 ms
checking query cache for query	0.10 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.03 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.64 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Creating sort index	0.35 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Creating sort index	0.33 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.03 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.12 ms
cleaning up	0.05 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:433
11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:363
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:45
8	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/templates/website/index.php:12
7	require JROOT/templates/website/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.29 ms After last query: 20.60 ms Query memory: 0.018 MB Memory before query: 19.830 MB Rows returned: 52

SELECT * 
  from	ted_rquote 
  WHERE published='1' 
  and catid = 9

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	1.15 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
13	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_rquotes/helper.php:53
12	modRquotesHelper::getRandomRquote()	JROOT/modules/mod_rquotes/mod_rquotes.php:39
11	include JROOT/modules/mod_rquotes/mod_rquotes.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
10	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
9	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
8	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/templates/website/index.php:12
7	require JROOT/templates/website/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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: 12.21 ms Query memory: 0.019 MB Memory before query: 21.169 MB Rows returned: 1

SELECT Published, FormTitle, MetaTitle, MetaDesc, MetaKeywords, ShowThankyou, Access 
  FROM ted_rsform_forms 
  WHERE FormId='3'

Explain

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

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_rsform/helpers/rsform.php:204
13	RSFormProHelper::displayForm()	JROOT/modules/mod_rsform/tmpl/default.php:14
12	require JROOT/modules/mod_rsform/tmpl/default.php	JROOT/modules/mod_rsform/mod_rsform.php:26
11	include JROOT/modules/mod_rsform/mod_rsform.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
10	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
9	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
8	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/templates/website/index.php:12
7	require JROOT/templates/website/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.04 ms After last query: 0.10 ms Query memory: 0.020 MB Memory before query: 21.192 MB Rows returned: 1

Duplicate queries: #34 #39

SELECT `Lang` 
  FROM ted_rsform_forms 
  WHERE FormId='3'

Explain

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

Profile

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_rsform/helpers/rsform.php:3692
14	RSFormProHelper::getTranslations()	JROOT/administrator/components/com_rsform/helpers/rsform.php:244
13	RSFormProHelper::displayForm()	JROOT/modules/mod_rsform/tmpl/default.php:14
12	require JROOT/modules/mod_rsform/tmpl/default.php	JROOT/modules/mod_rsform/mod_rsform.php:26
11	include JROOT/modules/mod_rsform/mod_rsform.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
10	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
9	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
8	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/templates/website/index.php:12
7	require JROOT/templates/website/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.06 ms After last query: 0.20 ms Query memory: 0.020 MB Memory before query: 21.218 MB Rows returned: 1

SELECT `FormId`, `FormLayoutName`, `FormLayout`, `ScriptDisplay`, `ErrorMessage`, `FormTitle`, `CSS`, `JS`, `CSSClass`, `CSSId`, `CSSName`, `CSSAction`, `CSSAdditionalAttributes`, `AjaxValidation`, `ThemeParams` 
  FROM ted_rsform_forms 
  WHERE FormId='3' 
  AND `Published`='1'

Explain

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

Profile

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_rsform/helpers/rsform.php:1632
14	RSFormProHelper::showForm()	JROOT/administrator/components/com_rsform/helpers/rsform.php:299
13	RSFormProHelper::displayForm()	JROOT/modules/mod_rsform/tmpl/default.php:14
12	require JROOT/modules/mod_rsform/tmpl/default.php	JROOT/modules/mod_rsform/mod_rsform.php:26
11	include JROOT/modules/mod_rsform/mod_rsform.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
10	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
9	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
8	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/templates/website/index.php:12
7	require JROOT/templates/website/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.04 ms After last query: 0.13 ms Query memory: 0.021 MB Memory before query: 21.243 MB Rows returned: 1

Duplicate queries: #32 #39

SELECT `Lang` 
  FROM ted_rsform_forms 
  WHERE FormId='3'

Explain

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

Profile

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
16	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_rsform/helpers/rsform.php:3692
15	RSFormProHelper::getTranslations()	JROOT/administrator/components/com_rsform/helpers/rsform.php:1635
14	RSFormProHelper::showForm()	JROOT/administrator/components/com_rsform/helpers/rsform.php:299
13	RSFormProHelper::displayForm()	JROOT/modules/mod_rsform/tmpl/default.php:14
12	require JROOT/modules/mod_rsform/tmpl/default.php	JROOT/modules/mod_rsform/mod_rsform.php:26
11	include JROOT/modules/mod_rsform/mod_rsform.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
10	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
9	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
8	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/templates/website/index.php:12
7	require JROOT/templates/website/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.04 ms After last query: 0.09 ms Query memory: 0.021 MB Memory before query: 21.267 MB Rows returned: 0

SELECT ComponentId 
  FROM ted_rsform_components 
  WHERE ComponentTypeId='6' 
  AND FormId='3' 
  AND Published='1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ted_rsform_components	ref	ComponentTypeId,FormId	ComponentTypeId	4	const	2	100.00	Using where

Profile

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
16	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsform/helpers/rsform.php:1541
15	RSFormProHelper::componentExists()	JROOT/administrator/components/com_rsform/helpers/rsform.php:1655
14	RSFormProHelper::showForm()	JROOT/administrator/components/com_rsform/helpers/rsform.php:299
13	RSFormProHelper::displayForm()	JROOT/modules/mod_rsform/tmpl/default.php:14
12	require JROOT/modules/mod_rsform/tmpl/default.php	JROOT/modules/mod_rsform/mod_rsform.php:26
11	include JROOT/modules/mod_rsform/mod_rsform.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
10	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
9	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
8	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/templates/website/index.php:12
7	require JROOT/templates/website/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.04 ms After last query: 0.07 ms Query memory: 0.020 MB Memory before query: 21.289 MB Rows returned: 3

SELECT p.PropertyValue AS name, c.ComponentId, c.ComponentTypeId, ct.ComponentTypeName, c.
  Order 
  FROM ted_rsform_properties p 
  LEFT JOIN ted_rsform_components c 
  ON (c.ComponentId=p.ComponentId) 
  LEFT JOIN ted_rsform_component_types ct 
  ON (ct.ComponentTypeId=c.ComponentTypeId) 
  WHERE c.FormId='3' 
  AND p.PropertyName='NAME' 
  AND c.Published='1' 
  ORDER BY c.
  Order

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	ref	ComponentId,FormId	FormId	4	const	3	100.00	Using where; Using filesort
1	SIMPLE	ct	eq_ref	PRIMARY	PRIMARY	4	therapye_liveupdated2.c.ComponentTypeId	1	100.00	NULL
1	SIMPLE	p	ref	ComponentId	ComponentId	4	therapye_liveupdated2.c.ComponentId	11	100.00	Using where

Profile

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsform/helpers/rsform.php:1708
14	RSFormProHelper::showForm()	JROOT/administrator/components/com_rsform/helpers/rsform.php:299
13	RSFormProHelper::displayForm()	JROOT/modules/mod_rsform/tmpl/default.php:14
12	require JROOT/modules/mod_rsform/tmpl/default.php	JROOT/modules/mod_rsform/mod_rsform.php:26
11	include JROOT/modules/mod_rsform/mod_rsform.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
10	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
9	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
8	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/templates/website/index.php:12
7	require JROOT/templates/website/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.04 ms After last query: 0.15 ms Query memory: 0.021 MB Memory before query: 21.319 MB Rows returned: 26

SELECT `PropertyName`,`PropertyValue`,`ComponentId`

  FROM `ted_rsform_properties`

  WHERE `ComponentId` IN (23,24,25)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ted_rsform_properties	range	ComponentId	ComponentId	4	NULL	23	100.00	Using index condition

Profile

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsform/helpers/rsform.php:524
15	RSFormProHelper::getComponentProperties()	JROOT/administrator/components/com_rsform/helpers/rsform.php:1733
14	RSFormProHelper::showForm()	JROOT/administrator/components/com_rsform/helpers/rsform.php:299
13	RSFormProHelper::displayForm()	JROOT/modules/mod_rsform/tmpl/default.php:14
12	require JROOT/modules/mod_rsform/tmpl/default.php	JROOT/modules/mod_rsform/mod_rsform.php:26
11	include JROOT/modules/mod_rsform/mod_rsform.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
10	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
9	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
8	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/templates/website/index.php:12
7	require JROOT/templates/website/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.04 ms After last query: 0.16 ms Query memory: 0.021 MB Memory before query: 21.367 MB Rows returned: 1

SELECT `FormId`

  FROM `ted_rsform_components`

  WHERE `ComponentId`='23'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ted_rsform_components	const	ComponentId	ComponentId	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
16	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_rsform/helpers/rsform.php:539
15	RSFormProHelper::getComponentProperties()	JROOT/administrator/components/com_rsform/helpers/rsform.php:1733
14	RSFormProHelper::showForm()	JROOT/administrator/components/com_rsform/helpers/rsform.php:299
13	RSFormProHelper::displayForm()	JROOT/modules/mod_rsform/tmpl/default.php:14
12	require JROOT/modules/mod_rsform/tmpl/default.php	JROOT/modules/mod_rsform/mod_rsform.php:26
11	include JROOT/modules/mod_rsform/mod_rsform.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
10	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
9	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
8	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/templates/website/index.php:12
7	require JROOT/templates/website/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.03 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 21.390 MB Rows returned: 1

Duplicate queries: #32 #34

SELECT `Lang` 
  FROM ted_rsform_forms 
  WHERE FormId='3'

Explain

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

Profile

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
17	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_rsform/helpers/rsform.php:3692
16	RSFormProHelper::getTranslations()	JROOT/administrator/components/com_rsform/helpers/rsform.php:543
15	RSFormProHelper::getComponentProperties()	JROOT/administrator/components/com_rsform/helpers/rsform.php:1733
14	RSFormProHelper::showForm()	JROOT/administrator/components/com_rsform/helpers/rsform.php:299
13	RSFormProHelper::displayForm()	JROOT/modules/mod_rsform/tmpl/default.php:14
12	require JROOT/modules/mod_rsform/tmpl/default.php	JROOT/modules/mod_rsform/mod_rsform.php:26
11	include JROOT/modules/mod_rsform/mod_rsform.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
10	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
9	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
8	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/templates/website/index.php:12
7	require JROOT/templates/website/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.04 ms After last query: 0.21 ms Query memory: 0.023 MB Memory before query: 21.405 MB Rows returned: 0

SELECT ComponentId 
  FROM ted_rsform_components 
  WHERE ComponentTypeId='41' 
  AND FormId='3' 
  AND Published='1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ted_rsform_components	ref	ComponentTypeId,FormId	ComponentTypeId	4	const	1	100.00	Using where

Profile

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
17	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsform/helpers/rsform.php:1541
16	RSFormProHelper::componentExists()	JROOT/administrator/components/com_rsform/helpers/rsform.php:3170
15	RSFormProHelper::getFrontComponentBody()	JROOT/administrator/components/com_rsform/helpers/rsform.php:1765
14	RSFormProHelper::showForm()	JROOT/administrator/components/com_rsform/helpers/rsform.php:299
13	RSFormProHelper::displayForm()	JROOT/modules/mod_rsform/tmpl/default.php:14
12	require JROOT/modules/mod_rsform/tmpl/default.php	JROOT/modules/mod_rsform/mod_rsform.php:26
11	include JROOT/modules/mod_rsform/mod_rsform.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
10	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
9	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
8	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/templates/website/index.php:12
7	require JROOT/templates/website/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.04 ms After last query: 0.18 ms Query memory: 0.025 MB Memory before query: 21.430 MB Rows returned: 13

SELECT *

  FROM ted_rsform_config

Explain

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

Profile

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsform/helpers/config.php:50
18	RSFormProConfig->load()	JROOT/administrator/components/com_rsform/helpers/config.php:17
17	RSFormProConfig->__construct()	JROOT/administrator/components/com_rsform/helpers/config.php:97
16	RSFormProConfig::getInstance()	JROOT/administrator/components/com_rsform/helpers/rsform.php:379
15	RSFormProHelper::getConfig()	JROOT/administrator/components/com_rsform/helpers/rsform.php:1816
14	RSFormProHelper::showForm()	JROOT/administrator/components/com_rsform/helpers/rsform.php:299
13	RSFormProHelper::displayForm()	JROOT/modules/mod_rsform/tmpl/default.php:14
12	require JROOT/modules/mod_rsform/tmpl/default.php	JROOT/modules/mod_rsform/mod_rsform.php:26
11	include JROOT/modules/mod_rsform/mod_rsform.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
10	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
9	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
8	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/templates/website/index.php:12
7	require JROOT/templates/website/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.04 ms After last query: 0.12 ms Query memory: 0.021 MB Memory before query: 21.458 MB Rows returned: 0

SELECT ComponentId 
  FROM ted_rsform_components 
  WHERE ComponentTypeId='9' 
  AND FormId='3' 
  AND Published='1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ted_rsform_components	ref	ComponentTypeId,FormId	ComponentTypeId	4	const	1	100.00	Using where

Profile

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
16	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsform/helpers/rsform.php:1541
15	RSFormProHelper::componentExists()	JROOT/administrator/components/com_rsform/helpers/rsform.php:1850
14	RSFormProHelper::showForm()	JROOT/administrator/components/com_rsform/helpers/rsform.php:299
13	RSFormProHelper::displayForm()	JROOT/modules/mod_rsform/tmpl/default.php:14
12	require JROOT/modules/mod_rsform/tmpl/default.php	JROOT/modules/mod_rsform/mod_rsform.php:26
11	include JROOT/modules/mod_rsform/mod_rsform.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
10	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
9	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
8	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/templates/website/index.php:12
7	require JROOT/templates/website/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.05 ms After last query: 0.26 ms Query memory: 0.021 MB Memory before query: 21.484 MB Rows returned: 0

SELECT c.*,p.PropertyValue AS ComponentName 
  FROM `ted_rsform_conditions` c 
  LEFT JOIN ted_rsform_properties p 
  ON (c.component_id = p.ComponentId) 
  LEFT JOIN ted_rsform_components comp 
  ON (comp.ComponentId=p.ComponentId) 
  WHERE c.`form_id` = 3 
  AND c.lang_code='en-GB' 
  AND comp.Published = 1 
  AND p.PropertyName='NAME' 
  ORDER BY c.`id` ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsform/helpers/rsform.php:1591
15	RSFormProHelper::getConditions()	JROOT/administrator/components/com_rsform/helpers/rsform.php:1927
14	RSFormProHelper::showForm()	JROOT/administrator/components/com_rsform/helpers/rsform.php:299
13	RSFormProHelper::displayForm()	JROOT/modules/mod_rsform/tmpl/default.php:14
12	require JROOT/modules/mod_rsform/tmpl/default.php	JROOT/modules/mod_rsform/mod_rsform.php:26
11	include JROOT/modules/mod_rsform/mod_rsform.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
10	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
9	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
8	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/templates/website/index.php:12
7	require JROOT/templates/website/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.04 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 21.507 MB Rows returned: 0

SELECT * 
  FROM ted_rsform_calculations 
  WHERE formId = 3 
  ORDER BY `ordering`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsform/helpers/rsform.php:4396
15	RSFormProHelper::getCalculations()	JROOT/administrator/components/com_rsform/helpers/rsform.php:1982
14	RSFormProHelper::showForm()	JROOT/administrator/components/com_rsform/helpers/rsform.php:299
13	RSFormProHelper::displayForm()	JROOT/modules/mod_rsform/tmpl/default.php:14
12	require JROOT/modules/mod_rsform/tmpl/default.php	JROOT/modules/mod_rsform/mod_rsform.php:26
11	include JROOT/modules/mod_rsform/mod_rsform.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
10	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
9	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
8	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/templates/website/index.php:12
7	require JROOT/templates/website/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.04 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 21.529 MB Rows returned: 0

SELECT ComponentId 
  FROM ted_rsform_components 
  WHERE ComponentTypeId='212' 
  AND FormId='3' 
  AND Published='1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ted_rsform_components	ref	ComponentTypeId,FormId	ComponentTypeId	4	const	1	100.00	Using where

Profile

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
16	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsform/helpers/rsform.php:1541
15	RSFormProHelper::componentExists()	JROOT/administrator/components/com_rsform/helpers/rsform.php:2000
14	RSFormProHelper::showForm()	JROOT/administrator/components/com_rsform/helpers/rsform.php:299
13	RSFormProHelper::displayForm()	JROOT/modules/mod_rsform/tmpl/default.php:14
12	require JROOT/modules/mod_rsform/tmpl/default.php	JROOT/modules/mod_rsform/mod_rsform.php:26
11	include JROOT/modules/mod_rsform/mod_rsform.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
10	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
9	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
8	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/templates/website/index.php:12
7	require JROOT/templates/website/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.06 ms After last query: 2.57 ms Query memory: 0.018 MB Memory before query: 21.571 MB Rows returned: 0

SELECT *
 
  FROM ted_jmap_metainfo
 
  WHERE `linkurl` = 'https://www.therapyed.com/'
 
  AND `published` = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ted_jmap_metainfo	ref	published	published	1	const	1	100.00	Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
14	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:276
13	plgSystemJMap->onBeforeCompileHead()	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/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->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:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.48 ms After last query: 1.64 ms Query memory: 0.022 MB Memory before query: 21.697 MB Rows returned: 1

SELECT `alias`

  FROM `ted_content`

  WHERE id = '129'

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.04 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.22 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.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.85 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
18	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
17	ContentRouter->getArticleSegment()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:670
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
8	PlgSystemSef->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:1047
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.67 ms After last query: 0.21 ms Query memory: 0.024 MB Memory before query: 21.724 MB Rows returned: 0

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `ted_categories` AS `s`

  INNER JOIN `ted_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 129

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:314
19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
18	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
17	ContentRouter->getCategorySegment()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:124
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:670
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
8	PlgSystemSef->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:1047
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.]

41 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

4 × SELECT ComponentId 
  FROM ted_rsform_components

3 × SELECT `Lang` 
  FROM ted_rsform_forms

2 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM `ted_categories` AS `s` 
  INNER JOIN `ted_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

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

```
1 × SELECT * 
  from ted_rquote
```

1 × SELECT `FormId`, `FormLayoutName`, `FormLayout`, `ScriptDisplay`, `ErrorMessage`, `FormTitle`, `CSS`, `JS`, `CSSClass`, `CSSId`, `CSSName`, `CSSAction`, `CSSAdditionalAttributes`, `AjaxValidation`, `ThemeParams` 
  FROM ted_rsform_forms

1 × SELECT p.PropertyValue AS name, c.ComponentId, c.ComponentTypeId, ct.ComponentTypeName, c.
  Order 
  FROM ted_rsform_properties p 
  LEFT JOIN ted_rsform_components c 
  ON (c.ComponentId=p.ComponentId) 
  LEFT JOIN ted_rsform_component_types ct 
  ON (ct.ComponentTypeId=c.ComponentTypeId)

1 × SELECT Published, FormTitle, MetaTitle, MetaDesc, MetaKeywords, ShowThankyou, Access 
  FROM ted_rsform_forms

1 × SELECT `FormId` 
  FROM `ted_rsform_components`

1 × SELECT *  
  FROM ted_jmap_metainfo

1 × SELECT `alias` 
  FROM `ted_content`

1 × SELECT * 
  FROM ted_rsform_calculations

1 × SELECT c.*,p.PropertyValue AS ComponentName 
  FROM `ted_rsform_conditions` c 
  LEFT JOIN ted_rsform_properties p 
  ON (c.component_id = p.ComponentId) 
  LEFT JOIN ted_rsform_components comp 
  ON (comp.ComponentId=p.ComponentId)

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM ted_modules AS m 
  LEFT JOIN ted_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN ted_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

```
1 × SELECT * 
  FROM ted_rsform_confi
```

1 × SELECT `PropertyName`,`PropertyValue`,`ComponentId` 
  FROM `ted_rsform_properties`

1 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state 
  FROM ted_fields AS a 
  LEFT JOIN `ted_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN ted_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN ted_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN ted_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN ted_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `ted_fields_categories` AS fc 
  ON fc.field_id = a.id

1 × SELECT * 
  FROM ted_j2store_configuration

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 ted_menu AS m 
  LEFT JOIN ted_extensions AS e 
  ON m.component_id = e.extension_id

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

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

1 × SELECT `session_id` 
  FROM `ted_session`

1 × SELECT id, rules 
  FROM `ted_viewlevels

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

```
1 × SELECT * 
  FROM ted_languages
```

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

1 × SELECT `data` 
  FROM `ted_session`

1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count 
  FROM ted_content AS a 
  INNER JOIN ted_categories AS c 
  on c.id = a.catid 
  LEFT JOIN ted_users AS u 
  on u.id = a.created_by 
  LEFT JOIN ted_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN ted_content_rating AS v 
  ON a.id = v.content_id

```
1 × SELECT * 
  FROM ted_content
```

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `ted_assets`

1 × SELECT ted_j2store_products.*,`ted_j2store_productimages`.`j2store_productimage_id`,`ted_j2store_productimages`.`main_image`,`ted_j2store_productimages`.`thumb_image`,`ted_j2store_productimages`.`additional_images`,`ted_j2store_manufacturers`.`brand_desc_id`,`ted_j2store_addresses`.`first_name` AS manufacturer_first_name,`ted_j2store_addresses`.`last_name` AS manufacturer_last_name,`ted_j2store_addresses`.`company` AS manufacturer 
  FROM ted_j2store_products 
  LEFT JOIN `ted_j2store_productimages` 
  ON `ted_j2store_products`.`j2store_product_id` = `ted_j2store_productimages`.`product_id` 
  LEFT JOIN `ted_j2store_manufacturers` 
  ON `ted_j2store_products`.`manufacturer_id` = `ted_j2store_manufacturers`.`j2store_manufacturer_id` 
  LEFT JOIN `ted_j2store_vendors` 
  ON `ted_j2store_products`.`vendor_id` = `ted_j2store_vendors`.`j2store_vendor_id` 
  LEFT JOIN `ted_j2store_addresses` 
  ON `ted_j2store_manufacturers`.`address_id` = `ted_j2store_addresses`.`j2store_address_id`

OTHER Tables:

1 × SHOW FULL COLUMNS 
  FROM `ted_j2store_productimages

1 × SHOW FULL COLUMNS 
  FROM `ted_j2store_manufacturers

1 × SHOW FULL COLUMNS 
  FROM `ted_j2store_vendors

1 × SHOW FULL COLUMNS 
  FROM `ted_j2store_addresses

1 × SHOW FULL COLUMNS 
  FROM `ted_j2store_products

```
1 × SHOW TABLE
```

1 × UPDATE `ted_extensions` 
  SET `params` = '{\"mediaversion\":\"1c710a7ba7541b0dbeedc19060414190\"}'

1 × SHOW FULL COLUMNS 
  FROM `ted_content

1 × UPDATE ted_content 
  SET `hits` = (`hits` + 1)

1 × INSERT INTO `ted_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('2ca7d1da9d73d754d4e6c4198562d682', 1, '1529314711', 0, '', 0