GET https://www.mondogolden.it/cuccioli_disponibili/cucciolo/16/Nela

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
18.89 ms
(68.38%)
1
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/16/Nela' AND g0_.data = '2024-12-23'
Parameters:
[]
3.15 ms
(11.41%)
3
"COMMIT"
Parameters:
[]
1.06 ms
(3.85%)
1
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:
[
  "16"
]
1.03 ms
(3.73%)
3
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:
[
  16
]
0.73 ms
(2.64%)
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_genitore_id = ?
Parameters:
[
  5
]
0.50 ms
(1.82%)
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 = ?
Parameters:
[
  5
]
0.42 ms
(1.52%)
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 = ? LIMIT 1
Parameters:
[
  "/cuccioli_disponibili/cucciolo/16/Nela"
]
0.36 ms
(1.29%)
3
"START TRANSACTION"
Parameters:
[]
0.36 ms
(1.29%)
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 = ?
Parameters:
[
  2
]
0.29 ms
(1.05%)
1
UPDATE gest_cuccioli SET contatore = ? WHERE id = ?
Parameters:
[
  458
  16
]
0.29 ms
(1.05%)
1
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:
[]
0.29 ms
(1.04%)
1
INSERT INTO gest_visite_giornaliere (pagina, contatore, data) VALUES (?, ?, ?)
Parameters:
[
  "/cuccioli_disponibili/cucciolo/16/Nela"
  "1"
  "2024-12-23 09:01:26"
]
0.26 ms
(0.93%)
1
UPDATE gest_pagine SET contatore = ? WHERE id = ?
Parameters:
[
  3
  100
]

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