- Details
-
Hits: 5118
La presidenta de la Comunidad de Madrid acaba de anunciar a bombo y platillo un Plan de inversiones de los hospitales públicos de la Comunidad, ante este anuncio la Asociación para la Defensa de la Sanidad Pública de Madrid tiene que señalar:
1.- Aunque obviamente es siempre positivo que se hagan inversiones en las abandonadas infraestructuras de los hospitales públicos de la Comunidad, no lo es menos que este anuncio, que habrá que trasladar a los presupuestos, se hace con un plan a 10 años vista, con lo que hablamos de 100 millones anuales para todos los centros hospitalarios de la región, de aprobación hipotética que va a depender de lo que suceda en este periodo de tiempo (resultados electorales, situación económica, etc), es decir se trata de una propuesta con demasiados condicionantes, por otro lado no es la primera vez que se hace un anuncio parecido por parte de la Comunidad sin que se hayan materializado las anteriores promesas.
2.- Por otro lado 10 años de abandono de las infraestructuras hospitalarias precisa de una mayor inversión y de una manera mas inmediata si no queremos que los centros se deterioren mas de lo que están
3.- Finalmente llama la atención que no se mencione en el Plan el antiguo hospital de Puerta de Hierro, edificio que se encuentra en un estado con un grado de elevado de deterioro y avanzando hacia una situación ruinosa (que por cierto, cuya reforma se prometió el año pasado)
En resumen, mucho ruido y pocas nueces, se ve que se van acercando las elecciones y rebrotan las promesas que luego muy probablemente acabaran incumpliéndose.
Asociación para la Defensa de la Sanidad Pública de Madrid
22 de Febrero de 2018
PLG_DEBUG_TITLE
session.counter ⇒ 1
session.timer.start ⇒ 1714838679
session.timer.last ⇒ 1714838679
session.timer.now ⇒ 1714838679
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
10.79 MB (11,310,584 Bytes)
19 Registro Consultas
SELECT `data`
FROM `hdr5j_session`
WHERE `session_id` = 'ruk8p195u5nkdd4oi9q8sk2r87'
DELETE
FROM `hdr5j_session`
WHERE `time` < '1714838079'
SELECT `session_id`
FROM `hdr5j_session`
WHERE `session_id` = 'ruk8p195u5nkdd4oi9q8sk2r87'
LIMIT 0, 1
INSERT INTO `hdr5j_session`
(`session_id`, `client_id`, `time`)
VALUES
('ruk8p195u5nkdd4oi9q8sk2r87', 0, '1714838679')
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=1714839000;
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=1630
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 = 1630
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, m.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_multicategories AS m
on m.aid = a.id
LEFT JOIN hdr5j_categories AS c
on c.id = m.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 m.catid = 78
AND a.id = 1630
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-05-04 16:04:39')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-04 16:04:39')
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=78
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 = 1630
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=78
AND badcats.id is null
GROUP BY c.id
ORDER BY c.lft
UPDATE `hdr5j_session`
SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1714838679;s:18:\"session.timer.last\";i:1714838679;s:17:\"session.timer.now\";i:1714838679;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` = '1714838679'
WHERE `session_id` = 'ruk8p195u5nkdd4oi9q8sk2r87'
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, m.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_multicategories AS m
on m.aid = a.id
LEFT JOIN hdr5j_categories AS c
on c.id = m.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 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 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:1714838679;s:18:\"session.timer.last\";i:1714838679;s:17:\"session.timer.now\";i:1714838679;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` = '1714838679'
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 ('ruk8p195u5nkdd4oi9q8sk2r87', 0, '1714838679'
1 × DELETE
FROM `hdr5j_session`