VERITALIA/Una rifessione sulle "ultime" della Asl...
Una riflessione sulla Asl di Chieti che ha aperto uno sportello agli extracomunitari che non sono in regola con il permesso di soggiorno va fatta
GUARDA VERITALIA
EXPLAIN non possibile sulla query: INSERT INTO `joo_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'31683375346c3467633371626f6d6769716974706e3575703574', 1, 1750626228, 0, '', 0)
EXPLAIN non possibile sulla query: UPDATE `joo_extensions`
SET `params` = '{\"mediaversion\":\"e7682e0b060d2e18df9af4c7a5b4897b\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
Tempo della query: 0.75 ms Dopo l'ultima query: 0.38 msMemoria query: 0.027 MB memoria prima della query: 2.166 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.60 msMemoria query: 0.023 MB memoria prima della query: 43.164 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 = 5157 AND c.published > 0 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-06-22 21:03:48') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-06-22 21:03:48') AND (a.state = 1 OR a.state =2)
Tempo della query: 0.25 ms Dopo l'ultima query: 0.24 msMemoria query: 0.022 MB memoria prima della query: 43.228 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` = 5157 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Tempo della query: 0.72 ms Dopo l'ultima query: 0.82 msMemoria query: 0.025 MB memoria prima della query: 43.336 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 (112,0,26,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: 2.12 ms Dopo l'ultima query: 65.67 msMemoria query: 0.263 MB memoria prima della query: 44.006 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
15 tipi di query eseguite, ordinate per Occurrences
Tabelle SELECT:
3 × SELECT* FROMjoo_content
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 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 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)
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
