Symfony Profiler

SELECT
  MAX(g0_.contatore) AS sclr_0
FROM
  gest_visitatori g0_
WHERE
  g0_.data = '2024-12-23'

SELECT MAX(g0_.contatore) AS sclr_0 FROM gest_visitatori g0_ WHERE g0_.data = '2024-12-23';

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO gest_visitatori (referer, ip, data, ora, contatore)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO gest_visitatori (referer, ip, data, ora, contatore) VALUES ('https://www.mondogolden.it/cuccioli', '18.119.28.173', '2024-12-23 04:22:39', '2024-12-23 04:22:00', 1);

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.pagina AS pagina_2,
  t0.path AS path_3,
  t0.contatore AS contatore_4
FROM
  gest_pagine t0
WHERE
  t0.pagina = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.pagina AS pagina_2, t0.path AS path_3, t0.contatore AS contatore_4 FROM gest_pagine t0 WHERE t0.pagina = '/cuccioli/' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  gest_pagine
SET
  contatore = ?
WHERE
  id = ?

UPDATE gest_pagine SET contatore = 553 WHERE id = 7;

"COMMIT"

"COMMIT";

SELECT
  g0_.id AS id_0,
  g0_.pagina AS pagina_1,
  g0_.contatore AS contatore_2,
  g0_.data AS data_3
FROM
  gest_visite_giornaliere g0_
WHERE
  g0_.pagina = '/cuccioli/'
  AND g0_.data = '2024-12-23'

SELECT g0_.id AS id_0, g0_.pagina AS pagina_1, g0_.contatore AS contatore_2, g0_.data AS data_3 FROM gest_visite_giornaliere g0_ WHERE g0_.pagina = '/cuccioli/' AND g0_.data = '2024-12-23';

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO gest_visite_giornaliere (pagina, contatore, data)
VALUES
  (?, ?, ?)

INSERT INTO gest_visite_giornaliere (pagina, contatore, data) VALUES ('/cuccioli/', '1', '2024-12-23 04:22:39');

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.nome AS nome_2,
  t0.sesso AS sesso_3,
  t0.colore AS colore_4,
  t0.stato AS stato_5,
  t0.prezzo AS prezzo_6,
  t0.contatore AS contatore_7,
  t0.cucciolata_id AS cucciolata_id_8
FROM
  gest_cuccioli t0
WHERE
  t0.stato = ?
ORDER BY
  t0.contatore DESC

SELECT t0.id AS id_1, t0.nome AS nome_2, t0.sesso AS sesso_3, t0.colore AS colore_4, t0.stato AS stato_5, t0.prezzo AS prezzo_6, t0.contatore AS contatore_7, t0.cucciolata_id AS cucciolata_id_8 FROM gest_cuccioli t0 WHERE t0.stato = 'disponibile' ORDER BY t0.contatore DESC;

SELECT
  t0.id AS id_1,
  t0.titolo AS titolo_2,
  t0.testo AS testo_3,
  t0.data_annuncio AS data_annuncio_4,
  t0.attivo AS attivo_5,
  t0.id_cucciolata_id AS id_cucciolata_id_6
FROM
  gest_annunci t0
WHERE
  t0.attivo = ?

SELECT t0.id AS id_1, t0.titolo AS titolo_2, t0.testo AS testo_3, t0.data_annuncio AS data_annuncio_4, t0.attivo AS attivo_5, t0.id_cucciolata_id AS id_cucciolata_id_6 FROM gest_annunci t0 WHERE t0.attivo = 1;

SELECT
  t0.id AS id_1,
  t0.numero_cuccioli AS numero_cuccioli_2,
  t0.youtube AS youtube_3,
  t0.madre_id AS madre_id_4,
  t0.padre_id AS padre_id_5,
  t0.foto_madre_id AS foto_madre_id_6,
  t0.foto_padre_id AS foto_padre_id_7,
  t8.id AS id_9,
  t8.titolo AS titolo_10,
  t8.testo AS testo_11,
  t8.data_annuncio AS data_annuncio_12,
  t8.attivo AS attivo_13,
  t8.id_cucciolata_id AS id_cucciolata_id_14
FROM
  gest_cucciolate t0
  LEFT JOIN gest_annunci t8 ON t8.id_cucciolata_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.numero_cuccioli AS numero_cuccioli_2, t0.youtube AS youtube_3, t0.madre_id AS madre_id_4, t0.padre_id AS padre_id_5, t0.foto_madre_id AS foto_madre_id_6, t0.foto_padre_id AS foto_padre_id_7, t8.id AS id_9, t8.titolo AS titolo_10, t8.testo AS testo_11, t8.data_annuncio AS data_annuncio_12, t8.attivo AS attivo_13, t8.id_cucciolata_id AS id_cucciolata_id_14 FROM gest_cucciolate t0 LEFT JOIN gest_annunci t8 ON t8.id_cucciolata_id = t0.id WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.nome AS nome_2,
  t0.sesso AS sesso_3,
  t0.descrizione AS descrizione_4,
  t0.attivo AS attivo_5
FROM
  gest_adulti t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nome AS nome_2, t0.sesso AS sesso_3, t0.descrizione AS descrizione_4, t0.attivo AS attivo_5 FROM gest_adulti t0 WHERE t0.id = 8;

SELECT
  t0.id AS id_1,
  t0.nome AS nome_2,
  t0.sesso AS sesso_3,
  t0.descrizione AS descrizione_4,
  t0.attivo AS attivo_5
FROM
  gest_adulti t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nome AS nome_2, t0.sesso AS sesso_3, t0.descrizione AS descrizione_4, t0.attivo AS attivo_5 FROM gest_adulti t0 WHERE t0.id = 7;

SELECT
  t0.id AS id_1,
  t0.nome AS nome_2,
  t0.sesso AS sesso_3,
  t0.colore AS colore_4,
  t0.stato AS stato_5,
  t0.prezzo AS prezzo_6,
  t0.contatore AS contatore_7,
  t0.cucciolata_id AS cucciolata_id_8
FROM
  gest_cuccioli t0
WHERE
  t0.cucciolata_id = ?

SELECT t0.id AS id_1, t0.nome AS nome_2, t0.sesso AS sesso_3, t0.colore AS colore_4, t0.stato AS stato_5, t0.prezzo AS prezzo_6, t0.contatore AS contatore_7, t0.cucciolata_id AS cucciolata_id_8 FROM gest_cuccioli t0 WHERE t0.cucciolata_id = 1;

SELECT
  t0.id AS id_1,
  t0.titolo AS titolo_2,
  t0.nome_foto AS nome_foto_3,
  t0.nome_foto_webp AS nome_foto_webp_4,
  t0.link_youtube AS link_youtube_5,
  t0.tipo AS tipo_6,
  t0.myme AS myme_7,
  t0.attivo AS attivo_8,
  t0.update_at AS update_at_9,
  t0.foto_cucciolo_id AS foto_cucciolo_id_10,
  t0.foto_genitore_id AS foto_genitore_id_11,
  t0.foto_cucciolata_id AS foto_cucciolata_id_12
FROM
  gest_foto t0
WHERE
  t0.foto_cucciolo_id = ?

SELECT t0.id AS id_1, t0.titolo AS titolo_2, t0.nome_foto AS nome_foto_3, t0.nome_foto_webp AS nome_foto_webp_4, t0.link_youtube AS link_youtube_5, t0.tipo AS tipo_6, t0.myme AS myme_7, t0.attivo AS attivo_8, t0.update_at AS update_at_9, t0.foto_cucciolo_id AS foto_cucciolo_id_10, t0.foto_genitore_id AS foto_genitore_id_11, t0.foto_cucciolata_id AS foto_cucciolata_id_12 FROM gest_foto t0 WHERE t0.foto_cucciolo_id = 1;

SELECT
  t0.id AS id_1,
  t0.titolo AS titolo_2,
  t0.nome_foto AS nome_foto_3,
  t0.nome_foto_webp AS nome_foto_webp_4,
  t0.link_youtube AS link_youtube_5,
  t0.tipo AS tipo_6,
  t0.myme AS myme_7,
  t0.attivo AS attivo_8,
  t0.update_at AS update_at_9,
  t0.foto_cucciolo_id AS foto_cucciolo_id_10,
  t0.foto_genitore_id AS foto_genitore_id_11,
  t0.foto_cucciolata_id AS foto_cucciolata_id_12
FROM
  gest_foto t0
WHERE
  t0.foto_cucciolo_id = ?

SELECT t0.id AS id_1, t0.titolo AS titolo_2, t0.nome_foto AS nome_foto_3, t0.nome_foto_webp AS nome_foto_webp_4, t0.link_youtube AS link_youtube_5, t0.tipo AS tipo_6, t0.myme AS myme_7, t0.attivo AS attivo_8, t0.update_at AS update_at_9, t0.foto_cucciolo_id AS foto_cucciolo_id_10, t0.foto_genitore_id AS foto_genitore_id_11, t0.foto_cucciolata_id AS foto_cucciolata_id_12 FROM gest_foto t0 WHERE t0.foto_cucciolo_id = 2;

SELECT
  t0.id AS id_1,
  t0.titolo AS titolo_2,
  t0.nome_foto AS nome_foto_3,
  t0.nome_foto_webp AS nome_foto_webp_4,
  t0.link_youtube AS link_youtube_5,
  t0.tipo AS tipo_6,
  t0.myme AS myme_7,
  t0.attivo AS attivo_8,
  t0.update_at AS update_at_9,
  t0.foto_cucciolo_id AS foto_cucciolo_id_10,
  t0.foto_genitore_id AS foto_genitore_id_11,
  t0.foto_cucciolata_id AS foto_cucciolata_id_12
FROM
  gest_foto t0
WHERE
  t0.foto_cucciolo_id = ?

SELECT t0.id AS id_1, t0.titolo AS titolo_2, t0.nome_foto AS nome_foto_3, t0.nome_foto_webp AS nome_foto_webp_4, t0.link_youtube AS link_youtube_5, t0.tipo AS tipo_6, t0.myme AS myme_7, t0.attivo AS attivo_8, t0.update_at AS update_at_9, t0.foto_cucciolo_id AS foto_cucciolo_id_10, t0.foto_genitore_id AS foto_genitore_id_11, t0.foto_cucciolata_id AS foto_cucciolata_id_12 FROM gest_foto t0 WHERE t0.foto_cucciolo_id = 5;

SELECT
  t0.id AS id_1,
  t0.titolo AS titolo_2,
  t0.nome_foto AS nome_foto_3,
  t0.nome_foto_webp AS nome_foto_webp_4,
  t0.link_youtube AS link_youtube_5,
  t0.tipo AS tipo_6,
  t0.myme AS myme_7,
  t0.attivo AS attivo_8,
  t0.update_at AS update_at_9,
  t0.foto_cucciolo_id AS foto_cucciolo_id_10,
  t0.foto_genitore_id AS foto_genitore_id_11,
  t0.foto_cucciolata_id AS foto_cucciolata_id_12
FROM
  gest_foto t0
WHERE
  t0.foto_cucciolo_id = ?

SELECT t0.id AS id_1, t0.titolo AS titolo_2, t0.nome_foto AS nome_foto_3, t0.nome_foto_webp AS nome_foto_webp_4, t0.link_youtube AS link_youtube_5, t0.tipo AS tipo_6, t0.myme AS myme_7, t0.attivo AS attivo_8, t0.update_at AS update_at_9, t0.foto_cucciolo_id AS foto_cucciolo_id_10, t0.foto_genitore_id AS foto_genitore_id_11, t0.foto_cucciolata_id AS foto_cucciolata_id_12 FROM gest_foto t0 WHERE t0.foto_cucciolo_id = 18;

SELECT
  t0.id AS id_1,
  t0.numero_cuccioli AS numero_cuccioli_2,
  t0.youtube AS youtube_3,
  t0.madre_id AS madre_id_4,
  t0.padre_id AS padre_id_5,
  t0.foto_madre_id AS foto_madre_id_6,
  t0.foto_padre_id AS foto_padre_id_7,
  t8.id AS id_9,
  t8.titolo AS titolo_10,
  t8.testo AS testo_11,
  t8.data_annuncio AS data_annuncio_12,
  t8.attivo AS attivo_13,
  t8.id_cucciolata_id AS id_cucciolata_id_14
FROM
  gest_cucciolate t0
  LEFT JOIN gest_annunci t8 ON t8.id_cucciolata_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.numero_cuccioli AS numero_cuccioli_2, t0.youtube AS youtube_3, t0.madre_id AS madre_id_4, t0.padre_id AS padre_id_5, t0.foto_madre_id AS foto_madre_id_6, t0.foto_padre_id AS foto_padre_id_7, t8.id AS id_9, t8.titolo AS titolo_10, t8.testo AS testo_11, t8.data_annuncio AS data_annuncio_12, t8.attivo AS attivo_13, t8.id_cucciolata_id AS id_cucciolata_id_14 FROM gest_cucciolate t0 LEFT JOIN gest_annunci t8 ON t8.id_cucciolata_id = t0.id WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.nome AS nome_2,
  t0.sesso AS sesso_3,
  t0.descrizione AS descrizione_4,
  t0.attivo AS attivo_5
FROM
  gest_adulti t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nome AS nome_2, t0.sesso AS sesso_3, t0.descrizione AS descrizione_4, t0.attivo AS attivo_5 FROM gest_adulti t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.nome AS nome_2,
  t0.sesso AS sesso_3,
  t0.descrizione AS descrizione_4,
  t0.attivo AS attivo_5
FROM
  gest_adulti t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nome AS nome_2, t0.sesso AS sesso_3, t0.descrizione AS descrizione_4, t0.attivo AS attivo_5 FROM gest_adulti t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.nome AS nome_2,
  t0.sesso AS sesso_3,
  t0.colore AS colore_4,
  t0.stato AS stato_5,
  t0.prezzo AS prezzo_6,
  t0.contatore AS contatore_7,
  t0.cucciolata_id AS cucciolata_id_8
FROM
  gest_cuccioli t0
WHERE
  t0.cucciolata_id = ?

SELECT t0.id AS id_1, t0.nome AS nome_2, t0.sesso AS sesso_3, t0.colore AS colore_4, t0.stato AS stato_5, t0.prezzo AS prezzo_6, t0.contatore AS contatore_7, t0.cucciolata_id AS cucciolata_id_8 FROM gest_cuccioli t0 WHERE t0.cucciolata_id = 2;

SELECT
  t0.id AS id_1,
  t0.titolo AS titolo_2,
  t0.nome_foto AS nome_foto_3,
  t0.nome_foto_webp AS nome_foto_webp_4,
  t0.link_youtube AS link_youtube_5,
  t0.tipo AS tipo_6,
  t0.myme AS myme_7,
  t0.attivo AS attivo_8,
  t0.update_at AS update_at_9,
  t0.foto_cucciolo_id AS foto_cucciolo_id_10,
  t0.foto_genitore_id AS foto_genitore_id_11,
  t0.foto_cucciolata_id AS foto_cucciolata_id_12
FROM
  gest_foto t0
WHERE
  t0.foto_cucciolo_id = ?

SELECT t0.id AS id_1, t0.titolo AS titolo_2, t0.nome_foto AS nome_foto_3, t0.nome_foto_webp AS nome_foto_webp_4, t0.link_youtube AS link_youtube_5, t0.tipo AS tipo_6, t0.myme AS myme_7, t0.attivo AS attivo_8, t0.update_at AS update_at_9, t0.foto_cucciolo_id AS foto_cucciolo_id_10, t0.foto_genitore_id AS foto_genitore_id_11, t0.foto_cucciolata_id AS foto_cucciolata_id_12 FROM gest_foto t0 WHERE t0.foto_cucciolo_id = 12;

SELECT
  t0.id AS id_1,
  t0.titolo AS titolo_2,
  t0.nome_foto AS nome_foto_3,
  t0.nome_foto_webp AS nome_foto_webp_4,
  t0.link_youtube AS link_youtube_5,
  t0.tipo AS tipo_6,
  t0.myme AS myme_7,
  t0.attivo AS attivo_8,
  t0.update_at AS update_at_9,
  t0.foto_cucciolo_id AS foto_cucciolo_id_10,
  t0.foto_genitore_id AS foto_genitore_id_11,
  t0.foto_cucciolata_id AS foto_cucciolata_id_12
FROM
  gest_foto t0
WHERE
  t0.foto_cucciolo_id = ?

SELECT t0.id AS id_1, t0.titolo AS titolo_2, t0.nome_foto AS nome_foto_3, t0.nome_foto_webp AS nome_foto_webp_4, t0.link_youtube AS link_youtube_5, t0.tipo AS tipo_6, t0.myme AS myme_7, t0.attivo AS attivo_8, t0.update_at AS update_at_9, t0.foto_cucciolo_id AS foto_cucciolo_id_10, t0.foto_genitore_id AS foto_genitore_id_11, t0.foto_cucciolata_id AS foto_cucciolata_id_12 FROM gest_foto t0 WHERE t0.foto_cucciolo_id = 13;