EXPLAIN não é possível na consulta: INSERT INTO `j25_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'6236633632646639666336653861376533343530366632313636323431326561', 1, 1790380566, 0, '', 0)
Tempo da consulta: 0.00 msConsulta a Memória: 0.006 MB de memória antes da consulta: 4.503 MBLinhas devolvidas: 41
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `j25_extensions`
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1
Tempo da consulta: 0.00 msConsulta a Memória: 0.005 MB de memória antes da consulta: 4.791 MBLinhas devolvidas: 95
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROMj25_extensions WHERE enabled = 1 AND type = 'plugin' AND state IN (0,1) AND access IN (1,1)
ORDERBY ordering
Tempo da consulta: 0.00 msConsulta a Memória: 0.006 MB de memória antes da consulta: 8.449 MBLinhas devolvidas: 18
SELECT id, home, template, s.params
FROMj25_template_styles as s
LEFTJOINj25_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
WHERE s.client_id = 0 AND e.enabled = 1
EXPLAIN não é possível na consulta: UPDATE `j25_extensions`
SET `params` = '{\"mediaversion\":\"147939ae05d07b5b60d6323c90d66574\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
Tempo da consulta: 0.00 msConsulta a Memória: 0.010 MB de memória antes da consulta: 11.305 MBLinhas devolvidas: 40
SELECT `id`,`name`,`rules`,`parent_id`
FROM `j25_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_gantry5','com_installer','com_jce','com_jevents','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocadownload','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_simplifiedsocialshare','com_tags','com_templates','com_users','com_weblinks','com_wrapper')
Tempo da consulta: 0.00 msConsulta a Memória: 0.014 MB de memória antes da consulta: 13.366 MBLinhas devolvidas: 0
SELECTDISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROMj25_fieldsAS a
LEFTJOIN `j25_languages` AS l ON l.lang_code = a.language
LEFTJOINj25_usersAS uc ON uc.id=a.checked_out
LEFTJOINj25_viewlevelsAS ag ON ag.id = a.access
LEFTJOINj25_usersAS ua ON ua.id = a.created_user_id
LEFTJOINj25_fields_groupsAS g ON g.id = a.group_id
WHERE a.context = 'com_content.article' 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)
ORDERBY a.ordering ASC
Tempo da consulta: 0.00 msConsulta a Memória: 0.014 MB de memória antes da consulta: 13.489 MBLinhas devolvidas: 8
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROMj25_modulesAS m
LEFTJOINj25_modules_menuAS mm ON mm.moduleid = m.id
LEFTJOINj25_extensionsAS e ON e.element = m.module AND e.client_id = m.client_id
WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-09-25 23:56:06') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-09-25 23:56:06') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 273 OR mm.menuid <= 0)
ORDERBY m.position, m.ordering
Tempo da consulta: 0.00 msConsulta a Memória: 0.013 MB de memória antes da consulta: 15.087 MBLinhas devolvidas: 17
SELECT c.id
FROMj25_categoriesAS c
WHERE c.access IN (1,1)
AND c.published = 1
AND c.language in ('pt-PT','*')
AND c.extension = 'com_jevents'
ORDERBY c.lft asc
Tempo da consulta: 0.00 msConsulta a Memória: 0.011 MB de memória antes da consulta: 15.120 MBLinhas devolvidas: 1
SELECT c.id
FROMj25_categoriesAS c
WHERE c.access IN (1,1)
AND c.published = 1
AND c.language in ('pt-PT','*')
AND c.extension = 'com_jevents'
AND ((c.lft>=326 AND c.rgt<=327 ))
ORDERBY c.lft asc
Tempo da consulta: 0.00 msConsulta a Memória: 0.011 MB de memória antes da consulta: 15.132 MBLinhas devolvidas: 0
SELECT det.evdet_id as detailid, rpt.*, ev.*, rr.*, det.* , ev.rawdata as evrawdata, ev.state as published, ev.created as created , GROUP_CONCAT(DISTINCT catmapcat.id ORDERBY catmapcat.lft ASCSEPARATOR ',' ) as catids
, YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
, YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn
, HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
, HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn
FROMj25_jevents_repetition as rpt
INNERJOINj25_jevents_vevent as ev ON rpt.eventid = ev.ev_id
INNERJOINj25_jevents_icsfile as icsf ON icsf.ics_id=ev.icsid
INNERJOINj25_jevents_vevdetail as det ON det.evdet_id = rpt.eventdetail_id
LEFTJOINj25_jevents_rrule as rr ON rr.eventid = rpt.eventid
LEFTJOINj25_jevents_catmap as catmap ON catmap.evid = rpt.eventid
LEFTJOINj25_categoriesAS catmapcat ON catmap.catid = catmapcat.id
WHERE 1
AND rpt.endrepeat >= '2026-10-08 00:00:00' AND rpt.startrepeat <= '2026-10-08 23:59:59'
ANDNOT (rpt.startrepeat < '2026-10-08 00:00:00' AND det.multiday=0) AND ev.state=1 AND catmap.catid IN(-1,175)
AND ev.access IN (1,1) AND icsf.state=1 AND icsf.access IN (1,1)
GROUPBY rpt.rp_id
21 tipos de pedidos registados, ordenados por ocorrências.
ESCOLHER tabelas:
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `j25_extensions`
2 × SELECT c.id FROMj25_categoriesAS c
1 × SELECT `data` FROM `j25_session`
1 × SELECT `session_id` FROM `j25_session`
1 × SELECT id, rules FROM `j25_viewlevels
1 × SELECT b.id FROMj25_usergroupsAS a LEFTJOINj25_usergroupsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROMj25_extensions
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROMj25_menuAS m LEFTJOINj25_extensionsAS e ON m.component_id = e.extension_id
1 × SELECT id, home, template, s.params FROMj25_template_styles as s LEFTJOINj25_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
1 × SELECT* FROMj25_languages
1 × SELECT `id`,`name`,`rules`,`parent_id` FROM `j25_assets`
1 × SELECTDISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROMj25_fieldsAS a LEFTJOIN `j25_languages` AS l ON l.lang_code = a.language LEFTJOINj25_usersAS uc ON uc.id=a.checked_out LEFTJOINj25_viewlevelsAS ag ON ag.id = a.access LEFTJOINj25_usersAS ua ON ua.id = a.created_user_id LEFTJOINj25_fields_groupsAS g ON g.id = a.group_id
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROMj25_modulesAS m LEFTJOINj25_modules_menuAS mm ON mm.moduleid = m.id LEFTJOINj25_extensionsAS e ON e.element = m.module AND e.client_id = m.client_id
1 × SELECT det.evdet_id as detailid, rpt.*, ev.*, rr.*, det.* , ev.rawdata as evrawdata, ev.state as published, ev.created as created , GROUP_CONCAT(DISTINCT catmapcat.id ORDERBY catmapcat.lft ASCSEPARATOR ',' ) as catids , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup , YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup , HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn FROMj25_jevents_repetition as rpt INNERJOINj25_jevents_vevent as ev ON rpt.eventid = ev.ev_id INNERJOINj25_jevents_icsfile as icsf ON icsf.ics_id=ev.icsid INNERJOINj25_jevents_vevdetail as det ON det.evdet_id = rpt.eventdetail_id LEFTJOINj25_jevents_rrule as rr ON rr.eventid = rpt.eventid LEFTJOINj25_jevents_catmap as catmap ON catmap.evid = rpt.eventid LEFTJOINj25_categoriesAS catmapcat ON catmap.catid = catmapcat.id