GET https://admin2.museidiroma.eu/public/opere_elenco?id=128

Query Metrics

5 Database Queries
5 Different statements
4.49 ms Query time
0 Invalid entities
16 Managed entities

Queries

Group similar statements

# Time Info
1 0.28 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nome AS nome_5 FROM utente t0 WHERE t0.id = ?
Parameters:
[
  1
]
2 0.14 ms
SELECT t0.id AS id_1, t0.nome AS nome_2, t0.indirizzo AS indirizzo_3, t0.numero_civico AS numero_civico_4, t0.cap AS cap_5, t0.citta AS citta_6, t0.sito AS sito_7, t0.email AS email_8, t0.latitudine AS latitudine_9, t0.longitudine AS longitudine_10, t0.logo AS logo_11, t0.telefono AS telefono_12, t0.fax AS fax_13, t0.categoria_id AS categoria_id_14 FROM museo t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "128"
]
3 0.20 ms
SELECT count(DISTINCT o0_.id) AS sclr_0 FROM opera o0_ WHERE o0_.museo_id = ?
Parameters:
[
  "128"
]
4 0.14 ms
SELECT DISTINCT o0_.id AS id_0, o0_.titolo AS titolo_1 FROM opera o0_ WHERE o0_.museo_id = ? ORDER BY o0_.titolo ASC LIMIT 30
Parameters:
[
  "128"
]
5 3.74 ms
SELECT o0_.id AS id_0, o0_.titolo AS titolo_1, o0_.url AS url_2, o0_.immagine AS immagine_3, o0_.descrizione AS descrizione_4, o0_.autore AS autore_5, o0_.tipo_immagine AS tipo_immagine_6, o0_.museo_id AS museo_id_7 FROM opera o0_ WHERE o0_.museo_id = ? AND o0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY o0_.titolo ASC
Parameters:
[
  "128"
  9
  5
  6
  12
  15
  13
  17
  8
  7
  14
  10
  16
  11
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Opera 13
App\Entity\Utente 1
App\Entity\Museo 1
App\Entity\Categoria 1

Entities Mapping

Class Mapping errors
App\Entity\Utente No errors.
App\Entity\Museo No errors.
App\Entity\Categoria No errors.
App\Entity\Mostra No errors.
App\Entity\Opera No errors.