Query Metrics

41 Database Queries
5 Different statements
5.65 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.31 ms
(40.84%)
19
SELECT t0.id AS id_1, t0.nome AS nome_2, t0.type AS type_3, t0.width AS width_4, t0.height AS height_5, t0.immagine AS immagine_6, t0.url AS url_7, t0.titolo AS titolo_8, t0.ext AS ext_9, t0.folder AS folder_10, t0.sel AS sel_11, t0.idold AS idold_12, t0.tecnica AS tecnica_13, t0.dimensione AS dimensione_14, t0.altro AS altro_15, t0.dataopera AS dataopera_16, t0.descrizione AS descrizione_17, t0.parent_id AS parent_id_18, t0.category_id AS category_id_19, t0.seo_id AS seo_id_20 FROM cat t0 WHERE t0.id = ?
Parameters:
[
  4112
]
2.20 ms
(38.90%)
19
SELECT t0.id AS id_1, t0.position AS position_2, t0.media_id AS media_id_3, t0.gallery_id AS gallery_id_4 FROM media__gallery_media t0 WHERE t0.gallery_id = ?
Parameters:
[
  2
]
0.80 ms
(14.17%)
1
SELECT DISTINCT m0_.id AS id_0 FROM media__gallery m0_ LIMIT 20
Parameters:
[]
0.19 ms
(3.42%)
1
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.context AS context_2, m0_.enabled AS enabled_3, m0_.titolo AS titolo_4, m0_.descrizione AS descrizione_5, m0_.title AS title_6, m0_.metadescription AS metadescription_7, m0_.url AS url_8, m0_.category_id AS category_id_9 FROM media__gallery m0_ WHERE m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  2
  5
  6
  13
  8
  9
  7
  12
  16
  14
  15
  17
  10
  11
  19
  20
  21
  22
  23
]
0.15 ms
(2.67%)
1
SELECT count(m0_.id) AS sclr_0 FROM media__gallery m0_
Parameters:
[]

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\MediaGallery No errors.
Umanit\EasyAdminTreeBundle\Entity\AbstractTreeItem No errors.
App\Entity\Categoria
  • The mappings App\Entity\Categoria#opere and App\Entity\Cat#categorias are inconsistent with each other.
App\Entity\Galleryhasmedia No errors.
App\Entity\Cat No errors.
App\Entity\CategoryImages No errors.
App\Entity\Seo
  • The association App\Entity\Seo#immagine refers to the inverse side field App\Entity\Cat#seos which does not exist.