Notice: Undefined property: stdClass::$sorting in /home/ordasvit/public_html/components/com_os_cck/classes/instance.class.php on line 1238

Custom Code Forum Home

Custom Code Last comments

Custom Code Forum Search

More details about wordPress map plugin

Message:

WordPress map plugin - is light plugin for show your location on map. It work with Google API and Open Map API

Images

Action button

Message:

Excellent

Attachment images

Action button

Review Pagination

Start
Prev
1
2
Next
End

Custom Code You need login for add your questions

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1760174247,
                "last": 1760174247,
                "now": 1760174247
            },
            "token": "GQR5o7CVSudJ6hpHo0DK39RimAaW90fN"
        },
        "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
        },
        "previous_page": null,
        "price_fields": ""
    }
}

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

Status	Duration
Starting	7.02 ms
checking permissions	0.03 ms
Opening tables	0.11 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.03 ms
init	0.06 ms
Optimizing	0.03 ms
Statistics	2.21 ms
Preparing	0.05 ms
Executing	0.03 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.01 ms
closing tables	0.03 ms
Unlocking tables	0.01 ms
closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

#	Caller	File and line number
16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1740
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:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
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:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

EXPLAIN not possible on query: INSERT INTO `j6au3_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'383667763063747474383770617536676e6835743862336a3430', 1, 1760174247, 0, '', 0)

Profile

Status	Duration
Starting	0.18 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.01 ms
init for update	0.06 ms
Update	0.22 ms
Waiting for query cache lock	0.02 ms
Update	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
Waiting for query cache lock	0.01 ms
Unlocking tables	0.50 ms
closing tables	0.02 ms
Starting cleanup	0.03 ms
Freeing items	0.01 ms
Updating status	6.20 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysql->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
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:386
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: 4.30 ms After last query: 15.35 ms

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

  FROM `j6au3_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j6au3_extensions	ref	extension	extension	82	const	40	Using index condition; Using where

Profile

Status	Duration
Starting	0.19 ms
checking permissions	0.19 ms
Opening tables	0.12 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.06 ms
Optimizing	0.06 ms
Statistics	0.23 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.40 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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: 39.53 ms After last query: 21.32 ms

SELECT id, rules

  FROM `j6au3_viewlevels`

Explain

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

Profile

Status	Duration
Starting	0.15 ms
checking permissions	0.02 ms
Opening tables	38.39 ms
After opening tables	0.20 ms
System lock	0.01 ms
table lock	0.03 ms
init	0.04 ms
Optimizing	0.01 ms
Statistics	0.12 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.12 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1506
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:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.79 ms After last query: 0.47 ms

SELECT b.id

  FROM j6au3_usergroups AS a

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

  WHERE a.id = 1

Explain

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

Profile

Status	Duration
Starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.14 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.18 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1550
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:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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: 24.35 ms After last query: 1.34 ms

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

  FROM j6au3_extensions

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

  ORDER BY ordering

Explain

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

Profile

Status	Duration
Starting	0.13 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	9.30 ms
Preparing	0.09 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.06 ms
Creating sort index	11.04 ms
End of update loop	0.05 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	7.47 ms
Reset for next command	0.05 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
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:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.37 ms After last query: 45.61 ms

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

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

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

  ORDER BY m.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	18	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	ordasvit_joomla.m.component_id	1	Using where

Profile

Status	Duration
Starting	0.21 ms
checking permissions	0.02 ms
Opening tables	0.16 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.06 ms
Optimizing	0.03 ms
Statistics	0.13 ms
Preparing	0.04 ms
Sorting result	0.02 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.32 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.04 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
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:78
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:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
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:65
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:533
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1141
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.52 ms After last query: 625.11 ms

SHOW FULL COLUMNS 
  FROM `j6au3_os_cck_sef_urls`

Explain

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

Profile

Status	Duration
Starting	0.14 ms
checking permissions	0.02 ms
closing tables	0.01 ms
Opening tables	0.42 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.03 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.08 ms
After opening tables	0.01 ms
checking permissions	0.21 ms
closing tables	0.03 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.00 ms
Removing tmp table	0.10 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.02 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
13	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
12	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
11	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_os_cck/classes/sefurl.class.php:45
10	osCckSefurl->__construct()	JROOT/components/com_os_cck/router.php:648
9	Os_cckRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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: 1.42 ms

SELECT id 
  FROM j6au3_os_cck_sef_urls 
  WHERE hash_url_segments = '2628d16babe5adb87288174db1c6ec34'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j6au3_os_cck_sef_urls	ref	hash_url_segments	hash_url_segments	107	const	1	Using index condition

Profile

Status	Duration
Starting	0.18 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.02 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.13 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/components/com_os_cck/classes/sefurl.class.php:51
10	osCckSefurl->loadByHashUrlSegments()	JROOT/components/com_os_cck/router.php:651
9	Os_cckRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.39 ms After last query: 0.43 ms

Duplicate queries: #66

SELECT *

  FROM j6au3_os_cck_sef_urls

  WHERE `id` = '438'

Explain

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

Profile

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
12	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
11	Joomla\CMS\Table\Table->load()	JROOT/components/com_os_cck/classes/sefurl.class.php:53
10	osCckSefurl->loadByHashUrlSegments()	JROOT/components/com_os_cck/router.php:651
9	Os_cckRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.89 ms After last query: 1.35 ms

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

  FROM `j6au3_extensions`

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

Explain

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

Profile

Status	Duration
Starting	0.16 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.27 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
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:225
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.61 ms After last query: 0.51 ms

UPDATE `j6au3_extensions`

  SET `params` = '{\"mediaversion\":\"11793d2d1c7fa583a1b7894e99ca5010\"}'

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

Explain

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

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.16 ms
Updating	0.12 ms
End of update loop	0.01 ms
Waiting for query cache lock	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
Waiting for query cache lock	0.01 ms
Unlocking tables	0.05 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysql->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
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:225
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: 99.34 ms After last query: 3.67 ms

SELECT *

  FROM j6au3_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
Starting	0.14 ms
checking permissions	0.02 ms
Opening tables	0.15 ms
After opening tables	0.05 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
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:225
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: 207.77 ms After last query: 0.93 ms

SELECT id, home, template, s.params

  FROM j6au3_template_styles as s

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

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	7
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	ordasvit_joomla.s.template,const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.14 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.06 ms
Optimizing	0.04 ms
Statistics	0.26 ms
Preparing	0.06 ms
Executing	0.01 ms
Sending data	206.72 ms
End of update loop	0.06 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.05 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.76 ms After last query: 712.76 ms

SELECT `key`

  FROM j6au3_os_cck_api

  WHERE service = 'os_cck_activation'

Explain

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

Profile

Status	Duration
Starting	0.14 ms
checking permissions	0.04 ms
Opening tables	0.09 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/components/com_os_cck/functions.php:7253
7	checkOsCckActivation()	JROOT/components/com_os_cck/os_cck.php:123
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.51 ms After last query: 0.26 ms

SELECT eid, type, custom_fields, sql_select 
  FROM j6au3_os_cck_entity

Explain

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

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
8	JDatabaseDriver->loadObjectList()	JROOT/components/com_os_cck/functions.php:6560
7	os_cck_initialization()	JROOT/components/com_os_cck/os_cck.php:153
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.51 ms After last query: 0.24 ms

SELECT f.* 
  FROM j6au3_os_cck_entity_field AS f FORCE INDEX(fk_eid_field_name) 
  WHERE f.fk_eid IN (2,3,17,11,7,12,14,13,21) 
  ORDER BY field_name

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	f	range	fk_eid_field_name	fk_eid_field_name	4	NULL	54	Using index condition; Using filesort

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.03 ms
Opening tables	0.09 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.02 ms
Statistics	0.30 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.55 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
8	JDatabaseDriver->loadObjectList()	JROOT/components/com_os_cck/functions.php:6594
7	os_cck_initialization()	JROOT/components/com_os_cck/os_cck.php:153
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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: 12.91 ms After last query: 7.21 ms

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

  FROM j6au3_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_users.user' 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

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

Profile

Status	Duration
Starting	0.24 ms
checking permissions	0.02 ms
Opening tables	0.39 ms
After opening tables	0.07 ms
System lock	0.03 ms
table lock	0.02 ms
init	0.11 ms
Optimizing	0.05 ms
Statistics	0.42 ms
Preparing	0.06 ms
Creating tmp table	0.16 ms
Sorting result	0.05 ms
Executing	0.01 ms
Sending data	0.46 ms
Creating sort index	0.07 ms
Removing tmp table	0.08 ms
Creating sort index	0.04 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.07 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
11	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
10	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
9	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
8	FieldsHelper::getFields()	JROOT/components/com_os_cck/functions.php:6632
7	os_cck_initialization()	JROOT/components/com_os_cck/os_cck.php:153
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.78 ms After last query: 46.32 ms

SHOW FULL COLUMNS 
  FROM `j6au3_os_cck_entity_field`

Explain

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

Profile

Status	Duration
Starting	0.12 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.37 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
checking permissions	0.10 ms
closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.00 ms
Removing tmp table	0.61 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
11	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
10	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
9	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_os_cck/classes/field.class.php:33
8	os_cckEntityField->__construct()	JROOT/components/com_os_cck/functions.php:6685
7	os_cck_initialization()	JROOT/components/com_os_cck/os_cck.php:153
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 5.48 ms After last query: 8.90 ms

SELECT lid, type 
  FROM j6au3_os_cck_layout

Explain

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

Profile

Status	Duration
Starting	0.13 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.04 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	4.72 ms
End of update loop	0.05 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1506
8	JDatabaseDriver->loadAssocList()	JROOT/components/com_os_cck/functions.php:6831
7	os_cck_initialization()	JROOT/components/com_os_cck/os_cck.php:153
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.18 ms After last query: 7.17 ms

SHOW FULL COLUMNS 
  FROM `j6au3_menu`

Explain

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

Profile

Status	Duration
Starting	0.15 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	1.13 ms
After opening tables	0.03 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.03 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
checking permissions	0.16 ms
closing tables	0.03 ms
Executing	0.01 ms
Sending data	0.08 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.00 ms
Removing tmp table	0.08 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
15	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
14	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
13	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Menu.php:33
12	Joomla\CMS\Table\Menu->__construct()	JROOT/components/com_os_cck/php/instance.php:1515
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.15 ms After last query: 0.72 ms

Duplicate queries: #41 #64 #67 #73 #74

SELECT *

  FROM j6au3_menu

  WHERE `id` = '827'

Explain

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

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.02 ms
Statistics	0.15 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
12	Joomla\CMS\Table\Table->load()	JROOT/components/com_os_cck/php/instance.php:1516
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.75 ms After last query: 0.55 ms

SHOW FULL COLUMNS 
  FROM `j6au3_os_cck_layout`

Explain

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

Profile

Status	Duration
Starting	0.12 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.27 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.02 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
checking permissions	0.10 ms
closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.02 ms
Commit	0.56 ms
closing tables	0.01 ms
Removing tmp table	0.12 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
15	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
14	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
13	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_os_cck/classes/layout.class.php:34
12	os_cckLayout->__construct()	JROOT/components/com_os_cck/php/instance.php:1543
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.41 ms After last query: 1.10 ms

SHOW FULL COLUMNS 
  FROM `j6au3_os_cck_entity_instance`

Explain

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

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.52 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.10 ms
After opening tables	0.01 ms
checking permissions	0.15 ms
closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Removing tmp table	0.07 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
15	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
14	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
13	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_os_cck/classes/instance.class.php:53
12	os_cckEntityInstance->__construct()	JROOT/components/com_os_cck/php/instance.php:1546
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.56 ms After last query: 0.63 ms

SELECT *

  FROM j6au3_os_cck_layout

  WHERE `lid` = '270'

Explain

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

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.10 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.09 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
12	Joomla\CMS\Table\Table->load()	JROOT/components/com_os_cck/php/instance.php:1790
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.46 ms After last query: 0.25 ms

SHOW FULL COLUMNS 
  FROM `j6au3_os_cck_entity`

Explain

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

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.60 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.13 ms
closing tables	0.21 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.00 ms
Removing tmp table	0.09 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
15	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
14	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
13	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_os_cck/classes/entity.class.php:40
12	os_cckEntity->__construct()	JROOT/components/com_os_cck/php/instance.php:1792
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.42 ms After last query: 0.49 ms

SELECT *

  FROM j6au3_os_cck_entity

  WHERE `eid` = '17'

Explain

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

Profile

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
12	Joomla\CMS\Table\Table->load()	JROOT/components/com_os_cck/php/instance.php:1793
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.77 ms After last query: 0.38 ms

SELECT eiid 
  FROM j6au3_os_cck_entity_instance as i 
 
  LEFT JOIN j6au3_os_cck_layout as l 
  ON l.lid = i.fk_lid 
 
  LEFT JOIN j6au3_os_cck_categories_connect as cc 
  ON cc.fk_eiid = i.eiid 
 
  WHERE l.type ='add_instance'  
  AND i.published=1 
 
  AND i.approved=1   
  AND i.eiid > 821
 
  AND i.fk_eid= 17
 
  ORDER BY eiid 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	ref	PRIMARY,fk_eid,fk_lid	fk_eid	4	const	7	Using where; Using filesort
1	SIMPLE	l	eq_ref	PRIMARY	PRIMARY	4	ordasvit_joomla.i.fk_lid	1	Using index condition; Using where
1	SIMPLE	cc	ref	fk_eiid,fk_eiid_fk_cid	fk_eiid	4	ordasvit_joomla.i.eiid	2	Using where; Using index

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.12 ms
Preparing	0.05 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.19 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/components/com_os_cck/php/instance.php:1821
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.46 ms After last query: 0.14 ms

SELECT eiid 
  FROM j6au3_os_cck_entity_instance as i 
 
  LEFT JOIN j6au3_os_cck_layout as l 
  ON l.lid = i.fk_lid 
 
  LEFT JOIN j6au3_os_cck_categories_connect as cc 
  ON cc.fk_eiid = i.eiid 
 
  WHERE l.type ='add_instance'  
  AND i.published=1 
 
  AND i.approved=1   
  AND i.eiid < 821
 
  AND i.fk_eid= 17
 
  ORDER BY eiid DESC 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	ref\|filter	PRIMARY,fk_eid,fk_lid	fk_eid\|PRIMARY	4\|4	const	7 (22%)	Using where; Using filesort; Using rowid filter
1	SIMPLE	l	eq_ref	PRIMARY	PRIMARY	4	ordasvit_joomla.i.fk_lid	1	Using index condition; Using where
1	SIMPLE	cc	ref	fk_eiid,fk_eiid_fk_cid	fk_eiid	4	ordasvit_joomla.i.eiid	2	Using where; Using index

Profile

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Creating sort index	0.05 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/components/com_os_cck/php/instance.php:1831
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 0.33 ms

Duplicate queries: #44 #48 #52

SELECT *

  FROM j6au3_os_cck_entity_instance

  WHERE `eiid` = '821'

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
13	Joomla\CMS\Table\Table->load()	JROOT/components/com_os_cck/classes/instance.class.php:296
12	os_cckEntityInstance->load()	JROOT/components/com_os_cck/php/instance.php:1869
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.49 ms After last query: 0.21 ms

Duplicate queries: #45 #49 #53

SELECT * 
  FROM j6au3_os_cck_content_entity_17 
  WHERE fk_eiid=821

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j6au3_os_cck_content_entity_17	ref	fk_eiid	fk_eiid	4	const	1

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.13 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
13	JDatabaseDriver->loadAssoc()	JROOT/components/com_os_cck/classes/instance.class.php:307
12	os_cckEntityInstance->load()	JROOT/components/com_os_cck/php/instance.php:1869
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.24 ms After last query: 0.29 ms

UPDATE j6au3_os_cck_entity_instance 
  SET 
 featured_clicks = featured_clicks-1
 
  WHERE eiid=821

Explain

EXPLAIN not possible on query: UPDATE j6au3_os_cck_entity_instance SET featured_clicks = featured_clicks-1 WHERE eiid=821

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.08 ms
Updating	0.32 ms
End of update loop	0.01 ms
Waiting for query cache lock	2.46 ms
End of update loop	0.04 ms
Query end	0.01 ms
Commit	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
Waiting for query cache lock	0.01 ms
Unlocking tables	0.04 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysql->execute()	JROOT/components/com_os_cck/php/instance.php:1895
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.01 ms After last query: 0.45 ms

SELECT * 
  FROM j6au3_os_cck_categories AS cc 
 
  LEFT JOIN j6au3_os_cck_categories_connect AS ccc 
  ON cc.cid=ccc.fk_cid 
 
  WHERE ccc.fk_eiid=821
 
  LIMIT 0,1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ccc	ref	fk_eiid,fk_cid,fk_eiid_fk_cid	fk_eiid	4	const	1	Using where
1	SIMPLE	cc	eq_ref	PRIMARY	PRIMARY	4	ordasvit_joomla.ccc.fk_cid	1

Profile

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.11 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.07 ms
Optimizing	0.03 ms
Statistics	0.19 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.10 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_os_cck/php/instance.php:2011
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.87 ms After last query: 2.98 ms

UPDATE j6au3_os_cck_entity_instance 
  SET hits = hits + 1 
  WHERE eiid = 821

Explain

EXPLAIN not possible on query: UPDATE j6au3_os_cck_entity_instance SET hits = hits + 1 WHERE eiid = 821

Profile

Status	Duration
Starting	0.13 ms
checking permissions	0.27 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.11 ms
Updating	0.07 ms
End of update loop	0.01 ms
Waiting for query cache lock	0.00 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.02 ms
Waiting for query cache lock	0.00 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysql->execute()	JROOT/components/com_os_cck/php/instance.php:2043
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 4.75 ms After last query: 0.97 ms

SELECT layout_html 
  FROM j6au3_os_cck_layout as c 
 
  LEFT JOIN j6au3_os_cck_layout_html as ch 
  ON c.lid = ch.fk_lid
 
  WHERE c.lid=270
 
  AND c.published = '1' 
  AND bootstrap = '3'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,published	PRIMARY	4	const	1
1	SIMPLE	ch	ref	fk_lid	fk_lid	5	const	2	Using where

Profile

Status	Duration
Starting	0.25 ms
checking permissions	0.01 ms
Opening tables	0.09 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.62 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Executing	2.25 ms
Sending data	0.98 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.05 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.01 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_os_cck/classes/layout.class.php:106
12	os_cckLayout->getLayoutHtml()	JROOT/components/com_os_cck/php/instance.php:2051
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.51 ms After last query: 1.06 ms

UPDATE j6au3_os_cck_entity_instance 
  SET 
 featured_shows = featured_shows-1
 
  WHERE eiid=821

Explain

EXPLAIN not possible on query: UPDATE j6au3_os_cck_entity_instance SET featured_shows = featured_shows-1 WHERE eiid=821

Profile

Status	Duration
Starting	0.11 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.09 ms
Updating	0.07 ms
End of update loop	0.01 ms
Waiting for query cache lock	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
Waiting for query cache lock	0.00 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysql->execute()	JROOT/components/com_os_cck/php/instance.php:2115
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.41 ms After last query: 0.11 ms

SELECT * 
  FROM `j6au3_os_cck_categories` e 
  WHERE e.`cid` = 35

Explain

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

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_os_cck/php/instance.php:2126
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.03 ms After last query: 17.20 ms

SELECT cc.title AS title ,cc.cid as catid, cc.image as image
 
  FROM j6au3_os_cck_entity_instance AS jei 
 
  LEFT JOIN j6au3_os_cck_categories_connect AS c 
  ON jei.eiid=c.fk_eiid 
 
  LEFT JOIN j6au3_os_cck_categories AS cc 
  ON cc.cid = c.fk_cid 
 
  WHERE jei.eiid=821

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jei	const	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	c	ref	fk_eiid,fk_eiid_fk_cid	fk_eiid_fk_cid	4	const	1	Using index
1	SIMPLE	cc	eq_ref	PRIMARY	PRIMARY	4	ordasvit_joomla.c.fk_cid	1	Using where

Profile

Status	Duration
Starting	0.19 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	1.26 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_os_cck/classes/instance.class.php:1243
15	os_cckEntityInstance->getFieldValue()	JROOT/components/com_os_cck/functions.php:298
14	replaceMaskCustomCodePHP()	JROOT/components/com_os_cck/classes/layout.class.php:270
13	os_cckLayout->getLayoutViews()	JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php:131
12	require JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php	JROOT/components/com_os_cck/php/instance.php:2146
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.57 ms After last query: 5.38 ms

SELECT cc.title AS title ,cc.cid as catid, cc.image as image
 
  FROM j6au3_os_cck_entity_instance AS jei 
 
  LEFT JOIN j6au3_os_cck_categories_connect AS c 
  ON jei.eiid=c.fk_eiid 
 
  LEFT JOIN j6au3_os_cck_categories AS cc 
  ON cc.cid = c.fk_cid 
 
  WHERE jei.eiid=821 
  ORDER BY cc.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jei	const	PRIMARY	PRIMARY	4	const	1	Using index; Using temporary; Using filesort
1	SIMPLE	c	ref	fk_eiid,fk_eiid_fk_cid	fk_eiid_fk_cid	4	const	1	Using index
1	SIMPLE	cc	eq_ref	PRIMARY	PRIMARY	4	ordasvit_joomla.c.fk_cid	1	Using where

Profile

Status	Duration
Starting	0.49 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
After opening tables	0.32 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.13 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Creating tmp table	0.04 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.07 ms
Creating sort index	0.03 ms
Removing tmp table	0.02 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_os_cck/classes/instance.class.php:1243
14	os_cckEntityInstance->getFieldValue()	JROOT/components/com_os_cck/classes/layout.class.php:321
13	os_cckLayout->getLayoutViews()	JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php:131
12	require JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php	JROOT/components/com_os_cck/php/instance.php:2146
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.27 ms After last query: 2.50 ms

Duplicate queries: #23 #64 #67 #73 #74

SELECT *

  FROM j6au3_menu

  WHERE `id` = '827'

Explain

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

Profile

Status	Duration
Starting	0.37 ms
checking permissions	0.37 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.03 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
24	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
23	Joomla\CMS\Table\Table->load()	JROOT/components/com_os_cck/functions.php:8528
22	get_menu_url_alias_cck()	JROOT/components/com_os_cck/router.php:77
21	Os_cckRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_os_cck/views/fieldsList/show/categoryfield/tmpl/tmpl_default.php:90
14	require JROOT/components/com_os_cck/views/fieldsList/show/categoryfield/tmpl/tmpl_default.php	JROOT/components/com_os_cck/classes/layout.class.php:540
13	os_cckLayout->getLayoutViews()	JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php:131
12	require JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php	JROOT/components/com_os_cck/php/instance.php:2146
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.83 ms After last query: 0.47 ms

SELECT id 
  FROM j6au3_os_cck_sef_urls 
  WHERE hash_vars = '4454efdf017eb39bcd52bc836c523987'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j6au3_os_cck_sef_urls	ref	hash_vars	hash_vars	107	const	1	Using index condition

Profile

Status	Duration
Starting	0.35 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.14 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1740
23	JDatabaseDriver->loadResult()	JROOT/components/com_os_cck/classes/sefurl.class.php:62
22	osCckSefurl->loadByHashVars()	JROOT/components/com_os_cck/router.php:108
21	Os_cckRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_os_cck/views/fieldsList/show/categoryfield/tmpl/tmpl_default.php:90
14	require JROOT/components/com_os_cck/views/fieldsList/show/categoryfield/tmpl/tmpl_default.php	JROOT/components/com_os_cck/classes/layout.class.php:540
13	os_cckLayout->getLayoutViews()	JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php:131
12	require JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php	JROOT/components/com_os_cck/php/instance.php:2146
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.43 ms After last query: 0.74 ms

SELECT *

  FROM j6au3_os_cck_sef_urls

  WHERE `id` = '413'

Explain

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

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
24	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
23	Joomla\CMS\Table\Table->load()	JROOT/components/com_os_cck/classes/sefurl.class.php:64
22	osCckSefurl->loadByHashVars()	JROOT/components/com_os_cck/router.php:108
21	Os_cckRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_os_cck/views/fieldsList/show/categoryfield/tmpl/tmpl_default.php:90
14	require JROOT/components/com_os_cck/views/fieldsList/show/categoryfield/tmpl/tmpl_default.php	JROOT/components/com_os_cck/classes/layout.class.php:540
13	os_cckLayout->getLayoutViews()	JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php:131
12	require JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php	JROOT/components/com_os_cck/php/instance.php:2146
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.41 ms After last query: 3.65 ms

Duplicate queries: #31 #48 #52

SELECT *

  FROM j6au3_os_cck_entity_instance

  WHERE `eiid` = '821'

Explain

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

Profile

Status	Duration
Starting	0.70 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.19 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
16	Joomla\CMS\Table\Table->load()	JROOT/components/com_os_cck/classes/instance.class.php:296
15	os_cckEntityInstance->load()	JROOT/components/com_os_cck/functions.php:4549
14	checkAccess_cck()	JROOT/components/com_os_cck/classes/layout.class.php:591
13	os_cckLayout->getLayoutViews()	JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php:131
12	require JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php	JROOT/components/com_os_cck/php/instance.php:2146
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.40 ms After last query: 0.36 ms

Duplicate queries: #32 #49 #53

SELECT * 
  FROM j6au3_os_cck_content_entity_17 
  WHERE fk_eiid=821

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j6au3_os_cck_content_entity_17	ref	fk_eiid	fk_eiid	4	const	1

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.03 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.02 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
16	JDatabaseDriver->loadAssoc()	JROOT/components/com_os_cck/classes/instance.class.php:307
15	os_cckEntityInstance->load()	JROOT/components/com_os_cck/functions.php:4549
14	checkAccess_cck()	JROOT/components/com_os_cck/classes/layout.class.php:591
13	os_cckLayout->getLayoutViews()	JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php:131
12	require JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php	JROOT/components/com_os_cck/php/instance.php:2146
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.74 ms After last query: 6.59 ms

SELECT *

  FROM j6au3_os_cck_layout

  WHERE `lid` = '262'

Explain

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

Profile

Status	Duration
Starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.13 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
16	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
15	Joomla\CMS\Table\Table->load()	JROOT/components/com_os_cck/php/instance.php:4628
14	Instance::show_request_layout()	JROOT/components/com_os_cck/classes/layout.class.php:655
13	os_cckLayout->getLayoutViews()	JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php:131
12	require JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php	JROOT/components/com_os_cck/php/instance.php:2146
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.03 ms After last query: 0.25 ms

SELECT layout_html 
  FROM j6au3_os_cck_layout as c 
 
  LEFT JOIN j6au3_os_cck_layout_html as ch 
  ON c.lid = ch.fk_lid
 
  WHERE c.lid=262
 
  AND c.published = '1' 
  AND bootstrap = '3'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,published	PRIMARY	4	const	1
1	SIMPLE	ch	ref	fk_lid	fk_lid	5	const	2	Using where

Profile

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.10 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.15 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_os_cck/classes/layout.class.php:106
15	os_cckLayout->getLayoutHtml()	JROOT/components/com_os_cck/php/instance.php:4631
14	Instance::show_request_layout()	JROOT/components/com_os_cck/classes/layout.class.php:655
13	os_cckLayout->getLayoutViews()	JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php:131
12	require JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php	JROOT/components/com_os_cck/php/instance.php:2146
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.41 ms After last query: 0.81 ms

Duplicate queries: #31 #44 #52

SELECT *

  FROM j6au3_os_cck_entity_instance

  WHERE `eiid` = '821'

Explain

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

Profile

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
16	Joomla\CMS\Table\Table->load()	JROOT/components/com_os_cck/classes/instance.class.php:296
15	os_cckEntityInstance->load()	JROOT/components/com_os_cck/php/instance.php:4727
14	Instance::show_request_layout()	JROOT/components/com_os_cck/classes/layout.class.php:655
13	os_cckLayout->getLayoutViews()	JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php:131
12	require JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php	JROOT/components/com_os_cck/php/instance.php:2146
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 0.20 ms

Duplicate queries: #32 #45 #53

SELECT * 
  FROM j6au3_os_cck_content_entity_17 
  WHERE fk_eiid=821

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j6au3_os_cck_content_entity_17	ref	fk_eiid	fk_eiid	4	const	1

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
16	JDatabaseDriver->loadAssoc()	JROOT/components/com_os_cck/classes/instance.class.php:307
15	os_cckEntityInstance->load()	JROOT/components/com_os_cck/php/instance.php:4727
14	Instance::show_request_layout()	JROOT/components/com_os_cck/classes/layout.class.php:655
13	os_cckLayout->getLayoutViews()	JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php:131
12	require JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php	JROOT/components/com_os_cck/php/instance.php:2146
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.69 ms After last query: 8.92 ms

SELECT *

  FROM j6au3_os_cck_layout

  WHERE `lid` = '266'

Explain

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

Profile

Status	Duration
Starting	0.14 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
16	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
15	Joomla\CMS\Table\Table->load()	JROOT/components/com_os_cck/php/instance.php:4628
14	Instance::show_request_layout()	JROOT/components/com_os_cck/classes/layout.class.php:655
13	os_cckLayout->getLayoutViews()	JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php:131
12	require JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php	JROOT/components/com_os_cck/php/instance.php:2146
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.65 ms After last query: 0.32 ms

SELECT layout_html 
  FROM j6au3_os_cck_layout as c 
 
  LEFT JOIN j6au3_os_cck_layout_html as ch 
  ON c.lid = ch.fk_lid
 
  WHERE c.lid=266
 
  AND c.published = '1' 
  AND bootstrap = '3'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,published	PRIMARY	4	const	1
1	SIMPLE	ch	ref	fk_lid	fk_lid	5	const	2	Using where

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.12 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.16 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_os_cck/classes/layout.class.php:106
15	os_cckLayout->getLayoutHtml()	JROOT/components/com_os_cck/php/instance.php:4631
14	Instance::show_request_layout()	JROOT/components/com_os_cck/classes/layout.class.php:655
13	os_cckLayout->getLayoutViews()	JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php:131
12	require JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php	JROOT/components/com_os_cck/php/instance.php:2146
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.92 ms After last query: 0.44 ms

Duplicate queries: #31 #44 #48

SELECT *

  FROM j6au3_os_cck_entity_instance

  WHERE `eiid` = '821'

Explain

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

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.03 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
16	Joomla\CMS\Table\Table->load()	JROOT/components/com_os_cck/classes/instance.class.php:296
15	os_cckEntityInstance->load()	JROOT/components/com_os_cck/php/instance.php:4666
14	Instance::show_request_layout()	JROOT/components/com_os_cck/classes/layout.class.php:655
13	os_cckLayout->getLayoutViews()	JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php:131
12	require JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php	JROOT/components/com_os_cck/php/instance.php:2146
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.67 ms After last query: 0.49 ms

Duplicate queries: #32 #45 #49

SELECT * 
  FROM j6au3_os_cck_content_entity_17 
  WHERE fk_eiid=821

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j6au3_os_cck_content_entity_17	ref	fk_eiid	fk_eiid	4	const	1

Profile

Status	Duration
Starting	0.20 ms
checking permissions	0.04 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.93 ms
Statistics	0.09 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
16	JDatabaseDriver->loadAssoc()	JROOT/components/com_os_cck/classes/instance.class.php:307
15	os_cckEntityInstance->load()	JROOT/components/com_os_cck/php/instance.php:4666
14	Instance::show_request_layout()	JROOT/components/com_os_cck/classes/layout.class.php:655
13	os_cckLayout->getLayoutViews()	JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php:131
12	require JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php	JROOT/components/com_os_cck/php/instance.php:2146
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.00 ms After last query: 0.35 ms

SELECT COUNT(ei2.eiid) 
  FROM j6au3_os_cck_entity_instance as ei
 
  LEFT JOIN j6au3_os_cck_child_parent_connect as pc 
  ON pc.fid_parent = ei.eiid
 
  LEFT JOIN j6au3_os_cck_entity_instance as ei2 
  ON pc.fid_child = ei2.eiid
 
  LEFT JOIN j6au3_os_cck_layout as l 
  ON l.lid = ei2.fk_lid
 
  LEFT JOIN j6au3_users as u 
  ON u.id = ei2.fk_userid
 
  WHERE fid_parent=821 
  AND l.type='review_instance' 
  AND ei2.published = 1 
  AND ei2.approved = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ei	const	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	pc	ref	fid_parent,fid_child	fid_parent	4	const	2
1	SIMPLE	ei2	eq_ref	PRIMARY,fk_lid	PRIMARY	4	ordasvit_joomla.pc.fid_child	1	Using where
1	SIMPLE	l	eq_ref	PRIMARY	PRIMARY	4	ordasvit_joomla.ei2.fk_lid	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.13 ms
checking permissions	0.01 ms
Opening tables	0.15 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.21 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.05 ms
Executing	0.03 ms
Sending data	0.11 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_os_cck/classes/instance.class.php:340
15	os_cckEntityInstance->getReviews()	JROOT/components/com_os_cck/php/instance.php:4674
14	Instance::show_request_layout()	JROOT/components/com_os_cck/classes/layout.class.php:655
13	os_cckLayout->getLayoutViews()	JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php:131
12	require JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php	JROOT/components/com_os_cck/php/instance.php:2146
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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: 17.88 ms After last query: 5.98 ms

SELECT ei2.*,u.*,l.params 
  FROM j6au3_os_cck_entity_instance as ei
 
  LEFT JOIN j6au3_os_cck_child_parent_connect as pc 
  ON pc.fid_parent = ei.eiid
 
  LEFT JOIN j6au3_os_cck_entity_instance as ei2 
  ON pc.fid_child = ei2.eiid
 
  LEFT JOIN `j6au3_os_cck_content_entity_17` as instance 
  ON instance.`fk_eiid` = ei2.eiid 
 
  LEFT JOIN j6au3_os_cck_layout as l 
  ON l.lid = ei2.fk_lid
 
  LEFT JOIN j6au3_users as u 
  ON u.id = ei2.fk_userid
 
  WHERE fid_parent=821 
  AND l.type='review_instance' 
  AND ei2.published = 1 
  AND ei2.approved = 1  
  ORDER BY ei2.eiid ASC  
  LIMIT 0, 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ei	const	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	pc	ref	fid_parent,fid_child	fid_parent	4	const	2	Using where; Using filesort
1	SIMPLE	ei2	eq_ref	PRIMARY,fk_lid	PRIMARY	4	ordasvit_joomla.pc.fid_child	1	Using where
1	SIMPLE	instance	ref	fk_eiid	fk_eiid	4	ordasvit_joomla.pc.fid_child	1	Using index
1	SIMPLE	l	eq_ref	PRIMARY	PRIMARY	4	ordasvit_joomla.ei2.fk_lid	1	Using index condition; Using where
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	ordasvit_joomla.ei2.fk_userid	1

Profile

Status	Duration
Starting	0.25 ms
checking permissions	0.03 ms
Opening tables	0.09 ms
After opening tables	0.02 ms
System lock	2.62 ms
table lock	0.07 ms
init	2.27 ms
Optimizing	0.10 ms
Statistics	3.37 ms
Preparing	0.05 ms
Unlocking tables	0.01 ms
Preparing	0.11 ms
Sorting result	0.44 ms
Executing	0.01 ms
Sending data	0.04 ms
Creating sort index	1.63 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.04 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_os_cck/classes/instance.class.php:432
15	os_cckEntityInstance->getReviews()	JROOT/components/com_os_cck/php/instance.php:4674
14	Instance::show_request_layout()	JROOT/components/com_os_cck/classes/layout.class.php:655
13	os_cckLayout->getLayoutViews()	JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php:131
12	require JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php	JROOT/components/com_os_cck/php/instance.php:2146
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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: 11.62 ms After last query: 2.57 ms

Duplicate queries: #58 #60 #62

SELECT *

  FROM j6au3_os_cck_entity_instance

  WHERE `eiid` = '860'

Explain

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

Profile

Status	Duration
Starting	0.15 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
16	Joomla\CMS\Table\Table->load()	JROOT/components/com_os_cck/classes/instance.class.php:296
15	os_cckEntityInstance->load()	JROOT/components/com_os_cck/php/instance.php:4682
14	Instance::show_request_layout()	JROOT/components/com_os_cck/classes/layout.class.php:655
13	os_cckLayout->getLayoutViews()	JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php:131
12	require JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php	JROOT/components/com_os_cck/php/instance.php:2146
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.57 ms After last query: 1.08 ms

Duplicate queries: #59 #61 #63

SELECT * 
  FROM j6au3_os_cck_content_entity_17 
  WHERE fk_eiid=860

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j6au3_os_cck_content_entity_17	ref	fk_eiid	fk_eiid	4	const	1

Profile

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
16	JDatabaseDriver->loadAssoc()	JROOT/components/com_os_cck/classes/instance.class.php:307
15	os_cckEntityInstance->load()	JROOT/components/com_os_cck/php/instance.php:4682
14	Instance::show_request_layout()	JROOT/components/com_os_cck/classes/layout.class.php:655
13	os_cckLayout->getLayoutViews()	JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php:131
12	require JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php	JROOT/components/com_os_cck/php/instance.php:2146
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.73 ms After last query: 6.13 ms

Duplicate queries: #56 #60 #62

SELECT *

  FROM j6au3_os_cck_entity_instance

  WHERE `eiid` = '860'

Explain

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

Profile

Status	Duration
Starting	0.13 ms
checking permissions	0.01 ms
Opening tables	0.09 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
19	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
18	Joomla\CMS\Table\Table->load()	JROOT/components/com_os_cck/classes/instance.class.php:296
17	os_cckEntityInstance->load()	JROOT/components/com_os_cck/functions.php:4549
16	checkAccess_cck()	JROOT/components/com_os_cck/views/show_review_instance/tmpl/tmpl_default.php:336
15	require JROOT/components/com_os_cck/views/show_review_instance/tmpl/tmpl_default.php	JROOT/components/com_os_cck/php/instance.php:4703
14	Instance::show_request_layout()	JROOT/components/com_os_cck/classes/layout.class.php:655
13	os_cckLayout->getLayoutViews()	JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php:131
12	require JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php	JROOT/components/com_os_cck/php/instance.php:2146
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.66 ms After last query: 0.23 ms

Duplicate queries: #57 #61 #63

SELECT * 
  FROM j6au3_os_cck_content_entity_17 
  WHERE fk_eiid=860

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j6au3_os_cck_content_entity_17	ref	fk_eiid	fk_eiid	4	const	1

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.34 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
18	JDatabaseDriver->loadAssoc()	JROOT/components/com_os_cck/classes/instance.class.php:307
17	os_cckEntityInstance->load()	JROOT/components/com_os_cck/functions.php:4549
16	checkAccess_cck()	JROOT/components/com_os_cck/views/show_review_instance/tmpl/tmpl_default.php:336
15	require JROOT/components/com_os_cck/views/show_review_instance/tmpl/tmpl_default.php	JROOT/components/com_os_cck/php/instance.php:4703
14	Instance::show_request_layout()	JROOT/components/com_os_cck/classes/layout.class.php:655
13	os_cckLayout->getLayoutViews()	JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php:131
12	require JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php	JROOT/components/com_os_cck/php/instance.php:2146
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.73 ms After last query: 1.78 ms

Duplicate queries: #56 #58 #62

SELECT *

  FROM j6au3_os_cck_entity_instance

  WHERE `eiid` = '860'

Explain

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

Profile

Status	Duration
Starting	0.23 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
19	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
18	Joomla\CMS\Table\Table->load()	JROOT/components/com_os_cck/classes/instance.class.php:296
17	os_cckEntityInstance->load()	JROOT/components/com_os_cck/functions.php:4549
16	checkAccess_cck()	JROOT/components/com_os_cck/views/show_review_instance/tmpl/tmpl_default.php:336
15	require JROOT/components/com_os_cck/views/show_review_instance/tmpl/tmpl_default.php	JROOT/components/com_os_cck/php/instance.php:4703
14	Instance::show_request_layout()	JROOT/components/com_os_cck/classes/layout.class.php:655
13	os_cckLayout->getLayoutViews()	JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php:131
12	require JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php	JROOT/components/com_os_cck/php/instance.php:2146
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.64 ms After last query: 0.24 ms

Duplicate queries: #57 #59 #63

SELECT * 
  FROM j6au3_os_cck_content_entity_17 
  WHERE fk_eiid=860

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j6au3_os_cck_content_entity_17	ref	fk_eiid	fk_eiid	4	const	1

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.28 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
18	JDatabaseDriver->loadAssoc()	JROOT/components/com_os_cck/classes/instance.class.php:307
17	os_cckEntityInstance->load()	JROOT/components/com_os_cck/functions.php:4549
16	checkAccess_cck()	JROOT/components/com_os_cck/views/show_review_instance/tmpl/tmpl_default.php:336
15	require JROOT/components/com_os_cck/views/show_review_instance/tmpl/tmpl_default.php	JROOT/components/com_os_cck/php/instance.php:4703
14	Instance::show_request_layout()	JROOT/components/com_os_cck/classes/layout.class.php:655
13	os_cckLayout->getLayoutViews()	JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php:131
12	require JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php	JROOT/components/com_os_cck/php/instance.php:2146
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.47 ms After last query: 1.41 ms

Duplicate queries: #56 #58 #60

SELECT *

  FROM j6au3_os_cck_entity_instance

  WHERE `eiid` = '860'

Explain

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

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
19	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
18	Joomla\CMS\Table\Table->load()	JROOT/components/com_os_cck/classes/instance.class.php:296
17	os_cckEntityInstance->load()	JROOT/components/com_os_cck/functions.php:4549
16	checkAccess_cck()	JROOT/components/com_os_cck/views/show_review_instance/tmpl/tmpl_default.php:336
15	require JROOT/components/com_os_cck/views/show_review_instance/tmpl/tmpl_default.php	JROOT/components/com_os_cck/php/instance.php:4703
14	Instance::show_request_layout()	JROOT/components/com_os_cck/classes/layout.class.php:655
13	os_cckLayout->getLayoutViews()	JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php:131
12	require JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php	JROOT/components/com_os_cck/php/instance.php:2146
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.35 ms After last query: 0.22 ms

Duplicate queries: #57 #59 #61

SELECT * 
  FROM j6au3_os_cck_content_entity_17 
  WHERE fk_eiid=860

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j6au3_os_cck_content_entity_17	ref	fk_eiid	fk_eiid	4	const	1

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.02 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
18	JDatabaseDriver->loadAssoc()	JROOT/components/com_os_cck/classes/instance.class.php:307
17	os_cckEntityInstance->load()	JROOT/components/com_os_cck/functions.php:4549
16	checkAccess_cck()	JROOT/components/com_os_cck/views/show_review_instance/tmpl/tmpl_default.php:336
15	require JROOT/components/com_os_cck/views/show_review_instance/tmpl/tmpl_default.php	JROOT/components/com_os_cck/php/instance.php:4703
14	Instance::show_request_layout()	JROOT/components/com_os_cck/classes/layout.class.php:655
13	os_cckLayout->getLayoutViews()	JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php:131
12	require JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php	JROOT/components/com_os_cck/php/instance.php:2146
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.74 ms After last query: 3.39 ms

Duplicate queries: #23 #41 #67 #73 #74

SELECT *

  FROM j6au3_menu

  WHERE `id` = '827'

Explain

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

Profile

Status	Duration
Starting	0.13 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.08 ms
Optimizing	0.02 ms
Statistics	0.09 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
25	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
24	Joomla\CMS\Table\Table->load()	JROOT/components/com_os_cck/functions.php:8528
23	get_menu_url_alias_cck()	JROOT/components/com_os_cck/router.php:77
22	Os_cckRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
21	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
20	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
16	Joomla\CMS\Router\Route::_()	JROOT/libraries/src/Pagination/Pagination.php:787
15	Joomla\CMS\Pagination\Pagination->_buildDataObject()	JROOT/libraries/src/Pagination/Pagination.php:328
14	Joomla\CMS\Pagination\Pagination->getPagesLinks()	JROOT/components/com_os_cck/classes/layout.class.php:1287
13	os_cckLayout->getLayoutViews()	JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php:131
12	require JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php	JROOT/components/com_os_cck/php/instance.php:2146
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.41 ms After last query: 0.36 ms

SELECT id 
  FROM j6au3_os_cck_sef_urls 
  WHERE hash_vars = '6eec03a610979593cb55a5c07c33069b'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j6au3_os_cck_sef_urls	ref	hash_vars	hash_vars	107	const	1	Using index condition

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.09 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1740
24	JDatabaseDriver->loadResult()	JROOT/components/com_os_cck/classes/sefurl.class.php:62
23	osCckSefurl->loadByHashVars()	JROOT/components/com_os_cck/router.php:108
22	Os_cckRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
21	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
20	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
16	Joomla\CMS\Router\Route::_()	JROOT/libraries/src/Pagination/Pagination.php:787
15	Joomla\CMS\Pagination\Pagination->_buildDataObject()	JROOT/libraries/src/Pagination/Pagination.php:328
14	Joomla\CMS\Pagination\Pagination->getPagesLinks()	JROOT/components/com_os_cck/classes/layout.class.php:1287
13	os_cckLayout->getLayoutViews()	JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php:131
12	require JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php	JROOT/components/com_os_cck/php/instance.php:2146
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.27 ms After last query: 0.26 ms

Duplicate queries: #11

SELECT *

  FROM j6au3_os_cck_sef_urls

  WHERE `id` = '438'

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
25	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
24	Joomla\CMS\Table\Table->load()	JROOT/components/com_os_cck/classes/sefurl.class.php:64
23	osCckSefurl->loadByHashVars()	JROOT/components/com_os_cck/router.php:108
22	Os_cckRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
21	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
20	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
16	Joomla\CMS\Router\Route::_()	JROOT/libraries/src/Pagination/Pagination.php:787
15	Joomla\CMS\Pagination\Pagination->_buildDataObject()	JROOT/libraries/src/Pagination/Pagination.php:328
14	Joomla\CMS\Pagination\Pagination->getPagesLinks()	JROOT/components/com_os_cck/classes/layout.class.php:1287
13	os_cckLayout->getLayoutViews()	JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php:131
12	require JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php	JROOT/components/com_os_cck/php/instance.php:2146
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.45 ms After last query: 1.17 ms

Duplicate queries: #23 #41 #64 #73 #74

SELECT *

  FROM j6au3_menu

  WHERE `id` = '827'

Explain

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

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
25	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
24	Joomla\CMS\Table\Table->load()	JROOT/components/com_os_cck/functions.php:8528
23	get_menu_url_alias_cck()	JROOT/components/com_os_cck/router.php:77
22	Os_cckRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
21	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
20	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
16	Joomla\CMS\Router\Route::_()	JROOT/libraries/src/Pagination/Pagination.php:830
15	Joomla\CMS\Pagination\Pagination->_buildDataObject()	JROOT/libraries/src/Pagination/Pagination.php:328
14	Joomla\CMS\Pagination\Pagination->getPagesLinks()	JROOT/components/com_os_cck/classes/layout.class.php:1287
13	os_cckLayout->getLayoutViews()	JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php:131
12	require JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php	JROOT/components/com_os_cck/php/instance.php:2146
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.38 ms After last query: 0.30 ms

SELECT id 
  FROM j6au3_os_cck_sef_urls 
  WHERE hash_vars = 'd33408aaf3ccb3aaabf7df7d4273e99d'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j6au3_os_cck_sef_urls	ref	hash_vars	hash_vars	107	const	1	Using index condition

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.03 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.07 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1740
24	JDatabaseDriver->loadResult()	JROOT/components/com_os_cck/classes/sefurl.class.php:62
23	osCckSefurl->loadByHashVars()	JROOT/components/com_os_cck/router.php:108
22	Os_cckRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
21	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
20	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
16	Joomla\CMS\Router\Route::_()	JROOT/libraries/src/Pagination/Pagination.php:830
15	Joomla\CMS\Pagination\Pagination->_buildDataObject()	JROOT/libraries/src/Pagination/Pagination.php:328
14	Joomla\CMS\Pagination\Pagination->getPagesLinks()	JROOT/components/com_os_cck/classes/layout.class.php:1287
13	os_cckLayout->getLayoutViews()	JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php:131
12	require JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php	JROOT/components/com_os_cck/php/instance.php:2146
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.28 ms After last query: 0.27 ms

SELECT *

  FROM j6au3_os_cck_sef_urls

  WHERE `id` = '465'

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
25	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
24	Joomla\CMS\Table\Table->load()	JROOT/components/com_os_cck/classes/sefurl.class.php:64
23	osCckSefurl->loadByHashVars()	JROOT/components/com_os_cck/router.php:108
22	Os_cckRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
21	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
20	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
16	Joomla\CMS\Router\Route::_()	JROOT/libraries/src/Pagination/Pagination.php:830
15	Joomla\CMS\Pagination\Pagination->_buildDataObject()	JROOT/libraries/src/Pagination/Pagination.php:328
14	Joomla\CMS\Pagination\Pagination->getPagesLinks()	JROOT/components/com_os_cck/classes/layout.class.php:1287
13	os_cckLayout->getLayoutViews()	JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php:131
12	require JROOT/components/com_os_cck/views/instance/tmpl/tmpl_default.php	JROOT/components/com_os_cck/php/instance.php:2146
11	Instance::showItem()	JROOT/components/com_os_cck/views/instance/view.html.php:42
10	Os_CCKViewInstance->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_os_cck/controller.php:84
8	Os_CCKController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_os_cck/os_cck.php:196
6	require_once JROOT/components/com_os_cck/os_cck.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.85 ms After last query: 48.92 ms

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

  FROM j6au3_modules AS m

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

  LEFT JOIN j6au3_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 <= '2025-10-11 09:17:29') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-10-11 09:17:29') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 827 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	13	Using index condition; Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	ordasvit_joomla.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	ordasvit_joomla.m.module,const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.27 ms
checking permissions	0.02 ms
Opening tables	0.25 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.09 ms
Optimizing	0.07 ms
Statistics	0.18 ms
Preparing	0.08 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.49 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
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:441
11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/wp_blank_theme/index.php:34
7	require JROOT/templates/wp_blank_theme/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
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.12 ms After last query: 15.51 ms

Duplicate queries: #72

SELECT *

  FROM j6au3_menu

  WHERE `id` = '678'

Explain

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

Profile

Status	Duration
Starting	0.13 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.08 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.02 ms
Sending data	0.30 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
20	Joomla\CMS\Table\Table->load()	JROOT/components/com_os_cck/functions.php:8528
19	get_menu_url_alias_cck()	JROOT/components/com_os_cck/router.php:77
18	Os_cckRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_breadcrumbs/helper.php:54
11	ModBreadCrumbsHelper::getList()	JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php:16
10	include JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.53 ms After last query: 5.73 ms

Duplicate queries: #71

SELECT *

  FROM j6au3_menu

  WHERE `id` = '678'

Explain

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

Profile

Status	Duration
Starting	0.22 ms
checking permissions	0.05 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.78 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.36 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
22	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
21	Joomla\CMS\Table\Table->load()	JROOT/components/com_os_cck/functions.php:8565
20	is_menu_item_cck()	JROOT/components/com_os_cck/functions.php:8548
19	get_menu_url_alias_cck()	JROOT/components/com_os_cck/router.php:77
18	Os_cckRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_breadcrumbs/helper.php:54
11	ModBreadCrumbsHelper::getList()	JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php:16
10	include JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
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.89 ms After last query: 1.39 ms

Duplicate queries: #23 #41 #64 #67 #74

SELECT *

  FROM j6au3_menu

  WHERE `id` = '827'

Explain

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

Profile

Status	Duration
Starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.43 ms
Executing	0.65 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
20	Joomla\CMS\Table\Table->load()	JROOT/components/com_os_cck/functions.php:8528
19	get_menu_url_alias_cck()	JROOT/components/com_os_cck/router.php:77
18	Os_cckRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_breadcrumbs/helper.php:54
11	ModBreadCrumbsHelper::getList()	JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php:16
10	include JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 5.13 ms After last query: 6.53 ms

Duplicate queries: #23 #41 #64 #67 #73

SELECT *

  FROM j6au3_menu

  WHERE `id` = '827'

Explain

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

Profile

Status	Duration
Starting	1.24 ms
checking permissions	0.94 ms
Opening tables	0.07 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.12 ms
Optimizing	0.02 ms
Statistics	0.09 ms
Preparing	0.01 ms
Unlocking tables	0.91 ms
Preparing	0.20 ms
Executing	0.01 ms
Sending data	0.33 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.52 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
22	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
21	Joomla\CMS\Table\Table->load()	JROOT/components/com_os_cck/functions.php:8565
20	is_menu_item_cck()	JROOT/components/com_os_cck/functions.php:8548
19	get_menu_url_alias_cck()	JROOT/components/com_os_cck/router.php:77
18	Os_cckRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_breadcrumbs/helper.php:54
11	ModBreadCrumbsHelper::getList()	JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php:16
10	include JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
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.]

40 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

8 × SELECT * 
  FROM j6au3_os_cck_content_entity_17

8 × SELECT * 
  FROM j6au3_os_cck_entity_instance

```
8 × SELECT * 
  FROM j6au3_menu
```

4 × SELECT * 
  FROM j6au3_os_cck_sef_urls

4 × SELECT id 
  FROM j6au3_os_cck_sef_urls

3 × SELECT layout_html 
  FROM j6au3_os_cck_layout as c   
  LEFT JOIN j6au3_os_cck_layout_html as ch 
  ON c.lid = ch.fk_lid

3 × SELECT * 
  FROM j6au3_os_cck_layout

2 × SELECT cc.title AS title ,cc.cid as catid, cc.image as image  
  FROM j6au3_os_cck_entity_instance AS jei   
  LEFT JOIN j6au3_os_cck_categories_connect AS c 
  ON jei.eiid=c.fk_eiid   
  LEFT JOIN j6au3_os_cck_categories AS cc 
  ON cc.cid = c.fk_cid

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

2 × SELECT eiid 
  FROM j6au3_os_cck_entity_instance as i   
  LEFT JOIN j6au3_os_cck_layout as l 
  ON l.lid = i.fk_lid   
  LEFT JOIN j6au3_os_cck_categories_connect as cc 
  ON cc.fk_eiid = i.eiid

1 × SELECT * 
  FROM j6au3_os_cck_entity

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

1 × SELECT * 
  FROM j6au3_os_cck_categories AS cc   
  LEFT JOIN j6au3_os_cck_categories_connect AS ccc 
  ON cc.cid=ccc.fk_cid

1 × SELECT * 
  FROM `j6au3_os_cck_categories` e

1 × SELECT COUNT(ei2.eiid) 
  FROM j6au3_os_cck_entity_instance as ei  
  LEFT JOIN j6au3_os_cck_child_parent_connect as pc 
  ON pc.fid_parent = ei.eiid  
  LEFT JOIN j6au3_os_cck_entity_instance as ei2 
  ON pc.fid_child = ei2.eiid  
  LEFT JOIN j6au3_os_cck_layout as l 
  ON l.lid = ei2.fk_lid  
  LEFT JOIN j6au3_users as u 
  ON u.id = ei2.fk_userid

1 × SELECT ei2.*,u.*,l.params 
  FROM j6au3_os_cck_entity_instance as ei  
  LEFT JOIN j6au3_os_cck_child_parent_connect as pc 
  ON pc.fid_parent = ei.eiid  
  LEFT JOIN j6au3_os_cck_entity_instance as ei2 
  ON pc.fid_child = ei2.eiid  
  LEFT JOIN `j6au3_os_cck_content_entity_17` as instance 
  ON instance.`fk_eiid` = ei2.eiid   
  LEFT JOIN j6au3_os_cck_layout as l 
  ON l.lid = ei2.fk_lid  
  LEFT JOIN j6au3_users as u 
  ON u.id = ei2.fk_userid

1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM j6au3_fields AS a 
  LEFT JOIN `j6au3_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN j6au3_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN j6au3_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN j6au3_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN j6au3_fields_groups AS g 
  ON g.id = a.group_id

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

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

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

1 × SELECT id, rules 
  FROM `j6au3_viewlevels

1 × SELECT `session_id` 
  FROM `j6au3_session`

```
1 × SELECT * 
  FROM j6au3_languages
```

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

1 × SELECT `data` 
  FROM `j6au3_session`

1 × SELECT f.* 
  FROM j6au3_os_cck_entity_field AS f FORCE INDEX(fk_eid_field_name)

1 × SELECT eid, type, custom_fields, sql_select 
  FROM j6au3_os_cck_entit

1 × SELECT `key` 
  FROM j6au3_os_cck_api

1 × SELECT lid, type 
  FROM j6au3_os_cck_layou

OTHER Tables:

1 × SHOW FULL COLUMNS 
  FROM `j6au3_os_cck_entity

1 × UPDATE j6au3_os_cck_entity_instance 
  SET   featured_clicks = featured_clicks-1

1 × UPDATE j6au3_os_cck_entity_instance 
  SET hits = hits + 1

1 × UPDATE j6au3_os_cck_entity_instance 
  SET   featured_shows = featured_shows-1

1 × SHOW FULL COLUMNS 
  FROM `j6au3_os_cck_entity_instance

1 × SHOW FULL COLUMNS 
  FROM `j6au3_os_cck_layout

1 × SHOW FULL COLUMNS 
  FROM `j6au3_os_cck_sef_urls

1 × UPDATE `j6au3_extensions` 
  SET `params` = '{\"mediaversion\":\"11793d2d1c7fa583a1b7894e99ca5010\"}'

1 × SHOW FULL COLUMNS 
  FROM `j6au3_os_cck_entity_field

1 × SHOW FULL COLUMNS 
  FROM `j6au3_menu

1 × INSERT INTO `j6au3_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'383667763063747474383770617536676e6835743862336a3430', 1, 1760174247, 0, '', 0

More details about wordPress map plugin

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

74 Queries Logged 520.39 ms

26 duplicate found!

40 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: