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:05:35' 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 = 2410, edited_at = '2026-10-11 19:05:36', searchable = '\"{\\\"createdAt\\\":\\\"14-04-2024\\\",\\\"editedAt\\\":\\\"20-05-2025\\\",\\\"id\\\":\\\"202\\\",\\\"category\\\":\\\"privacy e dintorni\\\",\\\"title\\\":\\\"come trattare i dati personali\\\",\\\"text\\\":\\\"<p>come prima cosa, si ricorda che la responsabilit&agrave; nel determinare il piano di protezione dei dati personali &egrave; in carico al <strong><a href=\\\\\\\"https:\\\\\\/\\\\\\/bellero.it\\\\\\/blog-dettaglio\\\\\\/il-datore-di-lavoro-d-l\\\\\\\">titolare del trattamento<\\\\\\/a> <\\\\\\/strong>(generalmente nella persona del datore di lavoro), con eventualmente l&rsquo;ausilio dei responsabili del trattamento e del responsabile della protezione dei dati. abbiamo gi&agrave; visto in precedenza come, con l&rsquo;entrata in vigore della nuova normativa sulla <a href=\\\\\\\"https:\\\\\\/\\\\\\/bellero.it\\\\\\/blog-dettaglio\\\\\\/privacy-come-adeguarsi\\\\\\\"><strong>privacy<\\\\\\/strong><\\\\\\/a>, &egrave; necessario adeguare gli standard aziendali garantendo maggior protezione ai dati trattati.<\\\\\\/p><p>&nbsp;<\\\\\\/p><h2>principi generali del trattamento dei dati personali<\\\\\\/h2><p>esistono dei principi, definiti dalla nuova normativa sulla privacy, che definiscono chiaramente quando e come trattare i dati personali. tali principi prevedono:<\\\\\\/p><p>- la liceit&agrave;, correttezza e trasparenza del trattamento, nei confronti dell&rsquo;interessato;<\\\\\\/p><p>- la limitazione della finalit&agrave; del trattamento, compreso l&rsquo;obbligo di assicurare che eventuali trattamenti successivi non siano incompatibili con le finalit&agrave; della raccolta dei dati;<\\\\\\/p><p>- la minimizzazione dei dati che devono essere adeguati pertinenti e limitati a quanto necessario rispetto alle finalit&agrave; del trattamento;<\\\\\\/p><p>- l&rsquo;esattezza e l&rsquo;aggiornamento dei dati, compresa la tempestiva cancellazione dei dati che risultino inesatti rispetto alle finalit&agrave; del trattamento;<\\\\\\/p><p>- la limitazione della conservazione, cio&egrave; la necessit&agrave; di conservare dei dati per un tempo non superiore a quello necessario rispetto agli scopi per i quali &egrave; stato effettuato il trattamento;<\\\\\\/p><p>- l&rsquo;integrit&agrave; e la riservatezza: occorre garantire la sicurezza adeguata dei dati personali oggetto del trattamento.<\\\\\\/p><p>&nbsp;<\\\\\\/p><h3>come proteggere i dati personali<\\\\\\/h3><p>proprio ai fini dell&rsquo;archiviazione e della protezione dei dati personali, vengono spesso utilizzati degli hard disk, dotati di applicativi criptografici incorporati. &egrave; questo uno strumento efficiente ed efficace, che permette di garantire il rispetto di precise esigenze di protezione dei dati, anche se ovviamente esiste qualche limitazione all&rsquo;uso; infatti, il dato rimane protetto solamente quando &egrave; archiviato sull&rsquo;hard disk e non quando viene movimentato e\\\\\\/o utilizzato. ovviamente non esistono mai difese assolute anche se questa sembra essere una valida soluzione violabile solo nel caso in cui un hacker abbia accesso fisico al disco rigido.<\\\\\\/p>\\\",\\\"metaTitle\\\":\\\"come trattare i dati personali|bellero\\\",\\\"metaDescription\\\":\\\"l\'adeguamento alla nuova normativa sulla privacy, prevede anche la definizione delle modalit\\\\u00e0 di protezione dei dati personali\\\",\\\"publishDate\\\":\\\"05-02-2019\\\",\\\"imageAlt\\\":\\\"definire in che modo trattare i dati personali, non \\\\u00e8 pi\\\\u00f9 una scelta, ma bens\\\\u00ec un obbligo\\\",\\\"imageFile\\\":\\\"blog\\\\\\/privacy-e-dati-personali.jpg\\\",\\\"views\\\":\\\"2410\\\"}\"' WHERE id = 202;

"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:05:36' AND b0_.category_id = 18 AND b0_.id <> 202 ORDER BY b0_.id DESC LIMIT 3;