El miércoles 27 de junio, se reunieron en nuestra sede de Arellano 286, Fernando Savore y Juan Carlos Menchikian, Presidente y Secretario de FABA (Federación de Entidades de Autoservicistas, Almaceneros, Supermercadistas y Polirrubros de Buenos Aires) junto a la Agrupación CCPI (Almaceneros de San A. de Areco) y Miembros de Comisión Directiva, con el fin de vincular dicha Agrupación local con las grandes cadenas mayoristas de la provincia de Bs. As., para lograr mejores precios y poder trasladarlos a las góndolas.

En el día de ayer se realizó la entrega de Premios de la campaña "De Taquito al Mundial", promo que arrancó el 6 de abril y culminó el pasado martes con el gran sorteo de 3 Smart Tv, 6 Pelotas de fútbol y 6 Camisetas de la selección Argentina.

En esta Promo participaron mas de 60 comercios de nuestra localidad, los cuales hicieron entrega de mas de 15.000 cupones a sus clientes.

Felicitaciones a los ganadores!!!

Gracias a todos por participar de esta exitosa Promo!

entrega1

Ayer 12 de junio, se realizó en nuestra sede el Sorteo de la Promo "De Taquito al Mundial". Estuvieron presentes certificando la realización del mismo, Miembros de Comisión Directiva del CCPI, Comerciantes que participaron de la Promo, y el Escribano Público Martín Totaro. El sorteo fue emitido por el Noticiero del canal local.

Desde el Centro del Comercio Propiedad e Industria, queremos hacerles llegar nuestros mejores deseos y un cálido saludo a todos los Periodistas en su día!!!

Página 10 de 17

Inicio
Anterior
5
6
7
8
9
10
11
12
13
14
Siguiente
Final

Desarrollo Puntovista.

Consola de depuración de Joomla!

Sesión

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

Información del perfil

Fecha y hora

Memoria

Fecha y hora: 4.39 ms / 4.39 ms Memoria: 0.850 MB / 1.06 MB Application: afterLoad

Fecha y hora: 64.98 ms / 69.37 ms Memoria: 4.167 MB / 5.23 MB Application: afterInitialise

Fecha y hora: 6.91 ms / 76.28 ms Memoria: 1.384 MB / 6.62 MB Application: afterRoute

Fecha y hora: 90.38 ms / 166.66 ms Memoria: 0.437 MB / 7.05 MB Application: beforeRenderComponent com_content

Fecha y hora: 3.11 ms / 169.76 ms Memoria: 0.673 MB / 7.73 MB Application: Before JAccess::preloadComponents (all components)

Fecha y hora: 0.28 ms / 170.04 ms Memoria: 0.080 MB / 7.81 MB Application: After JAccess::preloadComponents (all components)

Fecha y hora: 0.02 ms / 170.06 ms Memoria: 0.000 MB / 7.80 MB Application: Before JAccess::preloadPermissions (com_content)

Fecha y hora: 0.35 ms / 170.41 ms Memoria: 0.182 MB / 7.99 MB Application: After JAccess::preloadPermissions (com_content)

Fecha y hora: 0.04 ms / 170.45 ms Memoria: 0.000 MB / 7.98 MB Application: Before JAccess::getAssetRules (id:58 name:com_content.category.9)

Fecha y hora: 0.28 ms / 170.73 ms Memoria: 0.041 MB / 8.02 MB Application: After JAccess::getAssetRules (id:58 name:com_content.category.9)

Fecha y hora: 3.67 ms / 174.40 ms Memoria: 0.406 MB / 8.42 MB Application: Before JAccess::getAssetRules (id:8 name:com_content)

Fecha y hora: 0.02 ms / 174.42 ms Memoria: 0.003 MB / 8.43 MB Application: After JAccess::getAssetRules (id:8 name:com_content)

Fecha y hora: 8.65 ms / 183.07 ms Memoria: 1.385 MB / 9.81 MB Application: Before JAccess::getAssetRules (id:1 name:root.1)

Fecha y hora: 0.05 ms / 183.12 ms Memoria: 0.009 MB / 9.82 MB Application: After JAccess::getAssetRules (id:1 name:root.1)

Fecha y hora: 15.35 ms / 198.47 ms Memoria: 1.399 MB / 11.22 MB Application: afterRenderComponent com_content

Fecha y hora: 0.25 ms / 198.72 ms Memoria: 0.008 MB / 11.23 MB Application: afterDispatch

Fecha y hora: 2.25 ms / 200.96 ms Memoria: 0.377 MB / 11.61 MB Application: beforeRenderModule mod_custom (Centro del Comercio Prop. e Ind.)

Fecha y hora: 0.65 ms / 201.61 ms Memoria: 0.054 MB / 11.66 MB Application: afterRenderModule mod_custom (Centro del Comercio Prop. e Ind.)

Fecha y hora: 0.01 ms / 201.62 ms Memoria: 0.000 MB / 11.66 MB Application: beforeRenderModule mod_custom (Ubicación)

Fecha y hora: 0.15 ms / 201.78 ms Memoria: 0.007 MB / 11.66 MB Application: afterRenderModule mod_custom (Ubicación)

Fecha y hora: 0.75 ms / 202.52 ms Memoria: 0.000 MB / 11.66 MB Application: beforeRenderModule mod_custom (Capacitación)

Fecha y hora: 0.15 ms / 202.67 ms Memoria: 0.007 MB / 11.67 MB Application: afterRenderModule mod_custom (Capacitación)

Fecha y hora: 0.03 ms / 202.70 ms Memoria: 0.000 MB / 11.66 MB Application: beforeRenderModule mod_custom (Financiación)

Fecha y hora: 0.14 ms / 202.84 ms Memoria: 0.007 MB / 11.67 MB Application: afterRenderModule mod_custom (Financiación)

Fecha y hora: 0.05 ms / 202.89 ms Memoria: 0.000 MB / 11.67 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Fecha y hora: 0.62 ms / 203.51 ms Memoria: 0.032 MB / 11.70 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Fecha y hora: 0.06 ms / 203.56 ms Memoria: 0.000 MB / 11.69 MB Application: beforeRenderModule mod_menu (Main Menu)

Fecha y hora: 2.19 ms / 205.75 ms Memoria: 0.183 MB / 11.88 MB Application: afterRenderModule mod_menu (Main Menu)

Fecha y hora: 1.35 ms / 207.10 ms Memoria: 0.086 MB / 11.96 MB Application: afterRender

Total de consultas a la base de datos: 137.41 ms

Uso de la memoria

Consultas de la base de datos

23 consultas registradas 137.41 ms

Tiempo de la consulta: 44.68 ms Consulta a la memoria: 0.008 MB memoria antes de la consulta: 3.143 MB

DELETE 

  FROM `oja8d_session`

  WHERE `time` < '1716120443'

Explicar

'Explicar' no es posible en la consulta: DELETE FROM `oja8d_session` WHERE `time` < '1716120443'

Perfil

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.03 ms
updating	0.04 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.00 ms
query end	44.52 ms
closing tables	0.01 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:818
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Tiempo de la consulta: 0.13 ms Después de la última consulta: 0.24 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 3.174 MB Filas devueltas: 1

SELECT `data`

  FROM `oja8d_session`

  WHERE `session_id` = 'rd6q7grpd64qpdr2s24qpqdnl3'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	oja8d_session	const	PRIMARY	PRIMARY	766	const	1

Perfil

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.01 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
Waiting for query cache lock	0.00 ms
After table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.00 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Lo mismo que llamada de la línea de abajo.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:82
10	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:648
9	JSession->_start()	JROOT/libraries/joomla/session/session.php:608
8	JSession->start()	JROOT/libraries/joomla/session/session.php:486
7	JSession->get()	JROOT/libraries/joomla/session/session.php:443
6	JSession->isNew()	JROOT/libraries/cms/application/cms.php:825
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Tiempo de la consulta: 0.24 ms Después de la última consulta: 1.83 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 3.561 MB Filas devueltas: 35

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

  FROM `oja8d_extensions`

  WHERE `type` = 'component'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	oja8d_extensions	ref	extension	extension	82	const	35	Using index condition

Perfil

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
Waiting for query cache lock	0.00 ms
After table lock	0.02 ms
init	0.01 ms
optimizing	0.00 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.07 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/component/helper.php:452
9	JComponentHelper::{closure}()	Lo mismo que llamada de la línea de abajo.
8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:460
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:111
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:593
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.04 ms Después de la última consulta: 1.36 ms Consulta a la memoria: 0.015 MB memoria antes de la consulta: 3.848 MB Filas devueltas: 2

SELECT b.id

  FROM oja8d_usergroups AS a

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

  WHERE a.id = 9

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:978
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1047
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.04 ms Después de la última consulta: 0.36 ms Consulta a la memoria: 0.015 MB memoria antes de la consulta: 3.925 MB Filas devueltas: 5

SELECT id, rules

  FROM `oja8d_viewlevels`

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1064
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.41 ms Después de la última consulta: 0.14 ms Consulta a la memoria: 0.017 MB memoria antes de la consulta: 3.965 MB Filas devueltas: 63

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

  FROM oja8d_extensions

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

  ORDER BY ordering

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	oja8d_extensions	ref	extension	extension	82	const	112	Using index condition; Using where; Usando 'filesort'

Perfil

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
Waiting for query cache lock	0.00 ms
After table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.18 ms
Sending data	0.09 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:311
9	JPluginHelper::{closure}()	Lo mismo que llamada de la línea de abajo.
8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/plugin/helper.php:316
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.26 ms Después de la última consulta: 7.79 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 5.493 MB Filas devueltas: 7

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

  LEFT JOIN oja8d_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

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

Perfil

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
Waiting for query cache lock	0.00 ms
After table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.03 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:88
17	JMenuSite->{closure}()	Lo mismo que llamada de la línea de abajo.
16	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
15	JCacheControllerCallback->get()	JROOT/libraries/cms/menu/site.php:96
14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:129
11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:443
10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:59
8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:198
7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:548
6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:402
5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1141
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.18 ms Después de la última consulta: 5.83 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 6.665 MB Filas devueltas: 1

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

  FROM `oja8d_extensions`

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

Explicar

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

Perfil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
Waiting for query cache lock	0.00 ms
After table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
14	JDatabaseDriver->loadObject()	JROOT/libraries/cms/library/helper.php:166
13	JLibraryHelper::{closure}()	Lo mismo que llamada de la línea de abajo.
12	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:174
10	JLibraryHelper::loadLibrary()	JROOT/libraries/cms/library/helper.php:42
9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:89
8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:270
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:1022
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 87.16 ms Después de la última consulta: 0.17 ms Consulta a la memoria: 0.013 MB memoria antes de la consulta: 6.668 MB

UPDATE `oja8d_extensions`

  SET `params` = '{\"mediaversion\":\"0083410945796c4f12502d1a92828d34\"}'

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

Explicar

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

Perfil

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.03 ms
Updating	0.04 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.04 ms
query end	86.98 ms
closing tables	0.01 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:1022
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.05 ms Después de la última consulta: 1.17 ms Consulta a la memoria: 0.014 MB memoria antes de la consulta: 6.932 MB Filas devueltas: 1

SELECT *

  FROM oja8d_languages

  WHERE published=1

  ORDER BY ordering ASC

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	oja8d_languages	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	2	Using where; Usando 'filesort'

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:148
5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:327
4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.25 ms Después de la última consulta: 0.34 ms Consulta a la memoria: 0.010 MB memoria antes de la consulta: 6.964 MB Filas devueltas: 3

SELECT id, home, template, s.params

  FROM oja8d_template_styles as s

  LEFT JOIN oja8d_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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	Using index condition; Using where
1	SIMPLE	s	ALL	idx_template	No pudo usarse una clave de índice	NULL	NULL	5	Using where; Using join buffer (flat, BNL join)

Perfil

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
Waiting for query cache lock	0.00 ms
After table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:485
4	JApplicationSite->getTemplate()	JROOT/libraries/cms/application/site.php:165
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.05 ms Después de la última consulta: 4.03 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 7.732 MB Filas devueltas: 30

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

  FROM `oja8d_assets`

  WHERE `name` IN ('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_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper') OR `parent_id` = 0

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
18	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
16	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
15	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
14	JUser->authorise()	JROOT/plugins/system/contentmulticategories/classes/category35.php:137
13	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:434
12	JModelLegacy->getState()	JROOT/libraries/legacy/view/category.php:115
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.06 ms Después de la última consulta: 0.19 ms Consulta a la memoria: 0.031 MB memoria antes de la consulta: 7.805 MB Filas devueltas: 102

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

  FROM `oja8d_assets`

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

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:357
18	JAccess::preloadPermissions()	JROOT/libraries/joomla/access/access.php:224
17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:538
16	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
15	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
14	JUser->authorise()	JROOT/plugins/system/contentmulticategories/classes/category35.php:137
13	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:434
12	JModelLegacy->getState()	JROOT/libraries/legacy/view/category.php:115
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 1.32 ms Después de la última consulta: 1.30 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 8.138 MB Filas devueltas: 3

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

  FROM oja8d_categories as c

  LEFT JOIN oja8d_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 `oja8d_content` AS i 
  ON i.`catid` = c.id 
  AND i.state = 1

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

  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

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

Perfil

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.07 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
Waiting for query cache lock	0.00 ms
After table lock	0.02 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.00 ms
Creating tmp table	0.17 ms
Copying to tmp table	0.76 ms
Sorting result	0.01 ms
Sending data	0.02 ms
end	0.00 ms
removing tmp table	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:301
15	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
14	JCategories->get()	JROOT/plugins/system/contentmulticategories/classes/category35.php:354
13	ContentModelCategory->getCategory()	JROOT/libraries/legacy/view/legacy.php:422
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:121
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.05 ms Después de la última consulta: 0.96 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 8.348 MB Filas devueltas: 53

SELECT `article_id`

  FROM `oja8d_contentmulticategories_categories`

  WHERE `category_id` = '9'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	oja8d_contentmulticategories_categories	ref	category_id	category_id	4	const	58

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
19	JDatabaseDriver->loadColumn()	JROOT/plugins/system/contentmulticategories/contentmulticategories.php:380
18	plgSystemContentmulticategories->getMultiCatsArticles()	JROOT/plugins/system/contentmulticategories/contentmulticategories.php:280
17	plgSystemContentmulticategories->onGetContentItems()	Lo mismo que llamada de la línea de abajo.
16	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
14	JEventDispatcher->trigger()	JROOT/plugins/system/contentmulticategories/classes/category35.php:248
13	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:422
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:143
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.14 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 8.383 MB Filas devueltas: 71

SELECT `id`

  FROM `oja8d_content`

  WHERE `catid` = '9'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	oja8d_content	ref	idx_catid	idx_catid	4	const	71	Using index

Perfil

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.01 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
Waiting for query cache lock	0.00 ms
After table lock	0.01 ms
init	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
19	JDatabaseDriver->loadColumn()	JROOT/plugins/system/contentmulticategories/contentmulticategories.php:391
18	plgSystemContentmulticategories->getMultiCatsArticles()	JROOT/plugins/system/contentmulticategories/contentmulticategories.php:280
17	plgSystemContentmulticategories->onGetContentItems()	Lo mismo que llamada de la línea de abajo.
16	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
14	JEventDispatcher->trigger()	JROOT/plugins/system/contentmulticategories/classes/category35.php:248
13	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:422
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:143
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 1.34 ms Después de la última consulta: 0.42 ms Consulta a la memoria: 0.038 MB memoria antes de la consulta: 8.427 MB Filas devueltas: 14

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

  FROM oja8d_content AS a

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

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

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

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

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

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.id IN (17,18,20,21,22,23,24,25,26,27,28,29,30,31,33,35,36,37,38,39,40,41,42,43,44,45,46,48,51,53,55,56,57,58,59,60,61,62,64,65,67,68,71,72,73,74,75,76,77,78,79,80,81,2,6,7,8,12,13,14,16,19,34,50,63,66,84,85,86,87,89) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-05-19 12:22:23') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-19 12:22:23')

  ORDER BY  c.lft,   
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC ,  a.created   
  LIMIT 36, 14

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	PRIMARY,idx_access,idx_state,idx_catid	idx_state	1	const	80	Using index condition; Using where; Using temporary; Usando 'filesort'
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	centrodecomerciosada_org_ar.a.catid	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	centrodecomerciosada_org_ar.a.created_by	1	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	centrodecomerciosada_org_ar.a.modified_by	1	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	centrodecomerciosada_org_ar.c.parent_id	1	Using where
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	centrodecomerciosada_org_ar.a.id	1	Using where

Perfil

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.09 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
Waiting for query cache lock	0.00 ms
After table lock	0.02 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.00 ms
Creating tmp table	0.13 ms
Copying to tmp table	0.64 ms
Sorting result	0.06 ms
Sending data	0.06 ms
Waiting for query cache lock	0.00 ms
Sending data	0.05 ms
Waiting for query cache lock	0.00 ms
Sending data	0.02 ms
end	0.00 ms
removing tmp table	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
16	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
15	JModelList->getItems()	JROOT/components/com_content/models/articles.php:536
14	ContentModelArticles->getItems()	JROOT/plugins/system/contentmulticategories/classes/category35.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:422
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:143
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.42 ms Después de la última consulta: 2.66 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 8.982 MB Filas devueltas: 1

SELECT COUNT(*)

  FROM oja8d_content AS a

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

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

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

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

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

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.id IN (17,18,20,21,22,23,24,25,26,27,28,29,30,31,33,35,36,37,38,39,40,41,42,43,44,45,46,48,51,53,55,56,57,58,59,60,61,62,64,65,67,68,71,72,73,74,75,76,77,78,79,80,81,2,6,7,8,12,13,14,16,19,34,50,63,66,84,85,86,87,89) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-05-19 12:22:23') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-19 12:22:23')

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	PRIMARY,idx_access,idx_state,idx_catid	idx_state	1	const	80	Using index condition; Using where
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	centrodecomerciosada_org_ar.a.catid	1	Using where

Perfil

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
Waiting for query cache lock	0.00 ms
After table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.17 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
17	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:334
16	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:281
15	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:231
14	JModelList->getPagination()	JROOT/plugins/system/contentmulticategories/classes/category35.php:265
13	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:422
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:143
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.05 ms Después de la última consulta: 0.96 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 9.150 MB Filas devueltas: 0

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

  FROM `oja8d_contentitem_tag_map` AS m 

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

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

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	No pudo usarse una clave de índice	NULL	NULL	22	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	centrodecomerciosada_org_ar.m.tag_id	1	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
12	JHelperTags->getItemTags()	JROOT/libraries/legacy/view/category.php:225
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.05 ms Después de la última consulta: 2.96 ms Consulta a la memoria: 0.035 MB memoria antes de la consulta: 9.762 MB Filas devueltas: 3

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

  FROM oja8d_categories as c

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

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

  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

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:301
20	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
19	JCategories->get()	JROOT/administrator/components/com_fields/models/fields.php:197
18	FieldsModelFields->getListQuery()	JROOT/libraries/legacy/model/list.php:132
17	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:186
16	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
14	PlgSystemFields->onContentPrepare()	Lo mismo que llamada de la línea de abajo.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:108
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.05 ms Después de la última consulta: 0.27 ms Consulta a la memoria: 0.032 MB memoria antes de la consulta: 9.819 MB Filas devueltas: 0

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

  FROM oja8d_fields AS a

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

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

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

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

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

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

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (9,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)

  GROUP BY a.id, l.title, l.image, uc.name, ag.title, ua.name, g.title, g.access, g.state

  ORDER BY a.ordering

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
18	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
17	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
16	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
14	PlgSystemFields->onContentPrepare()	Lo mismo que llamada de la línea de abajo.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:108
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.06 ms Después de la última consulta: 7.95 ms Consulta a la memoria: 0.037 MB memoria antes de la consulta: 10.904 MB Filas devueltas: 0

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

  FROM oja8d_fields AS a

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

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

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

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

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

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

  WHERE a.context = 'com_content.categories' 
  AND (fc.category_id IS NULL OR fc.category_id IN (9,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)

  GROUP BY a.id, l.title, l.image, uc.name, ag.title, ua.name, g.title, g.access, g.state

  ORDER BY a.ordering

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
22	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
21	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
20	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
19	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
18	PlgSystemFields->onContentPrepare()	Lo mismo que llamada de la línea de abajo.
17	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/tmpl/blog.php:19
14	include JROOT/components/com_content/views/category/tmpl/blog.php	JROOT/libraries/legacy/view/legacy.php:694
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
12	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:241
11	JViewCategory->display()	JROOT/components/com_content/views/category/view.html.php:260
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.38 ms Después de la última consulta: 9.03 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 11.581 MB Filas devueltas: 6

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

  FROM oja8d_modules AS m

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

  LEFT JOIN oja8d_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 <= '2024-05-19 12:22:23') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-19 12:22:23') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 103 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	range	PRIMARY,published,newsfeeds	published	5	NULL	12	Using index condition; Using where; Usando 'filesort'
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	centrodecomerciosada_org_ar.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	centrodecomerciosada_org_ar.m.module,const	1	Using index condition; Using where

Perfil

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
Waiting for query cache lock	0.00 ms
After table lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.05 ms
Sending data	0.07 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	Lo mismo que llamada de la línea de abajo.
14	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
13	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:424
12	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:360
11	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
10	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
9	JDocumentHtml->countModules()	JROOT/templates/ja_simpli/helper.php:96
8	SimpliHelper->init()	JROOT/templates/ja_simpli/index.php:10
7	require JROOT/templates/ja_simpli/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

20 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

2 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state 
  FROM oja8d_fields AS a 
  LEFT JOIN `oja8d_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN oja8d_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN oja8d_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN oja8d_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN oja8d_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `oja8d_fields_categories` AS fc 
  ON fc.field_id = a.id

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

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

1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating, 
        COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count 
  FROM oja8d_content AS a 
  LEFT JOIN oja8d_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN oja8d_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN oja8d_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN oja8d_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN oja8d_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT `id` 
  FROM `oja8d_content`

1 × SELECT COUNT(*) 
  FROM oja8d_content AS a 
  LEFT JOIN oja8d_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN oja8d_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN oja8d_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN oja8d_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN oja8d_content_rating AS v 
  ON a.id = v.content_id

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

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

1 × SELECT `article_id` 
  FROM `oja8d_contentmulticategories_categories`

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

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems 
  FROM oja8d_categories as c 
  LEFT JOIN oja8d_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 `oja8d_content` AS i 
  ON i.`catid` = c.id 
  AND i.state = 1

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` 
  FROM oja8d_extensions

1 × SELECT id, rules 
  FROM `oja8d_viewlevels

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

```
1 × SELECT * 
  FROM oja8d_languages
```

1 × SELECT `data` 
  FROM `oja8d_session`

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

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

OTRAS tablas:

1 × UPDATE `oja8d_extensions` 
  SET `params` = '{\"mediaversion\":\"0083410945796c4f12502d1a92828d34\"}'

```
1 × DELETE  
  FROM `oja8d_session`
```

Reunión con FABA

Entrega de Premios "De Taquito al Mundial"

Se realizó el Sorteo "DE TAQUITO AL MUNDIAL"

Feliz Día del Periodista!!

CAPACITACIÓN

FINANCIACIÓN

Centro del Comercio Prop. e Ind.

+54 2326 456667/452396
Arellano 286
San Antonio de Areco - (2760)
Provincia de Buenos Aires - Argentina

Ubicación

Consola de depuración de Joomla!

Sesión

Información del perfil

Fecha y hora

Memoria

Uso de la memoria

Consultas de la base de datos

23 consultas registradas 137.41 ms

20 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

OTRAS tablas:

Reunión con FABA

Entrega de Premios "De Taquito al Mundial"

Se realizó el Sorteo "DE TAQUITO AL MUNDIAL"

Feliz Día del Periodista!!

CAPACITACIÓN

FINANCIACIÓN

Centro del Comercio Prop. e Ind.

+54 2326 456667/452396Arellano 286 San Antonio de Areco - (2760)Provincia de Buenos Aires - Argentina

Ubicación

Consola de depuración de Joomla!

Sesión

Información del perfil

Fecha y hora

Memoria

Uso de la memoria

Consultas de la base de datos

23 consultas registradas 137.41 ms

20 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

OTRAS tablas:

+54 2326 456667/452396
Arellano 286
San Antonio de Areco - (2760)
Provincia de Buenos Aires - Argentina