https://ginocortelazzonuovo.devlancer.it/bibliografia/elenco

Method
GET
HTTP Status
200
IP
216.73.216.59
Profiled on
Token
475115

Query Metrics

5 Database Queries
3 Different statements
7.63 ms Query time
5 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 4.83 ms 
SELECT t0.titolo AS titolo_1, t0.descrizione AS descrizione_2, t0.autore AS autore_3, t0.luogo AS luogo_4, t0.tipo AS tipo_5, t0.editore AS editore_6, t0.anno AS anno_7, t0.mese AS mese_8, t0.pagina AS pagina_9, t0.id AS id_10, t0.numero_progressivo AS numero_progressivo_11, t0.cover AS cover_12, t0.file AS file_13 FROM documento t0 WHERE t0.tipo IN (?) ORDER BY t0.anno ASC, t0.numero_progressivo ASC
Parameters: 
[
  [
    "monografia"
    "catalogo"
  ]
]
View formatted query    View runnable query    Explain query
2 0.82 ms 
SELECT t0.titolo AS titolo_1, t0.descrizione AS descrizione_2, t0.autore AS autore_3, t0.luogo AS luogo_4, t0.tipo AS tipo_5, t0.editore AS editore_6, t0.anno AS anno_7, t0.mese AS mese_8, t0.pagina AS pagina_9, t0.id AS id_10, t0.numero_progressivo AS numero_progressivo_11, t0.cover AS cover_12, t0.file AS file_13 FROM documento t0 WHERE t0.tipo = ? ORDER BY t0.anno ASC, t0.numero_progressivo ASC
Parameters: 
[
  "catalogo"
]
View formatted query    View runnable query    Explain query
3 0.41 ms 
SELECT t0.titolo AS titolo_1, t0.descrizione AS descrizione_2, t0.autore AS autore_3, t0.luogo AS luogo_4, t0.tipo AS tipo_5, t0.editore AS editore_6, t0.anno AS anno_7, t0.mese AS mese_8, t0.pagina AS pagina_9, t0.id AS id_10, t0.numero_progressivo AS numero_progressivo_11, t0.cover AS cover_12, t0.file AS file_13 FROM documento t0 WHERE t0.tipo = ? ORDER BY t0.anno ASC, t0.numero_progressivo ASC
Parameters: 
[
  "libro"
]
View formatted query    View runnable query    Explain query
4 0.42 ms 
SELECT t0.titolo AS titolo_1, t0.descrizione AS descrizione_2, t0.autore AS autore_3, t0.luogo AS luogo_4, t0.tipo AS tipo_5, t0.editore AS editore_6, t0.anno AS anno_7, t0.mese AS mese_8, t0.pagina AS pagina_9, t0.id AS id_10, t0.numero_progressivo AS numero_progressivo_11, t0.cover AS cover_12, t0.file AS file_13 FROM documento t0 WHERE t0.tipo = ? ORDER BY t0.anno ASC, t0.numero_progressivo ASC
Parameters: 
[
  "rivista"
]
View formatted query    View runnable query    Explain query
5 1.15 ms 
SELECT t0.titolo AS titolo_1, t0.autore AS autore_2, t0.sintesi AS sintesi_3, t0.immaginearticolo AS immaginearticolo_4, t0.selected AS selected_5, t0.anno AS anno_6, t0.mese AS mese_7, t0.giorno AS giorno_8, t0.id AS id_9, t0.pagina AS pagina_10, t0.idgiornale AS idgiornale_11, t0.idmostra AS idmostra_12 FROM articolo t0 ORDER BY t0.anno ASC, t0.mese ASC, t0.giorno ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query

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

Class Mapping errors
App\Entity\Documento
  • The field App\Entity\Documento#idopera is on the owning side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Opera# does not contain the required 'inversedBy' attribute.
App\Entity\Multimedia No errors.
App\Entity\Opera
  • The field App\Entity\Opera#idarticolo is on the owning side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Articolo# does not contain the required 'inversedBy' attribute.
  • The field App\Entity\Opera#idmostra is on the owning side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Mostra# does not contain the required 'inversedBy' attribute.
  • The field App\Entity\Opera#iddocumento is on the owning side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Documento# does not contain the required 'inversedBy' attribute.
App\Entity\Articolo
  • The field App\Entity\Articolo#idopera is on the owning side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Opera# does not contain the required 'inversedBy' attribute.
App\Entity\Giornale No errors.
App\Entity\Mostra
  • The field App\Entity\Mostra#idopera is on the owning side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Opera# does not contain the required 'inversedBy' attribute.
  • The association App\Entity\Mostra#iddocumento refers to the inverse side field App\Entity\Documento#idmostra which does not exist.
  • The field App\Entity\Mostra#idarticolo is on the owning side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Articolo# does not contain the required 'inversedBy' attribute.
  • If association App\Entity\Mostra#idarticolo is many-to-many, then the inversed side App\Entity\Articolo#idmostra has to be many-to-many as well.
App\Entity\Bibliografia
  • The association App\Entity\Bibliografia#documents refers to the inverse side field App\Entity\Documento#bibliografy which does not exist.