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:03:00' 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 = 9;

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

UPDATE blog_article SET views = 5011, edited_at = '2026-10-11 19:03:00', searchable = '\"{\\\"createdAt\\\":\\\"14-04-2024\\\",\\\"editedAt\\\":\\\"20-05-2025\\\",\\\"id\\\":\\\"120\\\",\\\"category\\\":\\\"documenti della sicurezza\\\",\\\"title\\\":\\\"la notifica preliminare\\\",\\\"text\\\":\\\"<p>la notifica preliminare &egrave; un documento che deve essere predisposto (nei casi previsti), dal <a href=\\\\\\\"https:\\\\\\/\\\\\\/bellero.it\\\\\\/blog-dettaglio\\\\\\/il-committente\\\\\\\"><strong>committente<\\\\\\/strong><\\\\\\/a> o dal <strong><a href=\\\\\\\"https:\\\\\\/\\\\\\/bellero.it\\\\\\/blog-dettaglio\\\\\\/il-responsabile-dei-lavori\\\\\\\">responsabile dei lavori<\\\\\\/a> <\\\\\\/strong>e inoltrato alla asl territorialmente competente, alla direzione provinciale del lavoro e all&rsquo;ente che rilascia l&rsquo;autorizzazione all&rsquo;apertura del cantiere, prima che i lavori in cantiere abbiano inizio. i contenuti della notifica, sono definiti dalla normativa e sono:<\\\\\\/p><ol>\\\\t<li>data della comunicazione.<\\\\\\/li>\\\\t<li>indirizzo del cantiere.<\\\\\\/li>\\\\t<li>committente (nome, cognome, codice fiscale e indirizzo).<\\\\\\/li>\\\\t<li>natura dell&#39;opera.<\\\\\\/li>\\\\t<li>responsabile dei lavori (nome, cognome, codice fiscale e indirizzo).<\\\\\\/li>\\\\t<li><a href=\\\\\\\"https:\\\\\\/\\\\\\/bellero.it\\\\\\/blog-dettaglio\\\\\\/coordinatore-della-sicurezza-in-fase-di-progettazione\\\\\\\"><strong>coordinatore della sicurezza in fase di progettazione<\\\\\\/strong><\\\\\\/a> dell&#39;opera (nome, cognome, codice fiscale e indirizzo).<\\\\\\/li>\\\\t<li><a href=\\\\\\\"https:\\\\\\/\\\\\\/bellero.it\\\\\\/blog-dettaglio\\\\\\/coordinatore-della-sicurezza-in-fase-di-esecuzione\\\\\\\"><strong>coordinatore della sicurezza in fase di esecuzione<\\\\\\/strong><\\\\\\/a> dell&#39;opera (nome, cognome, codice fiscale e indirizzo).<\\\\\\/li>\\\\t<li>data presunta d&#39;inizio dei lavori in cantiere.<\\\\\\/li>\\\\t<li>durata presunta dei lavori in cantiere.<\\\\\\/li>\\\\t<li>&nbsp;&nbsp; &nbsp;10.numero massimo presunto dei lavoratori sul cantiere.<\\\\\\/li>\\\\t<li>&nbsp;&nbsp; &nbsp;11.numero previsto di imprese e di lavoratori autonomi sul cantiere.<\\\\\\/li>\\\\t<li>&nbsp;&nbsp; &nbsp;12.identificazione, codice fiscale o partita iva, delle imprese gi&agrave; selezionate.<\\\\\\/li>\\\\t<li>&nbsp;&nbsp; &nbsp;13.ammontare complessivo presunto dei lavori (&euro;).<\\\\\\/li><\\\\\\/ol><p>&nbsp;<\\\\\\/p><h2>quando fare la notifica preliminare<\\\\\\/h2><p>la notifica preliminare &egrave; necessaria nei seguenti casi:<\\\\\\/p><p>- nei cantieri in cui &egrave; prevista la presenza di pi&ugrave; imprese esecutrici, anche non contemporanea;<\\\\\\/p><p>- nei cantieri che, inizialmente non soggetti all&rsquo;obbligo di notifica, ricadono nella categoria precedente per effetto di varianti sopravvenute in corso d&rsquo;opera;<\\\\\\/p>-&nbsp;nei cantieri in cui opera un&rsquo;unica impresa la cui entit&agrave; presunta di lavoro non sia inferiore a 200&nbsp;uomini-giorno.<p>una volta trasmessa agli organi preposti ai controlli, una copia della notifica preliminare deve essere affissa&nbsp;in maniera visibile presso il cantiere e custodita&nbsp;a disposizione degli organi di vigilanza territorialmente&nbsp;competenti. nel caso in cui si rendano necessari aggiornamenti, ad esempio perch&eacute; sono state selezionate nuove ditte esecutrici, occorre nuovamente aggiornare la notifica modificando il numero di revisione, trasmetterla nuovamente agli organi preposti ed esporla nuovamente all&rsquo;ingresso del cantiere.<\\\\\\/p>\\\",\\\"metaTitle\\\":\\\"la notifica preliminare|bellero\\\",\\\"metaDescription\\\":\\\"la notifica preliminare per comunicare la selezione di aziende idonee all\'esecuzione dei lavori\\\",\\\"publishDate\\\":\\\"29-05-2018\\\",\\\"imageAlt\\\":\\\"come gestire le notifiche preliminari\\\",\\\"imageFile\\\":\\\"blog\\\\\\/cosa-si-comunica-con-la-notifica-preliminare.png\\\",\\\"views\\\":\\\"5011\\\"}\"' WHERE id = 120;

"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:03:00' AND b0_.category_id = 9 AND b0_.id <> 120 ORDER BY b0_.id DESC LIMIT 3;