GET https://www.mondogolden.it/cuccioli_disponibili/cucciolo/15/Nemo

Query Metrics

21 Database Queries
13 Different statements
28.66 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.34 ms
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.id = ?
Parameters:
[
  "15"
]
2 0.47 ms
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
Parameters:
[
  "/cuccioli_disponibili/cucciolo/15/Nemo"
]
3 0.12 ms
"START TRANSACTION"
Parameters:
[]
4 0.28 ms
UPDATE gest_pagine SET contatore = ? WHERE id = ?
Parameters:
[
  2
  101
]
5 1.16 ms
"COMMIT"
Parameters:
[]
6 18.86 ms
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_disponibili/cucciolo/15/Nemo' AND g0_.data = '2024-12-23'
Parameters:
[]
7 0.21 ms
"START TRANSACTION"
Parameters:
[]
8 1.32 ms
INSERT INTO gest_visite_giornaliere (pagina, contatore, data) VALUES (?, ?, ?)
Parameters:
[
  "/cuccioli_disponibili/cucciolo/15/Nemo"
  "1"
  "2024-12-23 08:53:18"
]
9 0.78 ms
"COMMIT"
Parameters:
[]
10 0.11 ms
"START TRANSACTION"
Parameters:
[]
11 0.26 ms
UPDATE gest_cuccioli SET contatore = ? WHERE id = ?
Parameters:
[
  464
  15
]
12 0.66 ms
"COMMIT"
Parameters:
[]
13 0.30 ms
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
Parameters:
[]
14 0.38 ms
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 = ?
Parameters:
[
  15
]
15 0.35 ms
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 = ?
Parameters:
[
  14
]
16 0.31 ms
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 = ?
Parameters:
[
  2
]
17 0.40 ms
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 = ?
Parameters:
[
  2
]
18 0.29 ms
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 = ?
Parameters:
[
  5
]
19 0.39 ms
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_genitore_id = ?
Parameters:
[
  5
]
20 0.26 ms
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 = ?
Parameters:
[
  4
]
21 0.40 ms
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_genitore_id = ?
Parameters:
[
  4
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping