GET https://www.mondogolden.it/cuccioli_disponibili/cucciolo/14/Nathan

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
21.19 ms
(48.03%)
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/14/Nathan' AND g0_.data = '2024-12-23'
Parameters:
[]
13.97 ms
(31.67%)
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/14/Nathan"
]
3.15 ms
(7.13%)
3
"COMMIT"
Parameters:
[]
1.17 ms
(2.64%)
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:
[
  14
]
1.11 ms
(2.51%)
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:
[
  "14"
]
0.71 ms
(1.60%)
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.51 ms
(1.16%)
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.49 ms
(1.12%)
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.45 ms
(1.02%)
3
"START TRANSACTION"
Parameters:
[]
0.39 ms
(0.89%)
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.36 ms
(0.83%)
1
INSERT INTO gest_visite_giornaliere (pagina, contatore, data) VALUES (?, ?, ?)
Parameters:
[
  "/cuccioli_disponibili/cucciolo/14/Nathan"
  "1"
  "2024-12-23 08:48:18"
]
0.31 ms
(0.70%)
1
INSERT INTO gest_pagine (pagina, path, contatore) VALUES (?, ?, ?)
Parameters:
[
  "/cuccioli_disponibili/cucciolo/14/Nathan"
  "app_cucciolo"
  1
]
0.30 ms
(0.68%)
1
UPDATE gest_cuccioli SET contatore = ? WHERE id = ?
Parameters:
[
  579
  14
]

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