Query Metrics
95
Database Queries
35
Different statements
45.49 ms
Query time
0
Invalid entities
3
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
22.24 ms (48.90%) |
60 |
SELECT s0_.name AS name_0, s0_.role_key AS role_key_1, s0_.securitySystem AS securitySystem_2, s0_.anonymous AS anonymous_3, s0_.id AS id_4, s0_.created AS created_5, s0_.changed AS changed_6, s1_.context AS context_7, s1_.module AS module_8, s1_.permissions AS permissions_9, s1_.id AS id_10, s0_.idSecurityTypes AS idSecurityTypes_11, s0_.idUsersCreator AS idUsersCreator_12, s0_.idUsersChanger AS idUsersChanger_13, s1_.idRoles AS idRoles_14 FROM se_roles s0_ LEFT JOIN se_permissions s1_ ON s0_.id = s1_.idRoles WHERE s0_.anonymous = ?
Parameters:
[
1
]
|
|
7.75 ms (17.03%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND (n0.path LIKE '/cmf/jagunic/contents/%' OR n0.path = '/cmf/jagunic/contents') ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') ASC
Parameters:
[
"default_live"
]
|
|
1.76 ms (3.88%) |
2 |
SELECT phpcr_type_nodes.name AS node_name, phpcr_type_nodes.is_abstract AS node_abstract, phpcr_type_nodes.is_mixin AS node_mixin, phpcr_type_nodes.queryable AS node_queryable, phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes, phpcr_type_nodes.primary_item AS node_primary_item_name, phpcr_type_nodes.supertypes AS declared_super_type_names, phpcr_type_props.name AS property_name, phpcr_type_props.auto_created AS property_auto_created, phpcr_type_props.mandatory AS property_mandatory, phpcr_type_props.protected AS property_protected, phpcr_type_props.on_parent_version AS property_on_parent_version, phpcr_type_props.required_type AS property_required_type, phpcr_type_props.multiple AS property_multiple, phpcr_type_props.fulltext_searchable AS property_fulltext_searchable, phpcr_type_props.query_orderable AS property_query_orderable, phpcr_type_props.default_value as property_default_value, phpcr_type_childs.name AS child_name, phpcr_type_childs.auto_created AS child_auto_created, phpcr_type_childs.mandatory AS child_mandatory, phpcr_type_childs.protected AS child_protected, phpcr_type_childs.on_parent_version AS child_on_parent_version, phpcr_type_childs.default_type AS child_default_type, phpcr_type_childs.primary_types AS child_primary_types FROM phpcr_type_nodes LEFT JOIN phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id LEFT JOIN phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id
Parameters:
[] |
|
1.06 ms (2.32%) |
1 |
SELECT 1 FROM phpcr_workspaces WHERE name = ?
Parameters:
[
"default_live"
]
|
|
0.59 ms (1.30%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/jagunic/contents/vina/signature-no-1' LIMIT 1
Parameters:
[
"default_live"
]
|
|
0.53 ms (1.16%) |
1 |
SELECT prefix, uri FROM phpcr_namespaces
Parameters:
[] |
|
0.52 ms (1.15%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/jagunic/contents/vina' LIMIT 1
Parameters:
[
"default_live"
]
|
|
0.49 ms (1.08%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/jagunic/contents/novosti/otkrijte-pjenusava-vina-vinarije-jagunic' LIMIT 1
Parameters:
[
"default_live"
]
|
|
0.47 ms (1.04%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/jagunic/contents' LIMIT 1
Parameters:
[
"default_live"
]
|
|
0.46 ms (1.02%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/jagunic/contents/novosti/otkrijte-pjenusava-vina-vinarije-jagunic-1' LIMIT 1
Parameters:
[
"default_live"
]
|
|
0.46 ms (1.02%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/jagunic/contents/gift-card/gift-card-2' LIMIT 1
Parameters:
[
"default_live"
]
|
|
0.43 ms (0.96%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/jagunic/contents/gift-card/gift-card-1' LIMIT 1
Parameters:
[
"default_live"
]
|
|
0.43 ms (0.94%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/jagunic/contents/vinogradi' LIMIT 1
Parameters:
[
"default_live"
]
|
|
0.42 ms (0.93%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/jagunic/contents/vinski-podrum' LIMIT 1
Parameters:
[
"default_live"
]
|
|
0.42 ms (0.93%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/jagunic/contents/vina/killer-queen' LIMIT 1
Parameters:
[
"default_live"
]
|
|
0.42 ms (0.91%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/jagunic/contents/vina/blanc-de-blancs/nutrijenti-blanc-de-blancs-2022' LIMIT 1
Parameters:
[
"default_live"
]
|
|
0.41 ms (0.91%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/jagunic/contents/vina/blanc-de-noirs-2022/nutrijenti-blanc-de-noirs-2022' LIMIT 1
Parameters:
[
"default_live"
]
|
|
0.41 ms (0.91%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/jagunic/contents/novosti' LIMIT 1
Parameters:
[
"default_live"
]
|
|
0.41 ms (0.91%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/jagunic/contents/vina/mraz-o-mor' LIMIT 1
Parameters:
[
"default_live"
]
|
|
0.41 ms (0.90%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/jagunic/contents/vina/blanc-de-blancs' LIMIT 1
Parameters:
[
"default_live"
]
|
|
0.40 ms (0.88%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/jagunic/contents/gift-card' LIMIT 1
Parameters:
[
"default_live"
]
|
|
0.38 ms (0.83%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/jagunic/contents/kontakt' LIMIT 1
Parameters:
[
"default_live"
]
|
|
0.37 ms (0.82%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/jagunic/contents/vina/three-stars-brut' LIMIT 1
Parameters:
[
"default_live"
]
|
|
0.37 ms (0.82%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/jagunic/contents/pravila-privatnosti' LIMIT 1
Parameters:
[
"default_live"
]
|
|
0.37 ms (0.81%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/jagunic/contents/vina/traminac-crveni' LIMIT 1
Parameters:
[
"default_live"
]
|
|
0.37 ms (0.81%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/jagunic/contents/narudzba-uspjeh' LIMIT 1
Parameters:
[
"default_live"
]
|
|
0.36 ms (0.80%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/jagunic/contents/vina/traminac-crveni-amber-selection' LIMIT 1
Parameters:
[
"default_live"
]
|
|
0.36 ms (0.79%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/jagunic/contents/vodene-degustacije-i-posjete' LIMIT 1
Parameters:
[
"default_live"
]
|
|
0.36 ms (0.79%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/jagunic/contents/kosarica' LIMIT 1
Parameters:
[
"default_live"
]
|
|
0.36 ms (0.79%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/jagunic/contents/uvjeti-kupnje' LIMIT 1
Parameters:
[
"default_live"
]
|
|
0.36 ms (0.78%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/jagunic/contents/vina/three-stars-brut-0-375l' LIMIT 1
Parameters:
[
"default_live"
]
|
|
0.36 ms (0.78%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/jagunic/contents/narudzba' LIMIT 1
Parameters:
[
"default_live"
]
|
|
0.36 ms (0.78%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/jagunic/contents/organizacija-dogadaja' LIMIT 1
Parameters:
[
"default_live"
]
|
|
0.32 ms (0.70%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/jagunic/contents/vina/three-stars-rose-brut' LIMIT 1
Parameters:
[
"default_live"
]
|
|
0.29 ms (0.64%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/jagunic/contents/o-nama' LIMIT 1
Parameters:
[
"default_live"
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| Sulu\Bundle\SecurityBundle\Entity\Permission | 2 |
| Sulu\Bundle\SecurityBundle\Entity\Role | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| Sulu\Bundle\MediaBundle\Entity\Collection | No errors. |
| Sulu\Bundle\TrashBundle\Domain\Model\TrashItem | No errors. |
| Sulu\Bundle\FormBundle\Entity\Form | No errors. |
| Sulu\Bundle\ContactBundle\Entity\ContactTitle | No errors. |
| Sulu\Bundle\SecurityBundle\Entity\Group | No errors. |
| Sulu\Bundle\SecurityBundle\Entity\User | No errors. |
| App\Entity\User | No errors. |
| Sulu\Bundle\SecurityBundle\Entity\Role | No errors. |
| Sulu\Bundle\SecurityBundle\Entity\Permission | No errors. |
| Sulu\Bundle\SecurityBundle\Entity\SecurityType | No errors. |
| Sulu\Bundle\SecurityBundle\Entity\UserRole | No errors. |
| Sulu\Bundle\SecurityBundle\Entity\RoleSetting | No errors. |