LEY 5.810

Promoción de Técnicas de Reanimación Cardiopulmonar (RCP)

ARTÍCULO 1.- Créase el Programa Provincial para la difusión y promoción de técnicas de reanimación Cardiopulmonar (RCP) básicas, de carácter voluntario, altruistas, desinteresado y solidario. El Estado Provincial deberá fomentar la capacitación en atención primaria básica del paro cardiorrespiratorio.

ARTÍCULO 2.- El Poder Ejecutivo Provincial, a través del Ministerio de Educación, deberá orientar sus acciones para que la difusión y promoción de Técnicas de Reanimación Cardiopulmonar (RCP) se desarrolle en todas las instituciones educativas de nivel medio y superior no universitario de la Provincia de Jujuy

ARTÍCULO 3.- El Poder Ejecutivo Provincial determinará la autoridad de aplicación de la presente ley.

ARTÍCULO 4.- Comuníquese al Poder Ejecutivo Provincial.

SALA DE SESIONES, SAN SALVADOR DE JUJUY, 29 DE Noviembre de 213

Firmantes: Dr. Jorge Oscar Rodriguez - Dr. Guillermo Raul Jenefes

Cannot get Buenos Aires location id in module mod_sp_weather. Please also make sure that you have inserted city name.

CALENDARIO DE SALUD

RCP ARGENTINA
Ley 26835 sancionada
el 29 de noviembre de 2012

Para la inclusión del aprendizaje de técnicas de reanimación cardiopulmonar en los programas educativos.

NOVEDADES

APOYAN
RCP ARGENTINA

Joomla! meta tags

Consola de Joomla! Debug

Sesión

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1555640588,
                "last": 1555640588,
                "now": 1555640588
            }
        },
        "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": [
                "1"
            ],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "com_mailto": {
            "links": {
                "c795f8c9b531ba702dac47cbfb900fd822e14e90": {
                    "link": "http:\/\/antecualquierduda.com\/index.php\/rcp\/104-novedades-rcp\/657-adhesion-jujuy",
                    "expiry": 1555640588
                }
            }
        }
    }
}

Información de Perfil

Time

Memory

Time: 7.88 ms / 7.88 ms Memory: 0.359 MB / 0.47 MB Application: afterLoad

Time: 43.70 ms / 51.58 ms Memory: 2.474 MB / 2.94 MB Application: afterInitialise

Time: 6.28 ms / 57.86 ms Memory: 0.366 MB / 3.31 MB Application: afterRoute

Time: 5.45 ms / 63.31 ms Memory: 0.211 MB / 3.52 MB Application: beforeRenderComponent com_content

Time: 72.61 ms / 135.92 ms Memory: 2.436 MB / 5.95 MB Application: afterRenderComponent com_content

Time: 0.91 ms / 136.83 ms Memory: 0.004 MB / 5.96 MB Application: afterDispatch

Time: 6.46 ms / 143.28 ms Memory: 0.143 MB / 6.10 MB Application: beforeRenderModule mod_menu (Menú Principal Bottom)

Time: 5.01 ms / 148.30 ms Memory: 0.095 MB / 6.20 MB Application: afterRenderModule mod_menu (Menú Principal Bottom)

Time: 0.23 ms / 148.52 ms Memory: 0.000 MB / 6.19 MB Application: beforeRenderModule mod_custom (APOYAN RCP ARGENTINA)

Time: 1.22 ms / 149.74 ms Memory: 0.009 MB / 6.20 MB Application: afterRenderModule mod_custom (APOYAN RCP ARGENTINA)

Time: 0.11 ms / 149.85 ms Memory: 0.003 MB / 6.21 MB Application: beforeRenderModule mod_showplus (RCP1)

Time: 4.34 ms / 154.18 ms Memory: 0.247 MB / 6.45 MB Application: afterRenderModule mod_showplus (RCP1)

Time: 0.09 ms / 154.28 ms Memory: 0.000 MB / 6.45 MB Application: beforeRenderModule mod_showplus (RCP2)

Time: 0.80 ms / 155.08 ms Memory: 0.010 MB / 6.46 MB Application: afterRenderModule mod_showplus (RCP2)

Time: 0.09 ms / 155.17 ms Memory: 0.000 MB / 6.45 MB Application: beforeRenderModule mod_showplus (RCP3)

Time: 0.72 ms / 155.90 ms Memory: 0.010 MB / 6.46 MB Application: afterRenderModule mod_showplus (RCP3)

Time: 0.10 ms / 156.00 ms Memory: 0.000 MB / 6.45 MB Application: beforeRenderModule mod_search (Buscar)

Time: 2.36 ms / 158.36 ms Memory: 0.024 MB / 6.48 MB Application: afterRenderModule mod_search (Buscar)

Time: 0.06 ms / 158.42 ms Memory: 0.000 MB / 6.47 MB Application: beforeRenderModule mod_sp_weather (Clima)

Time: 5.39 ms / 163.82 ms Memory: 0.066 MB / 6.54 MB Application: afterRenderModule mod_sp_weather (Clima)

Time: 0.05 ms / 163.87 ms Memory: 0.000 MB / 6.53 MB Application: beforeRenderModule mod_visual_calendar (CALENDARIO DE SALUD)

Time: 0.40 ms / 164.26 ms Memory: 0.009 MB / 6.54 MB Application: afterRenderModule mod_visual_calendar (CALENDARIO DE SALUD)

Time: 0.05 ms / 164.31 ms Memory: 0.000 MB / 6.54 MB Application: beforeRenderModule mod_custom (RCP)

Time: 0.47 ms / 164.78 ms Memory: 0.054 MB / 6.60 MB Application: beforeRenderModule mod_articles_category (Novedades RCP)

Time: 16.15 ms / 180.93 ms Memory: 0.508 MB / 7.11 MB Application: afterRenderModule mod_articles_category (Novedades RCP)

Time: 0.43 ms / 181.36 ms Memory: 0.000 MB / 6.92 MB Application: afterRenderModule mod_custom (RCP)

Time: 0.19 ms / 181.55 ms Memory: 0.009 MB / 6.93 MB Application: beforeRenderModule mod_maximenuck (Maximenu Bottom)

Time: 17.41 ms / 198.96 ms Memory: 0.591 MB / 7.52 MB Application: afterRenderModule mod_maximenuck (Maximenu Bottom)

Time: 0.13 ms / 199.09 ms Memory: 0.000 MB / 7.50 MB Application: beforeRenderModule mod_banners (Header)

Time: 5.97 ms / 205.07 ms Memory: 0.159 MB / 7.66 MB Application: afterRenderModule mod_banners (Header)

Time: 22.08 ms / 227.15 ms Memory: 0.505 MB / 8.17 MB Application: afterRender

Database queries total: 39.69 ms

Uso de Memoria

Registro Database

36 Registro Consultas 39.69 ms

2 duplicate found!

2 duplicates: #20 #26

Query Time: 0.15 ms

SELECT `data`

  FROM `cbvjx_session`

  WHERE `session_id` = 'a06448e47dc9d280e3ea7f45d8d91dfb'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cbvjx_session	const	PRIMARY	PRIMARY	575	const	1

Profile

Error
MySql have_profiling = off

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1731
13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
12	JSessionStorageDatabase->read()	Same as call in the line below.
11	session_start()	JROOT/libraries/joomla/session/handler/native.php:258
10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
6	JSession->start()	JROOT/libraries/cms/application/cms.php:748
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:404
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Query Time: 0.10 ms After last query: 2.28 ms

SELECT `session_id`

  FROM `cbvjx_session`

  WHERE `session_id` = 'a06448e47dc9d280e3ea7f45d8d91dfb' 
  LIMIT 0, 1

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1731
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:774
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:404
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Query Time: 1.13 ms After last query: 0.13 ms

INSERT INTO `cbvjx_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('a06448e47dc9d280e3ea7f45d8d91dfb', 0, '1555640588')

Explain

EXPLAIN not possible on query: INSERT INTO `cbvjx_session` (`session_id`, `client_id`, `time`) VALUES ('a06448e47dc9d280e3ea7f45d8d91dfb', 0, '1555640588')

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysql->execute()	JROOT/libraries/cms/application/cms.php:208
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:774
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:404
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Query Time: 0.50 ms After last query: 3.54 ms

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

  FROM cbvjx_extensions

  WHERE `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cbvjx_extensions	ref	extension	extension	62	const	40	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1692
9	JDatabaseDriver->loadObjectList()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:157
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:584
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.15 ms After last query: 1.44 ms

SELECT b.id

  FROM cbvjx_usergroups AS a

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

  WHERE a.id = 1

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1541
9	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:354
8	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:423
7	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
6	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
5	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:163
4	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/site.php:589
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.15 ms After last query: 0.52 ms

SELECT id, rules

  FROM `cbvjx_viewlevels`

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1497
8	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:440
7	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
6	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
5	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:163
4	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/site.php:589
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.64 ms After last query: 0.17 ms

SELECT folder AS type, element AS name, params

  FROM cbvjx_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cbvjx_extensions	ref	extension	extension	62	const	77	Using where; Using filesort

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1692
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
5	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:163
4	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/site.php:589
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.61 ms After last query: 15.62 ms

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

  FROM cbvjx_menu AS m

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

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

  ORDER BY m.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	10	Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	acdJ3.m.component_id	1

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1692
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
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:133
11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:435
10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:196
7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:531
6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1097
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.17 ms After last query: 4.03 ms

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

  FROM cbvjx_extensions

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cbvjx_extensions	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1653
13	JDatabaseDriver->loadObject()	Same as call in the line below.
12	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:157
11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
10	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:737
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:991
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:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.50 ms After last query: 0.24 ms

UPDATE `cbvjx_extensions`

  SET `params` = '{\"mediaversion\":\"0b15c1f06656fe394d0519b272abb856\"}'

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

Explain

EXPLAIN not possible on query: UPDATE `cbvjx_extensions` SET `params` = '{\"mediaversion\":\"0b15c1f06656fe394d0519b272abb856\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysql->execute()	JROOT/libraries/cms/library/helper.php:119
9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:737
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:991
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:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.25 ms After last query: 2.13 ms

SELECT *

  FROM cbvjx_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cbvjx_languages	index	NULL	idx_ordering	4	NULL	2	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1692
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
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:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.28 ms After last query: 0.44 ms

SELECT id, home, template, s.params

  FROM cbvjx_template_styles as s

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

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	9	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	acdJ3.s.template,const	1	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1692
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
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:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.13 ms After last query: 7.19 ms

SELECT a.rules

  FROM cbvjx_assets AS a

  WHERE (a.id = 1)

  GROUP BY a.id, a.rules, a.lft

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1541
14	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:246
13	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:384
12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:439
10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.71 ms After last query: 0.67 ms

SELECT b.rules

  FROM cbvjx_assets AS a

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

  WHERE (a.name = 'com_content')

  GROUP BY b.id, b.rules, b.lft

  ORDER BY b.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	idx_asset_name	idx_asset_name	152	const	1	Using temporary; Using filesort
1	SIMPLE	b	range	idx_lft_rgt	idx_lft_rgt	4	NULL	46	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1541
15	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:246
14	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:107
13	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:439
10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.58 ms After last query: 0.90 ms

SHOW FULL COLUMNS 
  FROM `cbvjx_content`

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1692
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
12	JTable->__construct()	JROOT/libraries/legacy/table/content.php:31
11	JTableContent->__construct()	JROOT/libraries/joomla/table/table.php:305
10	JTable::getInstance()	JROOT/components/com_content/models/article.php:264
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.15 ms After last query: 3.33 ms

SELECT *

  FROM cbvjx_content

  WHERE `id` = '657'

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1456
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:728
10	JTable->load()	JROOT/components/com_content/models/article.php:265
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 18.04 ms After last query: 0.21 ms

UPDATE cbvjx_content

  SET `hits` = (`hits` + 1)

  WHERE `id` = '657'

Explain

EXPLAIN not possible on query: UPDATE cbvjx_content SET `hits` = (`hits` + 1) WHERE `id` = '657'

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/table/table.php:1249
10	JTable->hit()	JROOT/components/com_content/models/article.php:266
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.00 ms After last query: 3.56 ms

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM cbvjx_content AS a

  LEFT JOIN cbvjx_categories AS c 
  on c.id = a.catid

  LEFT JOIN cbvjx_users AS u 
  on u.id = a.created_by

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

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

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

  WHERE a.id = 657 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-04-19 02:23:08') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-04-19 02:23:08') 
  AND (a.state = 1 OR a.state =2)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	const	PRIMARY,idx_state	PRIMARY	4	const	1
1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	u	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	parent	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	v	const	PRIMARY	PRIMARY	4	const	0	unique row not found
1	PRIMARY	<derived2>	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	33
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	33	Using where; Using temporary; Using filesort
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	201	Using where; Using index

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1653
13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:159
12	ContentModelArticle->getItem()	JROOT/libraries/legacy/view/legacy.php:401
11	JViewLegacy->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:690
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.40 ms After last query: 4.66 ms

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 cbvjx_categories as c

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

  LEFT JOIN cbvjx_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) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=104

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

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Using filesort
1	PRIMARY	c	range	cat_idx,idx_access,idx_left_right	cat_idx	157	NULL	18	Using where
1	PRIMARY	<derived2>	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	33	Using where; Not exists
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	33	Using where; Using temporary; Using filesort
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	201	Using where; Using index

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1692
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
13	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
12	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
11	ContentHelperRoute::getArticleRoute()	JROOT/components/com_content/views/article/view.html.php:71
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:690
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.25 ms After last query: 1.25 ms

Duplicate queries: #26

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

  FROM `cbvjx_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 657 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	acdJ3.m.tag_id	1	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1692
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:426
11	JHelperTags->getItemTags()	JROOT/components/com_content/views/article/view.html.php:156
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:690
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.16 ms After last query: 18.76 ms

SELECT alias

  FROM cbvjx_content

  WHERE id=657

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1731
22	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:118
21	ContentRouter->build()	JROOT/libraries/cms/router/site.php:483
20	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:452
19	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:280
18	JRouter->build()	JROOT/libraries/cms/router/site.php:134
17	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
16	JRoute::_()	JROOT/plugins/content/bt_socialshare/bt_socialshare.php:93
15	plgContentBt_socialshare->buildHTML()	JROOT/plugins/content/bt_socialshare/bt_socialshare.php:353
14	plgContentBt_socialshare->onContentAfterTitle()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:164
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:690
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.71 ms After last query: 12.87 ms

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

  FROM cbvjx_modules AS m

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

  LEFT JOIN cbvjx_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 <= '2019-04-19 02:23:08') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-04-19 02:23:08') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 492 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1692
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/module/helper.php:409
11	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:352
10	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
9	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
8	JDocumentHtml->countModules()	JROOT/templates/beez_20/index.php:13
7	require JROOT/templates/beez_20/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:635
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1054
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 4.52 ms After last query: 28.21 ms

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 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,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published

  FROM cbvjx_content AS a

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

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

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

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

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

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

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

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND a.catid IN (104) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-04-19 02:23:08') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-04-19 02:23:08')

  ORDER BY a.created DESC 
  LIMIT 0, 7

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	Using temporary; Using filesort
1	PRIMARY	a	index_merge	idx_access,idx_catid	idx_catid,idx_access	4,4	NULL	4	Using intersect(idx_catid,idx_access); Using where
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	acdJ3.a.created_by	1
1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	acdJ3.a.modified_by	1
1	PRIMARY	fp	eq_ref	PRIMARY	PRIMARY	4	acdJ3.a.id	1	Using index
1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	acdJ3.a.id	1
1	PRIMARY	<derived2>	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	33	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	33	Using where; Using temporary; Using filesort
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	201	Using where; Using index

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
31	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1692
30	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:312
29	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:185
28	JModelList->getItems()	JROOT/components/com_content/models/articles.php:537
27	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:209
26	ModArticlesCategoryHelper::getList()	Same as call in the line below.
25	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:157
24	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:534
23	JModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
22	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/cms/module/helper.php:190
21	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
20	JDocumentRendererHtmlModule->render()	JROOT/plugins/content/loadmodule/loadmodule.php:143
19	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:78
18	PlgContentLoadmodule->onContentPrepare()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/cms/html/html.php:236
12	JHtml::call()	JROOT/libraries/cms/html/html.php:104
11	JHtml::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/cms/module/helper.php:190
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.36 ms After last query: 0.65 ms

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

  FROM `cbvjx_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 659 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	acdJ3.m.tag_id	1	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1692
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:426
28	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:665
27	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:209
26	ModArticlesCategoryHelper::getList()	Same as call in the line below.
25	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:157
24	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:534
23	JModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
22	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/cms/module/helper.php:190
21	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
20	JDocumentRendererHtmlModule->render()	JROOT/plugins/content/loadmodule/loadmodule.php:143
19	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:78
18	PlgContentLoadmodule->onContentPrepare()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/cms/html/html.php:236
12	JHtml::call()	JROOT/libraries/cms/html/html.php:104
11	JHtml::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/cms/module/helper.php:190
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 0.41 ms

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

  FROM `cbvjx_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 658 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	acdJ3.m.tag_id	1	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1692
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:426
28	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:665
27	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:209
26	ModArticlesCategoryHelper::getList()	Same as call in the line below.
25	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:157
24	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:534
23	JModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
22	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/cms/module/helper.php:190
21	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
20	JDocumentRendererHtmlModule->render()	JROOT/plugins/content/loadmodule/loadmodule.php:143
19	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:78
18	PlgContentLoadmodule->onContentPrepare()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/cms/html/html.php:236
12	JHtml::call()	JROOT/libraries/cms/html/html.php:104
11	JHtml::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/cms/module/helper.php:190
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 0.41 ms

Duplicate queries: #20

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

  FROM `cbvjx_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 657 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	acdJ3.m.tag_id	1	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1692
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:426
28	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:665
27	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:209
26	ModArticlesCategoryHelper::getList()	Same as call in the line below.
25	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:157
24	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:534
23	JModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
22	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/cms/module/helper.php:190
21	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
20	JDocumentRendererHtmlModule->render()	JROOT/plugins/content/loadmodule/loadmodule.php:143
19	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:78
18	PlgContentLoadmodule->onContentPrepare()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/cms/html/html.php:236
12	JHtml::call()	JROOT/libraries/cms/html/html.php:104
11	JHtml::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/cms/module/helper.php:190
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.35 ms After last query: 0.42 ms

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

  FROM `cbvjx_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 656 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	acdJ3.m.tag_id	1	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1692
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:426
28	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:665
27	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:209
26	ModArticlesCategoryHelper::getList()	Same as call in the line below.
25	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:157
24	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:534
23	JModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
22	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/cms/module/helper.php:190
21	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
20	JDocumentRendererHtmlModule->render()	JROOT/plugins/content/loadmodule/loadmodule.php:143
19	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:78
18	PlgContentLoadmodule->onContentPrepare()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/cms/html/html.php:236
12	JHtml::call()	JROOT/libraries/cms/html/html.php:104
11	JHtml::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/cms/module/helper.php:190
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.17 ms After last query: 0.41 ms

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

  FROM `cbvjx_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 655 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	acdJ3.m.tag_id	1	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1692
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:426
28	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:665
27	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:209
26	ModArticlesCategoryHelper::getList()	Same as call in the line below.
25	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:157
24	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:534
23	JModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
22	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/cms/module/helper.php:190
21	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
20	JDocumentRendererHtmlModule->render()	JROOT/plugins/content/loadmodule/loadmodule.php:143
19	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:78
18	PlgContentLoadmodule->onContentPrepare()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/cms/html/html.php:236
12	JHtml::call()	JROOT/libraries/cms/html/html.php:104
11	JHtml::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/cms/module/helper.php:190
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.17 ms After last query: 0.41 ms

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

  FROM `cbvjx_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 654 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	acdJ3.m.tag_id	1	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1692
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:426
28	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:665
27	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:209
26	ModArticlesCategoryHelper::getList()	Same as call in the line below.
25	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:157
24	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:534
23	JModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
22	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/cms/module/helper.php:190
21	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
20	JDocumentRendererHtmlModule->render()	JROOT/plugins/content/loadmodule/loadmodule.php:143
19	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:78
18	PlgContentLoadmodule->onContentPrepare()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/cms/html/html.php:236
12	JHtml::call()	JROOT/libraries/cms/html/html.php:104
11	JHtml::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/cms/module/helper.php:190
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.18 ms After last query: 0.40 ms

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

  FROM `cbvjx_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 382 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	acdJ3.m.tag_id	1	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1692
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:426
28	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:665
27	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:209
26	ModArticlesCategoryHelper::getList()	Same as call in the line below.
25	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:157
24	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:534
23	JModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
22	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/cms/module/helper.php:190
21	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
20	JDocumentRendererHtmlModule->render()	JROOT/plugins/content/loadmodule/loadmodule.php:143
19	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:78
18	PlgContentLoadmodule->onContentPrepare()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/cms/html/html.php:236
12	JHtml::call()	JROOT/libraries/cms/html/html.php:104
11	JHtml::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/cms/module/helper.php:190
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.23 ms After last query: 10.82 ms

SELECT *
			
  FROM cbvjx_modules
			
  WHERE published=1
			
  ORDER BY id
			;

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cbvjx_modules	ref	published	published	1	const	51	Using where; Using filesort

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1692
13	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_maximenuck/helper.php:391
12	modMaximenuckHelper::CreateModulesList()	JROOT/modules/mod_maximenuck/helper.php:61
11	modMaximenuckHelper::getItems()	JROOT/modules/mod_maximenuck/mod_maximenuck.php:43
10	include JROOT/modules/mod_maximenuck/mod_maximenuck.php	JROOT/libraries/cms/module/helper.php:190
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.25 ms After last query: 10.59 ms

SELECT *

  FROM cbvjx_banners

  WHERE '2019-04-19 02:23:08' >= 'reset' 
  AND `reset` != '0000-00-00 00:00:00' 
  AND `reset`!= NULL 
  AND (`checked_out` = 0 OR `checked_out` = 0)

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1692
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_banners/helpers/banners.php:79
11	BannersHelper::updateReset()	JROOT/modules/mod_banners/mod_banners.php:19
10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/cms/module/helper.php:190
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.38 ms After last query: 0.98 ms

SELECT COUNT(*)

  FROM cbvjx_banners as a

  LEFT JOIN cbvjx_banner_clients AS cl 
  ON cl.id = a.cid

  WHERE a.state=1 
  AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00') 
  AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00') 
  AND (a.imptotal = 0 OR a.impmade <= a.imptotal) 
  AND a.catid IN (10)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_banner_catid	idx_banner_catid	4	const	1	Using where
1	SIMPLE	cl	eq_ref	PRIMARY	PRIMARY	4	acdJ3.a.cid	1	Using index

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1731
17	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:341
16	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:290
15	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:324
14	JModelList->getStart()	JROOT/libraries/legacy/model/list.php:185
13	JModelList->getItems()	JROOT/components/com_banners/models/banners.php:203
12	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:44
11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/cms/module/helper.php:190
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.43 ms After last query: 0.13 ms

SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions

  FROM cbvjx_banners as a

  LEFT JOIN cbvjx_banner_clients AS cl 
  ON cl.id = a.cid

  WHERE a.state=1 
  AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00') 
  AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00') 
  AND (a.imptotal = 0 OR a.impmade <= a.imptotal) 
  AND a.catid IN (10)

  ORDER BY a.sticky DESC,a.ordering 
  LIMIT 0, 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_banner_catid	idx_banner_catid	4	const	1	Using where; Using filesort
1	SIMPLE	cl	eq_ref	PRIMARY	PRIMARY	4	acdJ3.a.cid	1

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1692
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:312
14	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:185
13	JModelList->getItems()	JROOT/components/com_banners/models/banners.php:203
12	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:44
11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/cms/module/helper.php:190
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.66 ms After last query: 0.20 ms

UPDATE cbvjx_banners

  SET impmade = (impmade + 1)

  WHERE id = 4

Explain

EXPLAIN not possible on query: UPDATE cbvjx_banners SET impmade = (impmade + 1) WHERE id = 4

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysql->execute()	JROOT/components/com_banners/models/banners.php:242
12	BannersModelBanners->impress()	JROOT/modules/mod_banners/helper.php:45
11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/cms/module/helper.php:190
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.62 ms After last query: 1.55 ms

( SELECT 
        		`output`
    		
  FROM
    			cbvjx_itpm_tags AS a
			
  LEFT JOIN
				cbvjx_itpm_urls AS b 
			
  ON 
				a.url_id = b.id
			
  WHERE
				b.uri = '/index.php/rcp/104-novedades-rcp/657-adhesion-jujuy'
			
  AND
				b.published = 1 )
				
			UNION
			
			( SELECT 
        		`output`
    		
  FROM
    			cbvjx_itpm_global_tags
			
  WHERE
				published = 1 )

Explain

EXPLAIN not possible on query: ( SELECT `output` FROM cbvjx_itpm_tags AS a LEFT JOIN cbvjx_itpm_urls AS b ON a.url_id = b.id WHERE b.uri = '/index.php/rcp/104-novedades-rcp/657-adhesion-jujuy' AND b.published = 1 ) UNION ( SELECT `output` FROM cbvjx_itpm_global_tags WHERE published = 1 )

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1692
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_itpmeta/helpers/helper.php:104
14	ItpMetaHelper::getTags()	JROOT/plugins/system/itpmeta/itpmeta.php:72
13	plgSystemItpMeta->onBeforeCompileHead()	Same as call in the line below.
12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
9	JApplicationBase->triggerEvent()	JROOT/libraries/joomla/document/renderer/html/head.php:58
8	JDocumentRendererHtmlHead->fetchHead()	JROOT/libraries/joomla/document/renderer/html/head.php:34
7	JDocumentRendererHtmlHead->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->execute()	JROOT/index.php:49

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

28 Tipos de consultas del registro, Ordenado por acontecimientos.

SELECCIONAR Tablas:

8 × SELECT `m`.`tag_id`,`t`.* 
  FROM `cbvjx_contentitem_tag_map` AS m  
  INNER JOIN `cbvjx_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

2 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM cbvjx_extensions

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

1 × SELECT alias 
  FROM cbvjx_content

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 cbvjx_categories as c 
  LEFT JOIN  (SELECT cat.id as id 
  FROM cbvjx_categories AS cat JOIN cbvjx_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

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 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,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published 
  FROM cbvjx_content AS a 
  LEFT JOIN cbvjx_content_frontpage AS fp 
  ON fp.content_id = a.id 
  LEFT JOIN cbvjx_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN cbvjx_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN cbvjx_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN cbvjx_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN cbvjx_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM cbvjx_categories AS cat JOIN cbvjx_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

```
1 × SELECT *    
  FROM cbvjx_modules
```

1 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions 
  FROM cbvjx_banners as a 
  LEFT JOIN cbvjx_banner_clients AS cl 
  ON cl.id = a.cid

1 × SELECT COUNT(*) 
  FROM cbvjx_banners as a 
  LEFT JOIN cbvjx_banner_clients AS cl 
  ON cl.id = a.cid

```
1 × SELECT * 
  FROM cbvjx_banners
```

1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count 
  FROM cbvjx_content AS a 
  LEFT JOIN cbvjx_categories AS c 
  on c.id = a.catid 
  LEFT JOIN cbvjx_users AS u 
  on u.id = a.created_by 
  LEFT JOIN cbvjx_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN cbvjx_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM cbvjx_categories AS cat JOIN cbvjx_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

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

1 × SELECT folder AS type, element AS name, params 
  FROM cbvjx_extensions

1 × SELECT id, rules 
  FROM `cbvjx_viewlevels

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

1 × SELECT `session_id` 
  FROM `cbvjx_session`

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

```
1 × SELECT * 
  FROM cbvjx_languages
```

1 × SELECT `data` 
  FROM `cbvjx_session`

1 × SELECT a.rules 
  FROM cbvjx_assets AS a

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

```
1 × SELECT * 
  FROM cbvjx_content
```

OTRAS Tablas:

1 × UPDATE cbvjx_banners 
  SET impmade = (impmade + 1)

1 × ( SELECT            `output`       
  FROM        cbvjx_itpm_tags AS a    
  LEFT JOIN     cbvjx_itpm_urls AS b     
  ON      a.url_id = b.id

1 × UPDATE cbvjx_content 
  SET `hits` = (`hits` + 1)

1 × SHOW FULL COLUMNS 
  FROM `cbvjx_content

1 × UPDATE `cbvjx_extensions` 
  SET `params` = '{\"mediaversion\":\"0b15c1f06656fe394d0519b272abb856\"}'

1 × INSERT INTO `cbvjx_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('a06448e47dc9d280e3ea7f45d8d91dfb', 0, '1555640588'

Adhesión de la Provincia de Jujuy

CALENDARIO DE SALUD

Consola de Joomla! Debug

Sesión

Información de Perfil

Time

Memory

Uso de Memoria

Registro Database

36 Registro Consultas 39.69 ms

2 duplicate found!

28 Tipos de consultas del registro, Ordenado por acontecimientos.

SELECCIONAR Tablas:

OTRAS Tablas: