EXPLAIN non possibile sulla query: UPDATE `joo_extensions`
SET `params` = '{\"mediaversion\":\"5d0532c6797c35df6f15abd5921b260b\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
Tempo della query: 0.60 ms Dopo l'ultima query: 0.33 msMemoria query: 0.027 MB memoria prima della query: 2.182 MBRighe restituite: 41
SELECT `id`,`name`,`rules`,`parent_id`
FROM `joo_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_advancedmodules','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djimageslider','com_fields','com_installer','com_j2xml','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_slideshowck','com_tags','com_templates','com_users','com_visforms','com_wrapper','com_xmap','com_yendifvideoshare')
Tempo della query: 0.60 ms Dopo l'ultima query: 0.88 msMemoria query: 0.023 MB memoria prima della query: 43.118 MBRighe restituite: 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, CASEWHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROMjoo_contentAS a
INNERJOINjoo_categoriesAS c on c.id = a.catid
LEFTJOINjoo_usersAS u on u.id = a.created_by
LEFTJOINjoo_categories as parent ON parent.id = c.parent_id
LEFTJOINjoo_content_ratingAS v ON a.id = v.content_id
WHERE a.id = 7716 AND c.published > 0 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-07-01 09:43:00') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-07-01 09:43:00') AND (a.state = 1 OR a.state =2)
Tempo della query: 0.28 ms Dopo l'ultima query: 0.30 msMemoria query: 0.022 MB memoria prima della query: 43.241 MBRighe restituite: 0
SELECT `m`.`tag_id`,`t`.* FROM `joo_contentitem_tag_map` AS m
INNERJOIN `joo_tags` AS t ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 7716 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Tempo della query: 1.01 ms Dopo l'ultima query: 1.22 msMemoria query: 0.025 MB memoria prima della query: 43.349 MBRighe restituite: 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
FROMjoo_fieldsAS a
LEFTJOIN `joo_languages` AS l ON l.lang_code = a.language
LEFTJOINjoo_usersAS uc ON uc.id=a.checked_out
LEFTJOINjoo_viewlevelsAS ag ON ag.id = a.access
LEFTJOINjoo_usersAS ua ON ua.id = a.created_user_id
LEFTJOINjoo_fields_groupsAS g ON g.id = a.group_id
LEFTJOIN `joo_fields_categories` AS fc ON fc.field_id = a.id
WHERE a.context = 'com_content.article' AND (fc.category_id ISNULLOR fc.category_id IN (101,0,47,123)) AND a.access IN (1,1,5) AND (a.group_id = 0 OR g.access IN (1,1,5)) AND a.state = 1 AND (a.group_id = 0 OR g.state = 1)
ORDERBY a.ordering ASC
Tempo della query: 1.87 ms Dopo l'ultima query: 28.42 msMemoria query: 0.263 MB memoria prima della query: 44.018 MBRighe restituite: 95
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down
FROMjoo_modulesAS m
LEFTJOINjoo_extensionsAS e ON e.element = m.module AND e.client_id = m.client_id
LEFTJOINjoo_advancedmodules as am ON am.moduleid = m.id
WHERE m.published = 1 AND e.enabled = 1 AND m.access IN (1,1,5) AND m.client_id = 0
ORDERBY m.position, m.ordering
14 tipi di query eseguite, ordinate per Occurrences
Tabelle SELECT:
3 × SELECT* FROMjoo_content
2 × 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, CASEWHENCHAR_LENGTH(c.alias) != 0 THENCONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM `joo_categories` AS `s` INNERJOIN `joo_categories` AS `c` ON (s.lft <= c.lft AND c.lft < s.rgt) OR (c.lft < s.lft AND s.rgt < c.rgt)
2 × SELECT `id`,`name`,`rules`,`parent_id` FROM `joo_assets`
1 × SELECT id, rules FROM `joo_viewlevels
1 × SELECT b.id FROMjoo_usergroupsAS a LEFTJOINjoo_usergroupsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT `alias`,`catid` FROM `joo_content`
1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, CASEWHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count FROMjoo_contentAS a INNERJOINjoo_categoriesAS c on c.id = a.catid LEFTJOINjoo_usersAS u on u.id = a.created_by LEFTJOINjoo_categories as parent ON parent.id = c.parent_id LEFTJOINjoo_content_ratingAS v ON a.id = v.content_id
1 × SELECT `m`.`tag_id`,`t`.* FROM `joo_contentitem_tag_map` AS m INNERJOIN `joo_tags` AS t ON `m`.`tag_id` = `t`.`id`
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 FROMjoo_fieldsAS a LEFTJOIN `joo_languages` AS l ON l.lang_code = a.language LEFTJOINjoo_usersAS uc ON uc.id=a.checked_out LEFTJOINjoo_viewlevelsAS ag ON ag.id = a.access LEFTJOINjoo_usersAS ua ON ua.id = a.created_user_id LEFTJOINjoo_fields_groupsAS g ON g.id = a.group_id LEFTJOIN `joo_fields_categories` AS fc ON fc.field_id = a.id
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down FROMjoo_modulesAS m LEFTJOINjoo_extensionsAS e ON e.element = m.module AND e.client_id = m.client_id LEFTJOINjoo_advancedmodules as am ON am.moduleid = m.id
ALTRE tabelle:
2 × LOCKTABLES `joo_extensions` WRIT
1 × UPDATE `joo_extensions` SET `params` = '{\"mediaversion\":\"5d0532c6797c35df6f15abd5921b260b\"}'
