Fecha de Publicacion :02/12/2016
Fuente : http://www.adspsalamanca.org/70-sanidad-sana/1026-que-descontrol
Autor: José Generoso Gómez Cruz
Hace unos días me dijo un paciente en mi consulta de atención primaria: “la vida nos dan ustedes, porque tal como esta la sanidad”. Y me quedé pensando en esas palabras y en el sentimiento que había detrás de ellas.
El sistema sanitario español siempre ha estado muy bien valorado por la población, pero ya no tanto. Los pacientes perciben que el sistema sanitario, ese del que siempre hemos tenido a gala que es uno de los mejores del mundo, está empeorando. Todavía saben que su médico y enfermera de atención primaria son su referencia, y como dicen ellos: “son los únicos que nos escuchan”. El problema surge cuando están pendientes de una consulta de atención especializada o cuando esperan para hacerse unas pruebas diagnósticas ó una operación quirúrgica, entonces empieza la incertidumbre, el llamar al servicio de citaciones, el no saber donde acudir; el ir a urgencias, el buscar conocidos que les adelanten la consulta. Esto lo que traduce es que se ven abandonados por el sistema y no lo podemos permitir.
Es preciso solucionar este descontrol, la administración anunció que tenía un plan para organizar las listas de espera, pero actualmente estas listas se mantienen.
La solución no es cosa de números, la solución no está en reducir el número de consultas en espera de forma indiscriminada, es preciso priorizar las derivaciones.
Nuestros pacientes perciben que su médico y su enfermera de atención primaria siguen siendo su referencia dentro del sistema sanitario público, ellos mismos nos están marcando el camino a seguir, potenciemos la atención primaria, coordinemos de una vez la atención primaria con la especializada de forma que mucha patología se pueda resolver en el primer nivel evitando el consumo innecesario de recursos, establezcamos los mecanismos para que los médicos de atención primaria puedan tener comunicación directa con los especialistas, permitamos que los especialistas prioricen los volantes derivados desde los centros de salud, hagamos interconsultas para que muchos de esos pacientes sean dirigidos adecuadamente.
El problema ha adquirido tal magnitud que actualmente la solución no está solo en reducir de forma indiscriminada el número de personas en lista de espera, la solución es multifactorial y pasa indefectiblemente por potenciar la atención primaria y organizar las derivaciones a especializada.
ADSP Salamanca
PLG_DEBUG_TITLE
session.counter ⇒ 1
session.timer.start ⇒ 1741949069
session.timer.last ⇒ 1741949069
session.timer.now ⇒ 1741949069
session.client.browser ⇒ Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
registry ⇒ {}
id ⇒ 0
name ⇒
username ⇒
email ⇒
password ⇒
password_clear ⇒
usertype ⇒
block ⇒
sendEmail ⇒ 0
registerDate ⇒
lastvisitDate ⇒
activation ⇒
params ⇒
groups ⇒
guest ⇒ 1
lastResetTime ⇒
resetCount ⇒
aid ⇒ 0
5.07 MB (5,314,512 Bytes)
19 Registro Consultas
SELECT `data`
FROM `hdr5j_session`
WHERE `session_id` = 'nqd4pe3v16qhquukpk40g5ugv2'
DELETE
FROM `hdr5j_session`
WHERE `time` < '1741948469'
SELECT `session_id`
FROM `hdr5j_session`
WHERE `session_id` = 'nqd4pe3v16qhquukpk40g5ugv2'
LIMIT 0, 1
INSERT INTO `hdr5j_session`
(`session_id`, `client_id`, `time`)
VALUES
('nqd4pe3v16qhquukpk40g5ugv2', 0, '1741949069')
SELECT b.id
FROM hdr5j_usergroups AS a
LEFT JOIN hdr5j_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
SELECT id, rules
FROM `hdr5j_viewlevels`
SELECT `enabled`
FROM `hdr5j_extensions`
WHERE `element` = 'com_akeeba'
AND `type` = 'component'
SELECT time
FROM hdr5j_vvisit_counter USE INDEX(time)
ORDER BY time DESC
LIMIT 1;
UPDATE hdr5j_vvisit_counter
SET visits=visits+1, bots=bots+1
WHERE time=1741949400;
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 hdr5j_menu AS m
LEFT JOIN hdr5j_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.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM hdr5j_categories as c
LEFT JOIN hdr5j_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 (SELECT cat.id as id
FROM hdr5j_categories AS cat JOIN hdr5j_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=1373
AND badcats.id is null
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
ORDER BY c.lft
SELECT alias, catid
FROM hdr5j_content
WHERE id = 1373
SELECT a.rules
FROM hdr5j_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
SELECT b.rules
FROM hdr5j_assets AS a
LEFT JOIN hdr5j_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content' OR a.parent_id=0)
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 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.parentid, 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,contact.id as contactid,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
FROM hdr5j_content AS a
LEFT JOIN hdr5j_categories AS c
on c.id = a.catid
LEFT JOIN hdr5j_users AS u
on u.id = a.created_by
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM hdr5j_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact
ON contact.user_id = a.created_by
LEFT JOIN hdr5j_categories as parent
ON parent.id = c.parent_id
LEFT JOIN hdr5j_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM hdr5j_categories AS cat JOIN hdr5j_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 1373
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-03-14 10:44:29')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-03-14 10:44:29')
AND (a.state = 1 OR a.state =2)
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM hdr5j_categories as c
LEFT JOIN hdr5j_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 (SELECT cat.id as id
FROM hdr5j_categories AS cat JOIN hdr5j_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=118
AND badcats.id is null
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
ORDER BY c.lft
UPDATE hdr5j_content
SET hits = hits + 1
WHERE id = 1373
SELECT *
FROM hdr5j_content
WHERE id=1373
LIMIT 1
UPDATE `hdr5j_session`
SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1741949069;s:18:\"session.timer.last\";i:1741949069;s:17:\"session.timer.now\";i:1741949069;s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}'
, `time` = '1741949069'
WHERE `session_id` = 'nqd4pe3v16qhquukpk40g5ugv2'
DESCRIPCION Tipos de consulta Conectados 18, por orden de suceso
SELECCIONAR Tablas:
2 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM hdr5j_categories as c
LEFT JOIN hdr5j_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 (SELECT cat.id as id
FROM hdr5j_categories AS cat JOIN hdr5j_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
1 × SELECT alias, catid
FROM hdr5j_content
1 × SELECT a.rules
FROM hdr5j_assets AS a
1 × SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 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.parentid, 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,contact.id as contactid,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
FROM hdr5j_content AS a
LEFT JOIN hdr5j_categories AS c
on c.id = a.catid
LEFT JOIN hdr5j_users AS u
on u.id = a.created_by
LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM hdr5j_contact_details AS contact
1 × SELECT *
FROM hdr5j_content
1 × SELECT b.rules
FROM hdr5j_assets AS a
LEFT JOIN hdr5j_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
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
FROM hdr5j_menu AS m
LEFT JOIN hdr5j_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT b.id
FROM hdr5j_usergroups AS a
LEFT JOIN hdr5j_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `session_id`
FROM `hdr5j_session`
1 × SELECT id, rules
FROM `hdr5j_viewlevels
1 × SELECT `enabled`
FROM `hdr5j_extensions`
1 × SELECT time
FROM hdr5j_vvisit_counter USE INDEX(time)
1 × SELECT `data`
FROM `hdr5j_session`
OTRAS Tablas:
1 × UPDATE `hdr5j_session`
SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1741949069;s:18:\"session.timer.last\";i:1741949069;s:17:\"session.timer.now\";i:1741949069;s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}' , `time` = '1741949069'
1 × UPDATE hdr5j_content
SET hits = hits + 1
1 × UPDATE hdr5j_vvisit_counter
SET visits=visits+1, bots=bots+1
1 × INSERT INTO `hdr5j_session` (`session_id`, `client_id`, `time`)
VALUES ('nqd4pe3v16qhquukpk40g5ugv2', 0, '1741949069'
1 × DELETE
FROM `hdr5j_session`