VIDEO/ Arrivano i nuovi vasi spartitraffico in centro storico
ARRIVANO 17 NUOVI VASI CHE FARANNO DA SPARTITRAFFICO IN CENTRO STORICO IN ATTESA DELL'ENTRATA IN FUNZIONE DEI NUOVI VARCHI, IL PRIMO DI DICEMBRE.
GUARDA IL SERVIZIO
EXPLAIN non possibile sulla query: INSERT INTO `joo_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'7670666963356b68317030686f7438337433696634317174736c', 1, 1750870397, 0, '', 0)
EXPLAIN non possibile sulla query: UPDATE `joo_extensions`
SET `params` = '{\"mediaversion\":\"3722672582df579dc7747ef3c7e07b51\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
Tempo della query: 0.60 ms Dopo l'ultima query: 0.37 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.44 ms Dopo l'ultima query: 0.61 msMemoria query: 0.023 MB memoria prima della query: 43.180 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 = 6111 AND c.published > 0 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-06-25 16:53:17') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-06-25 16:53:17') AND (a.state = 1 OR a.state =2)
Tempo della query: 0.27 ms Dopo l'ultima query: 0.29 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` = 6111 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Tempo della query: 0.78 ms Dopo l'ultima query: 1.03 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 (104,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: 5.62 ms Dopo l'ultima query: 50.46 msMemoria query: 0.263 MB memoria prima della query: 43.519 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
16 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 `session_id` FROM `joo_session`
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
