Posts @IPDRS
NOTICIAS - ACTUALIDAD
Qué pasa
La muerte y las amenazas no dejan de rondar por las casas palafíticas hechas en rústicas tablas de los resguardos wounaan nonam que se levantan sobre las orillas del río San Juan, junto a la espesa selva que une al Valle con Chocó.
Son designios de los mismos espíritus, como el del demonio Dosat. Pero muchos le temen menos a esta figura de su tradición oral que a los hombres armados que han acosado en los últimos cuatro años a diferentes comunidades a la orilla del San Juan, cuna de esta cultura indígena donde nativos habitan esparcidos entre ambos departamentos a lado y lado del río –unos 3.000 en la jurisdicción del Valle.
Read more: Colombia: La tribu que le hace frente a la violencia
Contrariamente a la caída en la producción mundial, las exportaciones de castaña de Bolivia gozan de buena salud y subieron en 56% desde 2000. El país ya cubre el 75% de la demanda mundial del fruto y este 2015 cumplirá 20 años como líder en la oferta global del alimento.
Brasil fue el mayor productor de castaña del mundo hasta 1995, cuando exportó 9.000 t contra 7.500 t de Bolivia, país que un año después se apoderó del liderazgo global del mercado. En 1999, la participación de la castaña boliviana llegó al 73% con 10.880 t contra 2.500 t del Brasil, según el Servicio de Información para el Desarrollo Económico Local (Sidel).
Actualmente, la participación del producto boliviano “en el mercado mundial es del 75%”, aseguró el responsable de la Dirección de Planificación de Empresa Boliviana de Almendra (EBA), Alejandro Cossío.
Según datos del INE elaborados por el IBCE, las ventas externas de almendros de Bolivia aumentaron en los últimos cinco años en 56%, de $us 103,71 millones en 2010 a 161,74 millones a noviembre de 2014. El volumen, a su vez, se acrecentó en 17,26%, de 21.120 toneladas (t) a 24.765 t.
El 98% de la producción total del país se destina al comercio exterior y el 2% al mercado interno, precisó Javier Freire, gerente técnico de la EBA, que opera en el país desde 2010.
Datos del sitio Trade Map dan cuenta de que desde 2009 hasta 2012, el volumen de las exportaciones de castaña del mundo se redujo en 45,5%, mientras que el valor se incrementó en 57,7%, una tendencia que se mantuvo en los últimos dos años.
Read more: Bolivia retiene liderazgo en la oferta global de castaña
De tantos golpes que recibió, el cerebro lo tiene muy separado del cráneo y tiene que usar sombrero de ala ancha para anticipar cualquier golpe, que por pequeño que sea, le puede reventar una vena. Ha visto varias veces la película ¡Viva Zapata! con Marlon Brando. Lleva su sempiterna barba bien cuidada, y unas pulseritas de colores le dan un aire festivo a su aspecto. Es una leyenda, lo quieran negar o no. Gran parte de la historia política peruana del siglo XX no puede escribirse sin mencionar su nombre. Suena recontra caviar por el disco de Silvio Rodríguez y todo eso, pero la cita a Bertolt Brecht cae a pelo: “Hay hombres que luchan un día y son buenos. Hay otros que luchan un año y son mejores. Hay quienes luchan muchos años, y son muy buenos. Pero hay los que luchan toda la vida, esos son los imprescindibles”. Hugo Blanco es imprescindible.
El Censo 2012 de los Pueblos Indígenas tiene el manto de la duda al igual que el Censo Nacional 2012, pero por ahora es el único dato oficial que servirá de fuente para investigaciones y políticas públicas en torno a los Pueblos Indigenas.
Es posible que los datos estén, pero que no sepamos leer en el documento de 718 páginas; el documento nos dice que los indigenas tienen muchas casas de hule, pero no nos dicen cuántas comunidades poseen el título de propiedad de sus tierras.
El infome oficial habla de viviendas y que ha aumentado la cantidad de indigenas que tienen baños modernos, pero no nos dice cuántas familias indígenas fueron desalojadas de sus tierras desde el 2002 hasta el 2012 y cuántas demandas tiene el Estado Paraguayo por violentar los derechos de los indigenas.
Read more: Paraguay: 10 datos sobre los indígenas según el Censo 2012
Por primera vez en Uruguay La Institución Nacional de Derechos Humanos del Uruguay realizó una "mesa redonda", en el marco del día intenacional de los Derechos Humanos el 10 de Diciembre del 2014 en la ciudad de Guichón, una de las zonas agrosojeras por excelencia. Asistieron personalidades que representaron a las autoridades y Organizaciones Sociales y representantes de la Sociedad Civil de diversos ámbitos de la población, por otro.
Con el objetivo de analizar conjuntamente el uso de plaguicidas en el Uruguay. El organismo (INDDHH) recibió varias denuncias sobre presuntas irregularidades con el uso de sustancias nocivas para la salud humana, ambiental, y animal, particularmente referido en áreas de producción agrícola y al uso de agrotóxicos, lo que les llevó a promover dicho encuentro, marcando así un precedente con esperanzas de avistar soluciones.
SOMOS PARTE DE:
CONTACTO:
Av. 20 de octubre # 2396, casi esq. Belisario Salinas
Edif. María Haydee. Piso 12
Edif. María Haydee. Piso 12
Telf. 591-2-2115952
Casilla Nº 9052
Casilla Nº 9052
La Paz – Bolivia
NIT: 169994029
NIT: 169994029
INTRANET
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.
Diseñado y administrado por: Bolivia Rural S.R.L.
Joomla! Debug Console
{
"__default": {
"session": {
"counter": 2,
"timer": {
"start": 1788185470,
"last": 1788185470,
"now": 1788185471
}
},
"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": {
"d8325bfdc6550f192d942c2a3fc3ca4cd3c6f94a": {
"link": "https:\/\/sudamericarural.org\/index.php\/noticias\/que-pasa\/6-brasil\/3566-o-brasil-tem-latifundios-70-mil-deles",
"expiry": 1788185471
},
"a2df1422655853405da0ad83fbec1025099bb706": {
"link": "https:\/\/sudamericarural.org\/index.php\/noticias\/que-pasa\/10-ecuador\/3562-ecuador-manana-termina-el-plazo-para-la-conaie",
"expiry": 1788185471
},
"0912e174263817ff58a91b0160baaba8d6eff5ab": {
"link": "https:\/\/sudamericarural.org\/index.php\/noticias\/que-pasa\/7-bolivia\/3560-bolivia-espacios-de-accionar-indigena-estan-contaminados-por-intereses-politicos",
"expiry": 1788185471
},
"c13a143b77a731501af484ba7bf1457f40c9013e": {
"link": "https:\/\/sudamericarural.org\/index.php\/noticias\/que-pasa\/7-bolivia\/3561-bolivia-ley-de-deslinde-cumple-4-anos-con-el-reto-de-aplicarse-a-plenitud",
"expiry": 1788185471
},
"8b6b45c6f08f2c702c5358f9707e7a0492a89da8": {
"link": "https:\/\/sudamericarural.org\/index.php\/noticias\/que-pasa\/8-colombia\/3559-colombia-restitucion-de-tierras-un-balance-claroscuro-en-2014",
"expiry": 1788185471
},
"88ff1b26637e532c532ab2793ac492cbefcad21f": {
"link": "https:\/\/sudamericarural.org\/index.php\/noticias\/que-pasa\/8-colombia\/3581-colombia-la-tribu-que-le-hace-frente-a-la-violencia",
"expiry": 1788185472
},
"f3a9f385c201e8f9d12d8898f5abd22201f6bf26": {
"link": "https:\/\/sudamericarural.org\/index.php\/noticias\/que-pasa\/7-bolivia\/3580-bolivia-retiene-liderazgo-en-la-oferta-global-de-castana",
"expiry": 1788185472
},
"d4a8607f85da3a35b0968f092a7bd5aadf7cbec8": {
"link": "https:\/\/sudamericarural.org\/index.php\/noticias\/que-pasa\/11-peru\/3577-peru-entrevista-a-hugo-blanco-tierra-o-muerte",
"expiry": 1788185472
},
"b417b95c3e73af6ad55432ae3647d4b5bbea9bb6": {
"link": "https:\/\/sudamericarural.org\/index.php\/noticias\/que-pasa\/13-paraguay\/3578-paraguay-10-datos-sobre-los-indigenas-segun-el-censo-2012",
"expiry": 1788185472
},
"662c2dae482800448dc1c3405ffad584b7272a92": {
"link": "https:\/\/sudamericarural.org\/index.php\/noticias\/que-pasa\/14-uruguay\/3575-uruguay-uruguay-agro-rural-una-muerte-silenciada",
"expiry": 1788185472
}
}
}
}
}
Time
Memory
Time: 2.75 ms / 2.75 ms Memory: 0.742 MB / 0.95 MB Application: afterLoad
Time: 34.27 ms / 37.02 ms Memory: 1.418 MB / 2.37 MB Application: afterInitialise
Time: 7.27 ms / 44.29 ms Memory: 0.616 MB / 2.99 MB Application: afterRoute
Time: 8.62 ms / 52.91 ms Memory: 0.171 MB / 3.16 MB Application: beforeRenderComponent com_content
Time: 1.98 ms / 54.90 ms Memory: 0.283 MB / 3.44 MB Application: Before Access::preloadComponents (all components)
Time: 2.24 ms / 57.13 ms Memory: 0.121 MB / 3.56 MB Application: After Access::preloadComponents (all components)
Time: 0.04 ms / 57.17 ms Memory: 0.000 MB / 3.56 MB Application: Before Access::preloadPermissions (com_content)
Time: 9.72 ms / 66.90 ms Memory: 3.322 MB / 6.88 MB Application: After Access::preloadPermissions (com_content)
Time: 4.63 ms / 71.52 ms Memory: 0.000 MB / 6.82 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Time: 0.33 ms / 71.85 ms Memory: 0.020 MB / 6.84 MB Application: After Access::getAssetRules (id:8 name:com_content)
Time: 513.91 ms / 585.76 ms Memory: 3.036 MB / 9.88 MB Application: afterRenderComponent com_content
Time: 0.41 ms / 586.17 ms Memory: 0.008 MB / 9.88 MB Application: afterDispatch
Time: 3.61 ms / 589.78 ms Memory: 0.204 MB / 10.09 MB Application: beforeRenderModule mod_custom (m2017 - Sidebar)
Time: 0.46 ms / 590.23 ms Memory: 0.013 MB / 10.10 MB Application: afterRenderModule mod_custom (m2017 - Sidebar)
Time: 0.05 ms / 590.29 ms Memory: 0.000 MB / 10.10 MB Application: beforeRenderModule mod_flexi_customcode (m2017 - FB)
Time: 1.53 ms / 591.81 ms Memory: 0.023 MB / 10.12 MB Application: afterRenderModule mod_flexi_customcode (m2017 - FB)
Time: 0.10 ms / 591.92 ms Memory: 0.000 MB / 10.11 MB Application: beforeRenderModule mod_search (m2017 - Buscador)
Time: 0.64 ms / 592.56 ms Memory: 0.025 MB / 10.14 MB Application: afterRenderModule mod_search (m2017 - Buscador)
Time: 0.15 ms / 592.71 ms Memory: 0.000 MB / 10.13 MB Application: beforeRenderModule mod_menu (m2017 - Menu)
Time: 6.41 ms / 599.12 ms Memory: 0.480 MB / 10.61 MB Application: afterRenderModule mod_menu (m2017 - Menu)
Time: 8.71 ms / 607.83 ms Memory: 0.706 MB / 11.31 MB Application: afterRender
Database queries total: 475.13 ms
12.83 MB (13,450,200 Bytes)
66 Queries Logged 475.13 ms
- Query Time: 1.29 ms Query memory: 0.008 MB Memory before query: 1.469 MB
DELETE
FROM `jo362_session`
WHERE `time` < '1788184571'EXPLAIN not possible on query: DELETE FROM `jo362_session` WHERE `time` < '1788184571'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.03 ms table lock 0.01 ms init for update 0.05 ms Updating 0.04 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.02 ms Reset for next command 0.00 ms # 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 - Query Time: 1.50 ms After last query: 0.31 ms Query memory: 0.023 MB Memory before query: 1.492 MB Rows returned: 1
SELECT `data`
FROM `jo362_session`
WHERE `session_id` = '1aelhvlf3hjjv16dhn9i4choi0'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jo362_session const PRIMARY PRIMARY 766 const 1 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.09 ms Optimizing 0.02 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.01 ms Query end 0.04 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # 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 - Query Time: 1.95 ms After last query: 0.97 ms Query memory: 0.021 MB Memory before query: 1.622 MB Rows returned: 102
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jo362_extensions`
WHERE `type` = 'component'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 Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.04 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.30 ms Preparing 0.03 ms Executing 0.00 ms Sending data 0.24 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.09 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 # 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 - Query Time: 1.21 ms After last query: 0.86 ms Query memory: 0.015 MB Memory before query: 1.720 MB Rows returned: 5
SELECT id, rules
FROM `jo362_viewlevels`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 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.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms 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.00 ms Updating status 0.02 ms Reset for next command 0.00 ms # 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 - Query Time: 1.24 ms After last query: 0.16 ms Query memory: 0.015 MB Memory before query: 1.745 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 = 1id 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 Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.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.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 # 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 - Query Time: 1.98 ms After last query: 0.30 ms Query memory: 0.021 MB Memory before query: 1.783 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 orderingid 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 Status Duration Starting 0.06 ms checking permissions 0.00 ms Opening tables 0.05 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 Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.36 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.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.09 ms Reset for next command 0.00 ms # 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 - Query Time: 2.97 ms After last query: 10.30 ms Query memory: 0.036 MB Memory before query: 2.447 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.lftid 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 Status Duration Starting 0.11 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.11 ms System lock 0.01 ms table lock 0.01 ms init 0.11 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.44 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 # 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 - Query Time: 1.43 ms After last query: 4.15 ms Query memory: 0.020 MB Memory before query: 3.014 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jo362_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'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 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.02 ms Optimizing 0.02 ms Statistics 0.14 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.04 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms 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 # 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 - Query Time: 2.41 ms After last query: 0.23 ms Query memory: 0.013 MB Memory before query: 3.016 MB
UPDATE `jo362_extensions`
SET `params` = '{\"mediaversion\":\"118245b6fc9e0ebb76d9ec96423325e3\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN not possible on query: UPDATE `jo362_extensions` SET `params` = '{\"mediaversion\":\"118245b6fc9e0ebb76d9ec96423325e3\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.05 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 for update 0.07 ms Updating 0.07 ms End of update loop 0.01 ms Query end 0.00 ms Commit 1.05 ms Query end 0.02 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.02 ms Reset for next command 0.00 ms # 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 - Query Time: 1.30 ms After last query: 0.62 ms Query memory: 0.014 MB Memory before query: 3.110 MB Rows returned: 3
SELECT *
FROM jo362_languages
WHERE published=1
ORDER BY ordering ASCid 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 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.02 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 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.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.04 ms Reset for next command 0.01 ms # 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 - Query Time: 1.48 ms After last query: 0.50 ms Query memory: 0.010 MB Memory before query: 3.147 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 = 1id 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 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.02 ms Executing 0.00 ms Sending data 0.08 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 # 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 - Query Time: 1.70 ms After last query: 2.64 ms Query memory: 0.029 MB Memory before query: 3.451 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')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 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.00 ms table lock 0.01 ms init 0.04 ms Optimizing 0.01 ms Statistics 0.10 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.30 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 # 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 - Query Time: 3.81 ms After last query: 0.41 ms Query memory: 0.106 MB Memory before query: 3.557 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` = 0id 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 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.07 ms Preparing 0.01 ms Executing 0.00 ms Sending data 2.42 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.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 # 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 - Query Time: 1.71 ms After last query: 6.56 ms Query memory: 0.032 MB Memory before query: 7.107 MB Rows returned: 8
SHOW FULL COLUMNS
FROM `jo362_assets`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `jo362_assets`Status Duration Starting 0.06 ms checking permissions 0.01 ms closing tables 0.00 ms checking permissions 0.00 ms Opening tables 0.24 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.00 ms checking permissions 0.05 ms closing tables 0.01 ms checking permissions 0.00 ms Executing 0.00 ms Sending data 0.09 ms End of update loop 0.01 ms Query end 0.00 ms closing tables 0.00 ms Removing tmp table 0.08 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.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # 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 - Query Time: 1.20 ms After last query: 0.40 ms Query memory: 0.028 MB Memory before query: 7.168 MB Rows returned: 0
SELECT *
FROM jo362_assets
WHERE `name` = 'com_content.category.4'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 Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.00 ms Executing 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms 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.00 ms Updating status 0.02 ms Reset for next command 0.00 ms # 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 - Query Time: 1.22 ms After last query: 1.35 ms Query memory: 0.028 MB Memory before query: 7.215 MB Rows returned: 0
SELECT *
FROM jo362_assets
WHERE `name` = 'com_content.category.4'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 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.03 ms Preparing 0.00 ms Executing 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.02 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 ms # 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 - Query Time: 45.32 ms After last query: 0.85 ms Query memory: 0.033 MB Memory before query: 6.881 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.lftid 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 Status Duration Starting 0.16 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.07 ms Optimizing 0.03 ms Statistics 0.33 ms Preparing 0.02 ms Unlocking tables 0.00 ms Preparing 0.04 ms Creating tmp table 0.08 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 43.02 ms Creating sort index 0.10 ms Removing tmp table 0.13 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.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.05 ms Updating status 0.05 ms Reset for next command 0.01 ms # 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 - Query Time: 1.56 ms After last query: 1.45 ms Query memory: 0.028 MB Memory before query: 7.414 MB Rows returned: 0
SELECT *
FROM jo362_assets
WHERE `name` = 'com_content.category.4'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 Status Duration Starting 0.09 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.04 ms Optimizing 0.01 ms Statistics 0.11 ms Preparing 0.01 ms Executing 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.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 # 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 - Query Time: 299.64 ms After last query: 0.94 ms Query memory: 0.081 MB Memory before query: 7.115 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-08-31 14:11:11')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-08-31 14:11:11')
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 2125, 9id 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 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.09 ms Statistics 0.21 ms Preparing 0.10 ms Optimizing 0.02 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 0.09 ms Executing 0.00 ms Sending data 277.38 ms Creating sort index 14.71 ms Removing tmp table 4.70 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.00 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 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.02 ms Updating status 0.05 ms Reset for next command 0.01 ms # 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 - Query Time: 26.47 ms After last query: 2.22 ms Query memory: 0.024 MB Memory before query: 7.561 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-08-31 14:11:11')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-08-31 14:11:11')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 Status Duration Starting 0.17 ms checking permissions 0.02 ms Opening tables 0.08 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.13 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.03 ms Optimizing 0.01 ms Statistics 0.09 ms Preparing 0.03 ms Executing 0.00 ms Sending data 0.11 ms Executing 0.00 ms Sending data 24.29 ms End of update loop 0.04 ms Query end 0.01 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 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 # 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 - Query Time: 2.92 ms After last query: 0.84 ms Query memory: 0.027 MB Memory before query: 7.588 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)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 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.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 1.21 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.00 ms # 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 - Query Time: 1.83 ms After last query: 1.71 ms Query memory: 0.036 MB Memory before query: 7.813 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.lftid 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 Status Duration Starting 0.16 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.10 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.12 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.04 ms Reset for next command 0.00 ms # 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 - Query Time: 1.75 ms After last query: 0.47 ms Query memory: 0.032 MB Memory before query: 7.866 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 ASCid 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 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.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.10 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 # 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 - Query Time: 1.38 ms After last query: 0.67 ms Query memory: 0.024 MB Memory before query: 7.982 MB Rows returned: 0
SELECT `field_id`,`value`
FROM `jo362_fields_values`
WHERE `field_id` IN (1)
AND `item_id` = '3581'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 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 0.06 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.03 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # 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 - Query Time: 1.52 ms After last query: 5.30 ms Query memory: 0.032 MB Memory before query: 8.306 MB Rows returned: 1
SELECT `alias`
FROM `jo362_content`
WHERE id = '3581'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jo362_content const PRIMARY PRIMARY 4 const 1 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.00 ms table lock 0.01 ms init 0.03 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.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 # 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 - Query Time: 1.37 ms After last query: 0.23 ms Query memory: 0.031 MB Memory before query: 8.336 MB Rows returned: 1
SELECT alias
FROM jo362_content
WHERE id=3581id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jo362_content const PRIMARY PRIMARY 4 const 1 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.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.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 # 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 - Query Time: 1.89 ms After last query: 1.78 ms Query memory: 0.036 MB Memory before query: 8.417 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=7
ORDER BY c.lftid 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 Status Duration Starting 0.15 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.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.13 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.06 ms Reset for next command 0.01 ms # 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 - Query Time: 1.85 ms After last query: 0.46 ms Query memory: 0.032 MB Memory before query: 8.440 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 (7,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 ASCid 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 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.07 ms Optimizing 0.04 ms Statistics 0.12 ms Preparing 0.04 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.08 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.06 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.02 ms Updating status 0.04 ms Reset for next command 0.01 ms # 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 - Query Time: 1.41 ms After last query: 0.23 ms Query memory: 0.024 MB Memory before query: 8.476 MB Rows returned: 0
SELECT `field_id`,`value`
FROM `jo362_fields_values`
WHERE `field_id` IN (1)
AND `item_id` = '3580'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 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 0.05 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.03 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 # 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 - Query Time: 1.64 ms After last query: 0.91 ms Query memory: 0.032 MB Memory before query: 8.509 MB Rows returned: 1
SELECT `alias`
FROM `jo362_content`
WHERE id = '3580'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jo362_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.03 ms Optimizing 0.07 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.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 # 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 - Query Time: 1.27 ms After last query: 0.25 ms Query memory: 0.031 MB Memory before query: 8.538 MB Rows returned: 1
SELECT alias
FROM jo362_content
WHERE id=3580id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jo362_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.02 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.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 # 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 - Query Time: 2.15 ms After last query: 1.49 ms Query memory: 0.036 MB Memory before query: 8.582 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.lftid 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 Status Duration Starting 0.18 ms checking permissions 0.01 ms Opening tables 0.26 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.07 ms Optimizing 0.03 ms Statistics 0.11 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.13 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.04 ms Reset for next command 0.00 ms # 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 - Query Time: 1.92 ms After last query: 0.41 ms Query memory: 0.033 MB Memory before query: 8.605 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 ASCid 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 Status Duration Starting 0.24 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.04 ms Updating status 0.03 ms Reset for next command 0.01 ms # 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 - Query Time: 1.37 ms After last query: 0.26 ms Query memory: 0.024 MB Memory before query: 8.641 MB Rows returned: 0
SELECT `field_id`,`value`
FROM `jo362_fields_values`
WHERE `field_id` IN (1)
AND `item_id` = '3578'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 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 0.06 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.03 ms Reset for next command 0.00 ms # 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 - Query Time: 1.38 ms After last query: 0.83 ms Query memory: 0.032 MB Memory before query: 8.674 MB Rows returned: 1
SELECT `alias`
FROM `jo362_content`
WHERE id = '3578'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jo362_content const PRIMARY PRIMARY 4 const 1 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.02 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.03 ms Reset for next command 0.01 ms # 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 - Query Time: 1.31 ms After last query: 0.24 ms Query memory: 0.031 MB Memory before query: 8.703 MB Rows returned: 1
SELECT alias
FROM jo362_content
WHERE id=3578id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jo362_content const PRIMARY PRIMARY 4 const 1 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.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.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 # 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 - Query Time: 2.08 ms After last query: 1.38 ms Query memory: 0.036 MB Memory before query: 8.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=11
ORDER BY c.lftid 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 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.00 ms table lock 0.01 ms init 0.06 ms Optimizing 0.12 ms Statistics 0.22 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.15 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 # 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 - Query Time: 1.75 ms After last query: 0.48 ms Query memory: 0.032 MB Memory before query: 8.769 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 ASCid 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 Status Duration Starting 0.13 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.09 ms Preparing 0.04 ms Sorting result 0.02 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.13 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 # 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 - Query Time: 1.41 ms After last query: 0.24 ms Query memory: 0.024 MB Memory before query: 8.805 MB Rows returned: 0
SELECT `field_id`,`value`
FROM `jo362_fields_values`
WHERE `field_id` IN (1)
AND `item_id` = '3577'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 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.02 ms Optimizing 0.02 ms Statistics 0.06 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 # 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 - Query Time: 1.36 ms After last query: 1.07 ms Query memory: 0.032 MB Memory before query: 8.837 MB Rows returned: 1
SELECT `alias`
FROM `jo362_content`
WHERE id = '3577'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jo362_content const PRIMARY PRIMARY 4 const 1 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.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 # 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 - Query Time: 1.26 ms After last query: 0.31 ms Query memory: 0.031 MB Memory before query: 8.866 MB Rows returned: 1
SELECT alias
FROM jo362_content
WHERE id=3577id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jo362_content const PRIMARY PRIMARY 4 const 1 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.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.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 # 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 - Query Time: 1.95 ms After last query: 1.29 ms Query memory: 0.036 MB Memory before query: 8.909 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=14
ORDER BY c.lftid 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 Status Duration Starting 0.31 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.06 ms Optimizing 0.03 ms Statistics 0.11 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.13 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.03 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # 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 - Query Time: 1.89 ms After last query: 0.45 ms Query memory: 0.032 MB Memory before query: 8.932 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 (14,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 ASCid 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 Status Duration Starting 0.22 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.15 ms Preparing 0.05 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.04 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # 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 - Query Time: 1.30 ms After last query: 0.19 ms Query memory: 0.024 MB Memory before query: 8.968 MB Rows returned: 0
SELECT `field_id`,`value`
FROM `jo362_fields_values`
WHERE `field_id` IN (1)
AND `item_id` = '3575'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 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.03 ms Optimizing 0.02 ms Statistics 0.05 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 # 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 - Query Time: 1.25 ms After last query: 0.75 ms Query memory: 0.032 MB Memory before query: 9.000 MB Rows returned: 1
SELECT `alias`
FROM `jo362_content`
WHERE id = '3575'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jo362_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.05 ms checking permissions 0.00 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.00 ms Updating status 0.02 ms Reset for next command 0.00 ms # 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 - Query Time: 1.24 ms After last query: 0.21 ms Query memory: 0.031 MB Memory before query: 9.029 MB Rows returned: 1
SELECT alias
FROM jo362_content
WHERE id=3575id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jo362_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.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.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 ms # 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 - Query Time: 1.77 ms After last query: 1.74 ms Query memory: 0.036 MB Memory before query: 9.072 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.lftid 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 Status Duration Starting 0.18 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.05 ms Optimizing 0.03 ms Statistics 0.10 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.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.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 # 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 - Query Time: 1.70 ms After last query: 0.55 ms Query memory: 0.032 MB Memory before query: 9.095 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 ASCid 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 Status Duration Starting 0.12 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.05 ms Optimizing 0.04 ms Statistics 0.08 ms Preparing 0.03 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.04 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 # 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 - Query Time: 1.23 ms After last query: 0.28 ms Query memory: 0.024 MB Memory before query: 9.131 MB Rows returned: 0
SELECT `field_id`,`value`
FROM `jo362_fields_values`
WHERE `field_id` IN (1)
AND `item_id` = '3572'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 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.04 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.00 ms Updating status 0.02 ms Reset for next command 0.00 ms # 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 - Query Time: 1.22 ms After last query: 0.94 ms Query memory: 0.032 MB Memory before query: 9.163 MB Rows returned: 1
SELECT `alias`
FROM `jo362_content`
WHERE id = '3572'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jo362_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.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.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 ms # 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 - Query Time: 1.26 ms After last query: 0.26 ms Query memory: 0.031 MB Memory before query: 9.192 MB Rows returned: 1
SELECT alias
FROM jo362_content
WHERE id=3572id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jo362_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.01 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.01 ms Unlocking tables 0.01 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 ms # 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 - Query Time: 1.72 ms After last query: 1.92 ms Query memory: 0.036 MB Memory before query: 9.236 MB Rows returned: 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)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=6
ORDER BY c.lftid 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 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.00 ms table lock 0.01 ms init 0.06 ms Optimizing 0.03 ms Statistics 0.10 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.12 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 # 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 - Query Time: 2.15 ms After last query: 0.50 ms Query memory: 0.032 MB Memory before query: 9.259 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 (6,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 ASCid 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 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.04 ms Statistics 0.17 ms Preparing 0.14 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.03 ms Creating sort index 0.26 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 # 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 - Query Time: 1.38 ms After last query: 0.26 ms Query memory: 0.024 MB Memory before query: 9.294 MB Rows returned: 0
SELECT `field_id`,`value`
FROM `jo362_fields_values`
WHERE `field_id` IN (1)
AND `item_id` = '3571'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 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.04 ms Statistics 0.05 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 # 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 - Query Time: 1.30 ms After last query: 1.11 ms Query memory: 0.032 MB Memory before query: 9.327 MB Rows returned: 1
SELECT `alias`
FROM `jo362_content`
WHERE id = '3571'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jo362_content const PRIMARY PRIMARY 4 const 1 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.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 # 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 - Query Time: 1.27 ms After last query: 0.28 ms Query memory: 0.031 MB Memory before query: 9.356 MB Rows returned: 1
SELECT alias
FROM jo362_content
WHERE id=3571id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jo362_content const PRIMARY PRIMARY 4 const 1 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.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.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 # 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 - Query Time: 1.31 ms After last query: 1.28 ms Query memory: 0.024 MB Memory before query: 9.389 MB Rows returned: 0
SELECT `field_id`,`value`
FROM `jo362_fields_values`
WHERE `field_id` IN (1)
AND `item_id` = '3570'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 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.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 # 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 - Query Time: 1.38 ms After last query: 0.96 ms Query memory: 0.032 MB Memory before query: 9.422 MB Rows returned: 1
SELECT `alias`
FROM `jo362_content`
WHERE id = '3570'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jo362_content const PRIMARY PRIMARY 4 const 1 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.05 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.03 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 # 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 - Query Time: 1.29 ms After last query: 0.29 ms Query memory: 0.031 MB Memory before query: 9.451 MB Rows returned: 1
SELECT alias
FROM jo362_content
WHERE id=3570id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jo362_content const PRIMARY PRIMARY 4 const 1 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.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.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 ms # 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 - Query Time: 1.41 ms After last query: 1.28 ms Query memory: 0.024 MB Memory before query: 9.484 MB Rows returned: 0
SELECT `field_id`,`value`
FROM `jo362_fields_values`
WHERE `field_id` IN (1)
AND `item_id` = '3569'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 Status Duration Starting 0.13 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.02 ms Statistics 0.05 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 # 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 - Query Time: 1.34 ms After last query: 0.68 ms Query memory: 0.032 MB Memory before query: 9.516 MB Rows returned: 1
SELECT `alias`
FROM `jo362_content`
WHERE id = '3569'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jo362_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.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.03 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 # 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 - Query Time: 1.42 ms After last query: 0.28 ms Query memory: 0.031 MB Memory before query: 9.545 MB Rows returned: 1
SELECT alias
FROM jo362_content
WHERE id=3569id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jo362_content const PRIMARY PRIMARY 4 const 1 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.04 ms Optimizing 0.02 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.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 # 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 - Query Time: 2.36 ms After last query: 3.23 ms Query memory: 0.037 MB Memory before query: 9.679 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 (6,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 ASCid 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 Status Duration Starting 0.53 ms checking permissions 0.02 ms Opening tables 0.09 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.18 ms Preparing 0.05 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.11 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.04 ms Reset for next command 0.00 ms # 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 - Query Time: 2.06 ms After last query: 0.39 ms Query memory: 0.038 MB Memory before query: 9.711 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 ASCid 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 Status Duration Starting 0.12 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.14 ms Optimizing 0.04 ms Statistics 0.08 ms Preparing 0.04 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.04 ms End of update loop 0.03 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 # 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 - Query Time: 1.97 ms After last query: 26.03 ms Query memory: 0.023 MB Memory before query: 9.948 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-08-31 14:11:11')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-08-31 14:11:11')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 117 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid 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 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.04 ms Optimizing 0.04 ms Statistics 0.07 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.41 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.03 ms Reset for next command 0.00 ms # 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 - Query Time: 1.73 ms After last query: 12.94 ms Query memory: 0.021 MB Memory before query: 11.158 MB Rows returned: 134
SELECT *
FROM jo362_acymailing_configid 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 Status Duration Starting 0.06 ms checking permissions 0.17 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.02 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.11 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.04 ms Reset for next command 0.00 ms # 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
24 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
9 × SELECT `field_id`,`value`
FROM `jo362_fields_values`9 × 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.id9 × SELECT alias
FROM jo362_content9 × SELECT `alias`
FROM `jo362_content`7 × 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_assets2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `jo362_assets`2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jo362_extensions`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`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_id1 × SELECT *
FROM jo362_acymailing_confi1 × 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_id1 × 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 = 11 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM jo362_extensions1 × SELECT b.id
FROM jo362_usergroups AS a
LEFT JOIN jo362_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `jo362_viewlevels1 × 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_id1 × SELECT *
FROM jo362_languages1 × SELECT `data`
FROM `jo362_session`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_id1 × 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
OTHER Tables:
1 × SHOW FULL COLUMNS
FROM `jo362_assets1 × UPDATE `jo362_extensions`
SET `params` = '{\"mediaversion\":\"118245b6fc9e0ebb76d9ec96423325e3\"}'1 × DELETE
FROM `jo362_session`