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

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

UPDATE blog_article SET views = 2259, edited_at = '2026-10-11 19:06:07', searchable = '\"{\\\"createdAt\\\":\\\"14-04-2024\\\",\\\"editedAt\\\":\\\"20-05-2025\\\",\\\"id\\\":\\\"249\\\",\\\"category\\\":\\\"privacy e dintorni\\\",\\\"title\\\":\\\"messaggi informativi sulla videosorveglianza\\\",\\\"text\\\":\\\"<p>e&rsquo; ormai anni che l&rsquo;autorit&agrave; garante ha pensato di mettere a disposizione di tutti i <a href=\\\\\\\"https:\\\\\\/\\\\\\/bellero.it\\\\\\/blog-dettaglio\\\\\\/come-trattare-i-dati-personali\\\\\\\"><strong>titolari del trattamento<\\\\\\/strong><\\\\\\/a> di impianti di videosorveglianza una informativa, da esibire agli interessati prima che essi entrino nel campo ripreso dalle telecamere. all&rsquo;informativa vera e propria, deve sempre seguire un&rsquo;altra informativa, che deve soddisfare i <a href=\\\\\\\"https:\\\\\\/\\\\\\/bellero.it\\\\\\/blog-dettaglio\\\\\\/privacy-perche-e-importante\\\\\\\"><strong>requisiti<\\\\\\/strong><\\\\\\/a> di completezza e immediatezza; quest&rsquo;ultima, ad esempio, deve essere esposta in prossimit&agrave; del punto di accoglienza di visitatori, o nei pressi delle casse dei supermercati. solo cos&igrave; &egrave; possibile rispettare puntualmente l&rsquo;obbligo di informativa agli interessati, prima che essi vengano ripresi. ma non basta!!!<\\\\\\/p><p>&nbsp;<\\\\\\/p><h2>contenuti dell&rsquo;informativa sulla videosorveglianza<\\\\\\/h2><p>l&rsquo;informativa semplificata di cui sopra, deve contenere almeno due informazioni:<\\\\\\/p><ul>\\\\t<li>le ragioni per la quale l&rsquo;impianto di videosorveglianza viene utilizzato;<\\\\\\/li>\\\\t<li>il soggetto cui rivolgersi per ottenere eventuali informazioni.<\\\\\\/li><\\\\\\/ul><p>nonostante gli aspetti fondamentali siano solamente due, l&rsquo;esperienza dimostra che purtroppo spesso tali obblighi non vengono soddisfatti, incappando cos&igrave; nell&rsquo;illecito di omessa od incompleta informazione offerta agli interessati. si ricorda che, con la precedente normativa di riferimento (decreto legislativo 196\\\\\\/2013), pi&ugrave; bonaria dell&rsquo;attuale gdpr, la sanzione per tale <a href=\\\\\\\"https:\\\\\\/\\\\\\/bellero.it\\\\\\/blog-dettaglio\\\\\\/preoccupazione-per-le-prime-violazioni-dei-dati\\\\\\\"><strong>violazione<\\\\\\/strong><\\\\\\/a> era di 6000 &euro;. concludendo, si raccomanda di prestare <a href=\\\\\\\"https:\\\\\\/\\\\\\/bellero.it\\\\\\/blog-dettaglio\\\\\\/privacy-come-adeguarsi\\\\\\\"><strong>attenzione<\\\\\\/strong><\\\\\\/a> all&rsquo;acquisto di cartelli adeguati, che abbiano sufficiente spazio a disposizione per scrivere i due messaggi sopra menzionati; si invita inoltre a scrivere i messaggi con un pennarello di buona qualit&agrave;, la cui traccia non venga cancellata dalla pioggia ed altri agenti atmosferici.<\\\\\\/p>\\\",\\\"metaTitle\\\":\\\"messaggi informativi sulla videosorveglianza|bellero\\\",\\\"metaDescription\\\":\\\"privacy e sistemi di videosorveglianza: vediamo come fare a gestirli correttamente\\\",\\\"publishDate\\\":\\\"03-05-2019\\\",\\\"imageAlt\\\":\\\"ecco come mettere a punto un sistema di videosorveglianza, nel pieno rispetto della nuova normativa sulla privacy \\\",\\\"imageFile\\\":\\\"blog\\\\\\/privacy-e-videosorveglianza.jpg\\\",\\\"views\\\":\\\"2259\\\"}\"' WHERE id = 249;

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;

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

"START TRANSACTION"

"START TRANSACTION";