Galería

Consola de depuración de Joomla!

Sesión

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

Información de perfil

Hora

Memoria

Hora: 13.48 ms / 13.48 ms Memoria: 1.641 MB / 1.99 MB Application: afterLoad

Hora: 71.51 ms / 84.99 ms Memoria: 4.695 MB / 6.68 MB Application: afterInitialise

Hora: 50.81 ms / 135.81 ms Memoria: 1.431 MB / 8.12 MB Application: afterRoute

Hora: 14.46 ms / 150.27 ms Memoria: 0.288 MB / 8.40 MB Application: beforeRenderComponent com_tz_portfolio_plus

Hora: 18.54 ms / 168.81 ms Memoria: 1.252 MB / 9.66 MB Application: Before Access::preloadComponents (all components)

Hora: 2.27 ms / 171.08 ms Memoria: 0.059 MB / 9.71 MB Application: After Access::preloadComponents (all components)

Hora: 0.03 ms / 171.11 ms Memoria: 0.000 MB / 9.71 MB Application: Before Access::getAssetRules (id:226 name:com_tz_portfolio_plus)

Hora: 0.44 ms / 171.55 ms Memoria: 0.026 MB / 9.74 MB Application: After Access::getAssetRules (id:226 name:com_tz_portfolio_plus)

Hora: 110.09 ms / 281.64 ms Memoria: 2.338 MB / 12.08 MB Application: afterRenderComponent com_tz_portfolio_plus

Hora: 0.51 ms / 282.15 ms Memoria: 0.013 MB / 12.09 MB Application: afterDispatch

Hora: 355.57 ms / 637.72 ms Memoria: 0.920 MB / 13.01 MB Application: Before Access::getAssetRules (id:16 name:com_menus)

Hora: 0.08 ms / 637.80 ms Memoria: 0.007 MB / 13.02 MB Application: After Access::getAssetRules (id:16 name:com_menus)

Hora: 0.13 ms / 637.93 ms Memoria: 0.003 MB / 13.02 MB Application: beforeRenderModule mod_custom (copyright)

Hora: 1.33 ms / 639.26 ms Memoria: 0.044 MB / 13.06 MB Application: afterRenderModule mod_custom (copyright)

Hora: 0.09 ms / 639.35 ms Memoria: 0.000 MB / 13.06 MB Application: beforeRenderModule mod_menu (Nuestro Menu)

Hora: 2.09 ms / 641.44 ms Memoria: 0.040 MB / 13.10 MB Application: afterRenderModule mod_menu (Nuestro Menu)

Hora: 0.03 ms / 641.47 ms Memoria: 0.000 MB / 13.10 MB Application: beforeRenderModule mod_menu (Menu2)

Hora: 0.81 ms / 642.28 ms Memoria: 0.032 MB / 13.13 MB Application: afterRenderModule mod_menu (Menu2)

Hora: 0.06 ms / 642.34 ms Memoria: 0.000 MB / 13.13 MB Application: beforeRenderModule mod_custom (Bottom 1)

Hora: 0.20 ms / 642.54 ms Memoria: 0.003 MB / 13.13 MB Application: afterRenderModule mod_custom (Bottom 1)

Hora: 0.05 ms / 642.59 ms Memoria: 0.000 MB / 13.13 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Hora: 1.33 ms / 643.92 ms Memoria: 0.043 MB / 13.17 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Hora: 0.08 ms / 643.99 ms Memoria: 0.000 MB / 13.17 MB Application: beforeRenderModule mod_custom (email)

Hora: 0.43 ms / 644.42 ms Memoria: 0.003 MB / 13.17 MB Application: afterRenderModule mod_custom (email)

Hora: 2.45 ms / 646.88 ms Memoria: 0.233 MB / 13.41 MB Application: afterRender

Total de consultas de base de datos: 125.45 ms

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `data` FROM `#__session` WHERE `session_id` = '08f0d89b8f349bc8aef24ff' at line 1

Status	Duration
starting	0.14 ms
Executing hook on transaction	0.02 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.91 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

#	Caller	Número de archivo y de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Igual que la llamada en 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

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `session_id` FROM `#__session` WHERE `session_id` = '08f0d89b8f349bc8a' at line 1

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

No es posible hacer EXPLAIN en la consulta: INSERT INTO `pzjpk_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('08f0d89b8f349bc8aef24ff535fc973b', 1, 1780980715, 0, '', 0)

Perfil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
update	0.12 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	7.81 ms
closing tables	0.04 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	Número de archivo y 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

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 2.33 ms Después de la última consulta: 2.68 ms Memoria de consulta: 0.030 MB memoria antes de consulta: 3.909 MB Filas entregadas por la consulta: 40

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

  FROM `pzjpk_extensions`

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

Explicar

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `pzj' at line 1

Perfil

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	1.33 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.28 ms
end	0.02 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Igual que la llamada en la línea de abajo.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 2.51 ms Después de la última consulta: 2.17 ms Memoria de consulta: 0.023 MB memoria antes de consulta: 4.109 MB Filas entregadas por la consulta: 5

SELECT id, rules

  FROM `pzjpk_viewlevels`

Explicar

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id, rules FROM `#__viewlevels`' at line 1

Perfil

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.73 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.03 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 1.49 ms Después de la última consulta: 0.09 ms Memoria de consulta: 0.022 MB memoria antes de consulta: 4.121 MB Filas entregadas por la consulta: 2

SELECT b.id

  FROM pzjpk_usergroups AS a

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

  WHERE a.id = 9

Explicar

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT b.id FROM #__usergroups AS a LEFT JOIN #__usergroups AS b ON b.lft ' at line 1

Perfil

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.02 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.70 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

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

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.91 ms Después de la última consulta: 0.61 ms Memoria de consulta: 0.034 MB memoria antes de consulta: 4.187 MB Filas entregadas por la consulta: 99

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

  FROM pzjpk_extensions

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

  ORDER BY ordering

Explicar

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id' at line 1

Perfil

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.50 ms
end	0.03 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Igual que la llamada en la línea de abajo.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 2.16 ms Después de la última consulta: 27.18 ms Memoria de consulta: 0.054 MB memoria antes de consulta: 6.864 MB Filas entregadas por la consulta: 20

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

  FROM pzjpk_menu AS m

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

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

  ORDER BY m.lft

Explicar

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.ty' at line 1

Perfil

Status	Duration
starting	0.18 ms
Executing hook on transaction	0.02 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	1.23 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.04 ms
executing	0.30 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.03 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Igual que la llamada en la línea de abajo.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 6.28 ms Después de la última consulta: 32.47 ms Memoria de consulta: 0.036 MB memoria antes de consulta: 7.660 MB Filas entregadas por la consulta: 1

SELECT *

  FROM pzjpk_tz_portfolio_plus_categories

  WHERE alias='tuberia-con-costura-y-sin-costura' 
  AND extension='com_tz_portfolio_plus'

Explicar

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM #__tz_portfolio_plus_categories WHERE alias='tuberia-con-costur' at line 1

Perfil

Status	Duration
starting	0.15 ms
Executing hook on transaction	0.02 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	1.75 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.03 ms
executing	0.05 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.14 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	Número de archivo y de línea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
12	JDatabaseDriver->loadObject()	JROOT/components/com_tz_portfolio_plus/router.php:951
11	TZ_Portfolio_PlusRouter->getCategoryByAlias()	JROOT/components/com_tz_portfolio_plus/router.php:1160
10	TZ_Portfolio_PlusRouter->sefParse()	JROOT/components/com_tz_portfolio_plus/router.php:131
9	TZ_Portfolio_PlusRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
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

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 1.28 ms Después de la última consulta: 1.63 ms Memoria de consulta: 0.026 MB memoria antes de consulta: 7.736 MB Filas entregadas por la consulta: 9

SELECT id, folder AS type, element AS name, params, manifest_cache, asset_id

  FROM pzjpk_tz_portfolio_plus_extensions

  WHERE type ='tz_portfolio_plus-plugin' 
  AND access IN(1,1,5) 
  AND published = 1

  ORDER BY ordering

Explicar

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id, folder AS type, element AS name, params, manifest_cache, asset_id FRO' at line 1

Perfil

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.79 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.03 ms
executing	0.11 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/plugin/helper.php:280
11	TZ_Portfolio_PlusPluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:175
10	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/plugin/helpers/legacy.php:92
9	TZ_Portfolio_PlusPluginHelperLegacy::importPlugin()	JROOT/plugins/system/tz_portfolio_plus/tz_portfolio_plus.php:48
8	PlgSystemTZ_Portfolio_Plus->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

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.80 ms Después de la última consulta: 5.67 ms Memoria de consulta: 0.025 MB memoria antes de consulta: 8.150 MB Filas entregadas por la consulta: 1

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

  FROM `pzjpk_extensions`

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

Explicar

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `pzj' at line 1

Perfil

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.03 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.04 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Igual que la llamada en la línea de abajo.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1119
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 8.01 ms Después de la última consulta: 0.20 ms Memoria de consulta: 0.005 MB memoria antes de consulta: 8.140 MB

UPDATE `pzjpk_extensions`

  SET `params` = '{\"mediaversion\":\"2a88ae15cf4c1d1f2d0e6a8ebe147e7a\"}'

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

Explicar

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE `#__extensions` SET `params` = '{\"mediaversion\":\"2a88ae15cf4c1d1f2d' at line 1

Perfil

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.06 ms
updating	0.11 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	2.93 ms
closing tables	0.05 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1119
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 1.21 ms Después de la última consulta: 1.81 ms Memoria de consulta: 0.025 MB memoria antes de consulta: 8.385 MB Filas entregadas por la consulta: 2

SELECT *

  FROM pzjpk_languages

  WHERE published=1

  ORDER BY ordering ASC

Explicar

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM #__languages WHERE published=1 ORDER BY ordering ASC' at line 1

Perfil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.03 ms
Opening tables	0.85 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.05 ms
end	0.01 ms
query end	0.03 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	Número de archivo y de línea
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 1.16 ms Después de la última consulta: 0.30 ms Memoria de consulta: 0.022 MB memoria antes de consulta: 8.398 MB Filas entregadas por la consulta: 5

SELECT id, home, template, s.params

  FROM pzjpk_template_styles as s

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

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

Explicar

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id, home, template, s.params FROM #__template_styles as s LEFT JOIN pz' at line 1

Perfil

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.75 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.09 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 2.37 ms Después de la última consulta: 12.15 ms Memoria de consulta: 0.029 MB memoria antes de consulta: 9.394 MB Filas entregadas por la consulta: 8

SHOW FULL COLUMNS 
  FROM `pzjpk_tz_portfolio_plus_templates`

Explicar

No es posible hacer EXPLAIN en la consulta: SHOW FULL COLUMNS FROM `pzjpk_tz_portfolio_plus_templates`

Perfil

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.51 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.86 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.16 ms
preparing	0.05 ms
Creating tmp table	0.05 ms
executing	0.07 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.05 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.04 ms
end	0.03 ms
query end	0.01 ms
waiting for handler commit	0.03 ms
closing tables	0.04 ms
freeing items	0.08 ms
cleaning up	0.02 ms

Call Stack

#	Caller	Número de archivo y de línea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
15	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
14	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_tz_portfolio_plus/tables/templates.php:26
13	TZ_Portfolio_PlusTableTemplates->__construct()	JROOT/libraries/src/Table/Table.php:312
12	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/template.php:47
11	TZ_Portfolio_PlusTemplate::getTemplate()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:54
10	TZ_Portfolio_PlusControllerLegacy->getView()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:40
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:167
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:46
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.91 ms Después de la última consulta: 0.45 ms Memoria de consulta: 0.023 MB memoria antes de consulta: 9.436 MB Filas entregadas por la consulta: 1

SELECT COUNT(t.id)

  FROM pzjpk_tz_portfolio_plus_templates AS t

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

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

  GROUP BY t.id

Explicar

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT COUNT(t.id) FROM #__tz_portfolio_plus_templates AS t INNER JOIN #__' at line 1

Perfil

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.02 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.42 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.03 ms
executing	0.03 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.05 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/template.php:65
11	TZ_Portfolio_PlusTemplate::getTemplate()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:54
10	TZ_Portfolio_PlusControllerLegacy->getView()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:40
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:167
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:46
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.27 ms Después de la última consulta: 0.07 ms Memoria de consulta: 0.027 MB memoria antes de consulta: 9.446 MB Filas entregadas por la consulta: 1

SELECT *

  FROM pzjpk_tz_portfolio_plus_templates

  WHERE `home`= 1

Explicar

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM #__tz_portfolio_plus_templates WHERE `home`= 1' at line 1

Perfil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.03 ms
executing	0.03 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
13	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_tz_portfolio_plus/tables/templates.php:64
12	TZ_Portfolio_PlusTableTemplates->getHome()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/template.php:69
11	TZ_Portfolio_PlusTemplate::getTemplate()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:54
10	TZ_Portfolio_PlusControllerLegacy->getView()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:40
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:167
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:46
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.30 ms Después de la última consulta: 0.12 ms Memoria de consulta: 0.026 MB memoria antes de consulta: 9.457 MB Filas entregadas por la consulta: 1

SELECT *

  FROM pzjpk_tz_portfolio_plus_templates

  WHERE `id` = '3'

Explicar

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM #__tz_portfolio_plus_templates WHERE `id` = '3'' at line 1

Perfil

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
12	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/template.php:76
11	TZ_Portfolio_PlusTemplate::getTemplate()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:54
10	TZ_Portfolio_PlusControllerLegacy->getView()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:40
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:167
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:46
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 2.06 ms Después de la última consulta: 2.59 ms Memoria de consulta: 0.031 MB memoria antes de consulta: 9.660 MB Filas entregadas por la consulta: 40

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

  FROM `pzjpk_assets`

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

Explicar

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `id`,`name`,`rules`,`parent_id` FROM `#__assets` WHERE `name` IN ('roo' at line 1

Perfil

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	1.12 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.13 ms
preparing	0.03 ms
executing	0.47 ms
end	0.02 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.04 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	Número de archivo y de línea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/components/com_tz_portfolio_plus/models/portfolio.php:72
14	TZ_Portfolio_PlusModelPortfolio->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tz_portfolio_plus/views/portfolio/view.html.php:66
11	TZ_Portfolio_PlusViewPortfolio->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:42
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:167
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:46
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 4.93 ms Después de la última consulta: 0.97 ms Memoria de consulta: 0.040 MB memoria antes de consulta: 9.757 MB Filas entregadas por la consulta: 1

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

  FROM `pzjpk_tz_portfolio_plus_content` AS c

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

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

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

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

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

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

  WHERE c.state = 1 
  AND (c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2026-06-09 04:51:55') 
  AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2026-06-09 04:51:55') 
  AND c.access IN (1,1,5) 
  AND cc.access IN (1,1,5) 
  AND m.catid IN(5)

  GROUP BY c.id

  ORDER BY   c.created  DESC   
  LIMIT 12

Explicar

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT c.*, m.catid AS catid ,cc.title AS category_title,CASE WHEN CHAR_LENGTH(c' at line 1

Perfil

Status	Duration
starting	0.13 ms
Executing hook on transaction	0.01 ms
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	3.73 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.03 ms
Creating tmp table	0.15 ms
executing	0.25 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.21 ms
freeing items	0.06 ms
cleaning up	0.02 ms

Call Stack

#	Caller	Número de archivo y de línea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
14	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_tz_portfolio_plus/models/portfolio.php:258
13	TZ_Portfolio_PlusModelPortfolio->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tz_portfolio_plus/views/portfolio/view.html.php:157
11	TZ_Portfolio_PlusViewPortfolio->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:42
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:167
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:46
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.51 ms Después de la última consulta: 0.20 ms Memoria de consulta: 0.037 MB memoria antes de consulta: 9.785 MB Filas entregadas por la consulta: 1

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

  FROM pzjpk_tz_portfolio_plus_categories AS c

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

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

  WHERE extension = 'com_tz_portfolio_plus' 
  AND cc.id IN(22) 
  AND m.main = 1

Explicar

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT c.*, m.contentid AS contentid,m.main FROM #__tz_portfolio_plus_categor' at line 1

Perfil

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.05 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	Número de archivo y de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio_plus/helpers/categories.php:165
14	TZ_Portfolio_PlusFrontHelperCategories::getCategoriesByArticleId()	JROOT/components/com_tz_portfolio_plus/models/portfolio.php:277
13	TZ_Portfolio_PlusModelPortfolio->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tz_portfolio_plus/views/portfolio/view.html.php:157
11	TZ_Portfolio_PlusViewPortfolio->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:42
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:167
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:46
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 2.09 ms Después de la última consulta: 0.49 ms Memoria de consulta: 0.039 MB memoria antes de consulta: 9.818 MB Filas entregadas por la consulta: 2

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

  FROM pzjpk_tz_portfolio_plus_categories as c

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

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

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

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

  ORDER BY c.lft

Explicar

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT c.id, c.asset_id, c.access, c.images, c.alias, c.checked_out, c.checked_o' at line 1

Perfil

Status	Duration
starting	0.15 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.23 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
Creating tmp table	0.03 ms
statistics	0.13 ms
preparing	0.04 ms
Creating tmp table	0.11 ms
executing	0.15 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.04 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio_plus/helpers/category.php:123
17	TZ_Portfolio_PlusCategories->_load()	JROOT/libraries/src/Categories/Categories.php:184
16	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_tz_portfolio_plus/helpers/route.php:89
15	TZ_Portfolio_PlusHelperRoute::getCategoryRoute()	JROOT/components/com_tz_portfolio_plus/helpers/categories.php:170
14	TZ_Portfolio_PlusFrontHelperCategories::getCategoriesByArticleId()	JROOT/components/com_tz_portfolio_plus/models/portfolio.php:277
13	TZ_Portfolio_PlusModelPortfolio->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tz_portfolio_plus/views/portfolio/view.html.php:157
11	TZ_Portfolio_PlusViewPortfolio->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:42
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:167
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:46
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.29 ms Después de la última consulta: 0.55 ms Memoria de consulta: 0.026 MB memoria antes de consulta: 9.864 MB Filas entregadas por la consulta: 5

SELECT id

  FROM pzjpk_tz_portfolio_plus_categories

  WHERE extension = 'com_tz_portfolio_plus' 
  AND published = 1

Explicar

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id FROM #__tz_portfolio_plus_categories WHERE extension = 'com_tz_port' at line 1

Perfil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.03 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.03 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
18	JDatabaseDriver->loadColumn()	JROOT/components/com_tz_portfolio_plus/helpers/route.php:632
17	TZ_Portfolio_PlusHelperRoute::getCatIds()	JROOT/components/com_tz_portfolio_plus/helpers/route.php:551
16	TZ_Portfolio_PlusHelperRoute::_findItem()	JROOT/components/com_tz_portfolio_plus/helpers/route.php:121
15	TZ_Portfolio_PlusHelperRoute::getCategoryRoute()	JROOT/components/com_tz_portfolio_plus/helpers/categories.php:170
14	TZ_Portfolio_PlusFrontHelperCategories::getCategoriesByArticleId()	JROOT/components/com_tz_portfolio_plus/models/portfolio.php:277
13	TZ_Portfolio_PlusModelPortfolio->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tz_portfolio_plus/views/portfolio/view.html.php:157
11	TZ_Portfolio_PlusViewPortfolio->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:42
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:167
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:46
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.36 ms Después de la última consulta: 0.30 ms Memoria de consulta: 0.036 MB memoria antes de consulta: 9.873 MB Filas entregadas por la consulta: 0

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

  FROM pzjpk_tz_portfolio_plus_categories AS c

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

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

  WHERE extension = 'com_tz_portfolio_plus' 
  AND cc.id IN(22) 
  AND m.main = 0

Explicar

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT c.*, m.contentid AS contentid,m.main FROM #__tz_portfolio_plus_categor' at line 1

Perfil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.03 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio_plus/helpers/categories.php:165
14	TZ_Portfolio_PlusFrontHelperCategories::getCategoriesByArticleId()	JROOT/components/com_tz_portfolio_plus/models/portfolio.php:279
13	TZ_Portfolio_PlusModelPortfolio->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tz_portfolio_plus/views/portfolio/view.html.php:157
11	TZ_Portfolio_PlusViewPortfolio->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:42
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:167
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:46
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.35 ms Después de la última consulta: 0.08 ms Memoria de consulta: 0.027 MB memoria antes de consulta: 9.881 MB Filas entregadas por la consulta: 0

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

  FROM pzjpk_tz_portfolio_plus_tags AS t

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

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

  WHERE t.published = 1 
  AND c.id IN(22)

  ORDER BY m.contentid

Explicar

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT t.*, c.id AS contentid,CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(":",' at line 1

Perfil

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio_plus/helpers/tags.php:207
14	TZ_Portfolio_PlusFrontHelperTags::getTagsByArticleId()	JROOT/components/com_tz_portfolio_plus/models/portfolio.php:284
13	TZ_Portfolio_PlusModelPortfolio->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tz_portfolio_plus/views/portfolio/view.html.php:157
11	TZ_Portfolio_PlusViewPortfolio->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:42
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:167
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:46
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 1.80 ms Después de la última consulta: 5.13 ms Memoria de consulta: 0.038 MB memoria antes de consulta: 10.382 MB Filas entregadas por la consulta: 16

SHOW FULL COLUMNS 
  FROM `pzjpk_users`

Explicar

No es posible hacer EXPLAIN en la consulta: SHOW FULL COLUMNS FROM `pzjpk_users`

Perfil

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.79 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.03 ms
Creating tmp table	0.04 ms
executing	0.08 ms
checking permissions	0.07 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.05 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.05 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	Número de archivo y de línea
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
33	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
32	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
31	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
30	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:40
29	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:312
28	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
27	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:880
26	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
25	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
24	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
23	Joomla\CMS\Factory::getUser()	JROOT/components/com_tz_portfolio_plus/router.php:906
22	TZ_Portfolio_PlusRouter->_getUserSegment()	JROOT/components/com_tz_portfolio_plus/router.php:226
21	TZ_Portfolio_PlusRouter->sefBuild()	JROOT/components/com_tz_portfolio_plus/router.php:69
20	TZ_Portfolio_PlusRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:528
19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
14	Joomla\CMS\Router\Route::_()	JROOT/components/com_tz_portfolio_plus/models/portfolio.php:382
13	TZ_Portfolio_PlusModelPortfolio->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tz_portfolio_plus/views/portfolio/view.html.php:157
11	TZ_Portfolio_PlusViewPortfolio->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:42
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:167
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:46
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.26 ms Después de la última consulta: 0.16 ms Memoria de consulta: 0.034 MB memoria antes de consulta: 10.427 MB Filas entregadas por la consulta: 1

SELECT *

  FROM `pzjpk_users`

  WHERE `id` = 218

Explicar

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM `#__users` WHERE `id` = 218' at line 1

Perfil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
28	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:86
27	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:883
26	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
25	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
24	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
23	Joomla\CMS\Factory::getUser()	JROOT/components/com_tz_portfolio_plus/router.php:906
22	TZ_Portfolio_PlusRouter->_getUserSegment()	JROOT/components/com_tz_portfolio_plus/router.php:226
21	TZ_Portfolio_PlusRouter->sefBuild()	JROOT/components/com_tz_portfolio_plus/router.php:69
20	TZ_Portfolio_PlusRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:528
19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
14	Joomla\CMS\Router\Route::_()	JROOT/components/com_tz_portfolio_plus/models/portfolio.php:382
13	TZ_Portfolio_PlusModelPortfolio->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tz_portfolio_plus/views/portfolio/view.html.php:157
11	TZ_Portfolio_PlusViewPortfolio->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:42
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:167
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:46
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 1.16 ms Después de la última consulta: 3.17 ms Memoria de consulta: 0.030 MB memoria antes de consulta: 11.179 MB Filas entregadas por la consulta: 1

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

  FROM `pzjpk_usergroups` AS g

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

  WHERE `m`.`user_id` = 218

Explicar

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `g`.`id`,`g`.`title` FROM `#__usergroups` AS g INNER JOIN `#__user_' at line 1

Perfil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.82 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.03 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.03 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
28	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:111
27	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:883
26	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
25	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
24	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
23	Joomla\CMS\Factory::getUser()	JROOT/components/com_tz_portfolio_plus/router.php:906
22	TZ_Portfolio_PlusRouter->_getUserSegment()	JROOT/components/com_tz_portfolio_plus/router.php:226
21	TZ_Portfolio_PlusRouter->sefBuild()	JROOT/components/com_tz_portfolio_plus/router.php:69
20	TZ_Portfolio_PlusRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:528
19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
14	Joomla\CMS\Router\Route::_()	JROOT/components/com_tz_portfolio_plus/models/portfolio.php:382
13	TZ_Portfolio_PlusModelPortfolio->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tz_portfolio_plus/views/portfolio/view.html.php:157
11	TZ_Portfolio_PlusViewPortfolio->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:42
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:167
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:46
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 2.97 ms Después de la última consulta: 4.49 ms Memoria de consulta: 0.039 MB memoria antes de consulta: 11.483 MB Filas entregadas por la consulta: 0

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

  FROM pzjpk_fields AS a

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

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

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

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

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

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

  WHERE a.context = 'com_tz_portfolio_plus.portfolio' 
  AND (fc.category_id IS NULL OR fc.category_id IN (5,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

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state' at line 1

Perfil

Status	Duration
starting	0.12 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	2.30 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.05 ms
executing	0.04 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.07 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	Número de archivo y de línea
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:488
17	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
14	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_tz_portfolio_plus/models/portfolio.php:428
13	TZ_Portfolio_PlusModelPortfolio->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tz_portfolio_plus/views/portfolio/view.html.php:157
11	TZ_Portfolio_PlusViewPortfolio->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:42
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:167
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:46
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 1.44 ms Después de la última consulta: 3.29 ms Memoria de consulta: 0.030 MB memoria antes de consulta: 11.727 MB Filas entregadas por la consulta: 0

SELECT *

  FROM pzjpk_tz_portfolio_plus_content_rating

  WHERE content_id = 22

Explicar

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM #__tz_portfolio_plus_content_rating WHERE content_id = 22' at line 1

Perfil

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	1.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	Número de archivo y de línea
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
25	JDatabaseDriver->loadObject()	JROOT/components/com_tz_portfolio_plus/addons/content/vote/helpers/vote.php:50
24	TZ_Portfolio_PlusAddOnContentVoteHelper::getVoteByArticleId()	JROOT/components/com_tz_portfolio_plus/addons/content/vote/models/portfolio.php:32
23	PlgTZ_Portfolio_PlusContentVoteModelPortfolio->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
22	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tz_portfolio_plus/addons/content/vote/views/portfolio/view.html.php:34
21	PlgTZ_Portfolio_PlusContentVoteViewPortfolio->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller/legacy.php:196
20	TZ_Portfolio_Plus_AddOnControllerLegacy->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller/legacy.php:288
19	TZ_Portfolio_Plus_AddOnControllerLegacy->execute()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/plugin/plugin.php:554
18	TZ_Portfolio_PlusPlugin->_getViewHtml()	JROOT/components/com_tz_portfolio_plus/addons/content/vote/vote.php:167
17	PlgTZ_Portfolio_PlusContentVote->onBeforeDisplayAdditionInfo()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
14	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_tz_portfolio_plus/models/portfolio.php:465
13	TZ_Portfolio_PlusModelPortfolio->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tz_portfolio_plus/views/portfolio/view.html.php:157
11	TZ_Portfolio_PlusViewPortfolio->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:42
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:167
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:46
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 14.98 ms Después de la última consulta: 17.30 ms Memoria de consulta: 0.030 MB memoria antes de consulta: 11.823 MB Filas entregadas por la consulta: 0

SELECT *

  FROM pzjpk_tz_portfolio_plus_fieldgroups

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

  FROM pzjpk_tz_portfolio_plus_content AS c

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

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

  WHERE c.id = 22

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

Explicar

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM #__tz_portfolio_plus_fieldgroups WHERE id IN( SELECT CASE WHEN ' at line 1

Perfil

Status	Duration
starting	0.15 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	1.57 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.05 ms
executing	0.05 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.10 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	Número de archivo y de línea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio_plus/helpers/extrafields.php:210
16	TZ_Portfolio_PlusFrontHelperExtraFields::getFieldGroupsByArticleId()	JROOT/components/com_tz_portfolio_plus/helpers/extrafields.php:409
15	TZ_Portfolio_PlusFrontHelperExtraFields::getExtraFieldsByArticle()	JROOT/components/com_tz_portfolio_plus/helpers/extrafields.php:132
14	TZ_Portfolio_PlusFrontHelperExtraFields::getExtraFields()	JROOT/components/com_tz_portfolio_plus/models/portfolio.php:511
13	TZ_Portfolio_PlusModelPortfolio->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tz_portfolio_plus/views/portfolio/view.html.php:157
11	TZ_Portfolio_PlusViewPortfolio->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:42
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:167
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:46
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 10.76 ms Después de la última consulta: 0.20 ms Memoria de consulta: 0.032 MB memoria antes de consulta: 11.834 MB Filas entregadas por la consulta: 0

SELECT f.*, fm.groupid

  FROM pzjpk_tz_portfolio_plus_fields AS f

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

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

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

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

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

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

  FROM pzjpk_tz_portfolio_plus_fieldgroups AS subg

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

  GROUP BY f.id

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

Explicar

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT f.*, fm.groupid FROM #__tz_portfolio_plus_fields AS f INNER JOIN pzjpk' at line 1

Perfil

Status	Duration
starting	0.16 ms
Executing hook on transaction	0.01 ms
starting	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	3.57 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.15 ms
preparing	0.04 ms
Creating tmp table	0.20 ms
executing	0.12 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.13 ms
freeing items	0.05 ms
cleaning up	0.04 ms

Call Stack

#	Caller	Número de archivo y de línea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio_plus/helpers/extrafields.php:512
15	TZ_Portfolio_PlusFrontHelperExtraFields::getExtraFieldsByArticle()	JROOT/components/com_tz_portfolio_plus/helpers/extrafields.php:132
14	TZ_Portfolio_PlusFrontHelperExtraFields::getExtraFields()	JROOT/components/com_tz_portfolio_plus/models/portfolio.php:511
13	TZ_Portfolio_PlusModelPortfolio->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tz_portfolio_plus/views/portfolio/view.html.php:157
11	TZ_Portfolio_PlusViewPortfolio->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:42
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:167
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:46
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 5.91 ms Después de la última consulta: 0.16 ms Memoria de consulta: 0.027 MB memoria antes de consulta: 11.815 MB Filas entregadas por la consulta: 0

SELECT t.*

  FROM pzjpk_tz_portfolio_plus_tags AS t

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

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

  WHERE t.published = 1

  GROUP BY t.id

Explicar

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT t.* FROM #__tz_portfolio_plus_tags AS t INNER JOIN #__tz_portfolio_' at line 1

Perfil

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
Creating tmp table	0.03 ms
executing	0.03 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.03 ms

Call Stack

#	Caller	Número de archivo y de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio_plus/helpers/tags.php:161
14	TZ_Portfolio_PlusFrontHelperTags::getTagsByCategoryId()	JROOT/components/com_tz_portfolio_plus/models/portfolio.php:680
13	TZ_Portfolio_PlusModelPortfolio->getAllTags()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tz_portfolio_plus/views/portfolio/view.html.php:161
11	TZ_Portfolio_PlusViewPortfolio->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:42
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:167
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:46
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.95 ms Después de la última consulta: 0.24 ms Memoria de consulta: 0.038 MB memoria antes de consulta: 11.824 MB Filas entregadas por la consulta: 4

SELECT c.*

  FROM pzjpk_tz_portfolio_plus_categories AS c

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

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

  WHERE c.published = 1 
  AND extension = 'com_tz_portfolio_plus' 
  AND m.main = 0 OR m.main = 1

  GROUP BY id

Explicar

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT c.* FROM #__tz_portfolio_plus_categories AS c INNER JOIN #__tz_port' at line 1

Perfil

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.06 ms
statistics	0.06 ms
preparing	0.03 ms
Creating tmp table	0.05 ms
executing	0.32 ms
end	0.02 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio_plus/helpers/categories.php:365
14	TZ_Portfolio_PlusFrontHelperCategories::getAllCategories()	JROOT/components/com_tz_portfolio_plus/models/portfolio.php:662
13	TZ_Portfolio_PlusModelPortfolio->getAllCategories()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tz_portfolio_plus/views/portfolio/view.html.php:164
11	TZ_Portfolio_PlusViewPortfolio->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:42
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:167
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:46
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 21.02 ms Después de la última consulta: 1.75 ms Memoria de consulta: 0.039 MB memoria antes de consulta: 12.009 MB Filas entregadas por la consulta: 1

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

  FROM `pzjpk_tz_portfolio_plus_content` AS c

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

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

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

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

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

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

  WHERE c.state = 1 
  AND (c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2026-06-09 04:51:55') 
  AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2026-06-09 04:51:55') 
  AND c.access IN (1,1,5) 
  AND cc.access IN (1,1,5) 
  AND m.catid IN(5)

  GROUP BY c.id

  ORDER BY   c.created  DESC

Explicar

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT c.*, m.catid AS catid ,cc.title AS category_title,CASE WHEN CHAR_LENGTH(c' at line 1

Perfil

Status	Duration
starting	0.19 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.12 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.16 ms
preparing	0.04 ms
Creating tmp table	0.14 ms
executing	0.19 ms
end	0.03 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.04 ms

Call Stack

#	Caller	Número de archivo y de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:353
15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
14	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
13	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tz_portfolio_plus/views/portfolio/view.html.php:189
11	TZ_Portfolio_PlusViewPortfolio->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_tz_portfolio_plus/libraries/controller.php:42
9	TZ_Portfolio_PlusControllerLegacy->display()	JROOT/components/com_tz_portfolio_plus/controller.php:167
8	TZ_Portfolio_PlusController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php:46
6	require_once JROOT/components/com_tz_portfolio_plus/tz_portfolio_plus.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 10.87 ms Después de la última consulta: 30.11 ms Memoria de consulta: 0.029 MB memoria antes de consulta: 13.654 MB Filas entregadas por la consulta: 7

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

  FROM pzjpk_modules AS m

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

  LEFT JOIN pzjpk_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-06-09 04:51:55') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-06-09 04:51:55') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 261 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explicar

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm' at line 1

Perfil

Status	Duration
starting	0.17 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	2.45 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.13 ms
preparing	0.07 ms
executing	0.45 ms
end	0.02 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.07 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	Número de archivo y de línea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	Igual que la llamada en la línea de abajo.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
14	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
13	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
12	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/astroid/framework/elements/module_position/module_position.php:12
11	include JROOT/libraries/astroid/framework/elements/module_position/module_position.php	JROOT/libraries/src/Layout/FileLayout.php:125
10	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/astroid/framework/element.php:187
9	AstroidElement->render()	JROOT/libraries/astroid/framework/template.php:159
8	AstroidFrameworkTemplate->renderLayout()	JROOT/templates/jd_paris/index.php:96
7	require JROOT/templates/jd_paris/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
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

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

32 tipos de consulta reportadas, ordenados por ocurrencias.

SELECT Tables:

2 × SELECT c.*, m.catid AS catid ,cc.title AS category_title,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug,
  CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug,
  CASE WHEN CHAR_LENGTH(c.fulltext) THEN c.fulltext ELSE null END as readmore,t.title AS tagName, u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias 
  FROM `pzjpk_tz_portfolio_plus_content` AS c 
  INNER JOIN `pzjpk_tz_portfolio_plus_content_category_map` AS m 
  ON m.contentid=c.id 
  LEFT JOIN `pzjpk_tz_portfolio_plus_categories` AS cc 
  ON cc.id=m.catid 
  LEFT JOIN `pzjpk_tz_portfolio_plus_tag_content_map` AS x 
  ON x.contentid=c.id 
  LEFT JOIN `pzjpk_tz_portfolio_plus_tags` AS t 
  ON t.id=x.tagsid 
  LEFT JOIN `pzjpk_users` AS u 
  ON u.id=c.created_by 
  LEFT JOIN pzjpk_tz_portfolio_plus_categories as parent 
  ON parent.id = cc.parent_id

2 × SELECT c.*, m.contentid AS contentid,m.main 
  FROM pzjpk_tz_portfolio_plus_categories AS c 
  INNER JOIN pzjpk_tz_portfolio_plus_content_category_map AS m 
  ON m.catid = c.id 
  INNER JOIN pzjpk_tz_portfolio_plus_content AS cc 
  ON cc.id = m.contentid

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

2 × SELECT * 
  FROM pzjpk_tz_portfolio_plus_templates

1 × SELECT c.* 
  FROM pzjpk_tz_portfolio_plus_categories AS c 
  INNER JOIN pzjpk_tz_portfolio_plus_content_category_map AS m 
  ON m.catid = c.id 
  INNER JOIN pzjpk_tz_portfolio_plus_content AS cc 
  ON cc.id = m.contentid

1 × SELECT t.* 
  FROM pzjpk_tz_portfolio_plus_tags AS t 
  INNER JOIN pzjpk_tz_portfolio_plus_tag_content_map AS m 
  ON m.tagsid = t.id 
  INNER JOIN pzjpk_tz_portfolio_plus_content AS c 
  ON c.id = m.contentid

1 × SELECT f.*, fm.groupid 
  FROM pzjpk_tz_portfolio_plus_fields AS f 
  INNER JOIN pzjpk_tz_portfolio_plus_field_content_map AS m 
  ON m.fieldsid = f.id 
  INNER JOIN pzjpk_tz_portfolio_plus_content AS c 
  ON c.id = m.contentid 
  INNER JOIN pzjpk_tz_portfolio_plus_field_fieldgroup_map AS fm 
  ON fm.fieldsid = f.id 
  INNER JOIN pzjpk_tz_portfolio_plus_fieldgroups AS fg 
  ON fg.id = fm.groupid 
  INNER JOIN pzjpk_tz_portfolio_plus_extensions AS e 
  ON e.element = f.type

1 × SELECT * 
  FROM pzjpk_tz_portfolio_plus_fieldgroups

1 × SELECT * 
  FROM pzjpk_tz_portfolio_plus_content_rating

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

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

```
1 × SELECT * 
  FROM `pzjpk_users`
```

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

1 × SELECT id 
  FROM pzjpk_tz_portfolio_plus_categories

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

1 × SELECT `data` 
  FROM `pzjpk_session`

1 × SELECT `session_id` 
  FROM `pzjpk_session`

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

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

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

```
1 × SELECT * 
  FROM pzjpk_languages
```

1 × SELECT id, folder AS type, element AS name, params, manifest_cache, asset_id 
  FROM pzjpk_tz_portfolio_plus_extensions

1 × SELECT * 
  FROM pzjpk_tz_portfolio_plus_categories

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

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

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

1 × SELECT id, rules 
  FROM `pzjpk_viewlevels

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

Otras tablas:

1 × INSERT INTO `pzjpk_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('08f0d89b8f349bc8aef24ff535fc973b', 1, 1780980715, 0, '', 0

1 × UPDATE `pzjpk_extensions` 
  SET `params` = '{\"mediaversion\":\"2a88ae15cf4c1d1f2d0e6a8ebe147e7a\"}'

1 × SHOW FULL COLUMNS 
  FROM `pzjpk_tz_portfolio_plus_templates

1 × SHOW FULL COLUMNS 
  FROM `pzjpk_users

Galería

Tubería

Tubería

Nuestro Menu

Consola de depuración de Joomla!

Sesión

Información de perfil

Hora

Memoria

Uso de la memoria

Consultas de base de datos

36 consultas reportadas 125.45 ms

32 tipos de consulta reportadas, ordenados por ocurrencias.

SELECT Tables:

Otras tablas: