Query Metrics

18 Database Queries
4 Different statements
4.65 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.92 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.context AS context_3, t0.enabled AS enabled_4, t0.titolo AS titolo_5, t0.descrizione AS descrizione_6, t0.title AS title_7, t0.metadescription AS metadescription_8, t0.url AS url_9, t0.category_id AS category_id_10 FROM media__gallery t0 WHERE t0.id = ?
Parameters:
[
  "17"
]
2 0.36 ms
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:
[
  17
]
3 0.34 ms
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:
[
  4320
]
4 0.21 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.metadescrizione AS metadescrizione_3, t0.keyword AS keyword_4, t0.ogtitle AS ogtitle_5, t0.ogdescription AS ogdescription_6, t0.ogurl AS ogurl_7, t0.immagine_id AS immagine_id_8 FROM seo t0 WHERE t0.id = ?
Parameters:
[
  1158
]
5 0.24 ms
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:
[
  4321
]
6 0.22 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.metadescrizione AS metadescrizione_3, t0.keyword AS keyword_4, t0.ogtitle AS ogtitle_5, t0.ogdescription AS ogdescription_6, t0.ogurl AS ogurl_7, t0.immagine_id AS immagine_id_8 FROM seo t0 WHERE t0.id = ?
Parameters:
[
  1159
]
7 0.23 ms
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:
[
  4322
]
8 0.21 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.metadescrizione AS metadescrizione_3, t0.keyword AS keyword_4, t0.ogtitle AS ogtitle_5, t0.ogdescription AS ogdescription_6, t0.ogurl AS ogurl_7, t0.immagine_id AS immagine_id_8 FROM seo t0 WHERE t0.id = ?
Parameters:
[
  1160
]
9 0.21 ms
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:
[
  4323
]
10 0.17 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.metadescrizione AS metadescrizione_3, t0.keyword AS keyword_4, t0.ogtitle AS ogtitle_5, t0.ogdescription AS ogdescription_6, t0.ogurl AS ogurl_7, t0.immagine_id AS immagine_id_8 FROM seo t0 WHERE t0.id = ?
Parameters:
[
  1161
]
11 0.18 ms
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:
[
  4324
]
12 0.17 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.metadescrizione AS metadescrizione_3, t0.keyword AS keyword_4, t0.ogtitle AS ogtitle_5, t0.ogdescription AS ogdescription_6, t0.ogurl AS ogurl_7, t0.immagine_id AS immagine_id_8 FROM seo t0 WHERE t0.id = ?
Parameters:
[
  1162
]
13 0.20 ms
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:
[
  4325
]
14 0.18 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.metadescrizione AS metadescrizione_3, t0.keyword AS keyword_4, t0.ogtitle AS ogtitle_5, t0.ogdescription AS ogdescription_6, t0.ogurl AS ogurl_7, t0.immagine_id AS immagine_id_8 FROM seo t0 WHERE t0.id = ?
Parameters:
[
  1163
]
15 0.20 ms
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:
[
  4326
]
16 0.21 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.metadescrizione AS metadescrizione_3, t0.keyword AS keyword_4, t0.ogtitle AS ogtitle_5, t0.ogdescription AS ogdescription_6, t0.ogurl AS ogurl_7, t0.immagine_id AS immagine_id_8 FROM seo t0 WHERE t0.id = ?
Parameters:
[
  1164
]
17 0.23 ms
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:
[
  4327
]
18 0.18 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.metadescrizione AS metadescrizione_3, t0.keyword AS keyword_4, t0.ogtitle AS ogtitle_5, t0.ogdescription AS ogdescription_6, t0.ogurl AS ogurl_7, t0.immagine_id AS immagine_id_8 FROM seo t0 WHERE t0.id = ?
Parameters:
[
  1165
]

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\Seo
  • The association App\Entity\Seo#immagine refers to the inverse side field App\Entity\Cat#seos which does not exist.
App\Entity\CategoryImages No errors.