Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.80 ms
SELECT DISTINCT m0_.id AS id_0 FROM media__gallery m0_ LIMIT 20
Parameters:
[]
2 0.19 ms
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
]
3 0.15 ms
SELECT count(m0_.id) AS sclr_0 FROM media__gallery m0_
Parameters:
[]
4 0.16 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:
[
  2
]
5 0.14 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:
[
  4112
]
6 0.12 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:
[
  5
]
7 0.13 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:
[
  4221
]
8 0.12 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:
[
  6
]
9 0.12 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:
[
  4199
]
10 0.11 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:
[
  7
]
11 0.12 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:
[
  4212
]
12 0.11 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:
[
  8
]
13 0.12 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:
[
  4230
]
14 0.11 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:
[
  9
]
15 0.12 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:
[
  4242
]
16 0.11 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:
[
  10
]
17 0.12 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:
[
  4259
]
18 0.12 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:
[
  11
]
19 0.12 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:
[
  4265
]
20 0.11 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:
[
  12
]
21 0.12 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:
[
  4269
]
22 0.11 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:
[
  13
]
23 0.12 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:
[
  4275
]
24 0.11 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:
[
  14
]
25 0.12 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:
[
  4284
]
26 0.12 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:
[
  15
]
27 0.12 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:
[
  4298
]
28 0.11 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:
[
  16
]
29 0.12 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:
[
  4311
]
30 0.11 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
]
31 0.12 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
]
32 0.11 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:
[
  19
]
33 0.12 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:
[
  4338
]
34 0.11 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:
[
  20
]
35 0.12 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:
[
  4348
]
36 0.12 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:
[
  21
]
37 0.12 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:
[
  4355
]
38 0.12 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:
[
  22
]
39 0.12 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:
[
  4356
]
40 0.11 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:
[
  23
]
41 0.12 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:
[
  4359
]

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.