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:06:09' ORDER BY b0_.id DESC LIMIT 999;

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

UPDATE blog_article SET views = 2262, edited_at = '2026-10-11 19:06:09', searchable = '\"{\\\"createdAt\\\":\\\"14-04-2024\\\",\\\"editedAt\\\":\\\"20-05-2025\\\",\\\"id\\\":\\\"287\\\",\\\"category\\\":\\\"privacy e dintorni\\\",\\\"title\\\":\\\"i rischi nell\\\\u2019acquisizione di dati non necessari\\\",\\\"text\\\":\\\"<p>spesso e volentieri ci capita di &ldquo;dover&rdquo; fornire dei dati che non sono strettamente necessari e connessi alle finalit&agrave; del <a href=\\\\\\\"https:\\\\\\/\\\\\\/bellero.it\\\\\\/blog-dettaglio\\\\\\/come-trattare-i-dati-personali\\\\\\\"><strong>trattamento<\\\\\\/strong><\\\\\\/a> per cui vengono forniti. esistono ad esempio delle aziende che ai fini commerciali, richiedono dei dati che vanno ben oltre lo scopo commerciale del prodotto (et&agrave; del consumatore, attivit&agrave; lavorativa svolta, interessi, ecc&hellip;), ma che condiscono la statistica di <a href=\\\\\\\"https:\\\\\\/\\\\\\/bellero.it\\\\\\/blog-dettaglio\\\\\\/privacy-perche-e-importante\\\\\\\"><strong>informazioni<\\\\\\/strong><\\\\\\/a> secondarie non necessarie che comunque verranno archiviate e custodite. tale atteggiamento non risulta essere troppo in linea con quanto dettato dal nuovo regolamento sulla privacy, che prevede di acquisire solo ed esclusivamente i dati necessari.<\\\\\\/p><p>&nbsp;<\\\\\\/p><h2>in che modo acquisire i dati<\\\\\\/h2><p>i dati raccolti, devono essere minimi necessari per raggiungere le finalit&agrave; del trattamento; in alternativa, altri ulteriori dati risultano essere <a href=\\\\\\\"https:\\\\\\/\\\\\\/bellero.it\\\\\\/blog-dettaglio\\\\\\/sanita-e-privacy\\\\\\\"><strong>eccessivi<\\\\\\/strong><\\\\\\/a>, rispetto alle finalit&agrave; minime desiderate. ci&ograve; accade anche se nell&#39;informativa dell&#39;interessato vengono raccolte notizie in merito a dati aggiuntivi, per il fatto che questi ulteriori dati non sono strettamente connessi alle finalit&agrave; del dichiarante; tale modo di operare potrebbe essere sanzionato dal <a href=\\\\\\\"https:\\\\\\/\\\\\\/bellero.it\\\\\\/blog-dettaglio\\\\\\/privacy-come-vengono-determinate-le-sanzioni\\\\\\\"><strong>garante<\\\\\\/strong><\\\\\\/a> in caso di segnalazione o ispezione.<\\\\\\/p><p>&nbsp;<\\\\\\/p><h3>perch&eacute; acquisire dati supplementari<\\\\\\/h3><p>talvolta, acquisire dati supplementari da parte dell&rsquo;azienda, a condizione che siano stati acquisiti legittimamente, possono consentire al <a href=\\\\\\\"https:\\\\\\/\\\\\\/bellero.it\\\\\\/blog-dettaglio\\\\\\/il-titolare-del-trattamento\\\\\\\"><strong>titolare del trattamento<\\\\\\/strong><\\\\\\/a> di sviluppare nuove iniziative che potrebbero risultare redditizie e molto comode per l&#39;azienda stessa. conoscere usi e costumi delle persone, consente di proporre loro dei prodotti con delle offerte commerciali che possono generare ritorni economici, talvolta di non poco conto. ad esempio l&#39;analisi dei registi di accesso al sito web di un&rsquo;azienda, potrebbe fornire preziose informazioni sulla tipologia degli interessati che accedono e consentire pertanto al titolare di adeguare i contenuti della pagina <a href=\\\\\\\"https:\\\\\\/\\\\\\/bellero.it\\\\\\/blog-dettaglio\\\\\\/garanzia-di-protezione-dei-dati-da-parte-delle-aziende-informatiche\\\\\\\"><strong>web<\\\\\\/strong><\\\\\\/a>, in modo da soddisfare le specifiche esigenze degli utenti. ecco perch&eacute; i dati oscuri possono rappresentare una vera e propria opportunit&agrave; per il titolare del trattamento, anche se, gestiti male, potrebbero rivelarsi un grosso problema.<\\\\\\/p>\\\",\\\"metaTitle\\\":\\\"i rischi nell\\\\u2019acquisizione di dati non necessari|bellero\\\",\\\"metaDescription\\\":\\\"acquisire dati non necessari, comporta un rischio e un\'opportunit\\\\u00e0: occorre pertanto gestire il processo di raccolta e archiviazione in modo corretto\\\",\\\"publishDate\\\":\\\"12-07-2019\\\",\\\"imageAlt\\\":\\\"attenzione ad acquisire dati non strettamente necessari\\\",\\\"imageFile\\\":\\\"blog\\\\\\/laptop-3196481-480.jpg\\\",\\\"views\\\":\\\"2262\\\"}\"' WHERE id = 287;

"COMMIT"

"COMMIT";

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;

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:06:09' AND b0_.category_id = 18 AND b0_.id <> 287 ORDER BY b0_.id DESC LIMIT 3;

"START TRANSACTION"

"START TRANSACTION";