https://gcs.host7.jamel.link/api/multidownload/item?files%5B0%5D=285

Query Metrics

6 Database Queries
6 Different statements
88.82 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.62 ms
SELECT k0_.locale AS locale_0, k0_.domain AS domain_1 FROM kuma_translation k0_ GROUP BY k0_.locale, k0_.domain
Parameters:
[]
2 0.75 ms
SELECT g0_.display_order AS display_order_0, g0_.id AS id_1, g0_.pagepart_id AS pagepart_id_2, g0_.media_id AS media_id_3 FROM gcs_multi_download_items g0_ WHERE g0_.id IN (?)
Parameters:
[
  [
    "285"
  ]
]
3 0.71 ms
SELECT t0.uuid AS uuid_1, t0.name AS name_2, t0.description AS description_3, t0.copyright AS copyright_4, t0.location AS location_5, t0.content_type AS content_type_6, t0.metadata AS metadata_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.filesize AS filesize_10, t0.url AS url_11, t0.original_filename AS original_filename_12, t0.deleted AS deleted_13, t0.removed_from_file_system AS removed_from_file_system_14, t0.id AS id_15, t0.folder_id AS folder_id_16 FROM kuma_media t0 WHERE t0.id = ?
Parameters:
[
  "3095"
]
4 0.64 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "3095"
  "pl"
  "Kunstmaan\MediaBundle\Entity\Media"
]
5 7.79 ms
SELECT k0_.lft AS lft_0, k0_.lvl AS lvl_1, k0_.rgt AS rgt_2, k0_.deleted AS deleted_3, k0_.hidden_from_nav AS hidden_from_nav_4, k0_.ref_entity_name AS ref_entity_name_5, k0_.internal_name AS internal_name_6, k0_.id AS id_7, k1_.lang AS lang_8, k1_.online AS online_9, k1_.title AS title_10, k1_.slug AS slug_11, k1_.url AS url_12, k1_.weight AS weight_13, k1_.created AS created_14, k1_.updated AS updated_15, k1_.id AS id_16, k2_.type AS type_17, k2_.owner AS owner_18, k2_.created AS created_19, k2_.updated AS updated_20, k2_.ref_id AS ref_id_21, k2_.ref_entity_name AS ref_entity_name_22, k2_.id AS id_23, k0_.parent_id AS parent_id_24, k1_.node_id AS node_id_25, k1_.public_node_version_id AS public_node_version_id_26, k2_.node_translation_id AS node_translation_id_27, k2_.origin_id AS origin_id_28 FROM kuma_nodes k0_ LEFT JOIN kuma_node_translations k1_ ON k0_.id = k1_.node_id AND (k1_.lang = ?) LEFT JOIN kuma_node_versions k2_ ON k1_.public_node_version_id = k2_.id AND (k1_.public_node_version_id = k2_.id) JOIN (SELECT DISTINCT o.object_identifier as id FROM host7_gcs_dev.acl_object_identities as o
INNER JOIN host7_gcs_dev.acl_classes c ON c.id = o.class_id
LEFT JOIN host7_gcs_dev.acl_entries e ON (
    e.class_id = o.class_id AND (e.object_identity_id = o.id
    OR e.object_identity_id IS NULL)
)
LEFT JOIN host7_gcs_dev.acl_security_identities s ON (
s.id = e.security_identity_id
)
WHERE c.class_type = "Kunstmaan\\NodeBundle\\Entity\\Node"
AND (s.identifier = "IS_AUTHENTICATED_ANONYMOUSLY")
AND e.mask & 1 > 0) ta_ ON k0_.id = ta_.id WHERE k0_.deleted = 0 AND ((k0_.hidden_from_nav <> 1 OR k0_.internal_name IS NOT NULL)) ORDER BY k1_.weight ASC, k1_.title ASC
Parameters:
[
  null
]
6 78.31 ms
SELECT COUNT(k0_.id) AS sclr_0, SUM(k0_.events) AS sclr_1 FROM kuma_exception k0_ WHERE k0_.is_resolved = 0
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
Kunstmaan\RedirectBundle\Entity\Redirect No errors.
Kunstmaan\TranslatorBundle\Entity\Translation No errors.
App\Entity\MultiDownloadItem No errors.
App\Entity\PageParts\MultiDownloadPagePart No errors.
Kunstmaan\MediaBundle\Entity\Media No errors.
Kunstmaan\MediaBundle\Entity\Folder No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation No errors.
Gedmo\Translatable\Entity\Translation No errors.
Kunstmaan\PagePartBundle\Entity\PageTemplateConfiguration No errors.
Kunstmaan\MenuBundle\Entity\BaseMenuItem No errors.
Kunstmaan\MenuBundle\Entity\MenuItem No errors.
Kunstmaan\MenuBundle\Entity\BaseMenu No errors.
Kunstmaan\MenuBundle\Entity\Menu No errors.
Kunstmaan\NodeBundle\Entity\NodeTranslation No errors.
Kunstmaan\NodeBundle\Entity\Node No errors.
Kunstmaan\NodeBundle\Entity\NodeVersion No errors.
Kunstmaan\AdminBundle\Entity\Exception No errors.