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

Method
GET
HTTP Status
200
IP
216.73.216.59
Profiled on
Token
14e72e

Query Metrics

13 Database Queries
4 Different statements
10.73 ms Query time
5 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 3.93 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.96 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.44 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.49 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.61 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
6 1.16 ms 
SELECT t0.nome AS nome_1, t0.medium AS medium_2, t0.descrizione AS descrizione_3, t0.note AS note_4, t0.anno AS anno_5, t0.numprogressivoanno AS numprogressivoanno_6, t0.widthNormal AS widthnormal_7, t0.heightNormal AS heightnormal_8, t0.widthBig AS widthbig_9, t0.heightBig AS heightbig_10, t0.widthThumbnail AS widththumbnail_11, t0.heightThumbnail AS heightthumbnail_12, t0.tipo AS tipo_13, t0.fileref AS fileref_14, t0.estensione AS estensione_15, t0.datacreazione AS datacreazione_16, t0.id AS id_17, t0.idtipoopera AS idtipoopera_18 FROM multimedia t0 WHERE t0.id = ?
Parameters: 
[
  4016
]
View formatted query    View runnable query    Explain query
7 0.36 ms 
SELECT t0.nome AS nome_1, t0.medium AS medium_2, t0.descrizione AS descrizione_3, t0.note AS note_4, t0.anno AS anno_5, t0.numprogressivoanno AS numprogressivoanno_6, t0.widthNormal AS widthnormal_7, t0.heightNormal AS heightnormal_8, t0.widthBig AS widthbig_9, t0.heightBig AS heightbig_10, t0.widthThumbnail AS widththumbnail_11, t0.heightThumbnail AS heightthumbnail_12, t0.tipo AS tipo_13, t0.fileref AS fileref_14, t0.estensione AS estensione_15, t0.datacreazione AS datacreazione_16, t0.id AS id_17, t0.idtipoopera AS idtipoopera_18 FROM multimedia t0 WHERE t0.id = ?
Parameters: 
[
  3982
]
View formatted query    View runnable query    Explain query
8 0.35 ms 
SELECT t0.nome AS nome_1, t0.medium AS medium_2, t0.descrizione AS descrizione_3, t0.note AS note_4, t0.anno AS anno_5, t0.numprogressivoanno AS numprogressivoanno_6, t0.widthNormal AS widthnormal_7, t0.heightNormal AS heightnormal_8, t0.widthBig AS widthbig_9, t0.heightBig AS heightbig_10, t0.widthThumbnail AS widththumbnail_11, t0.heightThumbnail AS heightthumbnail_12, t0.tipo AS tipo_13, t0.fileref AS fileref_14, t0.estensione AS estensione_15, t0.datacreazione AS datacreazione_16, t0.id AS id_17, t0.idtipoopera AS idtipoopera_18 FROM multimedia t0 WHERE t0.id = ?
Parameters: 
[
  3367
]
View formatted query    View runnable query    Explain query
9 0.28 ms 
SELECT t0.nome AS nome_1, t0.medium AS medium_2, t0.descrizione AS descrizione_3, t0.note AS note_4, t0.anno AS anno_5, t0.numprogressivoanno AS numprogressivoanno_6, t0.widthNormal AS widthnormal_7, t0.heightNormal AS heightnormal_8, t0.widthBig AS widthbig_9, t0.heightBig AS heightbig_10, t0.widthThumbnail AS widththumbnail_11, t0.heightThumbnail AS heightthumbnail_12, t0.tipo AS tipo_13, t0.fileref AS fileref_14, t0.estensione AS estensione_15, t0.datacreazione AS datacreazione_16, t0.id AS id_17, t0.idtipoopera AS idtipoopera_18 FROM multimedia t0 WHERE t0.id = ?
Parameters: 
[
  3366
]
View formatted query    View runnable query    Explain query
10 0.32 ms 
SELECT t0.nome AS nome_1, t0.medium AS medium_2, t0.descrizione AS descrizione_3, t0.note AS note_4, t0.anno AS anno_5, t0.numprogressivoanno AS numprogressivoanno_6, t0.widthNormal AS widthnormal_7, t0.heightNormal AS heightnormal_8, t0.widthBig AS widthbig_9, t0.heightBig AS heightbig_10, t0.widthThumbnail AS widththumbnail_11, t0.heightThumbnail AS heightthumbnail_12, t0.tipo AS tipo_13, t0.fileref AS fileref_14, t0.estensione AS estensione_15, t0.datacreazione AS datacreazione_16, t0.id AS id_17, t0.idtipoopera AS idtipoopera_18 FROM multimedia t0 WHERE t0.id = ?
Parameters: 
[
  3368
]
View formatted query    View runnable query    Explain query
11 0.30 ms 
SELECT t0.nome AS nome_1, t0.medium AS medium_2, t0.descrizione AS descrizione_3, t0.note AS note_4, t0.anno AS anno_5, t0.numprogressivoanno AS numprogressivoanno_6, t0.widthNormal AS widthnormal_7, t0.heightNormal AS heightnormal_8, t0.widthBig AS widthbig_9, t0.heightBig AS heightbig_10, t0.widthThumbnail AS widththumbnail_11, t0.heightThumbnail AS heightthumbnail_12, t0.tipo AS tipo_13, t0.fileref AS fileref_14, t0.estensione AS estensione_15, t0.datacreazione AS datacreazione_16, t0.id AS id_17, t0.idtipoopera AS idtipoopera_18 FROM multimedia t0 WHERE t0.id = ?
Parameters: 
[
  3412
]
View formatted query    View runnable query    Explain query
12 0.28 ms 
SELECT t0.nome AS nome_1, t0.medium AS medium_2, t0.descrizione AS descrizione_3, t0.note AS note_4, t0.anno AS anno_5, t0.numprogressivoanno AS numprogressivoanno_6, t0.widthNormal AS widthnormal_7, t0.heightNormal AS heightnormal_8, t0.widthBig AS widthbig_9, t0.heightBig AS heightbig_10, t0.widthThumbnail AS widththumbnail_11, t0.heightThumbnail AS heightthumbnail_12, t0.tipo AS tipo_13, t0.fileref AS fileref_14, t0.estensione AS estensione_15, t0.datacreazione AS datacreazione_16, t0.id AS id_17, t0.idtipoopera AS idtipoopera_18 FROM multimedia t0 WHERE t0.id = ?
Parameters: 
[
  3407
]
View formatted query    View runnable query    Explain query
13 0.26 ms 
SELECT t0.nome AS nome_1, t0.medium AS medium_2, t0.descrizione AS descrizione_3, t0.note AS note_4, t0.anno AS anno_5, t0.numprogressivoanno AS numprogressivoanno_6, t0.widthNormal AS widthnormal_7, t0.heightNormal AS heightnormal_8, t0.widthBig AS widthbig_9, t0.heightBig AS heightbig_10, t0.widthThumbnail AS widththumbnail_11, t0.heightThumbnail AS heightthumbnail_12, t0.tipo AS tipo_13, t0.fileref AS fileref_14, t0.estensione AS estensione_15, t0.datacreazione AS datacreazione_16, t0.id AS id_17, t0.idtipoopera AS idtipoopera_18 FROM multimedia t0 WHERE t0.id = ?
Parameters: 
[
  3439
]
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.