Enterprise Resource Manager

Some of Our Clients

We value and support all our clients.

Tag:

#Property Management

Show all College Retail Manufacturing Agriculture Vehicle Tracking Services Freight Motor Valuation Membership Custom Portal Yard Storage Hospital Management System Distribution sacco Property Management

view more:

CONTACTS

ASK FOR QUOTE

hello@anchorerp.co.ke

+254 740 870160

Anchor ERP ~ a product of Netrix Business Systems Ltd

Latest News

Tracker Installation Management Module

Anchor ERP now incorporates a module for managing the installation of vehicle trackers. Through the module one can issue job cards to technicians to undertake the installations and capture vehicle, financier and client details.

It also integrates with airtime and sms services for notifying clients and topping up trackers to keep them online.

Route Market Sales App

Anchor ERP now incorporates a mobile app for managing distributions and field sales. Through the app sales rep can be issued with goods that they can go and sell out in the field, they perform the sell on the app which automatically synchronizes with the ERP to track sales by each sales rep.

Stay Connected

Joomla! Debug Console

Session

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

Profile Information

Memory Usage

Database Queries

40 Queries Logged 1656.66 ms

3 duplicate found!

3 duplicates: #22 #35 #36

Query Time: 0.44 ms Query memory: 0.023 MB Memory before query: 4.156 MB Rows returned: 0

SELECT `data`

  FROM `o6z40_session`

  WHERE `session_id` = X'6236306136353131613863633537353233316163316430353262346166616364'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->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

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

Query Time: 0.25 ms After last query: 1.36 ms Query memory: 0.020 MB Memory before query: 4.251 MB Rows returned: 0

SELECT `session_id`

  FROM `o6z40_session`

  WHERE `session_id` = X'6236306136353131613863633537353233316163316430353262346166616364' 
  LIMIT 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
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: 1071.62 ms After last query: 0.12 ms Query memory: 0.004 MB Memory before query: 4.256 MB

INSERT INTO `o6z40_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'6236306136353131613863633537353233316163316430353262346166616364', 1, 1680075915, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `o6z40_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6236306136353131613863633537353233316163316430353262346166616364', 1, 1680075915, 0, '', 0)

Profile

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

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php: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: 0.31 ms After last query: 5.47 ms Query memory: 0.021 MB Memory before query: 4.803 MB Rows returned: 5

SELECT id, rules

  FROM `o6z40_viewlevels`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->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.23 ms After last query: 0.11 ms Query memory: 0.021 MB Memory before query: 4.816 MB Rows returned: 0

SELECT b.id

  FROM o6z40_usergroups AS a

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

  WHERE a.id = 13

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->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: 0.30 ms After last query: 32.16 ms Query memory: 0.020 MB Memory before query: 8.360 MB Rows returned: 1

SELECT count(*)

  FROM `o6z40_cwgears_schedule`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	o6z40_cwgears_schedule	NULL	index	NULL	PRIMARY	4	NULL	1	100.00	Using index

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:102
8	plgSystemCwgears->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.17 ms After last query: 0.05 ms Query memory: 0.020 MB Memory before query: 8.365 MB Rows returned: 1

SELECT count(*)

  FROM `o6z40_cwgears_schedule`

  WHERE time + '86400'<'1680075916'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:145
8	plgSystemCwgears->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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: 363.58 ms After last query: 10.46 ms Query memory: 0.006 MB Memory before query: 9.489 MB

UPDATE `o6z40_extensions`

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

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/djjquerymonster/djjquerymonster.php:58
8	plgSystemDJjQueryMonster->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
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: 195.39 ms After last query: 36.78 ms Query memory: 0.026 MB Memory before query: 11.936 MB Rows returned: 8

SHOW FULL COLUMNS 
  FROM `o6z40_tz_portfolio_plus_templates`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
15	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
14	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_tz_portfolio_plus/tables/templates.php:26
13	TZ_Portfolio_PlusTableTemplates->__construct()	JROOT/libraries/src/Table/Table.php:328
12	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/template.php:52
11	TZ_Portfolio_PlusTemplate::getTemplate()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:55
10	TZ_Portfolio_PlusControllerLegacy->getView()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:41
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:237
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:59
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.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.55 ms Query memory: 0.022 MB Memory before query: 11.973 MB Rows returned: 1

SELECT COUNT(t.id)

  FROM o6z40_tz_portfolio_plus_templates AS t

  INNER JOIN o6z40_tz_portfolio_plus_extensions AS e 
  On e.element = t.template

  WHERE e.type = 'tz_portfolio_plus-template' 
  AND e.published = 1 
  AND t.id =3

  GROUP BY t.id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	e	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	11	9.09	Using where

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/template.php:70
11	TZ_Portfolio_PlusTemplate::getTemplate()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:55
10	TZ_Portfolio_PlusControllerLegacy->getView()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:41
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:237
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:59
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.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.06 ms Query memory: 0.022 MB Memory before query: 11.981 MB Rows returned: 1

SELECT *

  FROM o6z40_tz_portfolio_plus_templates

  WHERE `home`= 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_tz_portfolio_plus/tables/templates.php:65
12	TZ_Portfolio_PlusTableTemplates->getHome()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/template.php:74
11	TZ_Portfolio_PlusTemplate::getTemplate()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:55
10	TZ_Portfolio_PlusControllerLegacy->getView()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:41
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:237
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:59
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.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.23 ms After last query: 0.12 ms Query memory: 0.022 MB Memory before query: 11.998 MB Rows returned: 1

SELECT *

  FROM o6z40_tz_portfolio_plus_templates

  WHERE `id` = '3'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->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/administrator/components/com_tz_portfolio_plus/libraries/template.php:81
11	TZ_Portfolio_PlusTemplate::getTemplate()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:55
10	TZ_Portfolio_PlusControllerLegacy->getView()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:41
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:237
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:59
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.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.55 ms After last query: 2.74 ms Query memory: 0.028 MB Memory before query: 12.282 MB Rows returned: 38

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

  FROM `o6z40_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_convertforms','com_cpanel','com_djimageslider','com_fields','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_tz_portfolio_plus','com_users','com_weblinks','com_wrapper')

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/components/com_tz_portfolio_plus/models/portfolio.php:68
14	TZ_Portfolio_PlusModelPortfolio->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tz_portfolio_plus/views/portfolio/view.html.php:72
11	TZ_Portfolio_PlusViewPortfolio->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:43
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:237
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:59
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.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.23 ms After last query: 0.72 ms Query memory: 0.022 MB Memory before query: 12.371 MB Rows returned: 1

SELECT *

  FROM o6z40_tz_portfolio_plus_tags

  WHERE id = 15

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_tz_portfolio_plus/helpers/tags.php:47
12	TZ_Portfolio_PlusFrontHelperTags::getTagById()	JROOT/components/com_tz_portfolio_plus/views/portfolio/view.html.php:83
11	TZ_Portfolio_PlusViewPortfolio->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:43
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:237
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:59
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.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.53 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 12.381 MB Rows returned: 1

SELECT c.*

  FROM o6z40_tz_portfolio_plus_categories AS c

  INNER JOIN o6z40_tz_portfolio_plus_content_category_map AS m 
  ON m.catid = c.id

  INNER JOIN o6z40_tz_portfolio_plus_content AS cc 
  ON cc.id = m.contentid

  WHERE c.published = 1 
  AND extension = 'com_tz_portfolio_plus' 
  AND m.main = 1 
  AND c.id = 3

  GROUP BY c.id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	const	PRIMARY,cat_idx	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	m	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	33	3.03	Using where
1	SIMPLE	cc	NULL	eq_ref	PRIMARY	PRIMARY	4	vhfcqidb_anchor.m.contentid	1	100.00	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_tz_portfolio_plus/helpers/categories.php:273
12	TZ_Portfolio_PlusFrontHelperCategories::getCategoriesById()	JROOT/components/com_tz_portfolio_plus/views/portfolio/view.html.php:98
11	TZ_Portfolio_PlusViewPortfolio->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:43
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:237
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:59
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.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.98 ms After last query: 0.39 ms Query memory: 0.025 MB Memory before query: 12.416 MB Rows returned: 2

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

  FROM o6z40_tz_portfolio_plus_categories as c

  LEFT JOIN o6z40_tz_portfolio_plus_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  LEFT JOIN  (SELECT cat.id as id 
  FROM o6z40_tz_portfolio_plus_categories AS cat JOIN o6z40_tz_portfolio_plus_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_tz_portfolio_plus' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE (c.extension='com_tz_portfolio_plus' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id=3 
  AND badcats.id is null

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

  ORDER BY c.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
1	PRIMARY	c	NULL	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	4	55.55	Using where
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	vhfcqidb_anchor.c.id	2	100.00	Using where; Not exists; Using index
2	DERIVED	parent	NULL	ALL	cat_idx,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	4	50.00	Using where; Using temporary; Using filesort
2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	4	25.00	Using where; Using index; Using join buffer (Block Nested Loop)

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio_plus/helpers/category.php:129
15	TZ_Portfolio_PlusCategories->_load()	JROOT/libraries/src/Categories/Categories.php:184
14	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_tz_portfolio_plus/helpers/route.php:89
13	TZ_Portfolio_PlusHelperRoute::getCategoryRoute()	JROOT/components/com_tz_portfolio_plus/helpers/categories.php:275
12	TZ_Portfolio_PlusFrontHelperCategories::getCategoriesById()	JROOT/components/com_tz_portfolio_plus/views/portfolio/view.html.php:98
11	TZ_Portfolio_PlusViewPortfolio->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:43
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:237
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:59
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.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.14 ms After last query: 0.85 ms Query memory: 0.041 MB Memory before query: 12.492 MB Rows returned: 2

SELECT c.*, m.catid AS catid ,cc.title AS category_title,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug,
  CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug,
  CASE WHEN CHAR_LENGTH(c.fulltext) THEN c.fulltext ELSE null END as readmore,t.title AS tagName, u.name AS author,u.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias

  FROM `o6z40_tz_portfolio_plus_content` AS c

  INNER JOIN `o6z40_tz_portfolio_plus_content_category_map` AS m 
  ON m.contentid=c.id

  LEFT JOIN `o6z40_tz_portfolio_plus_categories` AS cc 
  ON cc.id=m.catid

  LEFT JOIN `o6z40_tz_portfolio_plus_tag_content_map` AS x 
  ON x.contentid=c.id

  LEFT JOIN `o6z40_tz_portfolio_plus_tags` AS t 
  ON t.id=x.tagsid

  LEFT JOIN `o6z40_users` AS u 
  ON u.id=c.created_by

  LEFT JOIN o6z40_tz_portfolio_plus_categories as parent 
  ON parent.id = cc.parent_id

  WHERE t.id =15 
  AND c.state = 1 
  AND (c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2023-03-29 07:45:17') 
  AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2023-03-29 07:45:17') 
  AND c.access IN (1,1) 
  AND cc.access IN (1,1) 
  AND m.catid IN(3)

  GROUP BY c.id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cc	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
1	SIMPLE	t	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	m	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	33	10.00	Using where
1	SIMPLE	c	NULL	eq_ref	PRIMARY,idx_access,idx_checkout,idx_state,idx_createdby,idx_featured_catid,idx_language,idx_xreference	PRIMARY	4	vhfcqidb_anchor.m.contentid	1	16.00	Using where
1	SIMPLE	x	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	44	2.27	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	u	NULL	eq_ref	PRIMARY	PRIMARY	4	vhfcqidb_anchor.c.created_by	1	100.00	Using where
1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:367
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:289
13	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tz_portfolio_plus/views/portfolio/view.html.php:187
11	TZ_Portfolio_PlusViewPortfolio->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:43
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:237
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:59
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.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.02 ms After last query: 0.11 ms Query memory: 0.041 MB Memory before query: 12.490 MB Rows returned: 2

SELECT c.*, m.catid AS catid ,cc.title AS category_title,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug,
  CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug,
  CASE WHEN CHAR_LENGTH(c.fulltext) THEN c.fulltext ELSE null END as readmore,t.title AS tagName, u.name AS author,u.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias

  FROM `o6z40_tz_portfolio_plus_content` AS c

  INNER JOIN `o6z40_tz_portfolio_plus_content_category_map` AS m 
  ON m.contentid=c.id

  LEFT JOIN `o6z40_tz_portfolio_plus_categories` AS cc 
  ON cc.id=m.catid

  LEFT JOIN `o6z40_tz_portfolio_plus_tag_content_map` AS x 
  ON x.contentid=c.id

  LEFT JOIN `o6z40_tz_portfolio_plus_tags` AS t 
  ON t.id=x.tagsid

  LEFT JOIN `o6z40_users` AS u 
  ON u.id=c.created_by

  LEFT JOIN o6z40_tz_portfolio_plus_categories as parent 
  ON parent.id = cc.parent_id

  WHERE t.id =15 
  AND c.state = 1 
  AND (c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2023-03-29 07:45:17') 
  AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2023-03-29 07:45:17') 
  AND c.access IN (1,1) 
  AND cc.access IN (1,1) 
  AND m.catid IN(3)

  GROUP BY c.id

  ORDER BY cc.path,  c.title  
  LIMIT 16

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cc	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
1	SIMPLE	t	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	m	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	33	10.00	Using where
1	SIMPLE	c	NULL	eq_ref	PRIMARY,idx_access,idx_checkout,idx_state,idx_createdby,idx_featured_catid,idx_language,idx_xreference	PRIMARY	4	vhfcqidb_anchor.m.contentid	1	16.00	Using where
1	SIMPLE	x	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	44	2.27	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	u	NULL	eq_ref	PRIMARY	PRIMARY	4	vhfcqidb_anchor.c.created_by	1	100.00	Using where
1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
14	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_tz_portfolio_plus/models/portfolio.php:271
13	TZ_Portfolio_PlusModelPortfolio->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tz_portfolio_plus/views/portfolio/view.html.php:202
11	TZ_Portfolio_PlusViewPortfolio->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:43
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:237
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:59
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.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.16 ms Query memory: 0.024 MB Memory before query: 12.516 MB Rows returned: 2

SELECT c.*, m.contentid AS contentid,m.main

  FROM o6z40_tz_portfolio_plus_categories AS c

  INNER JOIN o6z40_tz_portfolio_plus_content_category_map AS m 
  ON m.catid = c.id

  INNER JOIN o6z40_tz_portfolio_plus_content AS cc 
  ON cc.id = m.contentid

  WHERE extension = 'com_tz_portfolio_plus' 
  AND cc.id IN(56,57) 
  AND m.main = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cc	NULL	range	PRIMARY	PRIMARY	4	NULL	2	100.00	Using where; Using index
1	SIMPLE	m	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	33	3.03	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	c	NULL	eq_ref	PRIMARY,cat_idx	PRIMARY	4	vhfcqidb_anchor.m.catid	1	75.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio_plus/helpers/categories.php:165
14	TZ_Portfolio_PlusFrontHelperCategories::getCategoriesByArticleId()	JROOT/components/com_tz_portfolio_plus/models/portfolio.php:290
13	TZ_Portfolio_PlusModelPortfolio->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tz_portfolio_plus/views/portfolio/view.html.php:202
11	TZ_Portfolio_PlusViewPortfolio->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:43
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:237
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:59
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.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.39 ms After last query: 0.16 ms Query memory: 0.023 MB Memory before query: 12.534 MB Rows returned: 0

SELECT c.*, m.contentid AS contentid,m.main

  FROM o6z40_tz_portfolio_plus_categories AS c

  INNER JOIN o6z40_tz_portfolio_plus_content_category_map AS m 
  ON m.catid = c.id

  INNER JOIN o6z40_tz_portfolio_plus_content AS cc 
  ON cc.id = m.contentid

  WHERE extension = 'com_tz_portfolio_plus' 
  AND cc.id IN(56,57) 
  AND m.main = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cc	NULL	range	PRIMARY	PRIMARY	4	NULL	2	100.00	Using where; Using index
1	SIMPLE	m	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	33	3.03	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	c	NULL	eq_ref	PRIMARY,cat_idx	PRIMARY	4	vhfcqidb_anchor.m.catid	1	75.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio_plus/helpers/categories.php:165
14	TZ_Portfolio_PlusFrontHelperCategories::getCategoriesByArticleId()	JROOT/components/com_tz_portfolio_plus/models/portfolio.php:292
13	TZ_Portfolio_PlusModelPortfolio->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tz_portfolio_plus/views/portfolio/view.html.php:202
11	TZ_Portfolio_PlusViewPortfolio->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:43
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:237
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:59
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.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.58 ms After last query: 0.08 ms Query memory: 0.023 MB Memory before query: 12.542 MB Rows returned: 2

SELECT t.*, c.id AS contentid,
  CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(":", t.id, t.alias) ELSE t.id END as slug

  FROM o6z40_tz_portfolio_plus_tags AS t

  INNER JOIN o6z40_tz_portfolio_plus_tag_content_map AS m 
  ON m.tagsid = t.id

  INNER JOIN o6z40_tz_portfolio_plus_content AS c 
  ON c.id = m.contentid

  WHERE t.published = 1 
  AND c.id IN(56,57)

  ORDER BY m.contentid

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t	NULL	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	9	11.11	Using where; Using temporary; Using filesort
1	SIMPLE	m	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	44	10.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	c	NULL	eq_ref	PRIMARY	PRIMARY	4	vhfcqidb_anchor.m.contentid	1	100.00	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio_plus/helpers/tags.php:207
14	TZ_Portfolio_PlusFrontHelperTags::getTagsByArticleId()	JROOT/components/com_tz_portfolio_plus/models/portfolio.php:297
13	TZ_Portfolio_PlusModelPortfolio->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tz_portfolio_plus/views/portfolio/view.html.php:202
11	TZ_Portfolio_PlusViewPortfolio->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:43
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:237
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:59
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.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.18 ms After last query: 0.14 ms Query memory: 0.027 MB Memory before query: 12.554 MB Rows returned: 1

Duplicate queries: #35 #36

SELECT alias

  FROM o6z40_tz_portfolio_plus_tags

  WHERE id=15

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
24	JDatabaseDriver->loadResult()	JROOT/components/com_tz_portfolio_plus/router.php:884
23	TZ_Portfolio_PlusRouter->_getTagSegment()	JROOT/components/com_tz_portfolio_plus/router.php:237
22	TZ_Portfolio_PlusRouter->sefBuild()	JROOT/components/com_tz_portfolio_plus/router.php:70
21	TZ_Portfolio_PlusRouter->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_tz_portfolio_plus/helpers/tags.php:217
14	TZ_Portfolio_PlusFrontHelperTags::getTagsByArticleId()	JROOT/components/com_tz_portfolio_plus/models/portfolio.php:297
13	TZ_Portfolio_PlusModelPortfolio->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tz_portfolio_plus/views/portfolio/view.html.php:202
11	TZ_Portfolio_PlusViewPortfolio->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:43
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:237
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:59
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.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.61 ms After last query: 4.48 ms Query memory: 0.034 MB Memory before query: 13.049 MB Rows returned: 17

SHOW FULL COLUMNS 
  FROM `o6z40_users`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
33	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
32	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
31	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
30	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
29	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:328
28	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
27	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:877
26	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
25	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
24	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
23	Joomla\CMS\Factory::getUser()	JROOT/components/com_tz_portfolio_plus/router.php:912
22	TZ_Portfolio_PlusRouter->_getUserSegment()	JROOT/components/com_tz_portfolio_plus/router.php:240
21	TZ_Portfolio_PlusRouter->sefBuild()	JROOT/components/com_tz_portfolio_plus/router.php:70
20	TZ_Portfolio_PlusRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
14	Joomla\CMS\Router\Route::_()	JROOT/components/com_tz_portfolio_plus/models/portfolio.php:403
13	TZ_Portfolio_PlusModelPortfolio->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tz_portfolio_plus/views/portfolio/view.html.php:202
11	TZ_Portfolio_PlusViewPortfolio->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:43
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:237
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:59
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.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.26 ms After last query: 0.12 ms Query memory: 0.029 MB Memory before query: 13.084 MB Rows returned: 1

SELECT *

  FROM `o6z40_users`

  WHERE `id` = 207

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
28	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
27	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
26	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
25	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
24	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
23	Joomla\CMS\Factory::getUser()	JROOT/components/com_tz_portfolio_plus/router.php:912
22	TZ_Portfolio_PlusRouter->_getUserSegment()	JROOT/components/com_tz_portfolio_plus/router.php:240
21	TZ_Portfolio_PlusRouter->sefBuild()	JROOT/components/com_tz_portfolio_plus/router.php:70
20	TZ_Portfolio_PlusRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
14	Joomla\CMS\Router\Route::_()	JROOT/components/com_tz_portfolio_plus/models/portfolio.php:403
13	TZ_Portfolio_PlusModelPortfolio->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tz_portfolio_plus/views/portfolio/view.html.php:202
11	TZ_Portfolio_PlusViewPortfolio->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:43
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:237
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:59
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.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: 2.53 ms Query memory: 0.028 MB Memory before query: 13.841 MB Rows returned: 1

SELECT `g`.`id`,`g`.`title`

  FROM `o6z40_usergroups` AS g

  INNER JOIN `o6z40_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 207

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	PRIMARY	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	vhfcqidb_anchor.m.group_id	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
28	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
27	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
26	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
25	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
24	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
23	Joomla\CMS\Factory::getUser()	JROOT/components/com_tz_portfolio_plus/router.php:912
22	TZ_Portfolio_PlusRouter->_getUserSegment()	JROOT/components/com_tz_portfolio_plus/router.php:240
21	TZ_Portfolio_PlusRouter->sefBuild()	JROOT/components/com_tz_portfolio_plus/router.php:70
20	TZ_Portfolio_PlusRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
14	Joomla\CMS\Router\Route::_()	JROOT/components/com_tz_portfolio_plus/models/portfolio.php:403
13	TZ_Portfolio_PlusModelPortfolio->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tz_portfolio_plus/views/portfolio/view.html.php:202
11	TZ_Portfolio_PlusViewPortfolio->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:43
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:237
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:59
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.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.90 ms After last query: 2.55 ms Query memory: 0.026 MB Memory before query: 14.087 MB Rows returned: 0

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

  FROM o6z40_fields AS a

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

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

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

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

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

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

  WHERE a.context = 'com_tz_portfolio_plus.portfolio' 
  AND (fc.category_id IS NULL OR fc.category_id IN (3,0)) 
  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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Using temporary; Using filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	21	vhfcqidb_anchor.a.language	1	100.00	NULL
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	vhfcqidb_anchor.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	vhfcqidb_anchor.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	vhfcqidb_anchor.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	vhfcqidb_anchor.a.group_id	1	100.00	Using where
1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	vhfcqidb_anchor.a.id	1	100.00	Using where; Using index; Distinct

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
17	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
14	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_tz_portfolio_plus/models/portfolio.php:455
13	TZ_Portfolio_PlusModelPortfolio->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tz_portfolio_plus/views/portfolio/view.html.php:202
11	TZ_Portfolio_PlusViewPortfolio->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:43
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:237
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:59
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.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.30 ms After last query: 2.56 ms Query memory: 0.027 MB Memory before query: 14.335 MB Rows returned: 0

SELECT *

  FROM o6z40_tz_portfolio_plus_content_rating

  WHERE content_id = 56

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
25	JDatabaseDriver->loadObject()	JROOT/components/com_tz_portfolio_plus/addons/content/vote/helpers/vote.php:50
24	TZ_Portfolio_PlusAddOnContentVoteHelper::getVoteByArticleId()	JROOT/components/com_tz_portfolio_plus/addons/content/vote/models/portfolio.php:32
23	PlgTZ_Portfolio_PlusContentVoteModelPortfolio->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
22	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tz_portfolio_plus/addons/content/vote/views/portfolio/view.html.php:34
21	PlgTZ_Portfolio_PlusContentVoteViewPortfolio->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller/legacy.php:135
20	TZ_Portfolio_Plus_AddOnControllerLegacy->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller/legacy.php:227
19	TZ_Portfolio_Plus_AddOnControllerLegacy->execute()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/plugin/plugin.php:585
18	TZ_Portfolio_PlusPlugin->_getViewHtml()	JROOT/components/com_tz_portfolio_plus/addons/content/vote/vote.php:167
17	PlgTZ_Portfolio_PlusContentVote->onBeforeDisplayAdditionInfo()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
14	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_tz_portfolio_plus/models/portfolio.php:492
13	TZ_Portfolio_PlusModelPortfolio->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tz_portfolio_plus/views/portfolio/view.html.php:202
11	TZ_Portfolio_PlusViewPortfolio->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:43
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:237
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:59
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.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: 1.34 ms Query memory: 0.024 MB Memory before query: 14.478 MB Rows returned: 0

SELECT *

  FROM o6z40_tz_portfolio_plus_fieldgroups

  WHERE id IN(
SELECT 
  CASE WHEN c.groupid = 0 OR c.groupid IS NULL THEN cc.groupid ELSE c.groupid END AS groupid

  FROM o6z40_tz_portfolio_plus_content AS c

  INNER JOIN o6z40_tz_portfolio_plus_content_category_map AS m 
  ON m.contentid = c.id

  LEFT JOIN o6z40_tz_portfolio_plus_categories AS cc 
  ON cc.id = m.catid

  WHERE c.id = 56

  GROUP BY groupid) 
  AND access IN (1,1)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	o6z40_tz_portfolio_plus_fieldgroups	NULL	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
1	SIMPLE	m	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	33	10.00	Using where
1	SIMPLE	cc	NULL	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	4	100.00	Using where; FirstMatch(o6z40_tz_portfolio_plus_fieldgroups)

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio_plus/helpers/extrafields.php:218
16	TZ_Portfolio_PlusFrontHelperExtraFields::getFieldGroupsByArticleId()	JROOT/components/com_tz_portfolio_plus/helpers/extrafields.php:417
15	TZ_Portfolio_PlusFrontHelperExtraFields::getExtraFieldsByArticle()	JROOT/components/com_tz_portfolio_plus/helpers/extrafields.php:131
14	TZ_Portfolio_PlusFrontHelperExtraFields::getExtraFields()	JROOT/components/com_tz_portfolio_plus/models/portfolio.php:539
13	TZ_Portfolio_PlusModelPortfolio->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tz_portfolio_plus/views/portfolio/view.html.php:202
11	TZ_Portfolio_PlusViewPortfolio->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:43
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:237
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:59
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.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.10 ms After last query: 0.10 ms Query memory: 0.649 MB Memory before query: 14.490 MB Rows returned: 0

SELECT f.*, fm.groupid

  FROM o6z40_tz_portfolio_plus_fields AS f

  INNER JOIN o6z40_tz_portfolio_plus_field_content_map AS m 
  ON m.fieldsid = f.id

  INNER JOIN o6z40_tz_portfolio_plus_content AS c 
  ON c.id = m.contentid

  INNER JOIN o6z40_tz_portfolio_plus_field_fieldgroup_map AS fm 
  ON fm.fieldsid = f.id

  INNER JOIN o6z40_tz_portfolio_plus_fieldgroups AS fg 
  ON fg.id = fm.groupid

  INNER JOIN o6z40_tz_portfolio_plus_extensions AS e 
  ON e.element = f.type

  WHERE e.type = 'tz_portfolio_plus-plugin' 
  AND e.folder = 'extrafields' 
  AND e.published = 1 
  AND c.id = 56 
  AND f.published = 1 
  AND f.list_view = 1 
  AND f.access IN(1,1) 
  AND fg.id IN(
SELECT subg.id

  FROM o6z40_tz_portfolio_plus_fieldgroups AS subg

  WHERE subg.access IN(1,1)) 
  AND e.access IN(1,1)

  GROUP BY f.id

  ORDER BY fg.id DESC,IF(fg.field_ordering_type = 2, `fm`.`ordering`,IF(fg.field_ordering_type = 1,`f`.`ordering`,NULL))

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index; Using temporary; Using filesort
1	SIMPLE	m	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
1	SIMPLE	fm	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	f	NULL	eq_ref	PRIMARY	PRIMARY	4	vhfcqidb_anchor.m.fieldsid	1	100.00	Using where
1	SIMPLE	fg	NULL	eq_ref	PRIMARY	PRIMARY	4	vhfcqidb_anchor.fm.groupid	1	100.00	NULL
1	SIMPLE	subg	NULL	eq_ref	PRIMARY	PRIMARY	4	vhfcqidb_anchor.fm.groupid	1	100.00	Using where
1	SIMPLE	e	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	11	9.09	Using where; Using join buffer (Block Nested Loop)

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio_plus/helpers/extrafields.php:520
15	TZ_Portfolio_PlusFrontHelperExtraFields::getExtraFieldsByArticle()	JROOT/components/com_tz_portfolio_plus/helpers/extrafields.php:131
14	TZ_Portfolio_PlusFrontHelperExtraFields::getExtraFields()	JROOT/components/com_tz_portfolio_plus/models/portfolio.php:539
13	TZ_Portfolio_PlusModelPortfolio->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tz_portfolio_plus/views/portfolio/view.html.php:202
11	TZ_Portfolio_PlusViewPortfolio->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:43
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:237
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:59
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.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.22 ms After last query: 0.71 ms Query memory: 0.027 MB Memory before query: 15.157 MB Rows returned: 0

SELECT *

  FROM o6z40_tz_portfolio_plus_content_rating

  WHERE content_id = 57

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
25	JDatabaseDriver->loadObject()	JROOT/components/com_tz_portfolio_plus/addons/content/vote/helpers/vote.php:50
24	TZ_Portfolio_PlusAddOnContentVoteHelper::getVoteByArticleId()	JROOT/components/com_tz_portfolio_plus/addons/content/vote/models/portfolio.php:32
23	PlgTZ_Portfolio_PlusContentVoteModelPortfolio->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
22	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tz_portfolio_plus/addons/content/vote/views/portfolio/view.html.php:34
21	PlgTZ_Portfolio_PlusContentVoteViewPortfolio->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller/legacy.php:135
20	TZ_Portfolio_Plus_AddOnControllerLegacy->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller/legacy.php:227
19	TZ_Portfolio_Plus_AddOnControllerLegacy->execute()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/plugin/plugin.php:585
18	TZ_Portfolio_PlusPlugin->_getViewHtml()	JROOT/components/com_tz_portfolio_plus/addons/content/vote/vote.php:167
17	PlgTZ_Portfolio_PlusContentVote->onBeforeDisplayAdditionInfo()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
14	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_tz_portfolio_plus/models/portfolio.php:492
13	TZ_Portfolio_PlusModelPortfolio->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tz_portfolio_plus/views/portfolio/view.html.php:202
11	TZ_Portfolio_PlusViewPortfolio->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:43
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:237
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:59
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.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.32 ms After last query: 0.86 ms Query memory: 0.024 MB Memory before query: 15.156 MB Rows returned: 0

SELECT *

  FROM o6z40_tz_portfolio_plus_fieldgroups

  WHERE id IN(
SELECT 
  CASE WHEN c.groupid = 0 OR c.groupid IS NULL THEN cc.groupid ELSE c.groupid END AS groupid

  FROM o6z40_tz_portfolio_plus_content AS c

  INNER JOIN o6z40_tz_portfolio_plus_content_category_map AS m 
  ON m.contentid = c.id

  LEFT JOIN o6z40_tz_portfolio_plus_categories AS cc 
  ON cc.id = m.catid

  WHERE c.id = 57

  GROUP BY groupid) 
  AND access IN (1,1)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	o6z40_tz_portfolio_plus_fieldgroups	NULL	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
1	SIMPLE	m	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	33	10.00	Using where
1	SIMPLE	cc	NULL	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	4	100.00	Using where; FirstMatch(o6z40_tz_portfolio_plus_fieldgroups)

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio_plus/helpers/extrafields.php:218
16	TZ_Portfolio_PlusFrontHelperExtraFields::getFieldGroupsByArticleId()	JROOT/components/com_tz_portfolio_plus/helpers/extrafields.php:417
15	TZ_Portfolio_PlusFrontHelperExtraFields::getExtraFieldsByArticle()	JROOT/components/com_tz_portfolio_plus/helpers/extrafields.php:131
14	TZ_Portfolio_PlusFrontHelperExtraFields::getExtraFields()	JROOT/components/com_tz_portfolio_plus/models/portfolio.php:539
13	TZ_Portfolio_PlusModelPortfolio->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tz_portfolio_plus/views/portfolio/view.html.php:202
11	TZ_Portfolio_PlusViewPortfolio->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:43
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:237
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:59
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.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.10 ms Query memory: 0.024 MB Memory before query: 15.167 MB Rows returned: 0

SELECT f.*, fm.groupid

  FROM o6z40_tz_portfolio_plus_fields AS f

  INNER JOIN o6z40_tz_portfolio_plus_field_content_map AS m 
  ON m.fieldsid = f.id

  INNER JOIN o6z40_tz_portfolio_plus_content AS c 
  ON c.id = m.contentid

  INNER JOIN o6z40_tz_portfolio_plus_field_fieldgroup_map AS fm 
  ON fm.fieldsid = f.id

  INNER JOIN o6z40_tz_portfolio_plus_fieldgroups AS fg 
  ON fg.id = fm.groupid

  INNER JOIN o6z40_tz_portfolio_plus_extensions AS e 
  ON e.element = f.type

  WHERE e.type = 'tz_portfolio_plus-plugin' 
  AND e.folder = 'extrafields' 
  AND e.published = 1 
  AND c.id = 57 
  AND f.published = 1 
  AND f.list_view = 1 
  AND f.access IN(1,1) 
  AND fg.id IN(
SELECT subg.id

  FROM o6z40_tz_portfolio_plus_fieldgroups AS subg

  WHERE subg.access IN(1,1)) 
  AND e.access IN(1,1)

  GROUP BY f.id

  ORDER BY fg.id DESC,IF(fg.field_ordering_type = 2, `fm`.`ordering`,IF(fg.field_ordering_type = 1,`f`.`ordering`,NULL))

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index; Using temporary; Using filesort
1	SIMPLE	m	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
1	SIMPLE	fm	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	f	NULL	eq_ref	PRIMARY	PRIMARY	4	vhfcqidb_anchor.m.fieldsid	1	100.00	Using where
1	SIMPLE	fg	NULL	eq_ref	PRIMARY	PRIMARY	4	vhfcqidb_anchor.fm.groupid	1	100.00	NULL
1	SIMPLE	subg	NULL	eq_ref	PRIMARY	PRIMARY	4	vhfcqidb_anchor.fm.groupid	1	100.00	Using where
1	SIMPLE	e	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	11	9.09	Using where; Using join buffer (Block Nested Loop)

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio_plus/helpers/extrafields.php:520
15	TZ_Portfolio_PlusFrontHelperExtraFields::getExtraFieldsByArticle()	JROOT/components/com_tz_portfolio_plus/helpers/extrafields.php:131
14	TZ_Portfolio_PlusFrontHelperExtraFields::getExtraFields()	JROOT/components/com_tz_portfolio_plus/models/portfolio.php:539
13	TZ_Portfolio_PlusModelPortfolio->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tz_portfolio_plus/views/portfolio/view.html.php:202
11	TZ_Portfolio_PlusViewPortfolio->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:43
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:237
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:59
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.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: 9.25 ms After last query: 0.11 ms Query memory: 0.026 MB Memory before query: 15.159 MB Rows returned: 15

SELECT t.*

  FROM o6z40_tz_portfolio_plus_tags AS t

  INNER JOIN o6z40_tz_portfolio_plus_tag_content_map AS m 
  ON m.tagsid = t.id

  INNER JOIN o6z40_tz_portfolio_plus_content AS c 
  ON c.id = m.contentid

  WHERE t.published = 1 
  AND c.id IN(
SELECT  c.id

  FROM o6z40_tz_portfolio_plus_content AS c

  INNER JOIN o6z40_tz_portfolio_plus_content_category_map AS m 
  ON m.contentid = c.id

  INNER JOIN o6z40_tz_portfolio_plus_categories AS cc 
  ON cc.id = m.catid

  WHERE cc.id IN(3)

  GROUP BY c.id)

  GROUP BY t.id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cc	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index; Using temporary; Using filesort
1	SIMPLE	t	NULL	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	9	11.11	Using where; Start temporary
1	SIMPLE	m	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	33	10.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	c	NULL	eq_ref	PRIMARY	PRIMARY	4	vhfcqidb_anchor.m.contentid	1	100.00	Using where; Using index
1	SIMPLE	c	NULL	eq_ref	PRIMARY	PRIMARY	4	vhfcqidb_anchor.c.id	1	100.00	Using index; End temporary
1	SIMPLE	m	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	44	2.27	Using where; Using join buffer (Block Nested Loop)

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio_plus/helpers/tags.php:161
14	TZ_Portfolio_PlusFrontHelperTags::getTagsByCategoryId()	JROOT/components/com_tz_portfolio_plus/models/portfolio.php:702
13	TZ_Portfolio_PlusModelPortfolio->getAllTags()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tz_portfolio_plus/views/portfolio/view.html.php:206
11	TZ_Portfolio_PlusViewPortfolio->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:43
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:237
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:59
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.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.21 ms After last query: 0.18 ms Query memory: 0.023 MB Memory before query: 15.176 MB Rows returned: 1

SELECT c.*

  FROM o6z40_tz_portfolio_plus_categories AS c

  INNER JOIN o6z40_tz_portfolio_plus_content_category_map AS m 
  ON m.catid = c.id

  INNER JOIN o6z40_tz_portfolio_plus_content AS cc 
  ON cc.id = m.contentid

  WHERE c.published = 1 
  AND extension = 'com_tz_portfolio_plus' 
  AND m.main = 0 OR m.main = 1 
  AND cc.id IN(
SELECT DISTINCT c2.id

  FROM o6z40_tz_portfolio_plus_content AS c2

  INNER JOIN o6z40_tz_portfolio_plus_content_category_map AS m2 
  ON m2.contentid = c2.id

  INNER JOIN o6z40_tz_portfolio_plus_categories AS cc2 
  ON cc2.id = m2.catid

  WHERE cc2.id IN(3))

  GROUP BY c.id,c.id

  ORDER BY c.title

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	c	NULL	ALL	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	4	100.00	Using temporary; Using filesort
1	PRIMARY	m	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	33	3.03	Using where; Using join buffer (Block Nested Loop)
1	PRIMARY	cc	NULL	eq_ref	PRIMARY	PRIMARY	4	vhfcqidb_anchor.m.contentid	1	100.00	Using where; Using index
2	SUBQUERY	cc2	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index
2	SUBQUERY	m2	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	33	10.00	Using where
2	SUBQUERY	c2	NULL	eq_ref	PRIMARY	PRIMARY	4	vhfcqidb_anchor.m2.contentid	1	100.00	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio_plus/helpers/categories.php:267
14	TZ_Portfolio_PlusFrontHelperCategories::getCategoriesById()	JROOT/components/com_tz_portfolio_plus/models/portfolio.php:685
13	TZ_Portfolio_PlusModelPortfolio->getAllCategories()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tz_portfolio_plus/views/portfolio/view.html.php:209
11	TZ_Portfolio_PlusViewPortfolio->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:43
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:237
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:59
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.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.25 ms After last query: 1.96 ms Query memory: 0.026 MB Memory before query: 15.290 MB Rows returned: 1

Duplicate queries: #22 #36

SELECT alias

  FROM o6z40_tz_portfolio_plus_tags

  WHERE id=15

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
21	JDatabaseDriver->loadResult()	JROOT/components/com_tz_portfolio_plus/router.php:884
20	TZ_Portfolio_PlusRouter->_getTagSegment()	JROOT/components/com_tz_portfolio_plus/router.php:237
19	TZ_Portfolio_PlusRouter->sefBuild()	JROOT/components/com_tz_portfolio_plus/router.php:70
18	TZ_Portfolio_PlusRouter->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/components/com_tz_portfolio_plus/views/portfolio/view.html.php:257
11	TZ_Portfolio_PlusViewPortfolio->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:43
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:237
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:59
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.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.20 ms After last query: 0.20 ms Query memory: 0.026 MB Memory before query: 15.301 MB Rows returned: 1

Duplicate queries: #22 #35

SELECT alias

  FROM o6z40_tz_portfolio_plus_tags

  WHERE id=15

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
21	JDatabaseDriver->loadResult()	JROOT/components/com_tz_portfolio_plus/router.php:884
20	TZ_Portfolio_PlusRouter->_getTagSegment()	JROOT/components/com_tz_portfolio_plus/router.php:237
19	TZ_Portfolio_PlusRouter->sefBuild()	JROOT/components/com_tz_portfolio_plus/router.php:70
18	TZ_Portfolio_PlusRouter->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/components/com_tz_portfolio_plus/views/portfolio/view.html.php:259
11	TZ_Portfolio_PlusViewPortfolio->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:43
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:237
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:59
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.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.36 ms After last query: 18.81 ms Query memory: 0.021 MB Memory before query: 15.566 MB Rows returned: 7

SELECT id 
  FROM o6z40_template_styles 
  ORDER BY id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	o6z40_template_styles	NULL	index	NULL	PRIMARY	4	NULL	7	100.00	Using index

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:329
9	JMFTemplate->setup()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:126
8	JMFTemplate->__construct()	JROOT/templates/jm-services/index.php:18
7	require JROOT/templates/jm-services/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: 0.41 ms After last query: 11.96 ms Query memory: 0.022 MB Memory before query: 16.774 MB Rows returned: 0

SELECT uikit

  FROM `o6z40_cwgears`

  WHERE url = 'https://www.anchorerp.co.ke/clients/tag/property-management/15'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/helpers/loadcount.php:64
13	CwGearsHelperLoadcount::getCounts()	JROOT/plugins/system/cwgears/cwgears.php:337
12	plgSystemCwgears->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php: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: 0.20 ms After last query: 0.08 ms Query memory: 0.022 MB Memory before query: 16.781 MB Rows returned: 0

SELECT uikit_plus

  FROM `o6z40_cwgears`

  WHERE url = 'https://www.anchorerp.co.ke/clients/tag/property-management/15'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/helpers/loadcount.php:64
13	CwGearsHelperLoadcount::getCounts()	JROOT/plugins/system/cwgears/cwgears.php:346
12	plgSystemCwgears->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php: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: 0.50 ms After last query: 2.50 ms Query memory: 0.025 MB Memory before query: 16.977 MB Rows returned: 1

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

  FROM `o6z40_categories` AS `s`

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

  WHERE (c.extension='com_contact' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id = 9

  ORDER BY c.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using filesort
1	SIMPLE	c	NULL	range	cat_idx,idx_access,idx_left_right	cat_idx	157	NULL	2	8.70	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
17	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
16	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_contact/helpers/legacyrouter.php:111
15	ContactRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
14	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:532
13	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
12	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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.]

31 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

3 × SELECT alias 
  FROM o6z40_tz_portfolio_plus_tags

2 × SELECT * 
  FROM o6z40_tz_portfolio_plus_templates

2 × SELECT c.* 
  FROM o6z40_tz_portfolio_plus_categories AS c 
  INNER JOIN o6z40_tz_portfolio_plus_content_category_map AS m 
  ON m.catid = c.id 
  INNER JOIN o6z40_tz_portfolio_plus_content AS cc 
  ON cc.id = m.contentid

2 × SELECT c.*, m.catid AS catid ,cc.title AS category_title,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug,
  CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug,
  CASE WHEN CHAR_LENGTH(c.fulltext) THEN c.fulltext ELSE null END as readmore,t.title AS tagName, u.name AS author,u.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias 
  FROM `o6z40_tz_portfolio_plus_content` AS c 
  INNER JOIN `o6z40_tz_portfolio_plus_content_category_map` AS m 
  ON m.contentid=c.id 
  LEFT JOIN `o6z40_tz_portfolio_plus_categories` AS cc 
  ON cc.id=m.catid 
  LEFT JOIN `o6z40_tz_portfolio_plus_tag_content_map` AS x 
  ON x.contentid=c.id 
  LEFT JOIN `o6z40_tz_portfolio_plus_tags` AS t 
  ON t.id=x.tagsid 
  LEFT JOIN `o6z40_users` AS u 
  ON u.id=c.created_by 
  LEFT JOIN o6z40_tz_portfolio_plus_categories as parent 
  ON parent.id = cc.parent_id

2 × SELECT c.*, m.contentid AS contentid,m.main 
  FROM o6z40_tz_portfolio_plus_categories AS c 
  INNER JOIN o6z40_tz_portfolio_plus_content_category_map AS m 
  ON m.catid = c.id 
  INNER JOIN o6z40_tz_portfolio_plus_content AS cc 
  ON cc.id = m.contentid

2 × SELECT * 
  FROM o6z40_tz_portfolio_plus_content_rating

2 × SELECT * 
  FROM o6z40_tz_portfolio_plus_fieldgroups

2 × SELECT f.*, fm.groupid 
  FROM o6z40_tz_portfolio_plus_fields AS f 
  INNER JOIN o6z40_tz_portfolio_plus_field_content_map AS m 
  ON m.fieldsid = f.id 
  INNER JOIN o6z40_tz_portfolio_plus_content AS c 
  ON c.id = m.contentid 
  INNER JOIN o6z40_tz_portfolio_plus_field_fieldgroup_map AS fm 
  ON fm.fieldsid = f.id 
  INNER JOIN o6z40_tz_portfolio_plus_fieldgroups AS fg 
  ON fg.id = fm.groupid 
  INNER JOIN o6z40_tz_portfolio_plus_extensions AS e 
  ON e.element = f.type

1 × SELECT `data` 
  FROM `o6z40_session`

1 × SELECT `session_id` 
  FROM `o6z40_session`

1 × SELECT id, rules 
  FROM `o6z40_viewlevels

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

1 × SELECT count(*) 
  FROM `o6z40_cwgears_schedule

1 × SELECT count(*) 
  FROM `o6z40_cwgears_schedule`

1 × SELECT COUNT(t.id) 
  FROM o6z40_tz_portfolio_plus_templates AS t 
  INNER JOIN o6z40_tz_portfolio_plus_extensions AS e 
  On e.element = t.template

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

1 × SELECT * 
  FROM o6z40_tz_portfolio_plus_tags

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

1 × SELECT t.*, c.id AS contentid,
  CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(":", t.id, t.alias) ELSE t.id END as slug 
  FROM o6z40_tz_portfolio_plus_tags AS t 
  INNER JOIN o6z40_tz_portfolio_plus_tag_content_map AS m 
  ON m.tagsid = t.id 
  INNER JOIN o6z40_tz_portfolio_plus_content AS c 
  ON c.id = m.contentid

```
1 × SELECT * 
  FROM `o6z40_users`
```

1 × SELECT `g`.`id`,`g`.`title` 
  FROM `o6z40_usergroups` AS g 
  INNER JOIN `o6z40_user_usergroup_map` AS m 
  ON m.group_id = g.id

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 o6z40_fields AS a 
  LEFT JOIN `o6z40_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN o6z40_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN o6z40_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN o6z40_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN o6z40_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `o6z40_fields_categories` AS fc 
  ON fc.field_id = a.id

1 × SELECT t.* 
  FROM o6z40_tz_portfolio_plus_tags AS t 
  INNER JOIN o6z40_tz_portfolio_plus_tag_content_map AS m 
  ON m.tagsid = t.id 
  INNER JOIN o6z40_tz_portfolio_plus_content AS c 
  ON c.id = m.contentid

1 × SELECT id 
  FROM o6z40_template_styles

1 × SELECT uikit 
  FROM `o6z40_cwgears`

1 × SELECT uikit_plus 
  FROM `o6z40_cwgears`

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

OTHER Tables:

1 × INSERT INTO `o6z40_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6236306136353131613863633537353233316163316430353262346166616364', 1, 1680075915, 0, '', 0

1 × UPDATE `o6z40_extensions` 
  SET `params` = '{\"mediaversion\":\"b66ac93efefcbbfb4ddaaae36bef0089\"}'

1 × SHOW FULL COLUMNS 
  FROM `o6z40_tz_portfolio_plus_templates

1 × SHOW FULL COLUMNS 
  FROM `o6z40_users

Some of Our Clients

#Property Management

Dhullos Apartments

Enterprise Apartments

CONTACTS

Latest News

Tracker Installation Management Module

Route Market Sales App

Stay Connected

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

40 Queries Logged 1656.66 ms

3 duplicate found!

31 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: