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

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

UPDATE blog_article SET views = 2100, edited_at = '2026-10-11 19:07:57', searchable = '\"{\\\"createdAt\\\":\\\"14-04-2024\\\",\\\"editedAt\\\":\\\"20-05-2025\\\",\\\"id\\\":\\\"259\\\",\\\"category\\\":\\\"privacy e dintorni\\\",\\\"title\\\":\\\"garanzia di protezione dei dati da parte delle aziende informatiche\\\",\\\"text\\\":\\\"<p>ormai tutti noi, oggi ci affidiamo a fornitori terzi di servizi di elaborazione dei dati, in quanto le aziende tendono a specializzarsi, offrendo <strong>servizi qualificati<\\\\\\/strong> (o almeno si spera), a prezzi a volte competitivi. l&rsquo;esperienza per&ograve; ci dimostra come l&rsquo;affidamento di dati personali a soggetti terzi, lascia molto a desiderare.<\\\\\\/p><p>&nbsp;<\\\\\\/p><h2>qual&rsquo;&egrave; la situazione attuale in europa<\\\\\\/h2><p>un recente studio, ha messo in risalto come sia importante che il titolare del trattamento prenda ogni possibile precauzione in fase di selezione e controllo dell&rsquo;attivit&agrave; di un fornitore di servizi, in quanto &egrave; scaturito che la situazione &egrave; assai <a href=\\\\\\\"https:\\\\\\/\\\\\\/bellero.it\\\\\\/blog-dettaglio\\\\\\/privacy-perche-e-importante\\\\\\\"><strong>preoccupante<\\\\\\/strong><\\\\\\/a>. a fronte di ci&ograve; &egrave; stato creato un elenco di <a href=\\\\\\\"https:\\\\\\/\\\\\\/bellero.it\\\\\\/blog-dettaglio\\\\\\/preoccupazione-per-le-prime-violazioni-dei-dati\\\\\\\"><strong>violazioni<\\\\\\/strong><\\\\\\/a> di dati, affidati in elaborazione a soggetti terzi, nel 2018; tale elenco dimostra che:<\\\\\\/p><ul>\\\\t<li>il 15% dei dati sono stati <a href=\\\\\\\"https:\\\\\\/\\\\\\/bellero.it\\\\\\/blog-dettaglio\\\\\\/come-trattare-i-dati-personali\\\\\\\"><strong>persi o rubati<\\\\\\/strong><\\\\\\/a>;<\\\\\\/li>\\\\t<li>il 21% dei dati sono stati oggetto di attacchi da parte di soggetti terzi malavitosi ed hackers;<\\\\\\/li>\\\\t<li>il 24% dei dati sono stati persi a causa di incidente di origine interna;<\\\\\\/li>\\\\t<li>il 40% dei dati sono stati persi a causa di attacchi provenienti dall&rsquo;esterno.<\\\\\\/li><\\\\\\/ul><p>il danno complessivo, causato da queste violazioni, &egrave; stato stimato intorno ai 3,86 milioni di euro. nel calcolare i costi di queste violazioni non basta calcolare i costi diretti, dovuti ad esempio alla ricostruzione dei dati, ma anche all&rsquo;applicazione di <a href=\\\\\\\"https:\\\\\\/\\\\\\/bellero.it\\\\\\/blog-dettaglio\\\\\\/messaggi-informativi-sulla-videosorveglianza\\\\\\\"><strong>sanzioni<\\\\\\/strong><\\\\\\/a>, da parte delle autorit&agrave; competenti. senza parlare poi della perdita di immagine, che rappresenta un aspetto sempre pi&ugrave; significativo del quadro delle perdite attribuibili alla violazione dei dati.<\\\\\\/p><p>&nbsp;<\\\\\\/p><h3>come comportarsi allora?<\\\\\\/h3><p>non potendo ormai fare a meno di queste aziende informatiche, non ci resta che fare delle raccomandazioni:<\\\\\\/p><ul>\\\\t<li>cercate fornitori che godano di certificazioni specifiche, come ad esempio la en 27000;<\\\\\\/li>\\\\t<li>pretendete dal vostro fornitore la dimostrazione di aderire a codici di condotta convalidati dai garanti;<\\\\\\/li>\\\\t<li>affidate ad una societ&agrave; di <a href=\\\\\\\"https:\\\\\\/\\\\\\/bellero.it\\\\\\/blog-dettaglio\\\\\\/privacy-come-adeguarsi\\\\\\\"><strong>consulenza<\\\\\\/strong><\\\\\\/a> che vi possa assistere in tutti questi passaggi.<\\\\\\/li><\\\\\\/ul>\\\",\\\"metaTitle\\\":\\\"garanzia di protezione dei dati da parte delle aziende informatiche|bellero\\\",\\\"metaDescription\\\":\\\"occorre prestare la massima attenzione a chi gestisce i nostri dati\\\",\\\"publishDate\\\":\\\"17-05-2019\\\",\\\"imageAlt\\\":\\\"a differenza di ci\\\\u00f2 che si pu\\\\u00f2 pensare, la violazione dei dati non \\\\u00e8 cos\\\\u00ec rara \\\",\\\"imageFile\\\":\\\"blog\\\\\\/protezione-dei-dati-delle-aziende-informatiche.jpg\\\",\\\"views\\\":\\\"2100\\\"}\"' WHERE id = 259;

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

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;

"START TRANSACTION"

"START TRANSACTION";