Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

7.98 ms Query time

1 Invalid entities

Time▼	Count	Info
5.49 ms (68.87%)	1	SELECT o0_.anno AS anno_0 FROM opera o0_ ORDER BY o0_.anno DESC, o0_.numprogressivoanno ASC, o0_.id ASC Parameters: [] View formatted query View runnable query Explain query SELECT o0_.anno AS anno_0 FROM opera o0_ ORDER BY o0_.anno DESC, o0_.numprogressivoanno ASC, o0_.id ASC SELECT o0_.anno AS anno_0 FROM opera o0_ ORDER BY o0_.anno DESC, o0_.numprogressivoanno ASC, o0_.id ASC;
2.48 ms (31.13%)	1	SELECT t0.tipo AS tipo_1, t0.sigla AS sigla_2, t0.Priority AS priority_3 FROM tipoopera t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.tipo AS tipo_1, t0.sigla AS sigla_2, t0.Priority AS priority_3 FROM tipoopera t0 SELECT t0.tipo AS tipo_1, t0.sigla AS sigla_2, t0.Priority AS priority_3 FROM tipoopera t0;

Time▼

Count

Info

5.49 ms
(68.87%)

SELECT o0_.anno AS anno_0 FROM opera o0_ ORDER BY o0_.anno DESC, o0_.numprogressivoanno ASC, o0_.id ASC

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  o0_.anno AS anno_0
FROM
  opera o0_
ORDER BY
  o0_.anno DESC,
  o0_.numprogressivoanno ASC,
  o0_.id ASC

SELECT o0_.anno AS anno_0 FROM opera o0_ ORDER BY o0_.anno DESC, o0_.numprogressivoanno ASC, o0_.id ASC;

2.48 ms
(31.13%)

SELECT t0.tipo AS tipo_1, t0.sigla AS sigla_2, t0.Priority AS priority_3 FROM tipoopera t0

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  t0.tipo AS tipo_1,
  t0.sigla AS sigla_2,
  t0.Priority AS priority_3
FROM
  tipoopera t0

SELECT t0.tipo AS tipo_1, t0.sigla AS sigla_2, t0.Priority AS priority_3 FROM tipoopera t0;

Name	Service
default	doctrine.dbal.default_connection

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache is not enabled.

Class	Mapping errors
App\Entity\Tipoopera	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.

Class

Mapping errors

App\Entity\Tipoopera

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.