Actualidad

Posts @IPDRS

Qué pasa

Details: Written by El Telégrafo; Parent Category: Qué pasa; Category: Ecuador; Published: 11 July 2016; Created: 11 July 2016; Last Updated: 11 July 2016; Hits: 11860

El campo se queda en manos de los más viejos. De aquellos que no abandonan la tierra en que nacieron, a pesar de que sus hijos se marcharon en busca de mejores días a las grandes ciudades. Esto sucede en Ecuador y en otros países de América Latina. El 80% de la población de esta región es urbana y la tendencia va en aumento.

Los más viejos son quienes ahora sostienen una precaria agricultura que solo alcanza para subsistir y nada más. Los jóvenes, la fuerza de trabajo, le dieron la espalda a la herencia que muchos de sus padres adquirieron de sus abuelos. Actualmente no hay quien trabaje en el campo. Esa es la realidad.

Details: Written by Servindi; Parent Category: Qué pasa; Category: Perú; Published: 11 July 2016; Created: 11 July 2016; Last Updated: 11 July 2016; Hits: 8370

“El ingreso de cultivos transgénicos podría traer irreparables consecuencias sobre las variedades genéticas, las prácticas agrícolas y la economía del país”, advierte un vídeo que destaca el proceso de lucha para evitar el ingreso de dichos productos al Perú hasta por diez años mediante la Ley de Moratoriaa los transgénicos en el 2012.

El vídeo producido por la Revista Leisa resalta el proceso de formación de la Plataforma Perú País Libre de Transgénicos y recoge la opinión de José Álvarez Alonso, director general de Diversidad Bilógica del Ministerio del Ambiente (Minam), Fernando Alvarado de la Fuente de la Red de Agricultura Ecológica (RAE) y Lucila Quintana de la Convención Nacional del Agro Peruano (CONVEAGRO).

Details: Written by El Espectador; Parent Category: Qué pasa; Category: Colombia; Published: 08 July 2016; Created: 08 July 2016; Last Updated: 08 July 2016; Hits: 7763

De las 32 mil veredas que tiene Colombia, 23 serán el escenario en el que las Farc harán la transición de guerrilleros a civiles. Aunque todavía no existen las coordenadas exactas de los puntos, lo que sí está claro es cuántas zonas habrá en cada departamento y el nombre de las veredas. Una de ellas, la segunda más al norte del país, es la que se ubicará en La Paz (Cesar), en donde viven más de 12 mil indígenas yukpa. Ellos, que vivieron los agravios en la época de la colonización y los estragos del conflicto interno, le tienen terror a las consecuencias que esa zona de transición puede causar en su comunidad. Así lo expresan en una carta que le enviaron a personalidades como Ban Ki-Moon, Secretario General de la ONU; Emilio Álvarez, Secretario Ejecutivo de la Comisión Interamericana de Derechos Humanos (Cidh), y al presidente Juan Manuel Santos, entre otros.

Details: Written by VSF "Justicia Alimentaria Global"; Parent Category: Qué pasa; Category: Otros Países; Published: 08 July 2016; Created: 08 July 2016; Last Updated: 08 July 2016; Hits: 9552

El Consejo Cívico de Organizaciones Populares e Indígenas de Honduras con mucho pesar comunica a la comunidad nacional e internacional del asesinato de la compañera Lesbia Yaneth Urquía Urquía de 49 años, madre de dos hijas y un hijo, del municipio de Marcala, La Paz.

La compañera Lesbia Yaneth era una destacada lideresa comunitaria vinculada al COPINH desde las protestas en contra del golpe de Estado del año 2009 y activa militante en la defensa de los bienes comunes de la naturaleza y los derechos indígenas en contra de la construcción de la represa hidroeléctrica AuroraI del municipio de San José, La Paz en la cual tiene vinculación directa la presidenta del Partido Nacional y vicepresidenta del Congreso Nacional, Gladys Aurora López.

Details: Written by Servindi; Parent Category: Qué pasa; Category: Perú; Published: 08 July 2016; Created: 08 July 2016; Last Updated: 08 July 2016; Hits: 8226

El Gobierno Regional de Amazonas aprobó la ordenanza que establece como requisito para la contratación de personal de salud, estar formado en salud intercultural y tener conocimiento de una lengua nativa. Ello a fin de garantizar que personal debidamente calificado asuma la atención de los pobladores indígenas de la región.

La ordenanza fue aprobada el 30 de junio y espera su publicación en los próximos días a través del diario oficial El Peruano. La norma regional especifica como puntajes de calificación tener un 15% de capacitación acreditada en salud intercultural, 10% por el dominio de una lengua del lugar y 5% por pertenencia étnica al pueblo.

Page 270 of 614

Start
Prev
265
266
267
268
269
270
271
272
273
274
Next
End

SOMOS PARTE DE:

CONTACTO:

Av. 20 de octubre # 2396, casi esq. Belisario Salinas
Edif. María Haydee. Piso 12

Telf. 591-2-2115952
Casilla Nº 9052

La Paz – Bolivia
NIT: 169994029

CONÉCTATE CON NOSOTROS

Síguenos y mantente en contacto a travéz de las redes sociales

2012 - 2026 Sudamérica Rural | Todos los derechos reservados
Diseñado y administrado por: Bolivia Rural S.R.L.

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1788250955,
                "last": 1788250955,
                "now": 1788250955
            }
        },
        "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
        },
        "com_mailto": {
            "links": {
                "ffdb44f641569fa3bb4e517aafb284f70226bdb0": {
                    "link": "https:\/\/sudamericarural.org\/index.php\/noticias\/que-pasa\/10-ecuador\/4810-ecuador-el-9-de-agricultores-tiene-mas-de-75-anos",
                    "expiry": 1788250960
                },
                "a1f4606868cb5a76369ceac77bcfd9d2098f7005": {
                    "link": "https:\/\/sudamericarural.org\/index.php\/noticias\/que-pasa\/11-peru\/4809-la-lucha-por-la-moratoria-a-los-transgenicos-en-el-peru",
                    "expiry": 1788250960
                },
                "fa482a96155ec8024ecffc046fc133a2af10046a": {
                    "link": "https:\/\/sudamericarural.org\/index.php\/noticias\/que-pasa\/8-colombia\/4807-colombia-por-nada-del-mundo-vamos-a-dejar-que-esa-guerra-vuelva-a-nuestra-tierra-lider-indigena-yukpa",
                    "expiry": 1788250960
                },
                "6d62fe4045c1620c31c33f65f2ebf9a53d340bdf": {
                    "link": "https:\/\/sudamericarural.org\/index.php\/noticias\/que-pasa\/17-otros-paises\/4808-honduras-copinh-comunicado-sobre-el-asesinato-de-la-companera-lesbia-yaneth-urquia",
                    "expiry": 1788250960
                },
                "bb653576b348c0b7f4344e1f84ae959682c0a610": {
                    "link": "https:\/\/sudamericarural.org\/index.php\/noticias\/que-pasa\/11-peru\/4806-peru-amazonas-poblacion-indigena-accedera-a-servicios-de-salud-en-su-idioma",
                    "expiry": 1788250960
                }
            }
        }
    }
}

Profile Information

Time

Memory

Time: 2.19 ms / 2.19 ms Memory: 0.742 MB / 0.95 MB Application: afterLoad

Time: 41.04 ms / 43.23 ms Memory: 1.429 MB / 2.38 MB Application: afterInitialise

Time: 9.29 ms / 52.52 ms Memory: 0.617 MB / 3.00 MB Application: afterRoute

Time: 9.26 ms / 61.78 ms Memory: 0.171 MB / 3.17 MB Application: beforeRenderComponent com_content

Time: 1.93 ms / 63.71 ms Memory: 0.283 MB / 3.45 MB Application: Before Access::preloadComponents (all components)

Time: 2.54 ms / 66.26 ms Memory: 0.121 MB / 3.57 MB Application: After Access::preloadComponents (all components)

Time: 0.08 ms / 66.34 ms Memory: 0.000 MB / 3.57 MB Application: Before Access::preloadPermissions (com_content)

Time: 32.00 ms / 98.34 ms Memory: 3.322 MB / 6.89 MB Application: After Access::preloadPermissions (com_content)

Time: 5.46 ms / 103.81 ms Memory: 0.000 MB / 6.83 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Time: 0.29 ms / 104.09 ms Memory: 0.020 MB / 6.85 MB Application: After Access::getAssetRules (id:8 name:com_content)

Time: 3961.66 ms / 4065.76 ms Memory: 2.888 MB / 9.74 MB Application: afterRenderComponent com_content

Time: 0.38 ms / 4066.13 ms Memory: 0.008 MB / 9.75 MB Application: afterDispatch

Time: 6.22 ms / 4072.35 ms Memory: 0.204 MB / 9.95 MB Application: beforeRenderModule mod_custom (m2017 - Sidebar)

Time: 0.39 ms / 4072.74 ms Memory: 0.013 MB / 9.96 MB Application: afterRenderModule mod_custom (m2017 - Sidebar)

Time: 0.05 ms / 4072.79 ms Memory: 0.000 MB / 9.96 MB Application: beforeRenderModule mod_flexi_customcode (m2017 - FB)

Time: 1.54 ms / 4074.33 ms Memory: 0.023 MB / 9.98 MB Application: afterRenderModule mod_flexi_customcode (m2017 - FB)

Time: 0.10 ms / 4074.43 ms Memory: 0.000 MB / 9.97 MB Application: beforeRenderModule mod_search (m2017 - Buscador)

Time: 0.70 ms / 4075.13 ms Memory: 0.025 MB / 10.00 MB Application: afterRenderModule mod_search (m2017 - Buscador)

Time: 0.09 ms / 4075.22 ms Memory: 0.000 MB / 9.99 MB Application: beforeRenderModule mod_menu (m2017 - Menu)

Time: 6.48 ms / 4081.69 ms Memory: 0.480 MB / 10.47 MB Application: afterRenderModule mod_menu (m2017 - Menu)

Time: 8.64 ms / 4090.33 ms Memory: 0.704 MB / 11.17 MB Application: afterRender

Database queries total: 3969.87 ms

Memory Usage

Database Queries

66 Queries Logged 3969.87 ms

3 duplicate found!

3 duplicates: #17 #18 #20

Query Time: 1.38 ms Query memory: 0.008 MB Memory before query: 1.468 MB

DELETE 

  FROM `jo362_session`

  WHERE `time` < '1788250055'

Explain

EXPLAIN not possible on query: DELETE FROM `jo362_session` WHERE `time` < '1788250055'

Profile

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

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Application/CMSApplication.php:824
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:133
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:415
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:49

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

Query Time: 2.13 ms After last query: 0.28 ms Query memory: 0.021 MB Memory before query: 1.491 MB Rows returned: 0

SELECT `data`

  FROM `jo362_session`

  WHERE `session_id` = 'tuhf6jiatqit6nbdgq57sekrv0'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:831
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:133
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:415
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:49

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

Query Time: 1.45 ms After last query: 0.45 ms Query memory: 0.012 MB Memory before query: 1.544 MB Rows returned: 0

SELECT `session_id`

  FROM `jo362_session`

  WHERE `session_id` = 'tuhf6jiatqit6nbdgq57sekrv0' 
  LIMIT 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
7	JDatabaseDriver->loadResult()	JROOT/libraries/src/Application/CMSApplication.php:178
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:833
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:133
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:415
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:49

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

Query Time: 3.34 ms After last query: 0.15 ms Query memory: 0.009 MB Memory before query: 1.560 MB

INSERT INTO `jo362_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('tuhf6jiatqit6nbdgq57sekrv0', 1, '1788250956', 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `jo362_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('tuhf6jiatqit6nbdgq57sekrv0', 1, '1788250956', 0, '', 0)

Profile

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

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Application/CMSApplication.php:218
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:833
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:133
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:415
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:49

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

Query Time: 1.76 ms After last query: 0.47 ms Query memory: 0.024 MB Memory before query: 1.632 MB Rows returned: 102

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

  FROM `jo362_extensions`

  WHERE `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jo362_extensions	ALL	extension	NO INDEX KEY COULD BE USED	NULL	NULL	300	Using where

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:422
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:430
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:496
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:596
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.72 ms After last query: 1.07 ms Query memory: 0.015 MB Memory before query: 1.734 MB Rows returned: 5

SELECT id, rules

  FROM `jo362_viewlevels`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:310
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.34 ms After last query: 0.16 ms Query memory: 0.015 MB Memory before query: 1.758 MB Rows returned: 1

SELECT b.id

  FROM jo362_usergroups AS a

  LEFT JOIN jo362_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	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	1	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:310
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 2.04 ms After last query: 0.30 ms Query memory: 0.018 MB Memory before query: 1.796 MB Rows returned: 74

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

  FROM jo362_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	jo362_extensions	ALL	extension	NO INDEX KEY COULD BE USED	NULL	NULL	300	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:343
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:348
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 4.68 ms After last query: 10.50 ms Query memory: 0.036 MB Memory before query: 2.458 MB Rows returned: 51

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

  LEFT JOIN jo362_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	62	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	sudmerik_samerik.m.component_id	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:446
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:551
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:405
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1146
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.62 ms After last query: 4.52 ms Query memory: 0.020 MB Memory before query: 3.025 MB Rows returned: 1

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

  FROM `jo362_extensions`

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1116
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 2.60 ms After last query: 0.23 ms Query memory: 0.013 MB Memory before query: 3.027 MB

UPDATE `jo362_extensions`

  SET `params` = '{\"mediaversion\":\"9c31b673b6344c158a51ed77709bf4f4\"}'

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

Explain

EXPLAIN not possible on query: UPDATE `jo362_extensions` SET `params` = '{\"mediaversion\":\"9c31b673b6344c158a51ed77709bf4f4\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1116
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.56 ms After last query: 0.54 ms Query memory: 0.014 MB Memory before query: 3.121 MB Rows returned: 3

SELECT *

  FROM jo362_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jo362_languages	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.63 ms After last query: 0.48 ms Query memory: 0.010 MB Memory before query: 3.157 MB Rows returned: 5

SELECT id, home, template, s.params

  FROM jo362_template_styles as s

  LEFT JOIN jo362_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	7	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	sudmerik_samerik.s.template,const	1	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:488
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 2.10 ms After last query: 2.39 ms Query memory: 0.029 MB Memory before query: 3.461 MB Rows returned: 53

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

  FROM `jo362_assets`

  WHERE `name` IN ('root.1','com_mailto','com_wrapper','com_admin','com_banners','com_cache','com_categories','com_checkin','com_contact','com_cpanel','com_installer','com_languages','com_login','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_search','com_templates','com_content','com_config','com_redirect','com_users','com_finder','com_joomlaupdate','com_tags','com_contenthistory','com_ajax','com_postinstall','com_fields','com_activities','com_jcomments','com_ruralistas','com_dialogues','com_explorations','com_acymailing','com_links_pages','com_countries','com_iso_languages','com_on_paper','com_interv1ews','com_gallery_ipdrs','com_opinion_articles','com_chronoforms','com_printed','com_multimedia','com_landvoc','com_license','com_publication_type','com_memorias','com_associations','com_calendar')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jo362_assets	range	idx_asset_name	idx_asset_name	202	NULL	54	Using index condition

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
18	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
13	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 26.13 ms After last query: 0.44 ms Query memory: 0.106 MB Memory before query: 3.568 MB Rows returned: 2063

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

  FROM `jo362_assets`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jo362_assets	ALL	idx_asset_name,idx_parent_id	NO INDEX KEY COULD BE USED	NULL	NULL	3315	Using where

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
18	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
13	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.93 ms After last query: 6.75 ms Query memory: 0.033 MB Memory before query: 7.117 MB Rows returned: 8

SHOW FULL COLUMNS 
  FROM `jo362_assets`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
20	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
19	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Asset.php:61
18	Joomla\CMS\Table\Asset->__construct()	JROOT/libraries/src/Access/Access.php:783
17	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
13	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.45 ms After last query: 0.44 ms Query memory: 0.028 MB Memory before query: 7.179 MB Rows returned: 0

Duplicate queries: #18 #20

SELECT *

  FROM jo362_assets

  WHERE `name` = 'com_content.category.4'

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 noticed after reading const tables

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
19	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:730
18	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
17	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
13	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.36 ms After last query: 1.35 ms Query memory: 0.028 MB Memory before query: 7.226 MB Rows returned: 0

Duplicate queries: #17 #20

SELECT *

  FROM jo362_assets

  WHERE `name` = 'com_content.category.4'

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 noticed after reading const tables

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
19	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:730
18	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
17	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
13	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 729.51 ms After last query: 0.82 ms Query memory: 0.033 MB Memory before query: 6.891 MB Rows returned: 16

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

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

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.published = 1 
  AND s.id=4

  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	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Using filesort
1	SIMPLE	c	ALL	cat_idx,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	98	Using where
1	SIMPLE	i	ref	idx_state,idx_catid	idx_catid	4	sudmerik_samerik.c.id	42	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:305
15	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
14	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/models/category.php:355
13	ContentModelCategory->getCategory()	JROOT/libraries/src/MVC/View/HtmlView.php:423
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:122
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.41 ms After last query: 1.46 ms Query memory: 0.028 MB Memory before query: 7.424 MB Rows returned: 0

Duplicate queries: #17 #18

SELECT *

  FROM jo362_assets

  WHERE `name` = 'com_content.category.4'

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 noticed after reading const tables

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
19	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:730
18	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
17	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:364
13	ContentModelCategory->getCategory()	JROOT/libraries/src/MVC/View/HtmlView.php:423
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:122
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1879.13 ms After last query: 0.89 ms Query memory: 0.049 MB Memory before query: 7.126 MB Rows returned: 9

SELECT DISTINCT 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, a.ordering,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, c.lft,
  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 jo362_content AS a

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

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

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

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

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

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.catid = 4 OR a.catid IN (
SELECT sub.id

  FROM jo362_categories as sub

  INNER JOIN jo362_categories as this 
  ON sub.lft > this.lft 
  AND sub.rgt < this.rgt

  WHERE this.id = 4)) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-09-01 08:22:36') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-09-01 08:22:36')

  ORDER BY    
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC ,  a.created   
  LIMIT 1345, 9

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	c	ALL	PRIMARY,idx_access	NO INDEX KEY COULD BE USED	NULL	NULL	98	Using where; Using temporary; Using filesort
1	PRIMARY	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	sudmerik_samerik.c.id	42	Using index condition; Using where
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	sudmerik_samerik.a.created_by	1	Using where
1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	sudmerik_samerik.a.modified_by	1	Using where
1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	sudmerik_samerik.c.parent_id	1	Using where
1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	sudmerik_samerik.a.id	1	Using where
2	MATERIALIZED	this	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
2	MATERIALIZED	sub	range	PRIMARY,idx_left_right	idx_left_right	4	NULL	93	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:556
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1191.48 ms After last query: 2.05 ms Query memory: 0.024 MB Memory before query: 7.494 MB Rows returned: 1

SELECT COUNT(*)

  FROM jo362_content AS a

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

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

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

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

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

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.catid = 4 OR a.catid IN (
SELECT sub.id

  FROM jo362_categories as sub

  INNER JOIN jo362_categories as this 
  ON sub.lft > this.lft 
  AND sub.rgt < this.rgt

  WHERE this.id = 4)) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-09-01 08:22:36') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-09-01 08:22:36')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	c	ALL	PRIMARY,idx_access	NO INDEX KEY COULD BE USED	NULL	NULL	98	Using where
1	PRIMARY	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	sudmerik_samerik.c.id	42	Using index condition; Using where
2	MATERIALIZED	this	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
2	MATERIALIZED	sub	range	PRIMARY,idx_left_right	idx_left_right	4	NULL	93	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
17	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:335
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
15	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
14	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/components/com_content/models/category.php:265
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 10.15 ms After last query: 0.82 ms Query memory: 0.027 MB Memory before query: 7.521 MB Rows returned: 0

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

  FROM `jo362_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.category' 
  AND `m`.`content_item_id` = 4 
  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	t	ALL	PRIMARY,tag_idx,idx_access	NO INDEX KEY COULD BE USED	NULL	NULL	360	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	sudmerik_samerik.t.id	8	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/libraries/src/MVC/View/CategoryView.php:226
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.92 ms After last query: 1.70 ms Query memory: 0.036 MB Memory before query: 7.746 MB Rows returned: 8

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

  LEFT JOIN jo362_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 s.id=10

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	98	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:305
20	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
19	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:197
18	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
17	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
14	PlgSystemFields->onContentPrepare()	Same as call in the line below.
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/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 28.74 ms After last query: 0.51 ms Query memory: 0.032 MB Memory before query: 7.799 MB Rows returned: 1

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

  FROM jo362_fields AS a

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

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

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

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

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

  LEFT JOIN `jo362_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 (10,0,4,3)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	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 filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	sudmerik_samerik.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	sudmerik_samerik.a.checked_out	1
1	SIMPLE	ag	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	sudmerik_samerik.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	sudmerik_samerik.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	sudmerik_samerik.a.id	1	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
14	PlgSystemFields->onContentPrepare()	Same as call in the line below.
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/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.57 ms After last query: 0.73 ms Query memory: 0.024 MB Memory before query: 7.916 MB Rows returned: 0

SELECT `field_id`,`value`

  FROM `jo362_fields_values`

  WHERE `field_id` IN (1) 
  AND `item_id` = '4810'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jo362_fields_values	ref	idx_field_id,idx_item_id	idx_field_id	4	const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_fields/models/field.php:708
16	FieldsModelField->getFieldValues()	JROOT/administrator/components/com_fields/helpers/fields.php:158
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
14	PlgSystemFields->onContentPrepare()	Same as call in the line below.
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/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.50 ms After last query: 5.11 ms Query memory: 0.032 MB Memory before query: 8.239 MB Rows returned: 1

SELECT `alias`

  FROM `jo362_content`

  WHERE id = '4810'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
25	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
24	ContentRouter->getArticleSegment()	Same as call in the line below.
23	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
22	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
21	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
20	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:669
19	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
16	Joomla\CMS\Router\Route::_()	JROOT/plugins/content/bt_socialshare/bt_socialshare.php:93
15	plgContentBt_socialshare->buildHTML()	JROOT/plugins/content/bt_socialshare/bt_socialshare.php:350
14	plgContentBt_socialshare->onContentAfterTitle()	Same as call in the line below.
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:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.35 ms After last query: 0.24 ms Query memory: 0.031 MB Memory before query: 8.269 MB Rows returned: 1

SELECT alias

  FROM jo362_content

  WHERE id=4810

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
23	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
22	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
21	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:528
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
16	Joomla\CMS\Router\Route::_()	JROOT/plugins/content/bt_socialshare/bt_socialshare.php:93
15	plgContentBt_socialshare->buildHTML()	JROOT/plugins/content/bt_socialshare/bt_socialshare.php:350
14	plgContentBt_socialshare->onContentAfterTitle()	Same as call in the line below.
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:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 2.00 ms After last query: 1.60 ms Query memory: 0.036 MB Memory before query: 8.351 MB Rows returned: 8

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

  LEFT JOIN jo362_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 s.id=11

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	98	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:305
20	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
19	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:197
18	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
17	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
14	PlgSystemFields->onContentPrepare()	Same as call in the line below.
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/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.89 ms After last query: 0.47 ms Query memory: 0.032 MB Memory before query: 8.374 MB Rows returned: 1

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

  FROM jo362_fields AS a

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

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

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

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

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

  LEFT JOIN `jo362_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 (11,0,4,3)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	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 filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	sudmerik_samerik.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	sudmerik_samerik.a.checked_out	1
1	SIMPLE	ag	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	sudmerik_samerik.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	sudmerik_samerik.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	sudmerik_samerik.a.id	1	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
14	PlgSystemFields->onContentPrepare()	Same as call in the line below.
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/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.38 ms After last query: 0.21 ms Query memory: 0.024 MB Memory before query: 8.410 MB Rows returned: 0

SELECT `field_id`,`value`

  FROM `jo362_fields_values`

  WHERE `field_id` IN (1) 
  AND `item_id` = '4809'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jo362_fields_values	ref	idx_field_id,idx_item_id	idx_field_id	4	const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_fields/models/field.php:708
16	FieldsModelField->getFieldValues()	JROOT/administrator/components/com_fields/helpers/fields.php:158
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
14	PlgSystemFields->onContentPrepare()	Same as call in the line below.
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/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.45 ms After last query: 0.78 ms Query memory: 0.032 MB Memory before query: 8.442 MB Rows returned: 1

SELECT `alias`

  FROM `jo362_content`

  WHERE id = '4809'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
25	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
24	ContentRouter->getArticleSegment()	Same as call in the line below.
23	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
22	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
21	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
20	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:669
19	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
16	Joomla\CMS\Router\Route::_()	JROOT/plugins/content/bt_socialshare/bt_socialshare.php:93
15	plgContentBt_socialshare->buildHTML()	JROOT/plugins/content/bt_socialshare/bt_socialshare.php:350
14	plgContentBt_socialshare->onContentAfterTitle()	Same as call in the line below.
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:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.32 ms After last query: 0.20 ms Query memory: 0.031 MB Memory before query: 8.472 MB Rows returned: 1

SELECT alias

  FROM jo362_content

  WHERE id=4809

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
23	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
22	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
21	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:528
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
16	Joomla\CMS\Router\Route::_()	JROOT/plugins/content/bt_socialshare/bt_socialshare.php:93
15	plgContentBt_socialshare->buildHTML()	JROOT/plugins/content/bt_socialshare/bt_socialshare.php:350
14	plgContentBt_socialshare->onContentAfterTitle()	Same as call in the line below.
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:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.80 ms After last query: 1.23 ms Query memory: 0.036 MB Memory before query: 8.515 MB Rows returned: 8

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

  LEFT JOIN jo362_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 s.id=17

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	98	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:305
20	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
19	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:197
18	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
17	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
14	PlgSystemFields->onContentPrepare()	Same as call in the line below.
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/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.98 ms After last query: 0.40 ms Query memory: 0.032 MB Memory before query: 8.538 MB Rows returned: 1

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

  FROM jo362_fields AS a

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

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

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

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

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

  LEFT JOIN `jo362_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 (17,0,4,3)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	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 filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	sudmerik_samerik.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	sudmerik_samerik.a.checked_out	1
1	SIMPLE	ag	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	sudmerik_samerik.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	sudmerik_samerik.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	sudmerik_samerik.a.id	1	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
14	PlgSystemFields->onContentPrepare()	Same as call in the line below.
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/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.39 ms After last query: 0.21 ms Query memory: 0.024 MB Memory before query: 8.574 MB Rows returned: 0

SELECT `field_id`,`value`

  FROM `jo362_fields_values`

  WHERE `field_id` IN (1) 
  AND `item_id` = '4808'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jo362_fields_values	ref	idx_field_id,idx_item_id	idx_field_id	4	const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_fields/models/field.php:708
16	FieldsModelField->getFieldValues()	JROOT/administrator/components/com_fields/helpers/fields.php:158
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
14	PlgSystemFields->onContentPrepare()	Same as call in the line below.
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/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.37 ms After last query: 0.64 ms Query memory: 0.032 MB Memory before query: 8.606 MB Rows returned: 1

SELECT `alias`

  FROM `jo362_content`

  WHERE id = '4808'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
25	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
24	ContentRouter->getArticleSegment()	Same as call in the line below.
23	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
22	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
21	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
20	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:669
19	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
16	Joomla\CMS\Router\Route::_()	JROOT/plugins/content/bt_socialshare/bt_socialshare.php:93
15	plgContentBt_socialshare->buildHTML()	JROOT/plugins/content/bt_socialshare/bt_socialshare.php:350
14	plgContentBt_socialshare->onContentAfterTitle()	Same as call in the line below.
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:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.24 ms After last query: 0.21 ms Query memory: 0.031 MB Memory before query: 8.635 MB Rows returned: 1

SELECT alias

  FROM jo362_content

  WHERE id=4808

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
23	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
22	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
21	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:528
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
16	Joomla\CMS\Router\Route::_()	JROOT/plugins/content/bt_socialshare/bt_socialshare.php:93
15	plgContentBt_socialshare->buildHTML()	JROOT/plugins/content/bt_socialshare/bt_socialshare.php:350
14	plgContentBt_socialshare->onContentAfterTitle()	Same as call in the line below.
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:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.79 ms After last query: 1.16 ms Query memory: 0.036 MB Memory before query: 8.678 MB Rows returned: 8

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

  LEFT JOIN jo362_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 s.id=8

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	98	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:305
20	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
19	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:197
18	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
17	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
14	PlgSystemFields->onContentPrepare()	Same as call in the line below.
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/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.84 ms After last query: 0.39 ms Query memory: 0.032 MB Memory before query: 8.701 MB Rows returned: 1

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

  FROM jo362_fields AS a

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

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

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

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

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

  LEFT JOIN `jo362_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 (8,0,4,3)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	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 filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	sudmerik_samerik.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	sudmerik_samerik.a.checked_out	1
1	SIMPLE	ag	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	sudmerik_samerik.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	sudmerik_samerik.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	sudmerik_samerik.a.id	1	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
14	PlgSystemFields->onContentPrepare()	Same as call in the line below.
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/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.34 ms After last query: 0.19 ms Query memory: 0.024 MB Memory before query: 8.737 MB Rows returned: 0

SELECT `field_id`,`value`

  FROM `jo362_fields_values`

  WHERE `field_id` IN (1) 
  AND `item_id` = '4807'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jo362_fields_values	ref	idx_field_id,idx_item_id	idx_field_id	4	const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_fields/models/field.php:708
16	FieldsModelField->getFieldValues()	JROOT/administrator/components/com_fields/helpers/fields.php:158
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
14	PlgSystemFields->onContentPrepare()	Same as call in the line below.
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/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.40 ms After last query: 0.68 ms Query memory: 0.032 MB Memory before query: 8.769 MB Rows returned: 1

SELECT `alias`

  FROM `jo362_content`

  WHERE id = '4807'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
25	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
24	ContentRouter->getArticleSegment()	Same as call in the line below.
23	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
22	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
21	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
20	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:669
19	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
16	Joomla\CMS\Router\Route::_()	JROOT/plugins/content/bt_socialshare/bt_socialshare.php:93
15	plgContentBt_socialshare->buildHTML()	JROOT/plugins/content/bt_socialshare/bt_socialshare.php:350
14	plgContentBt_socialshare->onContentAfterTitle()	Same as call in the line below.
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:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.56 ms After last query: 0.21 ms Query memory: 0.031 MB Memory before query: 8.798 MB Rows returned: 1

SELECT alias

  FROM jo362_content

  WHERE id=4807

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
23	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
22	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
21	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:528
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
16	Joomla\CMS\Router\Route::_()	JROOT/plugins/content/bt_socialshare/bt_socialshare.php:93
15	plgContentBt_socialshare->buildHTML()	JROOT/plugins/content/bt_socialshare/bt_socialshare.php:350
14	plgContentBt_socialshare->onContentAfterTitle()	Same as call in the line below.
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:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.47 ms After last query: 1.13 ms Query memory: 0.024 MB Memory before query: 8.832 MB Rows returned: 0

SELECT `field_id`,`value`

  FROM `jo362_fields_values`

  WHERE `field_id` IN (1) 
  AND `item_id` = '4806'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jo362_fields_values	ref	idx_field_id,idx_item_id	idx_field_id	4	const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_fields/models/field.php:708
16	FieldsModelField->getFieldValues()	JROOT/administrator/components/com_fields/helpers/fields.php:158
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
14	PlgSystemFields->onContentPrepare()	Same as call in the line below.
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/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.71 ms After last query: 0.77 ms Query memory: 0.032 MB Memory before query: 8.863 MB Rows returned: 1

SELECT `alias`

  FROM `jo362_content`

  WHERE id = '4806'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
25	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
24	ContentRouter->getArticleSegment()	Same as call in the line below.
23	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
22	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
21	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
20	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:669
19	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
16	Joomla\CMS\Router\Route::_()	JROOT/plugins/content/bt_socialshare/bt_socialshare.php:93
15	plgContentBt_socialshare->buildHTML()	JROOT/plugins/content/bt_socialshare/bt_socialshare.php:350
14	plgContentBt_socialshare->onContentAfterTitle()	Same as call in the line below.
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:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.32 ms After last query: 0.22 ms Query memory: 0.031 MB Memory before query: 8.893 MB Rows returned: 1

SELECT alias

  FROM jo362_content

  WHERE id=4806

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
23	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
22	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
21	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:528
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
16	Joomla\CMS\Router\Route::_()	JROOT/plugins/content/bt_socialshare/bt_socialshare.php:93
15	plgContentBt_socialshare->buildHTML()	JROOT/plugins/content/bt_socialshare/bt_socialshare.php:350
14	plgContentBt_socialshare->onContentAfterTitle()	Same as call in the line below.
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:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.83 ms After last query: 1.41 ms Query memory: 0.036 MB Memory before query: 8.936 MB Rows returned: 8

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

  LEFT JOIN jo362_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 s.id=9

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	98	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:305
20	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
19	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:197
18	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
17	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
14	PlgSystemFields->onContentPrepare()	Same as call in the line below.
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/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.93 ms After last query: 0.43 ms Query memory: 0.032 MB Memory before query: 8.959 MB Rows returned: 1

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

  FROM jo362_fields AS a

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

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

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

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

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

  LEFT JOIN `jo362_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,4,3)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	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 filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	sudmerik_samerik.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	sudmerik_samerik.a.checked_out	1
1	SIMPLE	ag	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	sudmerik_samerik.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	sudmerik_samerik.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	sudmerik_samerik.a.id	1	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
14	PlgSystemFields->onContentPrepare()	Same as call in the line below.
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/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.39 ms After last query: 0.24 ms Query memory: 0.024 MB Memory before query: 8.995 MB Rows returned: 0

SELECT `field_id`,`value`

  FROM `jo362_fields_values`

  WHERE `field_id` IN (1) 
  AND `item_id` = '4805'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jo362_fields_values	ref	idx_field_id,idx_item_id	idx_field_id	4	const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_fields/models/field.php:708
16	FieldsModelField->getFieldValues()	JROOT/administrator/components/com_fields/helpers/fields.php:158
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
14	PlgSystemFields->onContentPrepare()	Same as call in the line below.
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/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.36 ms After last query: 0.80 ms Query memory: 0.032 MB Memory before query: 9.027 MB Rows returned: 1

SELECT `alias`

  FROM `jo362_content`

  WHERE id = '4805'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
25	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
24	ContentRouter->getArticleSegment()	Same as call in the line below.
23	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
22	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
21	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
20	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:669
19	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
16	Joomla\CMS\Router\Route::_()	JROOT/plugins/content/bt_socialshare/bt_socialshare.php:93
15	plgContentBt_socialshare->buildHTML()	JROOT/plugins/content/bt_socialshare/bt_socialshare.php:350
14	plgContentBt_socialshare->onContentAfterTitle()	Same as call in the line below.
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:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.30 ms After last query: 0.23 ms Query memory: 0.031 MB Memory before query: 9.056 MB Rows returned: 1

SELECT alias

  FROM jo362_content

  WHERE id=4805

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
23	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
22	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
21	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:528
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
16	Joomla\CMS\Router\Route::_()	JROOT/plugins/content/bt_socialshare/bt_socialshare.php:93
15	plgContentBt_socialshare->buildHTML()	JROOT/plugins/content/bt_socialshare/bt_socialshare.php:350
14	plgContentBt_socialshare->onContentAfterTitle()	Same as call in the line below.
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:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.84 ms After last query: 1.28 ms Query memory: 0.036 MB Memory before query: 9.099 MB Rows returned: 8

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

  LEFT JOIN jo362_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 s.id=13

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	98	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:305
20	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
19	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:197
18	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
17	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
14	PlgSystemFields->onContentPrepare()	Same as call in the line below.
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/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.82 ms After last query: 0.44 ms Query memory: 0.032 MB Memory before query: 9.123 MB Rows returned: 1

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

  FROM jo362_fields AS a

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

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

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

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

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

  LEFT JOIN `jo362_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 (13,0,4,3)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	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 filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	sudmerik_samerik.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	sudmerik_samerik.a.checked_out	1
1	SIMPLE	ag	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	sudmerik_samerik.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	sudmerik_samerik.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	sudmerik_samerik.a.id	1	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
14	PlgSystemFields->onContentPrepare()	Same as call in the line below.
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/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.95 ms After last query: 0.23 ms Query memory: 0.024 MB Memory before query: 9.158 MB Rows returned: 0

SELECT `field_id`,`value`

  FROM `jo362_fields_values`

  WHERE `field_id` IN (1) 
  AND `item_id` = '4803'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jo362_fields_values	ref	idx_field_id,idx_item_id	idx_field_id	4	const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_fields/models/field.php:708
16	FieldsModelField->getFieldValues()	JROOT/administrator/components/com_fields/helpers/fields.php:158
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
14	PlgSystemFields->onContentPrepare()	Same as call in the line below.
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/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.44 ms After last query: 0.74 ms Query memory: 0.032 MB Memory before query: 9.190 MB Rows returned: 1

SELECT `alias`

  FROM `jo362_content`

  WHERE id = '4803'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
25	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
24	ContentRouter->getArticleSegment()	Same as call in the line below.
23	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
22	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
21	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
20	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:669
19	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
16	Joomla\CMS\Router\Route::_()	JROOT/plugins/content/bt_socialshare/bt_socialshare.php:93
15	plgContentBt_socialshare->buildHTML()	JROOT/plugins/content/bt_socialshare/bt_socialshare.php:350
14	plgContentBt_socialshare->onContentAfterTitle()	Same as call in the line below.
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:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.42 ms After last query: 0.22 ms Query memory: 0.031 MB Memory before query: 9.219 MB Rows returned: 1

SELECT alias

  FROM jo362_content

  WHERE id=4803

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
23	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
22	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
21	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:528
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
16	Joomla\CMS\Router\Route::_()	JROOT/plugins/content/bt_socialshare/bt_socialshare.php:93
15	plgContentBt_socialshare->buildHTML()	JROOT/plugins/content/bt_socialshare/bt_socialshare.php:350
14	plgContentBt_socialshare->onContentAfterTitle()	Same as call in the line below.
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:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.51 ms After last query: 1.18 ms Query memory: 0.024 MB Memory before query: 9.253 MB Rows returned: 0

SELECT `field_id`,`value`

  FROM `jo362_fields_values`

  WHERE `field_id` IN (1) 
  AND `item_id` = '4802'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jo362_fields_values	ref	idx_field_id,idx_item_id	idx_field_id	4	const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_fields/models/field.php:708
16	FieldsModelField->getFieldValues()	JROOT/administrator/components/com_fields/helpers/fields.php:158
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
14	PlgSystemFields->onContentPrepare()	Same as call in the line below.
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/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.42 ms After last query: 0.75 ms Query memory: 0.032 MB Memory before query: 9.285 MB Rows returned: 1

SELECT `alias`

  FROM `jo362_content`

  WHERE id = '4802'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
25	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
24	ContentRouter->getArticleSegment()	Same as call in the line below.
23	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
22	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
21	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
20	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:669
19	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
16	Joomla\CMS\Router\Route::_()	JROOT/plugins/content/bt_socialshare/bt_socialshare.php:93
15	plgContentBt_socialshare->buildHTML()	JROOT/plugins/content/bt_socialshare/bt_socialshare.php:350
14	plgContentBt_socialshare->onContentAfterTitle()	Same as call in the line below.
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:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.34 ms After last query: 0.25 ms Query memory: 0.031 MB Memory before query: 9.314 MB Rows returned: 1

SELECT alias

  FROM jo362_content

  WHERE id=4802

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
23	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
22	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
21	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:528
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
16	Joomla\CMS\Router\Route::_()	JROOT/plugins/content/bt_socialshare/bt_socialshare.php:93
15	plgContentBt_socialshare->buildHTML()	JROOT/plugins/content/bt_socialshare/bt_socialshare.php:350
14	plgContentBt_socialshare->onContentAfterTitle()	Same as call in the line below.
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:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.41 ms After last query: 1.21 ms Query memory: 0.024 MB Memory before query: 9.347 MB Rows returned: 0

SELECT `field_id`,`value`

  FROM `jo362_fields_values`

  WHERE `field_id` IN (1) 
  AND `item_id` = '4801'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jo362_fields_values	ref	idx_field_id,idx_item_id	idx_field_id	4	const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_fields/models/field.php:708
16	FieldsModelField->getFieldValues()	JROOT/administrator/components/com_fields/helpers/fields.php:158
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
14	PlgSystemFields->onContentPrepare()	Same as call in the line below.
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/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.43 ms After last query: 0.65 ms Query memory: 0.032 MB Memory before query: 9.379 MB Rows returned: 1

SELECT `alias`

  FROM `jo362_content`

  WHERE id = '4801'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
25	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
24	ContentRouter->getArticleSegment()	Same as call in the line below.
23	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
22	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
21	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
20	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:669
19	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
16	Joomla\CMS\Router\Route::_()	JROOT/plugins/content/bt_socialshare/bt_socialshare.php:93
15	plgContentBt_socialshare->buildHTML()	JROOT/plugins/content/bt_socialshare/bt_socialshare.php:350
14	plgContentBt_socialshare->onContentAfterTitle()	Same as call in the line below.
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:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.33 ms After last query: 0.21 ms Query memory: 0.031 MB Memory before query: 9.408 MB Rows returned: 1

SELECT alias

  FROM jo362_content

  WHERE id=4801

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
23	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
22	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
21	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:528
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
16	Joomla\CMS\Router\Route::_()	JROOT/plugins/content/bt_socialshare/bt_socialshare.php:93
15	plgContentBt_socialshare->buildHTML()	JROOT/plugins/content/bt_socialshare/bt_socialshare.php:350
14	plgContentBt_socialshare->onContentAfterTitle()	Same as call in the line below.
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:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.86 ms After last query: 2.95 ms Query memory: 0.037 MB Memory before query: 9.542 MB Rows returned: 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 jo362_fields AS a

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

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

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

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

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

  LEFT JOIN `jo362_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 (10,0,4,3)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	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 filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	sudmerik_samerik.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	sudmerik_samerik.a.checked_out	1
1	SIMPLE	ag	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	sudmerik_samerik.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	sudmerik_samerik.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	sudmerik_samerik.a.id	1	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
19	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
18	PlgSystemFields->onContentPrepare()	Same as call in the line below.
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/src/MVC/View/HtmlView.php:695
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:242
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:260
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.78 ms After last query: 0.42 ms Query memory: 0.038 MB Memory before query: 9.574 MB Rows returned: 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 jo362_fields AS a

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

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

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

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

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

  LEFT JOIN `jo362_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 (4,0,3)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	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 filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	sudmerik_samerik.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	sudmerik_samerik.a.checked_out	1
1	SIMPLE	ag	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	sudmerik_samerik.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	sudmerik_samerik.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	sudmerik_samerik.a.id	1	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
23	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
22	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
21	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
20	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:326
19	PlgSystemFields->display()	JROOT/plugins/system/fields/fields.php:255
18	PlgSystemFields->onContentAfterTitle()	Same as call in the line below.
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:22
14	include JROOT/components/com_content/views/category/tmpl/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:242
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:260
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 4.49 ms After last query: 18.80 ms Query memory: 0.023 MB Memory before query: 9.811 MB Rows returned: 19

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

  FROM jo362_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-09-01 08:22:36') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-09-01 08:22:36') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 117 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	ALL	PRIMARY,published,newsfeeds	NO INDEX KEY COULD BE USED	NULL	NULL	64	Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	sudmerik_samerik.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	sudmerik_samerik.m.module,const	1	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:433
11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:363
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/ipdrs21/index.php:181
7	require JROOT/templates/ipdrs21/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1103
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.79 ms After last query: 12.97 ms Query memory: 0.021 MB Memory before query: 11.019 MB Rows returned: 134

SELECT * 
  FROM jo362_acymailing_config

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
11	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:461
10	acymailing_config()	JROOT/administrator/components/com_acymailing/helpers/helper.php:1183
9	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:139
8	plgSystemRegacymailing->onAfterRender()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1123
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

26 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

9 × SELECT `field_id`,`value` 
  FROM `jo362_fields_values`

9 × SELECT `alias` 
  FROM `jo362_content`

9 × SELECT alias 
  FROM jo362_content

8 × 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 jo362_fields AS a 
  LEFT JOIN `jo362_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN jo362_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN jo362_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN jo362_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN jo362_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `jo362_fields_categories` AS fc 
  ON fc.field_id = a.id

6 × 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 jo362_categories as c 
  LEFT JOIN jo362_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

```
3 × SELECT * 
  FROM jo362_assets
```

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

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

1 × SELECT id, rules 
  FROM `jo362_viewlevels

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

1 × SELECT * 
  FROM jo362_acymailing_confi

1 × SELECT `session_id` 
  FROM `jo362_session`

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

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

1 × SELECT COUNT(*) 
  FROM jo362_content AS a 
  LEFT JOIN jo362_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN jo362_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN jo362_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN jo362_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN jo362_content_rating AS v 
  ON a.id = v.content_id

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

```
1 × SELECT * 
  FROM jo362_languages
```

1 × SELECT `data` 
  FROM `jo362_session`

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 jo362_categories as c 
  LEFT JOIN jo362_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 `jo362_content` AS i 
  ON i.`catid` = c.id 
  AND i.state = 1

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

1 × SELECT DISTINCT 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, a.ordering,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, c.lft,
  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 jo362_content AS a 
  LEFT JOIN jo362_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN jo362_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN jo362_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN jo362_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN jo362_content_rating AS v 
  ON a.id = v.content_id

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

OTHER Tables:

1 × SHOW FULL COLUMNS 
  FROM `jo362_assets

1 × UPDATE `jo362_extensions` 
  SET `params` = '{\"mediaversion\":\"9c31b673b6344c158a51ed77709bf4f4\"}'

1 × INSERT INTO `jo362_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('tuhf6jiatqit6nbdgq57sekrv0', 1, '1788250956', 0, '', 0

```
1 × DELETE  
  FROM `jo362_session`
```

Posts @IPDRS

NOTICIAS - ACTUALIDAD

Qué pasa

Ecuador - El 9% de agricultores tiene más de 75 años

La lucha por la moratoria a los transgénicos en el Perú

Colombia - "Por nada del mundo vamos a dejar que esa guerra vuelva a nuestra tierra”: líder indígena yukpa

Honduras - COPINH: Comunicado sobre el asesinato de la compañera Lesbia Yaneth Urquía

Perú - Amazonas: Población indígena accederá a servicios de salud en su idioma

SOMOS PARTE DE:

CONTACTO:

INTRANET

CONÉCTATE CON NOSOTROS

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

66 Queries Logged 3969.87 ms

3 duplicate found!

26 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: