Symfony Profiler

SELECT
  b0_.created_at AS created_at_0,
  b0_.edited_at AS edited_at_1,
  b0_.id AS id_2,
  b0_.title AS title_3,
  b0_.subtitle AS subtitle_4,
  b0_.text AS text_5,
  b0_.meta_title AS meta_title_6,
  b0_.meta_description AS meta_description_7,
  b0_.publish_date AS publish_date_8,
  b0_.image_alt AS image_alt_9,
  b0_.image_file AS image_file_10,
  b0_.video_url AS video_url_11,
  b0_.views AS views_12,
  b0_.searchable AS searchable_13,
  b0_.created_by_id AS created_by_id_14,
  b0_.edited_by_id AS edited_by_id_15,
  b0_.category_id AS category_id_16
FROM
  blog_article b0_
WHERE
  b0_.publish_date <= ?
ORDER BY
  b0_.id DESC
LIMIT
  999

SELECT b0_.created_at AS created_at_0, b0_.edited_at AS edited_at_1, b0_.id AS id_2, b0_.title AS title_3, b0_.subtitle AS subtitle_4, b0_.text AS text_5, b0_.meta_title AS meta_title_6, b0_.meta_description AS meta_description_7, b0_.publish_date AS publish_date_8, b0_.image_alt AS image_alt_9, b0_.image_file AS image_file_10, b0_.video_url AS video_url_11, b0_.views AS views_12, b0_.searchable AS searchable_13, b0_.created_by_id AS created_by_id_14, b0_.edited_by_id AS edited_by_id_15, b0_.category_id AS category_id_16 FROM blog_article b0_ WHERE b0_.publish_date <= '2026-10-11 19:03:00' ORDER BY b0_.id DESC LIMIT 999;

"START TRANSACTION"

"START TRANSACTION";

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.privacy AS privacy_3,
  t0.searchable AS searchable_4
FROM
  blog_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.privacy AS privacy_3, t0.searchable AS searchable_4 FROM blog_category t0 WHERE t0.id = 18;

UPDATE
  blog_article
SET
  views = ?,
  edited_at = ?,
  searchable = ?
WHERE
  id = ?

UPDATE blog_article SET views = 2342, edited_at = '2026-10-11 19:03:00', searchable = '\"{\\\"createdAt\\\":\\\"14-04-2024\\\",\\\"editedAt\\\":\\\"20-05-2025\\\",\\\"id\\\":\\\"241\\\",\\\"category\\\":\\\"privacy e dintorni\\\",\\\"title\\\":\\\"sanit\\\\u00e0 e privacy\\\",\\\"text\\\":\\\"<p>come possiamo intuire, il mondo della sanit&agrave; &egrave; quello pi&ugrave; delicato per quanto concerne il <a href=\\\\\\\"https:\\\\\\/\\\\\\/bellero.it\\\\\\/blog-dettaglio\\\\\\/come-trattare-i-dati-personali\\\\\\\"><strong>trattamento dei dati personali<\\\\\\/strong><\\\\\\/a> e ci&ograve; spesso pu&ograve; portare a situazioni assai imbarazzanti per i soggetti coinvolti. tutte le ricerche effettuate al mondo, confermano che il mondo della sanit&agrave; &egrave; quello che presenta il <a href=\\\\\\\"https:\\\\\\/\\\\\\/bellero.it\\\\\\/blog-dettaglio\\\\\\/preoccupazione-per-le-prime-violazioni-dei-dati\\\\\\\"><strong>maggior numero di violazioni di dati<\\\\\\/strong><\\\\\\/a> personali, con la relativa applicazione delle sanzioni pi&ugrave; salate.<\\\\\\/p><p>&nbsp;<\\\\\\/p><h2>come fare per migliorare la gestione dei dati sanitari<\\\\\\/h2><p>in italia, qualche passo in avanti &egrave; stato fatto, introducendo ad esempio delle aree di sicurezza agli sportelli di prenotazione delle visite e togliendo le cartelle cliniche posizionate ai piedi del letto di un paziente (in questi casi le <a href=\\\\\\\"https:\\\\\\/\\\\\\/bellero.it\\\\\\/blog-dettaglio\\\\\\/privacy-perche-e-importante\\\\\\\"><strong>violazioni dei dati<\\\\\\/strong><\\\\\\/a> erano all&rsquo;ordine del giorno!!). e&rsquo; comunque necessario fare di pi&ugrave;; ecco <a href=\\\\\\\"https:\\\\\\/\\\\\\/bellero.it\\\\\\/blog-dettaglio\\\\\\/privacy-come-adeguarsi\\\\\\\"><strong>qualche spunto<\\\\\\/strong><\\\\\\/a> che scaturisce dall&rsquo;esame delle ragioni per cui, in varie parti del mondo, si sono registrate delle violazioni:<\\\\\\/p><ul>\\\\t<li>non basta proteggere i dati sanitari, ma anche i dati finanziari associati ad un paziente (per esempio dati relativi alle coperture assicurative);<\\\\\\/li>\\\\t<li>i laboratori di analisi producono dati personali, che a loro volta vengono smistati in varie parti delle strutture sanitarie, aumentando il rischio di perdita dei dati;&nbsp;<\\\\\\/li>\\\\t<li>sarebbe importante creare un documento, che tenga sotto controllo il flusso dei dati, attraverso i numerosissimi enti;<\\\\\\/li>\\\\t<li>occorre prestare molta attenzione a fornire dati a soggetti terzi (come ad esempio cliniche convenzionate, ambulatori e simili), perch&eacute; bisogna essere certi che questi soggetti garantiscano una soddisfacente tutela dei dati trasferiti;<\\\\\\/li>\\\\t<li>occorre tenere sotto controllo stretto tutti gli autorizzati al trattamento (cio&egrave; persone che vedono e utilizzando i dati all&rsquo;interno di una struttura), che possono entrare ed uscire dalla struttura sanitaria. non appena un soggetto autorizzato abbandona la struttura, deve immediatamente essere revocato il suo profilo di accesso al sistema informativo e devono essere attivate procedure che garantiscano che nessun dato sanitario venga asportato dal soggetto in questione.<\\\\\\/li><\\\\\\/ul>\\\",\\\"metaTitle\\\":\\\"sanit\\\\u00e0 e privacy|bellero\\\",\\\"metaDescription\\\":\\\"una fuga di dati, \\\\u00e8 una chiara violazione del nuovo gdpr\\\",\\\"publishDate\\\":\\\"09-04-2019\\\",\\\"imageAlt\\\":\\\"pi\\\\u00f9 i dati forniscono informazioni, pi\\\\u00f9 vanno protetti\\\",\\\"imageFile\\\":\\\"blog\\\\\\/sanita-e-privacy.jpg\\\",\\\"views\\\":\\\"2342\\\"}\"' WHERE id = 241;

"COMMIT"

"COMMIT";

SELECT
  b0_.created_at AS created_at_0,
  b0_.edited_at AS edited_at_1,
  b0_.id AS id_2,
  b0_.title AS title_3,
  b0_.subtitle AS subtitle_4,
  b0_.text AS text_5,
  b0_.meta_title AS meta_title_6,
  b0_.meta_description AS meta_description_7,
  b0_.publish_date AS publish_date_8,
  b0_.image_alt AS image_alt_9,
  b0_.image_file AS image_file_10,
  b0_.video_url AS video_url_11,
  b0_.views AS views_12,
  b0_.searchable AS searchable_13,
  b0_.created_by_id AS created_by_id_14,
  b0_.edited_by_id AS edited_by_id_15,
  b0_.category_id AS category_id_16
FROM
  blog_article b0_
WHERE
  b0_.publish_date <= ?
  AND b0_.category_id = ?
  AND b0_.id <> ?
ORDER BY
  b0_.id DESC
LIMIT
  3

SELECT b0_.created_at AS created_at_0, b0_.edited_at AS edited_at_1, b0_.id AS id_2, b0_.title AS title_3, b0_.subtitle AS subtitle_4, b0_.text AS text_5, b0_.meta_title AS meta_title_6, b0_.meta_description AS meta_description_7, b0_.publish_date AS publish_date_8, b0_.image_alt AS image_alt_9, b0_.image_file AS image_file_10, b0_.video_url AS video_url_11, b0_.views AS views_12, b0_.searchable AS searchable_13, b0_.created_by_id AS created_by_id_14, b0_.edited_by_id AS edited_by_id_15, b0_.category_id AS category_id_16 FROM blog_article b0_ WHERE b0_.publish_date <= '2026-10-11 19:03:00' AND b0_.category_id = 18 AND b0_.id <> 241 ORDER BY b0_.id DESC LIMIT 3;