GET https://www.mondogolden.it/cuccioli_disponibili/cucciolo/2/Pedro

Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.75 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:
[
  "2"
]
2 0.69 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/2/Pedro"
]
3 0.21 ms
"START TRANSACTION"
Parameters:
[]
4 0.44 ms
UPDATE gest_pagine SET contatore = ? WHERE id = ?
Parameters:
[
  92
  1
]
5 1.31 ms
"COMMIT"
Parameters:
[]
6 19.98 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/2/Pedro' AND g0_.data = '2024-12-23'
Parameters:
[]
7 0.18 ms
"START TRANSACTION"
Parameters:
[]
8 0.36 ms
INSERT INTO gest_visite_giornaliere (pagina, contatore, data) VALUES (?, ?, ?)
Parameters:
[
  "/cuccioli_disponibili/cucciolo/2/Pedro"
  "1"
  "2024-12-23 08:22:27"
]
9 1.09 ms
"COMMIT"
Parameters:
[]
10 0.12 ms
"START TRANSACTION"
Parameters:
[]
11 0.31 ms
UPDATE gest_cuccioli SET contatore = ? WHERE id = ?
Parameters:
[
  764
  2
]
12 0.75 ms
"COMMIT"
Parameters:
[]
13 0.33 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.52 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
]
15 0.32 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:
[
  5
]
16 0.33 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:
[
  12
]
17 0.69 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:
[
  1
]
18 0.31 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:
[
  8
]
19 0.37 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:
[
  8
]
20 0.28 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:
[
  7
]
21 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_genitore_id = ?
Parameters:
[
  7
]

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