Colaboraciones - Astur Galaica del Camino de Santiago

Consola de depuración de Joomla!

Sesión

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

Información del perfil

Fecha y hora

Memoria

Fecha y hora: 8.68 ms / 8.68 ms Memoria: 0.401 MB / 0.75 MB Application: afterLoad

Fecha y hora: 105.75 ms / 114.43 ms Memoria: 0.888 MB / 1.63 MB Application: afterInitialise

Fecha y hora: 22.16 ms / 136.59 ms Memoria: 0.344 MB / 1.98 MB Application: afterRoute

Fecha y hora: 2.19 ms / 138.78 ms Memoria: 0.101 MB / 2.08 MB Application: beforeRenderComponent com_tz_portfolio

Fecha y hora: 42.29 ms / 181.07 ms Memoria: 0.328 MB / 2.41 MB Application: Before Access::preloadComponents (all components)

Fecha y hora: 0.72 ms / 181.79 ms Memoria: 0.057 MB / 2.46 MB Application: After Access::preloadComponents (all components)

Fecha y hora: 0.02 ms / 181.81 ms Memoria: 0.000 MB / 2.46 MB Application: Before Access::getAssetRules (id:36 name:com_tz_portfolio)

Fecha y hora: 0.38 ms / 182.19 ms Memoria: 0.008 MB / 2.47 MB Application: After Access::getAssetRules (id:36 name:com_tz_portfolio)

Fecha y hora: 1.85 ms / 184.05 ms Memoria: 0.027 MB / 2.50 MB Application: Before Access::preloadPermissions (com_tz_portfolio)

Fecha y hora: 0.42 ms / 184.47 ms Memoria: 0.013 MB / 2.51 MB Application: After Access::preloadPermissions (com_tz_portfolio)

Fecha y hora: 183.85 ms / 368.32 ms Memoria: 1.194 MB / 3.71 MB Application: afterRenderComponent com_tz_portfolio

Fecha y hora: 7.22 ms / 375.53 ms Memoria: 0.008 MB / 3.71 MB Application: afterDispatch

Fecha y hora: 16.34 ms / 391.88 ms Memoria: 3.101 MB / 6.81 MB Application: beforeRenderModule mod_tz_news_pro (Lo último publicado)

Fecha y hora: 4.57 ms / 396.44 ms Memoria: 0.294 MB / 7.11 MB Application: afterRenderModule mod_tz_news_pro (Lo último publicado)

Fecha y hora: 10.22 ms / 406.66 ms Memoria: 0.000 MB / 7.03 MB Application: beforeRenderModule mod_tz_news_pro (Cabecera personalizada)

Fecha y hora: 2.50 ms / 409.16 ms Memoria: 0.104 MB / 7.13 MB Application: afterRenderModule mod_tz_news_pro (Cabecera personalizada)

Fecha y hora: 3.90 ms / 413.06 ms Memoria: 0.000 MB / 4.18 MB Application: afterRender

Total de consultas a la base de datos: 95.08 ms

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

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Lo mismo que llamada de la línea de abajo.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

#	Comunicador	Archivo y número de línea
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:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

'Explicar' no es posible en la consulta: INSERT INTO `dzjxd_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6b3969757564636162366b6374716a7272336731707265687063', 1, 1680063574, 0, '', 0)

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.76 ms Después de la última consulta: 11.34 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 1.148 MB Filas devueltas: 4

SELECT id, rules

  FROM `dzjxd_viewlevels`

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dzjxd_viewlevels	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	4

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
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:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.92 ms Después de la última consulta: 0.26 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 1.160 MB Filas devueltas: 2

SELECT b.id

  FROM dzjxd_usergroups AS a

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

  WHERE a.id = 9

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
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:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 6.83 ms Después de la última consulta: 39.77 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 1.960 MB

UPDATE `dzjxd_extensions`

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

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

Explicar

'Explicar' no es posible en la consulta: UPDATE `dzjxd_extensions` SET `params` = '{\"mediaversion\":\"7ae1e50bc603ec0f582e6ff342132853\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
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/jcktypography/jcktypography.php:48
8	plgSystemJCKtypography->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.56 ms Después de la última consulta: 47.39 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 2.412 MB Filas devueltas: 39

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

  FROM `dzjxd_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_breezingforms','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jckman','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_guestbook','com_tz_portfolio','com_users','com_weblinks','com_wrapper','com_xmap')

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dzjxd_assets	ALL	idx_asset_name	No pudo usarse una clave de índice	NULL	NULL	107	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
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/models/category.php:155
14	TZ_PortfolioModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/category/view.html.php:50
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.68 ms Después de la última consulta: 1.39 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 2.478 MB Filas devueltas: 2

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

  FROM `dzjxd_content` AS `i`

  WHERE i.`catid` = c.id 
  AND i.state = 1) AS numitems

  FROM `dzjxd_categories` AS `s`

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

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

  ORDER BY c.lft

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	No pudo usarse una clave de índice	NULL	NULL	26	Using where; Usando 'filesort'
2	DEPENDENT SUBQUERY	i	ref	idx_state,idx_catid	idx_catid	4	asturgalaica_database.c.id	1	Using index condition; Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
16	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
15	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_tz_portfolio/models/category.php:348
14	TZ_PortfolioModelCategory->getCategory()	JROOT/components/com_tz_portfolio/models/category.php:239
13	TZ_PortfolioModelCategory->getItems()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/category/view.html.php:66
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.34 ms Después de la última consulta: 0.30 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 2.498 MB Filas devueltas: 2

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

  FROM `dzjxd_assets`

  WHERE `name` LIKE 'com_tz_portfolio.%' OR `name` = 'com_tz_portfolio' OR `parent_id` = 0

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dzjxd_assets	ALL	idx_asset_name,idx_parent_id	No pudo usarse una clave de índice	NULL	NULL	107	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
19	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
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/models/category.php:357
14	TZ_PortfolioModelCategory->getCategory()	JROOT/components/com_tz_portfolio/models/category.php:239
13	TZ_PortfolioModelCategory->getItems()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/category/view.html.php:66
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.71 ms Después de la última consulta: 8.25 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 2.714 MB Filas devueltas: 8

SHOW FULL COLUMNS 
  FROM `dzjxd_assets`

Explicar

'Explicar' no es posible en la consulta: SHOW FULL COLUMNS FROM `dzjxd_assets`

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
21	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
20	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Asset.php:61
19	Joomla\CMS\Table\Asset->__construct()	JROOT/libraries/src/Access/Access.php:783
18	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
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/models/category.php:357
14	TZ_PortfolioModelCategory->getCategory()	JROOT/components/com_tz_portfolio/models/category.php:239
13	TZ_PortfolioModelCategory->getItems()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/category/view.html.php:66
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.87 ms Después de la última consulta: 68.25 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 2.751 MB Filas devueltas: 0

SELECT *

  FROM dzjxd_assets

  WHERE `name` = 'com_tz_portfolio.category.26'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
20	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
19	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
18	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
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/models/category.php:357
14	TZ_PortfolioModelCategory->getCategory()	JROOT/components/com_tz_portfolio/models/category.php:239
13	TZ_PortfolioModelCategory->getItems()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/category/view.html.php:66
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 5.79 ms Después de la última consulta: 10.12 ms Consulta a la memoria: 0.042 MB memoria antes de la consulta: 2.901 MB Filas devueltas: 3

SELECT a.id, a.title, a.alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published

  FROM dzjxd_content AS a

  LEFT JOIN dzjxd_content_frontpage AS fp 
  ON fp.content_id = a.id

  LEFT JOIN dzjxd_categories AS c 
  ON c.id = a.catid

  LEFT JOIN dzjxd_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN dzjxd_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language

  FROM dzjxd_contact_details AS contact

  WHERE contact.published = 1

  GROUP BY contact.user_id, contact.language) AS contact 
  ON contact.user_id = a.created_by

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

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

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

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND a.catid = 26 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-03-29 04:19:34') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-29 04:19:34')

  GROUP BY a.id, a.title, a.alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls

  ORDER BY    
  CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END  DESC ,  a.created   
  LIMIT 8

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	Using temporary; Usando 'filesort'
1	PRIMARY	a	ref	idx_access,idx_catid	idx_catid	4	const	4	Using where
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	asturgalaica_database.a.created_by	1	Using where
1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	asturgalaica_database.a.modified_by	1	Using where
1	PRIMARY	fp	eq_ref	PRIMARY	PRIMARY	4	asturgalaica_database.a.id	1	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	asturgalaica_database.a.created_by	2	Using where
1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where
1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	asturgalaica_database.a.id	1	Using where
1	PRIMARY	<derived3>	ref	key0	key0	5	const	5	Using where
3	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	Using index condition; Using temporary; Usando 'filesort'
3	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	26	Using where; Using index; Using join buffer (flat, BNL join)
2	DERIVED	contact	ref	idx_state	idx_state	1	const	1	Using where; Using temporary; Usando 'filesort'

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_tz_portfolio/models/articles.php:504
14	TZ_PortfolioModelArticles->getItems()	JROOT/components/com_tz_portfolio/models/category.php:263
13	TZ_PortfolioModelCategory->getItems()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/category/view.html.php:66
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 1.49 ms Después de la última consulta: 0.39 ms Consulta a la memoria: 0.042 MB memoria antes de la consulta: 3.019 MB Filas devueltas: 3

SELECT a.id, a.title, a.alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published

  FROM dzjxd_content AS a

  LEFT JOIN dzjxd_content_frontpage AS fp 
  ON fp.content_id = a.id

  LEFT JOIN dzjxd_categories AS c 
  ON c.id = a.catid

  LEFT JOIN dzjxd_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN dzjxd_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language

  FROM dzjxd_contact_details AS contact

  WHERE contact.published = 1

  GROUP BY contact.user_id, contact.language) AS contact 
  ON contact.user_id = a.created_by

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

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

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

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND a.catid = 26 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-03-29 04:19:34') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-29 04:19:34')

  GROUP BY a.id, a.title, a.alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls

  ORDER BY    
  CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END  DESC ,  a.created

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	Using temporary; Usando 'filesort'
1	PRIMARY	a	ref	idx_access,idx_catid	idx_catid	4	const	4	Using where
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	asturgalaica_database.a.created_by	1	Using where
1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	asturgalaica_database.a.modified_by	1	Using where
1	PRIMARY	fp	eq_ref	PRIMARY	PRIMARY	4	asturgalaica_database.a.id	1	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	asturgalaica_database.a.created_by	2	Using where
1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where
1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	asturgalaica_database.a.id	1	Using where
1	PRIMARY	<derived3>	ref	key0	key0	5	const	5	Using where
3	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	Using index condition; Using temporary; Usando 'filesort'
3	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	26	Using where; Using index; Using join buffer (flat, BNL join)
2	DERIVED	contact	ref	idx_state	idx_state	1	const	1	Using where; Using temporary; Usando 'filesort'

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:353
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
15	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
14	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/components/com_tz_portfolio/models/category.php:274
13	TZ_PortfolioModelCategory->getItems()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/category/view.html.php:66
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.42 ms Después de la última consulta: 1.10 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 3.064 MB Filas devueltas: 2

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

  FROM `dzjxd_categories` AS `s`

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

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

  ORDER BY c.lft

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	No pudo usarse una clave de índice	NULL	NULL	26	Using where; Usando 'filesort'

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
14	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
13	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_tz_portfolio/helpers/route.php:41
12	TZ_PortfolioHelperRoute::getArticleRoute()	JROOT/components/com_tz_portfolio/views/category/view.html.php:136
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.44 ms Después de la última consulta: 0.51 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 3.099 MB Filas devueltas: 0

Consultas duplicadas: #19 #21

SELECT *

  FROM `dzjxd_extensions`

  WHERE `enabled`=1 
  AND `type`='plugin' 
  AND `folder`='tz_portfolio'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dzjxd_extensions	ALL	extension	No pudo usarse una clave de índice	NULL	NULL	240	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_tz_portfolio/models/plugin.php:100
14	TZ_PortfolioModelPlugin->getPluginItems()	JROOT/components/com_tz_portfolio/models/plugins.php:46
13	TZ_PortfolioModelPlugins->getPluginItems()	JROOT/components/com_tz_portfolio/models/plugins.php:72
12	TZ_PortfolioModelPlugins->getItems()	JROOT/components/com_tz_portfolio/views/category/view.html.php:189
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.18 ms Después de la última consulta: 0.05 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 3.107 MB Filas devueltas: 0

SELECT p.*,x.element

  FROM `dzjxd_tz_portfolio_plugin` AS p

  LEFT JOIN `dzjxd_extensions` AS x 
  ON p.pluginid = x.extension_id

  WHERE x.enabled = 1 
  AND x.folder = 'tz_portfolio' 
  AND p.contentid IN(60)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio/models/plugins.php:81
12	TZ_PortfolioModelPlugins->getItems()	JROOT/components/com_tz_portfolio/views/category/view.html.php:189
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 1.34 ms Después de la última consulta: 28.19 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 3.159 MB Filas devueltas: 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 dzjxd_fields AS a

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

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

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

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

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

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

  ORDER BY a.ordering ASC

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
19	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
18	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
15	JHtmlContent::prepare()	Lo mismo que llamada de la línea de abajo.
14	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
13	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
12	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_tz_portfolio/views/category/view.html.php:195
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 1.22 ms Después de la última consulta: 0.61 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 3.171 MB Filas devueltas: 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 dzjxd_fields AS a

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

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

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

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

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

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

  WHERE a.context = 'com_tz_portfolio.category' 
  AND (fc.category_id IS NULL OR fc.category_id IN (26,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
19	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
18	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
17	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
16	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:404
15	PlgSystemFields->display()	JROOT/plugins/system/fields/fields.php:324
14	PlgSystemFields->onContentAfterTitle()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_tz_portfolio/views/category/view.html.php:197
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.96 ms Después de la última consulta: 1.20 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 3.194 MB Filas devueltas: 0

Consultas duplicadas: #15 #21

SELECT *

  FROM `dzjxd_extensions`

  WHERE `enabled`=1 
  AND `type`='plugin' 
  AND `folder`='tz_portfolio'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dzjxd_extensions	ALL	extension	No pudo usarse una clave de índice	NULL	NULL	240	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_tz_portfolio/models/plugin.php:100
14	TZ_PortfolioModelPlugin->getPluginItems()	JROOT/components/com_tz_portfolio/models/plugins.php:46
13	TZ_PortfolioModelPlugins->getPluginItems()	JROOT/components/com_tz_portfolio/models/plugins.php:72
12	TZ_PortfolioModelPlugins->getItems()	JROOT/components/com_tz_portfolio/views/category/view.html.php:189
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.45 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 3.202 MB Filas devueltas: 0

SELECT p.*,x.element

  FROM `dzjxd_tz_portfolio_plugin` AS p

  LEFT JOIN `dzjxd_extensions` AS x 
  ON p.pluginid = x.extension_id

  WHERE x.enabled = 1 
  AND x.folder = 'tz_portfolio' 
  AND p.contentid IN(56)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio/models/plugins.php:81
12	TZ_PortfolioModelPlugins->getItems()	JROOT/components/com_tz_portfolio/views/category/view.html.php:189
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 1.16 ms Después de la última consulta: 1.11 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 3.209 MB Filas devueltas: 0

Consultas duplicadas: #15 #19

SELECT *

  FROM `dzjxd_extensions`

  WHERE `enabled`=1 
  AND `type`='plugin' 
  AND `folder`='tz_portfolio'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dzjxd_extensions	ALL	extension	No pudo usarse una clave de índice	NULL	NULL	240	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_tz_portfolio/models/plugin.php:100
14	TZ_PortfolioModelPlugin->getPluginItems()	JROOT/components/com_tz_portfolio/models/plugins.php:46
13	TZ_PortfolioModelPlugins->getPluginItems()	JROOT/components/com_tz_portfolio/models/plugins.php:72
12	TZ_PortfolioModelPlugins->getItems()	JROOT/components/com_tz_portfolio/views/category/view.html.php:189
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.48 ms Después de la última consulta: 0.11 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 3.217 MB Filas devueltas: 0

SELECT p.*,x.element

  FROM `dzjxd_tz_portfolio_plugin` AS p

  LEFT JOIN `dzjxd_extensions` AS x 
  ON p.pluginid = x.extension_id

  WHERE x.enabled = 1 
  AND x.folder = 'tz_portfolio' 
  AND p.contentid IN(55)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio/models/plugins.php:81
12	TZ_PortfolioModelPlugins->getItems()	JROOT/components/com_tz_portfolio/views/category/view.html.php:189
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.44 ms Después de la última consulta: 1.06 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 3.223 MB Filas devueltas: 1

Consultas duplicadas: #24

SELECT * 
  FROM dzjxd_tz_portfolio_categories 
  WHERE catid=26

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dzjxd_tz_portfolio_categories	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	17	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
14	JDatabase->query()	JROOT/components/com_tz_portfolio/models/category.php:109
13	TZ_PortfolioModelCategory->getCatImages()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/category/view.html.php:290
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.48 ms Después de la última consulta: 0.07 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 3.230 MB Filas devueltas: 1

Consultas duplicadas: #23

SELECT * 
  FROM dzjxd_tz_portfolio_categories 
  WHERE catid=26

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dzjxd_tz_portfolio_categories	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	17	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_tz_portfolio/models/category.php:113
13	TZ_PortfolioModelCategory->getCatImages()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/category/view.html.php:290
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.44 ms Después de la última consulta: 34.13 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 3.607 MB Filas devueltas: 1

Consultas duplicadas: #26

SELECT c.featured,xc.*,c.catid,c.attribs AS param 
  FROM dzjxd_tz_portfolio_xref_content AS xc 
  LEFT JOIN dzjxd_content AS c 
  ON c.id=xc.contentid 
  WHERE c.state=1 
  AND xc.contentid=60

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,idx_state	PRIMARY	4	const	1
1	SIMPLE	xc	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	42	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
18	JDatabase->query()	JROOT/components/com_tz_portfolio/models/media.php:66
17	TZ_PortfolioModelMedia->getMedia()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php:57
16	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
15	JViewLegacy->loadTemplate()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php:101
14	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:207
12	JViewLegacy->display()	JROOT/components/com_tz_portfolio/views/category/view.html.php:370
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.30 ms Después de la última consulta: 0.03 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 3.616 MB Filas devueltas: 1

Consultas duplicadas: #25

SELECT c.featured,xc.*,c.catid,c.attribs AS param 
  FROM dzjxd_tz_portfolio_xref_content AS xc 
  LEFT JOIN dzjxd_content AS c 
  ON c.id=xc.contentid 
  WHERE c.state=1 
  AND xc.contentid=60

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,idx_state	PRIMARY	4	const	1
1	SIMPLE	xc	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	42	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/components/com_tz_portfolio/models/media.php:71
17	TZ_PortfolioModelMedia->getMedia()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php:57
16	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
15	JViewLegacy->loadTemplate()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php:101
14	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:207
12	JViewLegacy->display()	JROOT/components/com_tz_portfolio/views/category/view.html.php:370
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.31 ms Después de la última consulta: 1.00 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 3.638 MB Filas devueltas: 1

SELECT name

  FROM dzjxd_users

  WHERE id=662

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
25	JDatabaseDriver->loadResult()	JROOT/components/com_tz_portfolio/router.php:238
24	TZ_PortfolioBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
23	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
22	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
21	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
20	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
19	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
18	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
17	Joomla\CMS\Router\Route::_()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php:112
16	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
15	JViewLegacy->loadTemplate()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php:101
14	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:207
12	JViewLegacy->display()	JROOT/components/com_tz_portfolio/views/category/view.html.php:370
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.33 ms Después de la última consulta: 0.77 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 3.652 MB Filas devueltas: 1

Consultas duplicadas: #29 #36 #37 #44 #45

SELECT * 
  FROM dzjxd_categories 
  WHERE published=1 
  AND id=26

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
19	JDatabase->query()	JROOT/components/com_tz_portfolio/models/extrafields.php:170
18	TZ_PortfolioModelExtraFields->getCatParams()	JROOT/components/com_tz_portfolio/models/extrafields.php:186
17	TZ_PortfolioModelExtraFields->getParams()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php:241
16	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
15	JViewLegacy->loadTemplate()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php:101
14	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:207
12	JViewLegacy->display()	JROOT/components/com_tz_portfolio/views/category/view.html.php:370
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.27 ms Después de la última consulta: 0.03 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 3.662 MB Filas devueltas: 1

Consultas duplicadas: #28 #36 #37 #44 #45

SELECT * 
  FROM dzjxd_categories 
  WHERE published=1 
  AND id=26

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/components/com_tz_portfolio/models/extrafields.php:174
18	TZ_PortfolioModelExtraFields->getCatParams()	JROOT/components/com_tz_portfolio/models/extrafields.php:186
17	TZ_PortfolioModelExtraFields->getParams()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php:241
16	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
15	JViewLegacy->loadTemplate()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php:101
14	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:207
12	JViewLegacy->display()	JROOT/components/com_tz_portfolio/views/category/view.html.php:370
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.20 ms Después de la última consulta: 0.06 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 3.673 MB Filas devueltas: 1

Consultas duplicadas: #31

SELECT groupid 
  FROM dzjxd_tz_portfolio_xref_content 
  WHERE contentid=60

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dzjxd_tz_portfolio_xref_content	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	42	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
19	JDatabase->query()	JROOT/components/com_tz_portfolio/models/extrafields.php:155
18	TZ_PortfolioModelExtraFields->_checkArticleGroupId()	JROOT/components/com_tz_portfolio/models/extrafields.php:188
17	TZ_PortfolioModelExtraFields->getParams()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php:241
16	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
15	JViewLegacy->loadTemplate()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php:101
14	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:207
12	JViewLegacy->display()	JROOT/components/com_tz_portfolio/views/category/view.html.php:370
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.20 ms Después de la última consulta: 0.04 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 3.683 MB Filas devueltas: 1

Consultas duplicadas: #30

SELECT groupid 
  FROM dzjxd_tz_portfolio_xref_content 
  WHERE contentid=60

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dzjxd_tz_portfolio_xref_content	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	42	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/components/com_tz_portfolio/models/extrafields.php:159
18	TZ_PortfolioModelExtraFields->_checkArticleGroupId()	JROOT/components/com_tz_portfolio/models/extrafields.php:188
17	TZ_PortfolioModelExtraFields->getParams()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php:241
16	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
15	JViewLegacy->loadTemplate()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php:101
14	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:207
12	JViewLegacy->display()	JROOT/components/com_tz_portfolio/views/category/view.html.php:370
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.23 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 3.705 MB Filas devueltas: 0

Consultas duplicadas: #33

SELECT t.*,f.title 
  FROM dzjxd_tz_portfolio AS t 
  LEFT JOIN dzjxd_tz_portfolio_fields AS f 
  ON f.id=t.fieldsid 
  LEFT JOIN dzjxd_content AS c 
  ON c.id=t.contentid 
  WHERE c.state=1 
  AND t.contentid=60 
  ORDER BY f.id DESC

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
18	JDatabase->query()	JROOT/components/com_tz_portfolio/models/extrafields.php:109
17	TZ_PortfolioModelExtraFields->getExtraFields()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php:249
16	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
15	JViewLegacy->loadTemplate()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php:101
14	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:207
12	JViewLegacy->display()	JROOT/components/com_tz_portfolio/views/category/view.html.php:370
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.25 ms Después de la última consulta: 0.06 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 3.721 MB Filas devueltas: 0

Consultas duplicadas: #32

SELECT t.*,f.title 
  FROM dzjxd_tz_portfolio AS t 
  LEFT JOIN dzjxd_tz_portfolio_fields AS f 
  ON f.id=t.fieldsid 
  LEFT JOIN dzjxd_content AS c 
  ON c.id=t.contentid 
  WHERE c.state=1 
  AND t.contentid=60 
  ORDER BY f.id DESC

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio/models/extrafields.php:113
17	TZ_PortfolioModelExtraFields->getExtraFields()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php:249
16	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
15	JViewLegacy->loadTemplate()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php:101
14	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:207
12	JViewLegacy->display()	JROOT/components/com_tz_portfolio/views/category/view.html.php:370
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.22 ms Después de la última consulta: 1.21 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 3.720 MB Filas devueltas: 1

Consultas duplicadas: #35

SELECT c.featured,xc.*,c.catid,c.attribs AS param 
  FROM dzjxd_tz_portfolio_xref_content AS xc 
  LEFT JOIN dzjxd_content AS c 
  ON c.id=xc.contentid 
  WHERE c.state=1 
  AND xc.contentid=56

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,idx_state	PRIMARY	4	const	1
1	SIMPLE	xc	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	42	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
18	JDatabase->query()	JROOT/components/com_tz_portfolio/models/media.php:66
17	TZ_PortfolioModelMedia->getMedia()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php:57
16	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
15	JViewLegacy->loadTemplate()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php:148
14	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:207
12	JViewLegacy->display()	JROOT/components/com_tz_portfolio/views/category/view.html.php:370
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.26 ms Después de la última consulta: 0.02 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 3.730 MB Filas devueltas: 1

Consultas duplicadas: #34

SELECT c.featured,xc.*,c.catid,c.attribs AS param 
  FROM dzjxd_tz_portfolio_xref_content AS xc 
  LEFT JOIN dzjxd_content AS c 
  ON c.id=xc.contentid 
  WHERE c.state=1 
  AND xc.contentid=56

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,idx_state	PRIMARY	4	const	1
1	SIMPLE	xc	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	42	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/components/com_tz_portfolio/models/media.php:71
17	TZ_PortfolioModelMedia->getMedia()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php:57
16	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
15	JViewLegacy->loadTemplate()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php:148
14	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:207
12	JViewLegacy->display()	JROOT/components/com_tz_portfolio/views/category/view.html.php:370
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.20 ms Después de la última consulta: 0.53 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 3.741 MB Filas devueltas: 1

Consultas duplicadas: #28 #29 #37 #44 #45

SELECT * 
  FROM dzjxd_categories 
  WHERE published=1 
  AND id=26

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
19	JDatabase->query()	JROOT/components/com_tz_portfolio/models/extrafields.php:170
18	TZ_PortfolioModelExtraFields->getCatParams()	JROOT/components/com_tz_portfolio/models/extrafields.php:186
17	TZ_PortfolioModelExtraFields->getParams()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php:241
16	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
15	JViewLegacy->loadTemplate()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php:148
14	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:207
12	JViewLegacy->display()	JROOT/components/com_tz_portfolio/views/category/view.html.php:370
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.16 ms Después de la última consulta: 0.02 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 3.751 MB Filas devueltas: 1

Consultas duplicadas: #28 #29 #36 #44 #45

SELECT * 
  FROM dzjxd_categories 
  WHERE published=1 
  AND id=26

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/components/com_tz_portfolio/models/extrafields.php:174
18	TZ_PortfolioModelExtraFields->getCatParams()	JROOT/components/com_tz_portfolio/models/extrafields.php:186
17	TZ_PortfolioModelExtraFields->getParams()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php:241
16	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
15	JViewLegacy->loadTemplate()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php:148
14	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:207
12	JViewLegacy->display()	JROOT/components/com_tz_portfolio/views/category/view.html.php:370
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.14 ms Después de la última consulta: 0.07 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 3.762 MB Filas devueltas: 1

Consultas duplicadas: #39

SELECT groupid 
  FROM dzjxd_tz_portfolio_xref_content 
  WHERE contentid=56

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dzjxd_tz_portfolio_xref_content	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	42	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
19	JDatabase->query()	JROOT/components/com_tz_portfolio/models/extrafields.php:155
18	TZ_PortfolioModelExtraFields->_checkArticleGroupId()	JROOT/components/com_tz_portfolio/models/extrafields.php:188
17	TZ_PortfolioModelExtraFields->getParams()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php:241
16	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
15	JViewLegacy->loadTemplate()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php:148
14	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:207
12	JViewLegacy->display()	JROOT/components/com_tz_portfolio/views/category/view.html.php:370
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.19 ms Después de la última consulta: 0.03 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 3.772 MB Filas devueltas: 1

Consultas duplicadas: #38

SELECT groupid 
  FROM dzjxd_tz_portfolio_xref_content 
  WHERE contentid=56

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dzjxd_tz_portfolio_xref_content	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	42	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/components/com_tz_portfolio/models/extrafields.php:159
18	TZ_PortfolioModelExtraFields->_checkArticleGroupId()	JROOT/components/com_tz_portfolio/models/extrafields.php:188
17	TZ_PortfolioModelExtraFields->getParams()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php:241
16	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
15	JViewLegacy->loadTemplate()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php:148
14	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:207
12	JViewLegacy->display()	JROOT/components/com_tz_portfolio/views/category/view.html.php:370
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.20 ms Después de la última consulta: 0.07 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 3.793 MB Filas devueltas: 0

Consultas duplicadas: #41

SELECT t.*,f.title 
  FROM dzjxd_tz_portfolio AS t 
  LEFT JOIN dzjxd_tz_portfolio_fields AS f 
  ON f.id=t.fieldsid 
  LEFT JOIN dzjxd_content AS c 
  ON c.id=t.contentid 
  WHERE c.state=1 
  AND t.contentid=56 
  ORDER BY f.id DESC

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
18	JDatabase->query()	JROOT/components/com_tz_portfolio/models/extrafields.php:109
17	TZ_PortfolioModelExtraFields->getExtraFields()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php:249
16	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
15	JViewLegacy->loadTemplate()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php:148
14	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:207
12	JViewLegacy->display()	JROOT/components/com_tz_portfolio/views/category/view.html.php:370
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.21 ms Después de la última consulta: 0.03 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 3.803 MB Filas devueltas: 0

Consultas duplicadas: #40

SELECT t.*,f.title 
  FROM dzjxd_tz_portfolio AS t 
  LEFT JOIN dzjxd_tz_portfolio_fields AS f 
  ON f.id=t.fieldsid 
  LEFT JOIN dzjxd_content AS c 
  ON c.id=t.contentid 
  WHERE c.state=1 
  AND t.contentid=56 
  ORDER BY f.id DESC

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio/models/extrafields.php:113
17	TZ_PortfolioModelExtraFields->getExtraFields()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php:249
16	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
15	JViewLegacy->loadTemplate()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php:148
14	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:207
12	JViewLegacy->display()	JROOT/components/com_tz_portfolio/views/category/view.html.php:370
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.27 ms Después de la última consulta: 0.92 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 3.800 MB Filas devueltas: 1

Consultas duplicadas: #43

SELECT c.featured,xc.*,c.catid,c.attribs AS param 
  FROM dzjxd_tz_portfolio_xref_content AS xc 
  LEFT JOIN dzjxd_content AS c 
  ON c.id=xc.contentid 
  WHERE c.state=1 
  AND xc.contentid=55

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,idx_state	PRIMARY	4	const	1
1	SIMPLE	xc	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	42	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
18	JDatabase->query()	JROOT/components/com_tz_portfolio/models/media.php:66
17	TZ_PortfolioModelMedia->getMedia()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php:57
16	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
15	JViewLegacy->loadTemplate()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php:148
14	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:207
12	JViewLegacy->display()	JROOT/components/com_tz_portfolio/views/category/view.html.php:370
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.26 ms Después de la última consulta: 0.02 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 3.810 MB Filas devueltas: 1

Consultas duplicadas: #42

SELECT c.featured,xc.*,c.catid,c.attribs AS param 
  FROM dzjxd_tz_portfolio_xref_content AS xc 
  LEFT JOIN dzjxd_content AS c 
  ON c.id=xc.contentid 
  WHERE c.state=1 
  AND xc.contentid=55

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,idx_state	PRIMARY	4	const	1
1	SIMPLE	xc	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	42	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/components/com_tz_portfolio/models/media.php:71
17	TZ_PortfolioModelMedia->getMedia()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php:57
16	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
15	JViewLegacy->loadTemplate()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php:148
14	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:207
12	JViewLegacy->display()	JROOT/components/com_tz_portfolio/views/category/view.html.php:370
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.26 ms Después de la última consulta: 0.53 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 3.821 MB Filas devueltas: 1

Consultas duplicadas: #28 #29 #36 #37 #45

SELECT * 
  FROM dzjxd_categories 
  WHERE published=1 
  AND id=26

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
19	JDatabase->query()	JROOT/components/com_tz_portfolio/models/extrafields.php:170
18	TZ_PortfolioModelExtraFields->getCatParams()	JROOT/components/com_tz_portfolio/models/extrafields.php:186
17	TZ_PortfolioModelExtraFields->getParams()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php:241
16	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
15	JViewLegacy->loadTemplate()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php:148
14	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:207
12	JViewLegacy->display()	JROOT/components/com_tz_portfolio/views/category/view.html.php:370
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.22 ms Después de la última consulta: 0.02 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 3.831 MB Filas devueltas: 1

Consultas duplicadas: #28 #29 #36 #37 #44

SELECT * 
  FROM dzjxd_categories 
  WHERE published=1 
  AND id=26

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/components/com_tz_portfolio/models/extrafields.php:174
18	TZ_PortfolioModelExtraFields->getCatParams()	JROOT/components/com_tz_portfolio/models/extrafields.php:186
17	TZ_PortfolioModelExtraFields->getParams()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php:241
16	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
15	JViewLegacy->loadTemplate()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php:148
14	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:207
12	JViewLegacy->display()	JROOT/components/com_tz_portfolio/views/category/view.html.php:370
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.19 ms Después de la última consulta: 0.06 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 3.842 MB Filas devueltas: 1

Consultas duplicadas: #47

SELECT groupid 
  FROM dzjxd_tz_portfolio_xref_content 
  WHERE contentid=55

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dzjxd_tz_portfolio_xref_content	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	42	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
19	JDatabase->query()	JROOT/components/com_tz_portfolio/models/extrafields.php:155
18	TZ_PortfolioModelExtraFields->_checkArticleGroupId()	JROOT/components/com_tz_portfolio/models/extrafields.php:188
17	TZ_PortfolioModelExtraFields->getParams()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php:241
16	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
15	JViewLegacy->loadTemplate()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php:148
14	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:207
12	JViewLegacy->display()	JROOT/components/com_tz_portfolio/views/category/view.html.php:370
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.14 ms Después de la última consulta: 0.02 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 3.852 MB Filas devueltas: 1

Consultas duplicadas: #46

SELECT groupid 
  FROM dzjxd_tz_portfolio_xref_content 
  WHERE contentid=55

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dzjxd_tz_portfolio_xref_content	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	42	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/components/com_tz_portfolio/models/extrafields.php:159
18	TZ_PortfolioModelExtraFields->_checkArticleGroupId()	JROOT/components/com_tz_portfolio/models/extrafields.php:188
17	TZ_PortfolioModelExtraFields->getParams()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php:241
16	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
15	JViewLegacy->loadTemplate()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php:148
14	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:207
12	JViewLegacy->display()	JROOT/components/com_tz_portfolio/views/category/view.html.php:370
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.15 ms Después de la última consulta: 0.07 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 3.873 MB Filas devueltas: 0

Consultas duplicadas: #49

SELECT t.*,f.title 
  FROM dzjxd_tz_portfolio AS t 
  LEFT JOIN dzjxd_tz_portfolio_fields AS f 
  ON f.id=t.fieldsid 
  LEFT JOIN dzjxd_content AS c 
  ON c.id=t.contentid 
  WHERE c.state=1 
  AND t.contentid=55 
  ORDER BY f.id DESC

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
18	JDatabase->query()	JROOT/components/com_tz_portfolio/models/extrafields.php:109
17	TZ_PortfolioModelExtraFields->getExtraFields()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php:249
16	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
15	JViewLegacy->loadTemplate()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php:148
14	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:207
12	JViewLegacy->display()	JROOT/components/com_tz_portfolio/views/category/view.html.php:370
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.24 ms Después de la última consulta: 0.03 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 3.883 MB Filas devueltas: 0

Consultas duplicadas: #48

SELECT t.*,f.title 
  FROM dzjxd_tz_portfolio AS t 
  LEFT JOIN dzjxd_tz_portfolio_fields AS f 
  ON f.id=t.fieldsid 
  LEFT JOIN dzjxd_content AS c 
  ON c.id=t.contentid 
  WHERE c.state=1 
  AND t.contentid=55 
  ORDER BY f.id DESC

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio/models/extrafields.php:113
17	TZ_PortfolioModelExtraFields->getExtraFields()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php:249
16	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog_item.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
15	JViewLegacy->loadTemplate()	JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php:148
14	include JROOT/templates/tz_blog/html/com_tz_portfolio/category/blog.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:207
12	JViewLegacy->display()	JROOT/components/com_tz_portfolio/views/category/view.html.php:370
11	TZ_PortfolioViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tz_portfolio/controller.php:112
8	TZ_PortfolioController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 2.17 ms Después de la última consulta: 24.85 ms Consulta a la memoria: 0.144 MB memoria antes de la consulta: 6.927 MB Filas devueltas: 6

SELECT *, ct.id as arid, ct.hits as hit, ct.title as artitle, ct.alias as aralias, cat.alias as category_alias, tzx.images as tzimages,
                                      tzx.gallery as tzgallery, tzx.video as tzvideo
                                    
  FROM dzjxd_content ct 
  LEFT JOIN dzjxd_tz_portfolio_xref_content tzx 
  ON(ct.id = tzx.contentid)
                                    
  LEFT JOIN dzjxd_categories cat 
  ON(ct.catid = cat.id)
                                    
  WHERE ct.catid IN(18,11,8,9,26) 
  and ct.state = 1  
  ORDER BY ct.created DESC 
  LIMIT 6

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ct	range	idx_state,idx_catid	idx_catid	4	NULL	22	Using index condition; Using where; Using temporary; Usando 'filesort'
1	SIMPLE	tzx	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	42	Using where; Using join buffer (flat, BNL join)
1	SIMPLE	cat	eq_ref	PRIMARY	PRIMARY	4	asturgalaica_database.ct.catid	1	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_tz_news_pro/helper.php:118
11	modTzNewsHelper::getList()	JROOT/modules/mod_tz_news_pro/mod_tz_news_pro.php:54
10	include JROOT/modules/mod_tz_news_pro/mod_tz_news_pro.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:489
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.39 ms Después de la última consulta: 0.32 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 7.086 MB Filas devueltas: 3

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

  FROM `dzjxd_categories` AS `s`

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

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

  ORDER BY c.lft

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	No pudo usarse una clave de índice	NULL	NULL	26	Using where; Usando 'filesort'

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
14	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
13	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_tz_portfolio/helpers/route.php:41
12	TZ_PortfolioHelperRoute::getArticleRoute()	JROOT/modules/mod_tz_news_pro/helper.php:127
11	modTzNewsHelper::getList()	JROOT/modules/mod_tz_news_pro/mod_tz_news_pro.php:54
10	include JROOT/modules/mod_tz_news_pro/mod_tz_news_pro.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:489
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.30 ms Después de la última consulta: 0.13 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 7.104 MB Filas devueltas: 3

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

  FROM `dzjxd_categories` AS `s`

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

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

  ORDER BY c.lft

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
14	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
13	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_tz_portfolio/helpers/route.php:41
12	TZ_PortfolioHelperRoute::getArticleRoute()	JROOT/modules/mod_tz_news_pro/helper.php:127
11	modTzNewsHelper::getList()	JROOT/modules/mod_tz_news_pro/mod_tz_news_pro.php:54
10	include JROOT/modules/mod_tz_news_pro/mod_tz_news_pro.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:489
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 1.11 ms Después de la última consulta: 11.13 ms Consulta a la memoria: 0.062 MB memoria antes de la consulta: 7.049 MB Filas devueltas: 5

SELECT *, ct.id as arid, ct.hits as hit, ct.title as artitle, ct.alias as aralias, cat.alias as category_alias, tzx.images as tzimages,
                                      tzx.gallery as tzgallery, tzx.video as tzvideo
                                    
  FROM dzjxd_content ct 
  LEFT JOIN dzjxd_tz_portfolio_xref_content tzx 
  ON(ct.id = tzx.contentid)
                                    
  LEFT JOIN dzjxd_categories cat 
  ON(ct.catid = cat.id)
                                    
  WHERE ct.catid IN(13) 
  and ct.state = 1  
  ORDER BY ct.title DESC 
  LIMIT 5

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ct	ref	idx_state,idx_catid	idx_catid	4	const	10	Using where; Using temporary; Usando 'filesort'
1	SIMPLE	tzx	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	42	Using where; Using join buffer (flat, BNL join)
1	SIMPLE	cat	const	PRIMARY	PRIMARY	4	const	1

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_tz_news_pro/helper.php:118
11	modTzNewsHelper::getList()	JROOT/modules/mod_tz_news_pro/mod_tz_news_pro.php:54
10	include JROOT/modules/mod_tz_news_pro/mod_tz_news_pro.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:489
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.42 ms Después de la última consulta: 0.14 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 7.121 MB Filas devueltas: 2

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

  FROM `dzjxd_categories` AS `s`

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

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

  ORDER BY c.lft

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	No pudo usarse una clave de índice	NULL	NULL	26	Using where; Usando 'filesort'

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
14	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
13	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_tz_portfolio/helpers/route.php:41
12	TZ_PortfolioHelperRoute::getArticleRoute()	JROOT/modules/mod_tz_news_pro/helper.php:127
11	modTzNewsHelper::getList()	JROOT/modules/mod_tz_news_pro/mod_tz_news_pro.php:54
10	include JROOT/modules/mod_tz_news_pro/mod_tz_news_pro.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:489
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

23 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

6 × SELECT t.*,f.title 
  FROM dzjxd_tz_portfolio AS t 
  LEFT JOIN dzjxd_tz_portfolio_fields AS f 
  ON f.id=t.fieldsid 
  LEFT JOIN dzjxd_content AS c 
  ON c.id=t.contentid

6 × SELECT groupid 
  FROM dzjxd_tz_portfolio_xref_content

```
6 × SELECT * 
  FROM dzjxd_categories
```

6 × SELECT c.featured,xc.*,c.catid,c.attribs AS param 
  FROM dzjxd_tz_portfolio_xref_content AS xc 
  LEFT JOIN dzjxd_content AS c 
  ON c.id=xc.contentid

4 × 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 `dzjxd_categories` AS `s` 
  INNER JOIN `dzjxd_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

3 × SELECT p.*,x.element 
  FROM `dzjxd_tz_portfolio_plugin` AS p 
  LEFT JOIN `dzjxd_extensions` AS x 
  ON p.pluginid = x.extension_id

3 × SELECT * 
  FROM `dzjxd_extensions`

2 × SELECT * 
  FROM dzjxd_tz_portfolio_categories

2 × SELECT *, ct.id as arid, ct.hits as hit, ct.title as artitle, ct.alias as aralias, cat.alias as category_alias, tzx.images as tzimages,
                                       tzx.gallery as tzgallery, tzx.video as tzvideo
                                     
  FROM dzjxd_content ct 
  LEFT JOIN dzjxd_tz_portfolio_xref_content tzx 
  ON(ct.id = tzx.contentid)
                                     
  LEFT JOIN dzjxd_categories cat 
  ON(ct.catid = cat.id)

2 × SELECT a.id, a.title, a.alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published 
  FROM dzjxd_content AS a 
  LEFT JOIN dzjxd_content_frontpage AS fp 
  ON fp.content_id = a.id 
  LEFT JOIN dzjxd_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN dzjxd_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN dzjxd_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language 
  FROM dzjxd_contact_details AS contact

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `dzjxd_assets`

1 × SELECT `session_id` 
  FROM `dzjxd_session`

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 dzjxd_fields AS a 
  LEFT JOIN `dzjxd_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN dzjxd_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN dzjxd_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN dzjxd_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN dzjxd_fields_groups AS g 
  ON g.id = a.group_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 dzjxd_fields AS a 
  LEFT JOIN `dzjxd_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN dzjxd_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN dzjxd_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN dzjxd_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN dzjxd_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `dzjxd_fields_categories` AS fc 
  ON fc.field_id = a.id

```
1 × SELECT * 
  FROM dzjxd_assets
```

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,( SELECT COUNT(i.`id`) 
  FROM `dzjxd_content` AS `i`

```
1 × SELECT name 
  FROM dzjxd_users
```

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

1 × SELECT id, rules 
  FROM `dzjxd_viewlevels

1 × SELECT `data` 
  FROM `dzjxd_session`

OTRAS tablas:

1 × INSERT INTO `dzjxd_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6b3969757564636162366b6374716a7272336731707265687063', 1, 1680063574, 0, '', 0

1 × UPDATE `dzjxd_extensions` 
  SET `params` = '{\"mediaversion\":\"7ae1e50bc603ec0f582e6ff342132853\"}'

1 × SHOW FULL COLUMNS 
  FROM `dzjxd_assets

Camino de Santiago. El Camino histórico por la costa (I)

Camino de Santiago. El Camino histórico por la costa (y II)

Camino de Santiago. Explorando Tol-Vegadeo

Camino de Santiago. El Camino histórico por la costa (I)

Camino de Santiago. El Camino histórico por la costa (y II)

Camino de Santiago. Explorando Tol-Vegadeo

Vegadeo-Abres, por el Camino de Santiago.

Viajar con lo indispensable

¿Qué calzado es mejor?

Consola de depuración de Joomla!

Sesión

Información del perfil

Fecha y hora

Memoria

Uso de la memoria

Consultas de la base de datos

54 consultas registradas 95.08 ms

¡ 29 duplicaciones detectadas!

23 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

OTRAS tablas: