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 18:09:09' 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 = 19;

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

UPDATE blog_article SET views = 1977, edited_at = '2026-10-11 18:09:09', searchable = '\"{\\\"createdAt\\\":\\\"14-04-2024\\\",\\\"editedAt\\\":\\\"20-05-2025\\\",\\\"id\\\":\\\"377\\\",\\\"category\\\":\\\"videosorveglianza e privacy\\\",\\\"title\\\":\\\"sistemi di videosorveglianza delle aree pubbliche\\\",\\\"text\\\":\\\"<p>e&rsquo; ormai frequente vedere nei luoghi pubblici, nelle piazze e nelle vie delle <a href=\\\\\\\"https:\\\\\\/\\\\\\/bellero.it\\\\\\/blog-dettaglio\\\\\\/come-predisporre-un-impianto-di-videosorveglianza\\\\\\\"><strong>telecamere<\\\\\\/strong><\\\\\\/a> di videosorveglianza, ma non tutti sanno che il paese al mondo con pi&ugrave; telecamere &egrave; la cina che conta circa una telecamera ogni 7 cittadini, ma l&rsquo;obbiettivo cinese &egrave; destinato ancora a crescere.&nbsp;<\\\\\\/p><p>&nbsp;<\\\\\\/p><h2>applicativi integrati ai sistemi di videosorveglianza<\\\\\\/h2><p>esistono per&ograve; dei sistemi di videosorveglianza, che includono il riconoscimento facciale, aspetto che dal punto di vista della <a href=\\\\\\\"https:\\\\\\/\\\\\\/bellero.it\\\\\\/blog-dettaglio\\\\\\/la-violazione-dei-dati-personali\\\\\\\"><strong>privacy<\\\\\\/strong><\\\\\\/a> ha destato un p&ograve; di scalpore, anche se i benefici di questi applicativi non si sono fatti attendere. infatti, ad esempio in india, le <a href=\\\\\\\"https:\\\\\\/\\\\\\/bellero.it\\\\\\/blog-dettaglio\\\\\\/i-rischi-nell-acquisizione-di-dati-non-necessari\\\\\\\"><strong>telecamere<\\\\\\/strong><\\\\\\/a> con riconoscimento facciale hanno riconosciuto 3000 bambini scomparsi in solo 4 giorni!!!&nbsp;<\\\\\\/p><p>ma gli applicativi sono tanti, cos&igrave; come gli scopi da perseguire; un altro esempio &egrave; quello che riguarda una regione cinese, in cui &egrave; stato installato un applicativo di <a href=\\\\\\\"https:\\\\\\/\\\\\\/bellero.it\\\\\\/blog-dettaglio\\\\\\/messaggi-informativi-sulla-videosorveglianza\\\\\\\"><strong>videosorveglianza<\\\\\\/strong><\\\\\\/a>, che ha come scopo quello di controllare il comportamento dei detenuti durante l&rsquo;ora d&rsquo;aria, segnalando i detenuti che interagiscono fra di loro, per un tempo superiore a quello consentito. sempre in un&rsquo;altra citt&agrave; cinese, &egrave; stato ideato un sistema che permette di&nbsp; monitorare il comportamento del cittadino. ad ogni cittadino viene consegnato un bonus di 100 punti, che vengono aumentati o diminuiti a seconda del comportamento che ha tenuto, come rilevato dalle telecamere. ad esempio, un battibecco con un vicino pu&ograve; portare alla perdita di 5 punti oppure 10 punti se non vengono pulite le deiezioni del cane durante una passeggiata. il punto per&ograve; &egrave; questo: in relazione a tutte queste norme che tendono a <a href=\\\\\\\"https:\\\\\\/\\\\\\/bellero.it\\\\\\/blog-dettaglio\\\\\\/preoccupazione-per-le-prime-violazioni-dei-dati\\\\\\\"><strong>tutelare la privacy<\\\\\\/strong><\\\\\\/a> di ognuno di noi, tali sistemi sono davvero applicabili da tutte le parti? e&rsquo; evidente che la pubblica utilit&agrave; ne abbia un vantaggio da questi sistemi, ma come fanno i disonesti e i furbetti a farla franca? una cosa &egrave; certa: con tutti questi sistemi all&rsquo;avanguardia, &egrave; impossibile non ottenere risultati!<\\\\\\/p><p>&nbsp;<\\\\\\/p><p>e voi cosa ne pensate? fatecelo sapere scrivendo qui sotto!!!<\\\\\\/p>\\\",\\\"metaTitle\\\":\\\"sistemi di videosorveglianza delle aree pubbliche|bellero\\\",\\\"metaDescription\\\":\\\"videosorveglianza e sistemi applicativi di ultima generazione. ma la privacy?\\\",\\\"publishDate\\\":\\\"21-01-2020\\\",\\\"imageAlt\\\":\\\"la tecnologia nei sistemi di videosorveglianza \\\\u00e8 efficace, ma \\\\u00e8 conforme al nuovo regolamento sulla privacy\\\",\\\"imageFile\\\":\\\"blog\\\\\\/videosorveglianza-aree-pubbliche.jpg\\\",\\\"views\\\":\\\"1977\\\"}\"' WHERE id = 377;

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