Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

4.27 ms Query time

3 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
3.01 ms (70.44%)	1	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.id = ? Parameters: [`"61"`] View formatted query View runnable query Explain query 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.id = ? 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.id = '61';
1.26 ms (29.56%)	1	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: [`3411`] View formatted query View runnable query Explain query 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 = ? 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 = 3411;

Time▼

Count

Info

3.01 ms
(70.44%)

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.id = ?

Parameters:

[
  "61"
]

View formatted query View runnable query Explain query

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.id = ?

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.id = '61';

1.26 ms
(29.56%)

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:

[
  3411
]

View formatted query View runnable query Explain query

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 = ?

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 = 3411;

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.

Symfony Profiler

https://ginocortelazzonuovo.devlancer.it/monografie-cataloghi/61/

Configuration Settings

Theme